Hi Falko, Hi Till just updated my small cluster setup from ISPConfig 3.0.3 to latest stable version, but I am now getting the following error from the slave machine: Code: DB::query(SELECT * FROM sys_ini WHERE sysini_id = 1) -> mysqli_query SELECT command denied to user 'ispcsrv3'@'*******' for table 'sys_ini' (***** has the correct server name). The setup was running perfectly before the update and the ispconfig updater didn't show any problems. As suggested in the entry in the FAQ I chose to reconfigure the database permissions on the master when updating the slave. The servers are running on Debian Wheezy. The user ispcsrv3 does exist on the master server and has two entries in the mysql.user table, one for the correct slave host name, one for the correct slave ip. Both servers find each other by ip and by name. However the user ispcsrv3 does neither appear in the access rights for database dbispconfig1 on the master nor for database dbispconfig2 on the slave server. Any idea what went wrong and how to fix it? I am uncertain where the ispcsrv3 should be configured and which access rights it should have?!? When viewing the specific rights for the user ispcsrv3 to the database dbispconfig1, it seems that the user indeed has no access to the table sys_ini? These are the access rights: HTML: Tabelle Rechte GRANT Spaltenspezifische Rechte Aktion aps_instances SELECT, UPDATE Nein Nein Rechte ändern Rechte ändern Entfernen Entfernen mail_traffic SELECT, INSERT, UPDATE Nein Nein Rechte ändern Rechte ändern Entfernen Entfernen monitor_data SELECT, INSERT, DELETE Nein Nein Rechte ändern Rechte ändern Entfernen Entfernen server SELECT Nein Ja Rechte ändern Rechte ändern Entfernen Entfernen software_update_inst SELECT Nein Ja Rechte ändern Rechte ändern Entfernen Entfernen sys_datalog SELECT Nein Ja Rechte ändern Rechte ändern Entfernen Entfernen sys_group SELECT Nein Nein Rechte ändern Rechte ändern Entfernen Entfernen sys_log SELECT, INSERT Nein Nein Rechte ändern Rechte ändern Entfernen Entfernen sys_remoteaction SELECT Nein Ja Rechte ändern Rechte ändern Entfernen Entfernen web_backup SELECT, INSERT, DELETE Nein Nein Rechte ändern Rechte ändern Entfernen Entfernen web_domain SELECT Nein Ja Rechte ändern Rechte ändern Entfernen Entfernen web_traffic SELECT, INSERT, UPDATE Many thanks for your help!
Thats a known issue in the 3,0,5,2 version and already fixed in svn 3.0.5 stable branch. The issue is uncritical as all functions available in 3.0.5.2 will work and are not affected by this. The nly function that is affected by this sql warning is the new quota notification function. You can give the ispcsrv users read access permissions to the sys_ini table to stop the warning, but this access should be removed when you update to 3.0.5.4 in future as the problem is solved differently without requiring access to that table.
