:DI am using Roundcube Webmail 0.8.3 on a qmail server. I have new mail in my new folder on qmail but no new mail messages are showing in Roundcube.
Can you help? I am using Qmailtoaster on CentOS 5.8 with PHP 5.3.18.
Enable imap_debug and post the log.
This is the entire imap log in /var/www/roundcube/logs after I enabled it.
[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0006 OK STATUS Completed.
[12-Nov-2012 20:56:38 -0600]: [65F1] C: A0007 STATUS INBOX.Trash (MESSAGES UNSEEN)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: * STATUS "INBOX.Trash" (MESSAGES 0 UNSEEN 0)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0007 OK STATUS Completed.
[12-Nov-2012 20:56:38 -0600]: [65F1] C: A0008 STATUS INBOX.Archive (MESSAGES UNSEEN)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: * STATUS "INBOX.Archive" (MESSAGES 0 UNSEEN 0)
[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0008 OK STATUS Completed.
[12-Nov-2012 20:56:38 -0600]: [65F1] C: A0009 LOGOUT
[12-Nov-2012 20:56:38 -0600]: [65F1] S: * BYE Courier-IMAP server shutting down
[12-Nov-2012 20:56:38 -0600]: [65F1] S: A0009 OK LOGOUT completed
Here is what "tail errors" gives me:
[12-Nov-2012 20:56:35 America/Winnipeg] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3e8118ab96692537f4a186e98b6724d0a5efa0d4c FROM 'SELECT * FROM accounts WHERE user_id=?']
[Native code: 1146]
[Native message: Table 'roundcubemail.accounts' doesn't exist]
[12-Nov-2012 20:56:35 -0600]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3e8118ab96692537f4a186e98b6724d0a5efa0d4c FROM 'SELECT * FROM accounts WHERE user_id=?']
[Native code: 1146]
[Native message: Table 'roundcubemail.accounts' doesn't exist]
in /var/www/roundcube/program/include/rcube_mdb2.php on line 296 (GET /?_task=mail)
here are the tables in roundcubemail database:
+-------------------------+
| Tables_in_roundcubemail |
+-------------------------+
| cache |
| cache_index |
| cache_messages |
| cache_thread |
| contactgroupmembers |
| contactgroups |
| contacts |
| dictionary |
| events |
| events_cache |
| events_caldav |
| forgot_password |
| identities |
| reminders |
| searches |
| session |
| users |
+-------------------------+
The imap log shows that the server isn't finding any messages, the error log seems to show that the accounts plugin isn't setup correctly.
My fault for not setting up the sql script from the accounts plugin. But now, after setting it up, I can see my new messages, but my old ones have disappeared!
Also, my fault. My script to sync the mail in the old server to the new one had an error. I forgot to add the "/" after everything (a problem when cutting and pasting between text files, excel and back) The server seems to be running fine now.