fail to upgrade to the latest with DB error

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: fail to upgrade to the latest with DB error

Post by benjaminsmith »

Hello @iwang,
are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier.
The timezone error is still present. Please post the output to the following command:

Code: Select all

grep date.timezone /etc/php.ini
Next, the database is not connecting. Check the status to make sure the service is running.

Code: Select all

service mysqld status
# to restart
service mysqld restart
If you're unable to restart the database, please upload the log /var/log/mysqld.log .
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
iwang
Posts: 41
Joined: Tue Nov 12, 2019 1:22 pm

Re: fail to upgrade to the latest with DB error

Post by iwang »

thank you Benjemin for the help!

the database is setup in another machine instead of the same one with Nagios.
and i am sure the db don't have any issue. is there configuration in Nagios side when doing the upgrade in this case?

many thanks,
Irene
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: fail to upgrade to the latest with DB error

Post by benjaminsmith »

Hi Irene,

I noticed you have two forum posts related to the failed upgrade. If this is for the same system, I would like to close this one and continue to troubleshoot this on the other posts? Let me know. Thanks.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
iwang
Posts: 41
Joined: Tue Nov 12, 2019 1:22 pm

Re: fail to upgrade to the latest with DB error

Post by iwang »

yes you can lock this one. as the other one has the latest update.
even though each comes from two different issues when upgrade in different way.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: fail to upgrade to the latest with DB error

Post by benjaminsmith »

Hi Irene,

Thanks. We'll lock this up and move it over to the other post.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked