Please don't top post. Please read the mailing list posting guidelines which you were asked to when you subscribed to this list. > 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. Don't ignore errors. It's there for a reason. > 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. I think you have confused what credentials you need to log in to the mail client (SM) versus what credentials you need for SM to use the preferences DB. The two are NOT the same. The DSN needs to have a single set of credentials of an administrative database user which SM will use to store all user preferences in the database. Alternatively, change to storing user prefs in the data directory. >> 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; >> ------------------------------------------------------------------------- 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
