Cluster Update problem

Discussion in 'ISPConfig 3 Priority Support' started by stefanm, Aug 13, 2013.

  1. stefanm

    stefanm New Member HowtoForge Supporter

    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!
     
    Last edited: Aug 13, 2013
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page