PheMail::Vhost - Perl extension for Apache MySQL Vhost loading
use PheMail::Vhost; alterSqlFromString("backendtype","user","password","mysqlhost","myip"); PheMail::LoadVhosts(\%VirtualHost);
PheMail::Vhost loads vhosts into httpd.conf (Apache 1.3.x) collected from a MySQL database. Used in Project PheMail. It is possible to extend it's features to do a lot of other stuff. Here's a sample MySQL structure:
CREATE TABLE `vhosts` ( `id` int(11) NOT NULL auto_increment, `hoster` varchar(15) NOT NULL default '192.168.1.1', `sname` varchar(255) NOT NULL default '', `droot` varchar(255) NOT NULL default '', `sadmin` varchar(255) NOT NULL default 'spike@printf.dk', `domain` varchar(255) NOT NULL default '', `soptions` varchar(255) NOT NULL default '', `htaccess` text NOT NULL, `users` text NOT NULL, `extensions` text NOT NULL, `redirect` varchar(255) NOT NULL default '', `eredirect` enum('1','0') NOT NULL default '0', `open_basedir` enum('1','0') NOT NULL default '1', `safe_mode` enum('1','0') NOT NULL default '0', `magic_quotes` enum('1','0') NOT NULL default '1', `enableauth` enum('1','0') NOT NULL default '0', `authname` varchar(255) NOT NULL default 'PheMail Protected Area', `disablefunc` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
The fields should be pretty selfexplanatory. Since this is a part of a project, I don't really support the structure.
LoadVhosts(); ReportSql(); altersqlFromString();
Jesper Noehr, <jesper@noehr.org>
perl, DBI
I rewrote the code, it seems pretty stable as it is now. I will need to add more features later.
To install PheMail::Vhost, copy and paste the appropriate command in to your terminal.
cpanm
cpanm PheMail::Vhost
CPAN shell
perl -MCPAN -e shell install PheMail::Vhost
For more information on module installation, please visit the detailed CPAN module installation guide.