> I'm getting the following error in the middle when trying to login to > squirrelmail with a virtual user: > > *ERROR : Could not complete request. > *Query: SELECT "INBOX" > Reason Given: Unable to open this mailbox. > > > Before I changed the $auto_create_special = line to false from the > default true, I was getting this additional error on the left hand pane: > > *ERROR:* *ERROR : Could not complete request.* > Query: CREATE "INBOX.Sent" > Reason Given: Cannot create this folder. > When I ran configtest.php this is the output: > > .... > Checking IMAP service.... > IMAP server ready (* OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE > THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION > STARTTLS] Courier-IMAP ready. Copyright 1998-2004 Double Precision, Inc. > See COPYING for distribution information.) ... > Checking database functions... PHP Pear DB support is present. > > * ERROR: database support not present!* > > > The database support error that I'm getting is a little puzzling to me, > since it authenticates fine thru MySQL as it's evident by the syslog: > > Dec 25 04:00:37 chaos authdaemond.mysql: authmysql: trying this module ...
> Now, the /var/mail/virtual/dino directory I have changed the ownership to > user "mail" and still no go. > > Here's the important parts of my config.php file: > > .... > $imap_server_type = 'courier'; ... > $default_folder_prefix = ''; > $trash_folder = 'INBOX.Trash'; > $sent_folder = 'INBOX.Sent'; > $draft_folder = 'INBOX.Drafts'; ... > $force_username_lowercase = false; ... > $plugins[7] = 'change_ldappass'; > $plugins[8] = 'avelsieve'; ... > *$addrbook_dsn = 'mysql://mail:[EMAIL PROTECTED]/maildb'; > $addrbook_table = 'address';* ... > $addrbook_global_dsn = 'mysql://mail:[EMAIL PROTECTED]/maildb'; > $addrbook_global_table = 'address'; 1. 'select inbox' error Do you have maildir directory structure with cur, new and tmp subdirectories in user's home directory. Check /var/mail/virtual/dino directory. It must contain cur, new and tmp subdirectories and must be owned by user with system id equal to 5000. 2. 'ERROR: database support not present!' You have configured two database based address books. maildb database should contain address table which uses format defined in SquirrelMail documentation. doc/db-backend.txt file. You showed syslog messages that indicate MySQL support in courier. SquirrelMail needs Pear DB and MySQL support in PHP. 3. Other courier issues First thing that you should do when you start SquirrelMail configuration utility is to select D command and set your IMAP server. setting $imap_server_type is not enough. SquirrelMail does not support NAMESPACE extension and folder names must be set correctly in SquirrelMail configuration. D menu option does that. 4. plugins You have mysql based setup and have installed poppass and ldap password changing plugins and cyrus sieve filtering plugin. Why? 5. $force_username_lowercase = false; I think, your MySQL select query is case insensitive. $force_username_lowercase must be set to true in order to avoid loss of settings when user enters login in different case. for example Dino@@gamelaironline.com instead of [EMAIL PROTECTED] -- 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
