Update 1.8 error

[HDSRetail]

Hi,
the update to version 1.8 in my log the error
Patching NDOUtils...
PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /root/tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /root/tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
ERROR CONNECTING TO DATABASES!
Installing new XI templates...
~/tmp/nagiosxi/nagiosxi/basedir/scripts ~/tmp/nagiosxi
PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /root/tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /root/tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
ERROR CONNECTING TO DATABASES!
NAGIOSQL LOGIN FAILED!
MySQL database is on the second server. What do I do that update was successful?

[lmiltchev]

Are you behind a proxy?

[HDSRetail]

No, I do not have a proxy. if you try to connect

Code: Select all

mysql -u nagiosql -p'nagiosql' -h <IP_ADDRESS_OF_MYSQL_SERVER>

to the MySQL server, everything is OK. I noticed that after 1.8 update changes settings in the admin to local MySQL.

[mguthrie]

Ok, so this is going to be a little bit of a workaround, but you should only need to do this once.

Open the /tmp/nagiosxi/subcomponents/ndoutils/post-upgrade script in a text-editor.
Update line 15 with the password, and hostname that match your environment.
Re-Run the upgrade script.

[HDSRetail]

Ok, thanks it helped.

[mguthrie]

Good deal!