Unable to read server configuration from database.

Discussion in 'Installation/Configuration' started by pcboyau, Sep 4, 2012.

  1. pcboyau

    pcboyau New Member

    Hi all :D

    having some problems doing an update on a multi server setup. i've been able to update my master server my primary servers updated fine and also update the slave mail fine but for some reason the slave web server does not want to update.

    I've checked the config files and checked that the mysql database details work from the shell to the master database also checked the server_id is correct in the config.... i'm at a loss :(

    I'm going from 3.0.4.2 to 3.0.4.6

    anyone got any ideas?
    :mad:

    oh snap this should be in ispconfig3 Sorry
     
    Last edited: Sep 4, 2012
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    As the error message says, the server configuration can not be retrieved from the local database. Check that a record with the server_id that you find in the /usr/local/ispconfig/server/lib/config.inc.php exists in the local dbispconfig database of the slave server and that this records has a valid ini style configuraton in the 'config' field. If the ini style info is missing on the slave, copy it from the server record of this server that you find in the master database.
     
  3. pcboyau

    pcboyau New Member

    Checked the database and the Servers table looks fine. the config cell for that server looks fine as well.

    I've compared the cells from the server table on both the mast and the slave and they are the same

    local access to the local database looks fine from the command line .. any other ideas?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    There must be a problem with the content of the config cell as it an not be parsed which throws this error. Copy the content of the config field into a text editor and check if the format is ok. Ini sytsle format can contain section in this format:

    [section]

    and inside the sections key value paisr like this:

    key=value
     
  5. pcboyau

    pcboyau New Member

    send you the configs via PM

    thx
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    The config seems to be ok. And you are really sure that the mysql root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf AND the ispconfig password for the local database /usr/local/ispconfig/server/lib/config.inc.php are correct?
     
  7. pcboyau

    pcboyau New Member

    yeah just double checked and confirmed that they are working fine.

    checked the local root - working from the config details
    checked the master root - working from the config details
    checked the local ispconfig - working from the config details

    :(
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Then you can just try to debug the isuue on your server, the installer is not able to get the system configuration and stops so that your system does not get damaged. The code is in the file install/lib/update.lib.php on line 120. The issue is quite uncommon as I do ISPConfig updates daily and did not had it on a server yet.

    If you are not able to debug that yourself, then you might want to contact the ispconfig support:

    http://support.projektfarm.com/
     
    Last edited: Sep 4, 2012
  9. EntireNet

    EntireNet New Member

    Update issues

    Hi all,

    i have similar problems updating a multiserver setup.

    In mysql.log i see that the update script is querying the local db of the master server. The last entries in /var/log/mysql/mysql.log before the script stops with "Unable to read server configuration from database." is:

    199 Query SELECT * FROM dbispconfig.server WHERE server_id = 1
    199 Quit
    202 Quit

    I'm using 3.0.4.6 version of ICPConfig.

    What else can i check?

    Since all service are running fine on the dedicated web and ftp, mail and database server, i assume the mysql connections and privileges are all fine.

    Regards,

    EntireNet
     
  10. SamTzu

    SamTzu Active Member

    I'm seeing weird MySQL problems on several servers that might be related.
    Maybe Oracle finally had enough :)
     
  11. abdi

    abdi Member

    This was my solution to this problem!
     

Share This Page