>>> I did reply, probably did not copy it to the list >>> >> by >>> mistake. I did reload the privileges but I am >> still getting the same error >>> message. What else could be going wrong? I get an >> error message saying >>> that I need the reload privilege for this >> operation, which I do not have. >>> Would privileges not be restored the next >>> time the user will try to log on to the database? >> >> SquirrelMail db-based address books need only >> SELECT, INSERT, UPDATE and >> DELETE privileges. If you don't have administrative >> access to MySQL, you must have enough privileges to list/add/modify/delete >> records and create tables and indexes in selected database. If you >> already have these privileges, you don't have to reload MySQL privilege >> information. >> >> Are you sure that you used correct DSN syntax? >> > This is the error message I am getting: > > > ERROR: Database error: insufficient permissions in > addressbook DSN > > I don't understand it, as I can insert/remove/update > records from the database without any problems. What could be wrong? > > Thanks, > George >
Which page generates this error? SquirrelMail 1.4.5 uses different error message. There is no 'ERROR:' string. if you use dsn 'mysql://someuser:[EMAIL PROTECTED]/somedb' and address book table is set to 'address' without single quotes and error is displayed when you try to list addresses, then 'someuser' logged with 'somepassword' on 'somehost' mysql server does not have SELECT privilege on 'somedb' database 'address' table or address book table is not setup correctly. Check your privileges and used DSN or contact your web service provider. Database without SELECT privilege is unusable in any normal setup. It is possible that you have used incorrect database or table name or address book table is not created. -- Tomas ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click -- squirrelmail-users mailing list Posting Guidelines: http://www.squirrelmail.org/wiki/MailingListPostingGuidelines List Address: [email protected] List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
