Search found 8 matches

by kvijay
Sun Jan 12, 2025 7:19 am
Forum: Nagios XI
Topic: mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
Replies: 2
Views: 763

mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired

Hello, It has been noticed that 'Monitoring Engine' in Nagios XI has been failing often recently. On checking the mariadb logs, it says that DB tables are crashed and should be repaired. Mariadb logs: 250110 21:56:47 [ERROR] mysqld: Table './nagios/nagios_programstatus' is marked as crashed and shou...
by kvijay
Mon Mar 15, 2021 4:33 am
Forum: Nagios XI
Topic: HOw to configure new services in bulk (500+ servies)
Replies: 1
Views: 131

HOw to configure new services in bulk (500+ servies)

Team, We have the requirement to setup new services to nagios. there are sround 500 new services to configure. please advice on this can be achieved in NagiosXI. In core we have some option like creating file in SSH. Similar like can we do this form XI ? PLease share the documentation to create new ...
by kvijay
Sat Aug 15, 2020 1:13 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi]
Replies: 7
Views: 136296

Re: SQL Error [nagiosxi]

[root@cbq2-svu-nagxi1 ~]# systemctl cat ndo2db.service # /usr/lib/systemd/system/ndo2db.service [Unit] Description=Nagios Data Out Daemon Documentation=http://www.nagios.org/documentation After=var-run.mount nss-lookup.target network.target local-fs.target time-sync.target mariadb.service mysql.serv...
by kvijay
Thu Aug 13, 2020 12:18 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi]
Replies: 7
Views: 136296

Re: SQL Error [nagiosxi]

Below is the output of command.attached the profile.zip [root@cbq2-svu-nagxi1 components]# /usr/local/nagiosxi/scripts/components/getprofile.sh SUPPORT -------------------Fetching Information------------------- Please wait....... Creating system information... Creating nagios.txt... Creating perfdat...
by kvijay
Thu Aug 13, 2020 12:13 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi]
Replies: 7
Views: 136296

Re: SQL Error [nagiosxi]

What version of XI are you running? Please send me a copy of your profile, you can download it from Admin > System Profile > Download Profile button. If you're unable to generate the the profile through the web interface, please try generating it from the command line by running these commands as r...
by kvijay
Thu Aug 13, 2020 12:11 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi]
Replies: 7
Views: 136296

Re: SQL Error [nagiosxi]

[root@cbq2-svu-nagxi1 components]# echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table +-------------...
by kvijay
Tue Aug 11, 2020 6:42 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi]
Replies: 7
Views: 136296

SQL Error [nagiosxi]

while i logoin to nagiosxi
getting below errir .

SQL Error [nagiosxi] : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE user_id = 9' at line 3