>> >> >> > 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) >> >> >> >> >> >> DSN should not include table name. Your configuration is set to use >> >> >> database >> >> >> called "maildb.users" >> >> > >> >> > >> >> > Hi Tomas, >> >> > >> >> > >> >> > Thanks for your advice. >> >> > >> >> > >> >> > Changing the statement of "DSN for Address Book" as; >> >> > mysql://rkllee@xxxxxxxxxxx:mypassword@xxxxxxxxx/maildb >> >> > >> >> > >> >> > didn't help, ERROR warning still popup. I tested it before posting. >> >> > Therefore I changed "maildb" as "maildb.users" including the >> >> table_name. >> >> > Just reconfirmed it before posting this email. >> >> > >> >> >> >> SquirrelMail interacts only with SMTP server, IMAP server and SQL server. >> >> We >> >> don't need any details about your amavis setup. It is totally unrelated >> >> to >> >> your issue. >> >> >> >> Please don't invent new DSN syntax. Table name is set in other >> >> SquirrelMail >> >> setting. >> >> >> >> Do you have 'users' table with correct fields? >> > >> > >> > Yes I have users table on maildb, the database. I did not find any >> > problem on its settings. Besides SM is now working. Users of all domains >> > can send/read mails direct on browser. The ERROR warning does not affect >> > the operation of SM. >> > >> > >> >> Could you show structure of users table? > > > mysql> SELECT * from users; > +------------------------------+---------------+------+------+-------------------------+-------------------+---------+-----------------+----------------+---------------+-------+------------+----------------+ > | id | name | uid | gid | home | maildir | enabled | change_password | clear | crypt | quota | procmailrc | spamassassinrc | > +------------------------------+---------------+------+------+-------------------------+-------------------+---------+-----------------+----------------+---------------+-------+------------+----------------+ > | root@localhost | root | 5000 | 5000 | /var/spool/mail/virtual | root/ | 1 | 1 | passwd1 | sdtrusfX0Jj66 | | | | > | rkllee@xxxxxxxxxxx | Satimis | 5000 | 5000 | /var/spool/mail/virtual | KLLEE/ | 1 | 1 | passwd2 | sdtrusfX0Jj66 | | | | > | lms@xxxxxxxxxxx | lmsoomn | 5000 | 5000 | /var/spool/mail/virtual | LMS/ | 1 | 1 | passwd3 | sdtrusfX0Jj66 | | | | > | albert@xxxxxxxxxxx | Albert Conong | 5000 | 5000 | /var/spool/mail/virtual | Albert/ | 1 | 1 | passwd4 | sdtrusfX0Jj66 | | | | > |....... This is your account database. It has nothing to do with your SquirrelMail preferences database. Also, make sure the user/pwd in your DSN is the right one for your database user login and NOT your personal email login. You need to read: http://squirrelmail.org/docs/admin/admin-5.html#ss5.7 ------------------------------------------------------------------------- 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
