roundcube users no longer updated

Discussion in 'ISPConfig 3 Priority Support' started by aldo, May 24, 2016.

  1. aldo

    aldo Member HowtoForge Supporter

    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.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. aldo

    aldo Member HowtoForge Supporter

    Sorry for the lack of information.
    Attached htf_report.txt

    enabling debug
    Code:
    [email protected]:~/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:
    [email protected]:~/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:
    [email protected]:~/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.
    
     

    Attached Files:

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  5. aldo

    aldo Member HowtoForge Supporter

    I think I've already done that.
    I have posted the results in the spoiler but maybe I did not understand something.
     
  6. aldo

    aldo Member HowtoForge Supporter

    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.
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

Share This Page