Unable to read server configuration from database.
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 22.214.171.124 to 126.96.36.199
anyone got any ideas?
oh snap this should be in ispconfig3 Sorry
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.
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?
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:
and inside the sections key value paisr like this:
send you the configs via PM
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?
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
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:
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
I'm using 188.8.131.52 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.
I'm seeing weird MySQL problems on several servers that might be related.
Maybe Oracle finally had enough :)
|All times are GMT +2. The time now is 19:46.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.