Hi folks, Postfix squirrelmail mysql amavis On login; Code: Preference database error (connect failed). Exiting abnormally login - [email protected] password - mypassword Both of them are correct. # tail /var/log/mail.log Code: Nov 22 08:46:03 xen05 imapd-ssl: LOGIN: ip=[::ffff:127.0.0.1], command=LOGIN Nov 22 08:46:03 xen05 imapd-ssl: LOGIN: ip=[::ffff:127.0.0.1], [email protected] Nov 22 08:46:03 xen05 imapd-ssl: LOGIN: ip=[::ffff:127.0.0.1], password=mypassword Nov 22 08:46:03 xen05 authdaemond: received auth request, service=imap, authtype=login Nov 22 08:46:03 xen05 authdaemond: authmysql: trying this module Nov 22 08:46:03 xen05 authdaemond: SQL query: SELECT id, "", clear, uid, gid, home, concat(home,'/',maildir), "", name, "" FROM users WHERE id = "[email protected]" AND (enabled=1) Nov 22 08:46:03 xen05 authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, [email protected], fullname=Stephen, maildir=/var/spool/mail/virtual/Stephen/, quota=<null>, options=<null> Nov 22 08:46:03 xen05 authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, [email protected], fullname=Stephen, maildir=/var/spool/mail/virtual/Stephen/, quota=<null>, options=<null> Nov 22 08:46:03 xen05 imapd-ssl: LOGIN, [email protected], ip=[::ffff:127.0.0.1], protocol=IMAP Nov 22 08:46:03 xen05 imapd-ssl: LOGOUT, [email protected], ip=[::ffff:127.0.0.1], headers=0, body=0, rcvd=46, sent=376, time=0, sta No warning there. # cat /etc/amavis/conf.d/50-user Code: use strict; @lookup_sql_dsn = ( ['DBI:mysql:database=maildb;host=127.0.0.1;port=3306', 'mail', 'mailpassword']); $sql_select_policy = 'SELECT name FROM virtual_domains WHERE CONCAT("@",name) IN (%k)'; #------------ Do not modify anything below this line ------------- 1; # insure a defined return $mydomain= 'satimis.com'; $daemon_user= 'virtual'; $daemon_group= 'virtual'; @local_domains_acl = qw(.); $inet_socket_port = 10024; $forward_method = 'smtp:127.0.0.1:10025'; # @bypass_virus_checks_acl = qw( . ); # @bypass_spam_checks_acl = qw( . ); # I also change these $TEMPBASE = "$MYHOME/tmp"; # Whilst debugging $log_level = 2; $warnbannedrecip = 1; $warn_offsite = 1; $warnvirusrecip = 1; $spam_quarantine_to = "spam-quarantine\@$mydomain"; $virus_quarantine_to = "virus-quarantine\@$mydomain"; $sa_local_tests_only = 0; Please help. TIA B.R. satimis
Solved Hi falko, I was following; http://flurdy.com/docs/postfix/index.html#conf_web in combination with; http://workaround.org/articles/ispmail-etch/ Plus heavy search on Internet building this mail server serving multiple domains, virtual domain. SquirrelMail version 1.4.9a Problem solved. Solution is still a mystery to me. Steps performed as follows; At the beginning SM was unable to start on browser. 1) After running; # apt-get install php-file php-db then I can start SM but unable to login. 2) #pear list Code: Installed packages, channel pear.php.net: ========================================= Package Version State Archive_Tar 1.3.1 stable Console_Getopt 1.2 stable PEAR 1.4.11 stable Download DB-1.7.13.tgz on Internet. Decompressed it. Then # cp -R db-4.7.25/db/ /usr/share/php Still unable to login SM. 3) Edited following file; # nano /etc/amavis/conf.d/50-user adding following lines before 1; Code: @lookup_sql_dsn = ( ['DBI:mysql:database=maildb;host=127.0.0.1;port=3306', 'mail', 'mailpassword']); $sql_select_policy = 'SELECT name FROM virtual_domains WHERE CONCAT("@",name) IN (%k)'; Still I can't login. # cat /etc/amavis/conf.d/50-user Code: use strict; @lookup_sql_dsn = ( ['DBI:mysql:database=maildb;host=127.0.0.1;port=3306', 'mail', 'mailpassword']); $sql_select_policy = 'SELECT name FROM virtual_domains WHERE CONCAT("@",name) IN (%k)'; #------------ Do not modify anything below this line ------------- 1; # insure a defined return $mydomain= 'satimis.com'; $daemon_user= 'virtual'; $daemon_group= 'virtual'; @local_domains_acl = qw(.); $inet_socket_port = 10024; $forward_method = 'smtp:127.0.0.1:10025'; # @bypass_virus_checks_acl = qw( . ); # @bypass_spam_checks_acl = qw( . ); # $TEMPBASE = "$MYHOME/tmp"; # Whilst debugging $log_level = 2; $warnbannedrecip = 1; $warn_offsite = 1; $warnvirusrecip = 1; $spam_quarantine_to = "spam-quarantine\@$mydomain"; $virus_quarantine_to = "virus-quarantine\@$mydomain"; $sa_local_tests_only = 0; Finally; 4) Ran # /var/www/squirrelmail/config/conf.pl 9 -> 1 DSN for Address Book entered; mysql://[email protected]:[email protected]/maildb S -> Q (remark: maildb=database users=table) Leaving "DSN for Preferences" blank On browser checking; http://satimis.com/squirrelmail/src/configtest.php Code: ..... ..... Error: Database error: connect failed in addressbook DSN. Ignored it for the time being. On browser; http://satimis.com/squirrelmail/ Login [email protected] Password mypassword This time I can login SM reading mails. Now it doesn't work for me only. Other users under different domains are also able to login with their password sending/reading mails. This is working mail server running postfix virtual and MySQL as database serving users of multiple domains. I'm testing the server with 4 domains. All users can send/receive mails on their mail client. Evolution, as well. The said server is running as guest on a Xen box . This happening surprises me. I only edited the file entering my own data there. Why other users of other domains can also login? Their login data have not been entered on SM. If it uses the data on database then why it needs my data on SM before login can work? Whether I can revoke steps 2) and 3) above ? TIA B.R. satimis
