Hi,

Debian Etch
Postfix
squirrelmail
mysql
amavis


On login;
Preference database error (connect failed). Exiting abnormally


login - [EMAIL PROTECTED]
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], [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=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, [EMAIL 
PROTECTED], fullname=Richard, maildir=/var/spool/mail/virtual/Richard/, 
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= '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 = "[EMAIL PROTECTED]";
$virus_quarantine_to = "[EMAIL PROTECTED]";
$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@lists.sourceforge.net
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): 
https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

Reply via email to