Both systems are running: //** Application define('ISPC_APP_TITLE', 'ISPConfig'); define('ISPC_APP_VERSION', '3.0.5.4rc2'); define('DEVSYSTEM', 0); And seems to be working fine... From /usr/local/ispconfig/server/lib/config.inc.php On master: [...] //** Database $conf['db_type'] = 'mysql'; $conf['db_host'] = 'localhost'; $conf['db_database'] = 'dbispconfig1'; [...] //** Database settings for the master DB. This setting is only used in multiserver setups $conf['dbmaster_type'] = 'mysql'; $conf['dbmaster_host'] = ''; $conf['dbmaster_database'] = 'dbispconfig'; $conf['dbmaster_user'] = ''; On slave: [...] //** Database $conf['db_type'] = 'mysql'; $conf['db_host'] = 'localhost'; $conf['db_database'] = 'dbispconfig2'; [...] //** Database settings for the master DB. This setting is only used in multiserver setups $conf['dbmaster_type'] = 'mysql'; $conf['dbmaster_host'] = 'mydomain.com'; $conf['dbmaster_database'] = 'dbispconfig1'; But, when I try to apply the new version: /tmp/ispconfig3_install/install# php -q update.php [...] Reconfigure Permissions in master database? (yes,no) [no]: yes WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON dbispconfig.`server` TO 'user'@'myIpAddress' 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 'user'@'myIpAddress' 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 'user'@'myIpAddress' 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 'user'@'myIpAddress' Error: Table 'dbispconfig.software_update_inst' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`updated`) ON dbispconfig.`server` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.server' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (`ssl_request`, `ssl_cert`, `ssl_action`, `ssl_key`) ON dbispconfig.`web_domain` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.web_domain' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON dbispconfig.`sys_group` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.sys_group' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON dbispconfig.`sys_remoteaction` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.sys_remoteaction' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT , DELETE ON dbispconfig.`monitor_data` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.monitor_data' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`mail_traffic` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.mail_traffic' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`web_traffic` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.web_traffic' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE, DELETE ON dbispconfig.`aps_instances` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.aps_instances' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, DELETE ON dbispconfig.`aps_instances_settings` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.aps_instances_settings' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON dbispconfig.`web_backup` TO 'user'@'myIpAddress' Error: Table 'dbispconfig.web_backup' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON dbispconfig.`server` TO 'user'@'mydomain2.com' 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 'user'@'mydomain2.com' 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 'user'@'mydomain2.com' 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 'user'@'mydomain2.com' Error: Table 'dbispconfig.software_update_inst' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(`updated`) ON dbispconfig.`server` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.server' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (`ssl_request`, `ssl_cert`, `ssl_action`, `ssl_key`) ON dbispconfig.`web_domain` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.web_domain' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON dbispconfig.`sys_group` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.sys_group' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON dbispconfig.`sys_remoteaction` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.sys_remoteaction' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT , DELETE ON dbispconfig.`monitor_data` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.monitor_data' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`mail_traffic` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.mail_traffic' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`web_traffic` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.web_traffic' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE, DELETE ON dbispconfig.`aps_instances` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.aps_instances' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, DELETE ON dbispconfig.`aps_instances_settings` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.aps_instances_settings' doesn't exist WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON dbispconfig.`web_backup` TO 'user'@'mydomain2.com' Error: Table 'dbispconfig.web_backup' doesn't exist My question is.... Should I create manually all these entries?
No, do not create any tables manually. My guess is that you did not update the master first, before you updated the slave. In a multiserver setup, the master server ahs to be updated first, then the slaves. Update the master now and then rerun the update on the slave.
Looks like "something" changed my original configuration $conf['dbmaster_database'] = 'dbispconfig'; looking into backups, I couldn't find a "dbispconfig" database, so, I changed it to: $conf['dbmaster_database'] = 'dbispconfig1'; and re - run the updater. And now everything goes fine! Thanks!
