Search found 8 matches
- Sun Jan 12, 2025 7:20 am
- Forum: Nagios XI
- Topic: mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
- Replies: 2
- Views: 763
Re: mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
We have paid support and would like to get support from Nagios support.
- 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...
- 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 ...
- 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...
- 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...
- 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...
- 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 +-------------...
- 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
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