Hi, After updating to 3.2, I am unable to login to webmail. I am getting error as "Unknown column 'failed_login' in 'field list'". Also I am unable to see any old data in ISPconfig. Please help me. Thank you
From which version did you update? Did you get any errors during the update? Is the MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf correct?
From which version did you update? Updated from ISPConfig 3.0.X to ISPconfig3.2. Did you get any errors during the update? No errors Is the MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf correct? Yes, correct. Checked twice.
Before that I upgraded OS from debian 7 to debian 10. Sites were not working properly, so I have executed the command "php -q update.php" and gave the default values for the questions. After that site are working fine but I have the issues with ISPconfig and webmail.
ISPConfig has Business support that can fix your issues for a fee. https://www.ispconfig.org/get-support/ If you plan to fix yourself, start with this: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ Have you after upgrading to Debian 10 followed the ISPConfig Perfect Server Guide for Debian 10, installing all packages and doing configurations? When that is done, force reconfigure services with Code: ispconfig_update.sh --force How did you do the upgrade from Debian 7 to Debian 10?
That field is part of the roundcube database, not ISPConfig's, so you need to update your roundcube schema from the older version. A quick search finds https://github.com/roundcube/roundcubemail/blob/master/UPGRADING which indicates roundcube's installer can check and update your schema, so if you installed roundcube from source you shouldn't have much more to do; if you installed from debian package, read their release notes and see if it mentions specifically what to do (I note there is a /usr/share/roundcube/program/include/rcmail_install.php with a function to update the db, so the required pieces may well be present).
