Waiting for database startup... after initial install?

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
Locked
Gleep52
Posts: 1
Joined: Tue Feb 01, 2022 4:05 pm

Waiting for database startup... after initial install?

Post by Gleep52 »

We set up our NagiosLS instance, and started forwarding logs from a few AD servers and our Meraki network - let it collect data for a few days and checked in on it a few times. Eventually - after login (which becomes very slow) it brings up the page:

Waiting for Database Startup
It looks like your local elasticsearch service is starting.

But it stays on that page indefinitely. If I run "Service elasticsearch status" from the command prompt I get the results:
https://www.screencast.com/t/RF07Zt5j

Any ideas why this happens? This is the second time in a row I've gone through the install process and started forwarding logs with the same outcome....
User avatar
pbroste
Posts: 1288
Joined: Tue Jun 01, 2021 1:27 pm

Re: Waiting for database startup... after initial install?

Post by pbroste »

Hello @Gleep52

date
ll /etc/localtime
grep date.timezone /etc/php.ini
grep ZONE /etc/sysconfig/clock

log server system profile:

over the System Profile if see that you are unable to access the log server web console.

Code: Select all

/usr/local/nagioslogserver/scripts/profile.sh
The System Profile is found in '/tmp/system-profile.tar.gz'

To size down the System Profile a bit you can run the following:

Code: Select all

cd /tmp/ && gzip -d system-profile.tar.gz -c | tar --delete --wildcards system-profile/logstashlogs/logstash.log-*.gz | gzip - > /tmp/tmp.$$.tar.gz && mv /tmp/tmp.$$.tar.gz system-profile.tar.gz
Also verify that the date/time/timezone are sync'ed across all:

Code: Select all

date
ll /etc/localtime
grep date.timezone /etc/php.ini
grep ZONE /etc/sysconfig/clock
php -r 'echo date("D M j G:i:s T Y")."\n";'
grep "date.timezone =" /etc/php.ini
grep date.timezone /etc/php.ini
php -r "echo date_default_timezone_get();" #timezone
Let us know the results:
Please send over the System Profile is found in '/tmp/system-profile.tar.gz' and the other info in a Private Message.

Thanks,
Perry
Locked