Mail-Toaster

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

       - new user sub, $vals->{'username'} needed to be $vals->{'user'}

     Qmail.pm
       - on FreeBSD, be smarter about disabling sendmail and enabling qmail

     Setup.pm -
       - Georg von Itzenplitz - allspam target created an empty .qmail with
         invalid ownership, sent patch.
       - fix for installing phpMyAdmin with php5
       - the squirrelmail sub does a better job of setting up squirrelmail with
         mysql prefs (no guarantees yet).
       - added sub for installing roundcube, domainkeys, and dovecot
       - RRDutil was not fetching dist properly
       - autorespond failed to build on darwin due to quoting error
       - if $config_dir ($prefix/etc)  is missing, create it
       - added vpopmail_valias to Darwin config tweaks
       - added an entire section of Linux config tweaks
       - search for gmake is no longer fatal (on Linux, gmake is installed as make)
       - isoqlog source build now works again (patches needed to be an arrayref)
       - added port_ options for Apache2-SOAP perl module
       - added download addresses for NicTool installs

doc/Changes.html  view on Meta::CPAN

   - new user sub, $vals->{'username'} needed to be $vals->{'user'}

 Qmail.pm
   - on FreeBSD, be smarter about disabling sendmail and enabling qmail

 Setup.pm -
   - Georg von Itzenplitz - allspam target created an empty .qmail with
     invalid ownership, sent patch.
   - fix for installing phpMyAdmin with php5
   - the squirrelmail sub does a better job of setting up squirrelmail with
     mysql prefs (no guarantees yet).
   - added sub for installing roundcube, domainkeys, and dovecot
   - RRDutil was not fetching dist properly
   - autorespond failed to build on darwin due to quoting error
   - if $config_dir ($prefix/etc)  is missing, create it
   - added vpopmail_valias to Darwin config tweaks
   - added an entire section of Linux config tweaks
   - search for gmake is no longer fatal (on Linux, gmake is installed as make)
   - isoqlog source build now works again (patches needed to be an arrayref)
   - added port_ options for Apache2-SOAP perl module
   - added download addresses for NicTool installs

doc/Changes.pod  view on Meta::CPAN

   - new user sub, $vals->{'username'} needed to be $vals->{'user'}

 Qmail.pm
   - on FreeBSD, be smarter about disabling sendmail and enabling qmail

 Setup.pm -
   - Georg von Itzenplitz - allspam target created an empty .qmail with
     invalid ownership, sent patch.
   - fix for installing phpMyAdmin with php5
   - the squirrelmail sub does a better job of setting up squirrelmail with
     mysql prefs (no guarantees yet).
   - added sub for installing roundcube, domainkeys, and dovecot
   - RRDutil was not fetching dist properly
   - autorespond failed to build on darwin due to quoting error
   - if $config_dir ($prefix/etc)  is missing, create it
   - added vpopmail_valias to Darwin config tweaks
   - added an entire section of Linux config tweaks
   - search for gmake is no longer fatal (on Linux, gmake is installed as make)
   - isoqlog source build now works again (patches needed to be an arrayref)
   - added port_ options for Apache2-SOAP perl module
   - added download addresses for NicTool installs

lib/Mail/Toaster/Setup.pm  view on Meta::CPAN

the following contents:

	user_scores_dsn                 DBI:mysql:spamassassin:localhost
	user_scores_sql_username        $self->conf->{install_spamassassin_dbuser}
	user_scores_sql_password        $self->conf->{install_spamassassin_dbpass}

	# default query
	#SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '\@GLOBAL' ORDER BY username ASC
	# global, then domain level
	#SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '\@GLOBAL' OR username = '@~'||_DOMAIN_ ORDER BY username ASC
	# global overrides user prefs
	#SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '\@GLOBAL' ORDER BY username DESC
	# from the SA SQL README
	#user_scores_sql_custom_query     SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '\$GLOBAL' OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC

	bayes_store_module              Mail::SpamAssassin::BayesStore::SQL
	bayes_sql_dsn                   DBI:mysql:spamassassin:localhost
	bayes_sql_username              $self->conf->{install_spamassassin_dbuser}
	bayes_sql_password              $self->conf->{install_spamassassin_dbpass}
	#bayes_sql_override_username    someusername

lib/Mail/Toaster/Setup.pm  view on Meta::CPAN

        $sth = $self->mysql->query( $dbh, $query );

        $query =
"CREATE TABLE squirrelmail.global_abook ( owner varchar(128) DEFAULT '' NOT NULL, nickname varchar(16) DEFAULT '' NOT NULL, firstname varchar(128) DEFAULT '' NOT NULL,
lastname varchar(128) DEFAULT '' NOT NULL, email varchar(128) DEFAULT '' NOT NULL,
label varchar(255), PRIMARY KEY (owner,nickname), KEY firstname (firstname,lastname));";

        $sth = $self->mysql->query( $dbh, $query );

        $query =
"CREATE TABLE squirrelmail.userprefs ( user varchar(128) DEFAULT '' NOT NULL, prefkey varchar(64) DEFAULT '' NOT NULL, prefval BLOB DEFAULT '' NOT NULL, PRIMARY KEY (user,prefkey))";
        $sth = $self->mysql->query( $dbh, $query );

        $sth->finish;
        return 1;
    }

    print "

WARNING: I could not connect to your database server!  If this is a new install,
you will need to connect to your database server and run this command manually:

lib/Mail/Toaster/Setup.pm  view on Meta::CPAN

CREATE TABLE squirrelmail.global_abook (
owner varchar(128) DEFAULT '' NOT NULL,
nickname varchar(16) DEFAULT '' NOT NULL,
firstname varchar(128) DEFAULT '' NOT NULL,
lastname varchar(128) DEFAULT '' NOT NULL,
email varchar(128) DEFAULT '' NOT NULL,
label varchar(255),
PRIMARY KEY (owner,nickname),
KEY firstname (firstname,lastname)
);
CREATE TABLE squirrelmail.userprefs (
user varchar(128) DEFAULT '' NOT NULL,
prefkey varchar(64) DEFAULT '' NOT NULL,
prefval BLOB DEFAULT '' NOT NULL,
PRIMARY KEY (user,prefkey)
);
quit;

If this is an upgrade, you can probably ignore this warning.

";

lib/Mail/Toaster/Setup.pm  view on Meta::CPAN


    my $string = <<"EOCONFIG";
<?php
\$signout_page  = 'https://$mailhost/';
\$provider_name     = 'Powered by Mail::Toaster';
\$provider_uri     = 'http://www.tnpi.net/wiki/Mail_Toaster';
\$domain                 = '$mailhost';
\$useSendmail            = true;
\$imap_server_type       = 'dovecot';
\$addrbook_dsn = '$dsn';
\$prefs_dsn = '$dsn';
?>
EOCONFIG
      ;

    $self->util->file_write( "config_local.php", lines => [ $string ] );

    if ( -d "$sqdir/plugins/sasql" ) {
        if ( ! -e "$sqdir/plugins/sasql/sasql_conf.php" ) {
            copy('sasql_conf.php.dist', 'sasql_conf.php');
        };

toaster-watcher.conf-dist  view on Meta::CPAN

# if you with to install a particular version
#    0  = do not install
#    1  = install
# port  = install from FreeBSD or Darwin ports
# other = install particular version
#
# Extra options are noted after the # where available. Selecting 1 is the most reliable
# and will install trying first via ports, then sources if the port install fails.

install_squirrelmail               = 1.4.22  # 0, ver, port
install_squirrelmail_sql           = 0       # use MySQL for user prefs and address book?
install_squirrelmail_sql_pass      = chAnge7his
install_lighttpd                   = 1
install_cronolog                   = 1.6.2   # ver, port
install_phpmyadmin                 = 0       # 0, 1
install_mysql                      = 0       # 0, 1, 2, 3, 40, 41, 5, 51
install_mysqld                     = 0       # 0, 1
install_mysql_optimized            = 0
install_mysql_dir                  = /var/db/mysql
install_courier_imap               = port    # 0, ver, port
install_sqwebmail                  = 0       # 0, ver, port

toaster-watcher.conf-dist  view on Meta::CPAN


######################################
#           Mail Filtering
######################################

install_mail_filtering             = 1
install_procmail                   = 0
install_maildrop                   = 1       # 0, 1, ver
install_spamassassin               = 1
install_spamassassin_flags         = -v -u spamd -H /var/spool/spamd -x # Add -q for per user SQL
install_spamassassin_sql           = 0       # use AWL, bayes, and per-user prefs from MySQL
install_spamassassin_dbuser        = spamassassin
install_spamassassin_dbpass        = assSPAMing
install_dspam                      = 0
install_simscan                    = 1.4.0   # 0, ver
install_qmailscanner               = 0       # 0, ver       (1.25  as of 04/08/05)
install_qmailscanner_stats         = 0       # 0, ver       (2.0.2 as of 02/02/05)
install_clamav                     = port    # 0, port, ver
install_clamav_user                = clamav  # qscand | clamav
install_pyzor                      = 0
install_razor                      = port    # 0, port, ver



( run in 0.856 second using v1.01-cache-2.11-cpan-8f98c5d2c55 )