Hi, Further to my posting at the bottom of this email problem has been solved. Steps performed as follows; Ran # /var/www/squirrelmail/config/conf.pl 9 -> 1 entered; mysql://rkllee@xxxxxxxxxxx:mypassword@xxxxxxxxx/maildb.users S -> Q (remark: maildb=database users=table) On browser checking; http://example.com/squirrelmail/src/configtest.php ..... ..... Error: Database error: connect failed in addressbook DSN. Ignore it. On browser; http://example.com/squirrelmail/ Login rkllee@xxxxxxxxxxx Password mypassword This time I can login reading mails. It now doesn't work for myself only. Other users are also able to login with their password. This happening surprises me. I only edited the file entering my own data there. Why other users can also login? Their login data have not been entered. B.R. rkllee > > From: <rkllee@xxxxxxxxxxxxxx> > Date: Nov 22, 2008 05:06 PM > To: <squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx> > Subject: Fail to start SM > > 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 > ------------------------------------------------------------------------- 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
