Hi all, I've performed the update and followed step by step the instructions. However i have a problem. Our installation is with remote mysql server, and now ispconfig is not creating the databases on the remote host. The upgrade was performed on the master ISPConfig 3 and then on the Mysql Server. What must I check in order to debug this problem? Thank you. Sergio Rosa
Yes. I did. I'm looking at the output of the update and I find this " WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON dbispconfig.`server` TO 'ispcsrv3'@'127.0.0.1' Error: Table 'dbispconfig.server' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT ON dbispconfig.`sys_log` TO 'ispcsrv3'@'127.0.0.1' Error: Table 'dbispconfig.sys_log' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`status`, `error`) ON dbispconfig.`sys_datalog` TO 'ispcsrv3'@'127.0.0.1' Error: Table 'dbispconfig.sys_datalog' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`status`) ON dbispconfig.`software_update_inst` TO 'ispcsrv3'@'127.0.0.1' Error: Table 'dbispconfig.software_update_inst' doesn't exist " however on our installation the ISPC3 Database is not called dbispconfig but dbispconfig3. Could this is be the cause? Thank you.
Which database is set in $conf['dbmaster_database'] on the slave server in /usr/local/ispconfig/server/lib/config.inc.php file?
the configuration on the remote mysql server is " $conf['dbmaster_type'] = 'mysql'; $conf['dbmaster_host'] = 'ispc3'; $conf['dbmaster_database'] = 'dbispconfig3'; "
Then it should not throw these errors, maybe the update script uses the local database name. I will add a report in the bugtracker.
Replace the database name in the grant queries from error.log and execute them manually with phpmyadmin on the master server. Then flush priveliges on the master in mysql.
Isn't the database name of master queried in the update process? Maybe you entered the wrong database name (dbispconfig) there mistakenly?
