HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Unable to read server configuration from database. (http://www.howtoforge.com/forums/showthread.php?t=58539)

pcboyau 4th September 2012 14:04

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 3.0.4.2 to 3.0.4.6

anyone got any ideas?
:mad:

oh snap this should be in ispconfig3 Sorry

till 4th September 2012 14:13

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.

pcboyau 4th September 2012 15:03

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?

till 4th September 2012 15:09

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

pcboyau 4th September 2012 15:18

send you the configs via PM

thx

till 4th September 2012 15:25

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?

pcboyau 4th September 2012 15:30

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

:(

till 4th September 2012 15:43

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/

EntireNet 21st March 2013 17:09

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

SamTzu 21st March 2013 20:15

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 15:23.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.