Page 1 of 1

Waiting for database startup... after initial install?

Posted: Tue Feb 01, 2022 4:12 pm
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....

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

Posted: Wed Feb 02, 2022 1:53 pm
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