New Nagios install

[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.

[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

[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'

[scottwilkerson]

Lets run the following

Code: Select all

mysqlcheck -f -r -u root -pnagiosxi --all-databases --use_frm

[angus]

When i run that i get several lines of "The storage engine for the table doesn't support repair"

[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

[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.

[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?

[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.

[scottwilkerson]

Did you install it following this guide?
https://assets.nagios.com/downloads/nag ... ponent.pdf