Hi,
Debian Etch
Postfix
squirrelmail
mysql
amavis
On login;
Preference database error (connect failed). Exiting abnormally
login - rkllee@xxxxxxxxxxx
password - mypassword
Both are correct.
# tail /var/log/mail.log
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], username=rkllee@xxxxxxxxxxx
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 = "rkllee@xxxxxxxxxxx" AND (enabled=1)
Nov 22 08:46:03 xen05 authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=rkllee@xxxxxxxxxxx, fullname=Richard, maildir=/var/spool/mail/virtual/Richard/, quota=<null>, options=<null>
Nov 22 08:46:03 xen05 authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=rkllee@xxxxxxxxxxx, fullname=Richard, maildir=/var/spool/mail/virtual/Richard/, quota=<null>, options=<null>
Nov 22 08:46:03 xen05 imapd-ssl: LOGIN, user=rkllee@xxxxxxxxxxx, ip=[::ffff:127.0.0.1], protocol=IMAP
Nov 22 08:46:03 xen05 imapd-ssl: LOGOUT, user=rkllee@xxxxxxxxxxx, 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= 'example.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 advise. TIA
B.R.
rkllee
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
