Page 1 of 1
New Nagios install
Posted: Wed Aug 01, 2018 7:01 am
by angus
Hello,
I am trying to setup a new Nagios XI server but i am running into a couple issues. This server is meant to be my new Nagios XI server, i will import my old Nagios to this one.
I am trying to setup single sign on with AD but i am running into issue. If i don't use SSl or TLS to secure the communication to AD, i can query AD and add users. If i use SSL or TLS, i am rejected due to a certificate. I have uploaded a cert provided by my CA already. I am not sure what the issue is, please assist.
I also have an error pop up at login, shown below.
SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus
Thank you for your help.
Re: New Nagios install
Posted: Wed Aug 01, 2018 9:23 am
by scottwilkerson
First lets fix the DB issue
Code: Select all
echo "use nagios;repair table nagios_programstatus use_frm;" | mysql -pnagiosxi
Then I would run a complete database repair
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Finally, here is our doc on using AD/LDAP with certificates
https://assets.nagios.com/downloads/nag ... ponent.pdf
Re: New Nagios install
Posted: Thu Aug 02, 2018 8:36 am
by angus
I have run the commands but the errors are still are still present. I also followed that KB article for the cert already. It isn't working properly.
SQL Error [ndoutils] : Incorrect file format 'nagios_servicestatus'
Re: New Nagios install
Posted: Thu Aug 02, 2018 8:38 am
by scottwilkerson
Lets run the following
Code: Select all
mysqlcheck -f -r -u root -pnagiosxi --all-databases --use_frm
Re: New Nagios install
Posted: Thu Aug 02, 2018 12:43 pm
by angus
When i run that i get several lines of "The storage engine for the table doesn't support repair"
Re: New Nagios install
Posted: Thu Aug 02, 2018 3:52 pm
by scottwilkerson
Lets change it to just 2 databases
Code: Select all
mysqlcheck -f -r -u root -pnagiosxi nagios --use_frm
mysqlcheck -f -r -u root -pnagiosxi nagiosql --use_frm
Re: New Nagios install
Posted: Mon Aug 06, 2018 8:19 am
by angus
mysqlcheck -f -r -u root -pnagiosxi nagios --use_frm - Everything comes back as "OK"
mysqlcheck -f -r -u root -pnagiosxi nagiosql --use_frm - Errors with "The storage engine for the table doesn't support repair"
Thanks.
Re: New Nagios install
Posted: Mon Aug 06, 2018 8:48 am
by scottwilkerson
This is normal for a couple tables
Code: Select all
nagiosql.tbl_permission
note : The storage engine for the table doesn't support repair
nagiosql.tbl_permission_inactive
note : The storage engine for the table doesn't support repair
Are you still experiencing issues?
Re: New Nagios install
Posted: Mon Aug 06, 2018 9:44 am
by angus
The SQL issues seem to be resolved. I am still not sure why my cert isn't functioning properly. Can we verify that it is properly installed?
Thanks.
Re: New Nagios install
Posted: Mon Aug 06, 2018 10:36 am
by scottwilkerson