> > 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 Hi, Thanks for your advice. > > 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. I just ignored it for the time being to check whether login worked. To my surprise it worked even there was an error. > > 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. I must leave preferences DB blank in order to login SM. What shall I add there? TIA Now all users can login SM to send and receive mails B.R. rkllee > >> 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 > ------------------------------------------------------------------------- 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
