> > 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://[EMAIL PROTECTED]:[EMAIL PROTECTED]/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 [EMAIL PROTECTED] > > 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 - [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; > >> > > ------------------------------------------------------------------------- > 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 > ------------------------------------------------------------------------- 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
