Time ago I installed ISPConfig3 on Debian 7 with Roundcube (0.72). It worked creating a test user (mailbox). Now I notice that creating new mailboxes with ISPConfig3 roundcubedb is no longer updated and new mailboxes aren't accessible by roundcube (login fails). I regularly updated ISPConfig3 which is now at version 3.0.5.4p9. Any help would be appreciated.
Users in RoundCube get added when you login with this IMAP account the first time in RoundCube, that's nothing that ISPconfig is doing. If new imap accounts are not working, then see last chapter of this post: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
Sorry for the lack of information. Attached htf_report.txt Expand: server.sh debug enabling debug Code: root@peano:~/temp# /usr/local/ispconfig/server/server.sh 24.05.2016-10:55 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock /usr/sbin/mpt-status /usr/bin/fail2ban-client /sbin/iptables /sbin/ip6tables 24.05.2016-10:55 - DEBUG - Found 2 changes, starting update process. 24.05.2016-10:55 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 24.05.2016-10:55 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 24.05.2016-10:55 - DEBUG - Network configuration disabled in server settings. 24.05.2016-10:55 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 24.05.2016-10:55 - DEBUG - Processed datalog_id 963 24.05.2016-10:55 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 24.05.2016-10:55 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 24.05.2016-10:55 - DEBUG - Network configuration disabled in server settings. 24.05.2016-10:55 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 24.05.2016-10:55 - DEBUG - Processed datalog_id 964 24.05.2016-10:55 - DEBUG - Calling function 'restartHttpd' from module 'web_module'. 24.05.2016-10:55 - DEBUG - Restarting httpd: /etc/init.d/apache2 restart 24.05.2016-10:55 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock finished. doing nothing Code: root@peano:~/temp# /usr/local/ispconfig/server/server.sh 24.05.2016-10:56 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 24.05.2016-10:56 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock finished. adding mailbox [email protected] Code: root@peano:~/temp# /usr/local/ispconfig/server/server.sh 24.05.2016-11:04 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 24.05.2016-11:04 - DEBUG - Found 2 changes, starting update process. 24.05.2016-11:04 - DEBUG - Processed datalog_id 965 24.05.2016-11:04 - DEBUG - Calling function 'user_insert' from plugin 'mail_plugin' raised by event 'mail_user_insert'. 24.05.2016-11:04 - DEBUG - Created Directory: /var/vmail/domain.tld/test2 24.05.2016-11:04 - DEBUG - Created Maildir /var/vmail/domain.tld/test2/Maildir with subfolder: 24.05.2016-11:04 - DEBUG - Set ownership on /var/vmail/domain.tld/test2 24.05.2016-11:04 - DEBUG - Created Maildir /var/vmail/domain.tld/test2/Maildir with subfolder: Sent 24.05.2016-11:04 - DEBUG - Created Maildir /var/vmail/domain.tld/test2/Maildir with subfolder: Drafts 24.05.2016-11:04 - DEBUG - Created Maildir /var/vmail/domain.tld/test2/Maildir with subfolder: Trash 24.05.2016-11:04 - DEBUG - Created Maildir /var/vmail/domain.tld/test2/Maildir with subfolder: Junk 24.05.2016-11:04 - DEBUG - Calling function 'update' from plugin 'maildeliver_plugin' raised by event 'mail_user_insert'. 24.05.2016-11:04 - DEBUG - Mailfilter config has been changed 24.05.2016-11:04 - DEBUG - Found 1 addresses. 24.05.2016-11:04 - DEBUG - Found 1 addresses at all. 24.05.2016-11:04 - DEBUG - Found 1 unique addresses at all. 24.05.2016-11:04 - DEBUG - Processed datalog_id 966 24.05.2016-11:04 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock finished.
Please see the last chapter of the post that I added a link to, it tells you how to debug your issue when ispconfig is not able to write changes to disk.
I think I've already done that. I have posted the results in the spoiler but maybe I did not understand something.
It seems that the DB is different from what expected. Code: [24-May-2016 14:48:17 Europe/Berlin] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_4f4e868331c813ae5951598f248101e25775d70b8 FROM 'SELECT * FROM users WHERE mail_host = ? AND alias = ?'] [Native code: 1054] [Native message: Unknown column 'alias' in 'where clause'] [24-May-2016 14:48:17 +0200]: DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_4f4e868331c813ae5951598f248101e25775d70b8 FROM 'SELECT * FROM users WHERE mail_host = ? AND alias = ?'] [Native code: 1054] [Native message: Unknown column 'alias' in 'where clause'] in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (POST /webmail/?_task=login&_action=login) [24-May-2016 14:48:17 Europe/Berlin] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_57a71e5dd44f064e55891f56202284be784b04343 FROM 'INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), ?, ?, ?, ?)'] [Native code: 1054] [Native message: Unknown column 'alias' in 'field list'] [24-May-2016 14:48:17 +0200]: DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_57a71e5dd44f064e55891f56202284be784b04343 FROM 'INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), ?, ?, ?, ?)'] [Native code: 1054] [Native message: Unknown column 'alias' in 'field list'] in /usr/share/roundcube/program/include/rcube_mdb2.php on line 293 (POST /webmail/?_task=login&_action=login) [24-May-2016 14:48:17 +0200]: PHP Error: Failed to create new user in /usr/share/roundcube/program/include/rcube_user.php on line 510 (POST /webmail/?_task=login&_action=login) [24-May-2016 14:48:17 +0200]: PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /usr/share/roundcube/program/include/rcmail.php on line 860 (POST /webmail/?_task=login&_action=login) Would it be possible to uninstall roundcube, and install a newer version? Could I follow this tutorial: https://www.howtoforge.com/using-roundcube-webmail-with-ispconfig-3-on-debian-wheezy-apache2 using the last stable version of roundcube? Thanks.
I guess this should work. Just be aware that you will loose custom settings that you might have done in roundcube.