Nagios XI Don't Send E-Mail

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Nagios XI Don't Send E-Mail

Post by rkennedy »

I also notice the 'skip' button is clicked by the notifications, did someone else change any of the configuration?
Former Nagios Employee
Top
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Nagios XI Don't Send E-Mail

Post by Bone8Head »

rkennedy wrote:I also notice the 'skip' button is clicked by the notifications, did someone else change any of the configuration?
Unfortunately not. :|

This is the messages file log in /var/log.
You can see someone related about notifications issue?

Code: Select all

Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.220;Datastore usage for VMHost;2;ESX3 CRITICAL - Error connecting to server at \'https://192\.168\.50\.220/sdk/webService\': Perhaps host is not a vCenter or ESX server|''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe nagios: SERVICE ALERT: NEWSRVXBS - 225;Drive E: Disk Usage;OK;SOFT;2;E:\ - total: 39.99 Gb - used: 16.61 Gb (42%) - free 23.38 Gb (58%)
Jan 20 16:50:35 nagiosfe nagios: SERVICE ALERT: Sito Finance Evolution;HTTP;OK;SOFT;2;HTTP OK: HTTP/1.1 200 OK - 16830 bytes in 0.210 second response time
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCECITRIX-23CACEIS;Ping;0;OK - 10\.210\.1\.23: rta 13\.744ms, lost 0%|rta=13\.744ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=16\.517ms;;;; rtmin=12\.564ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCECITRIX-23CAPB;Drive C: Disk Usage;0;C:\\\\ - total: 39\.90 Gb - used: 26\.08 Gb \(65%\) - free 13\.82 Gb \(35%\)|\'C:\\\\ Used Space\'=26\.08Gb;31\.12;33\.92;0\.00;39\.90''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCETEST-20CACEIS;Drive E: Disk Usage;0;E:\\\\ - total: 130\.23 Gb - used: 60\.21 Gb \(46%\) - free 70\.02 Gb \(54%\)|\'E:\\\\ Used Space\'=60\.21Gb;110\.70;117\.21;0\.00;130\.23''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='Sito Finance Evolution;HTTP;0;HTTP OK: HTTP/1\.1 200 OK - 16830 bytes in 0\.129 second response time|time=0\.129336s;;;0\.000000 size=16830B;;;0''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCELIVE-21CAPB;Memory Usage;0;Memory usage: total:12285\.39 MB - used: 3499\.19 MB \(28%\) - free: 8786\.20 MB \(72%\)|\'Memory usage\'=3499\.19MB;10442\.59;11056\.85;0\.00;12285\.39''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVKLREPO - 9\.1;MySQL Uptime;0;OK - database is up since 69459 minutes|uptime=4167576s''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWT2S - 214;Drive C: Disk Usage;0;C:\\\\ - total: 39\.90 Gb - used: 25\.29 Gb \(63%\) - free 14\.61 Gb \(37%\)|\'C:\\\\ Used Space\'=25\.29Gb;31\.92;35\.91;0\.00;39\.90''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVWEBREP - 9\.4;Drive E: Disk Usage;0;E:\\\\ - total: 91\.21 Gb - used: 0\.27 Gb \(0%\) - free 90\.94 Gb \(100%\)|\'E:\\\\ Used Space\'=0\.27Gb;71\.14;82\.09;0\.00;91\.21''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='DEVSTO01 - 211;Ping;0;OK - 192\.168\.50\.211: rta 0\.160ms, lost 0%|rta=0\.160ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=0\.262ms;;;; rtmin=0\.122ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='Sito Finance Evolution;Ping;0;OK - www\.finance-evolution\.it: rta 38\.421ms, lost 0%|rta=38\.421ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=46\.824ms;;;; rtmin=35\.689ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCECITRIX-23CAPB;Ping;0;OK - 10\.210\.13\.23: rta 14\.719ms, lost 0%|rta=14\.719ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=18\.431ms;;;; rtmin=13\.445ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.240;CPU Usage for VMHost;0;ESX3 OK - cpu usage=291\.00 MHz \(6\.26%\)|cpu_usagemhz=291\.00Mhz;; cpu_usage=6\.26%;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVCOGETO01 - 9\.3;Ping;0;OK - 10\.210\.9\.3: rta 14\.956ms, lost 0%|rta=14\.956ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=19\.258ms;;;; rtmin=12\.440ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVXBS4KL - 226;Drive E: Disk Usage;0;E:\\\\ - total: 49\.00 Gb - used: 26\.72 Gb \(55%\) - free 22\.28 Gb \(45%\)|\'E:\\\\ Used Space\'=26\.72Gb;44\.10;46\.55;0\.00;49\.00''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCESWAN-24CAPB;Drive E: Disk Usage;0;E:\\\\ - total: 9\.77 Gb - used: 0\.17 Gb \(2%\) - free 9\.60 Gb \(98%\)|\'E:\\\\ Used Space\'=0\.17Gb;7\.62;8\.30;0\.00;9\.77''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWICBP - 243;BARCLAYSDATA MSSQL Database Size;0;OK: Database size is 407552\.0KB|KB=407552\.0;1500000;2000000;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWICBP - 243;BARCLAYSDATAMSSQL Log File Usage;0;OK: Log File Usage is 2\.0%|log_file_usage=2\.0%;0:80;0:90;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='DEVSTO02 - 212;Ping;0;OK - 192\.168\.50\.212: rta 0\.187ms, lost 0%|rta=0\.187ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=0\.209ms;;;; rtmin=0\.166ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVSUPPORT - 188;Ping;0;OK - 192\.168\.50\.188: rta 0\.150ms, lost 0%|rta=0\.150ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=0\.264ms;;;; rtmin=0\.110ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='Finance E-Mail Server;Blacklist Status;0;Not black-listed|''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='Finance E-Mail Server;POP;0;POP OK - 0\.058 second response time on 217\.27\.90\.51 port 110|time=0\.057954s;;;0\.000000;10\.000000''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='NEWSRVXBS - 225;Drive E: Disk Usage;0;E:\\\\ - total: 39\.99 Gb - used: 16\.61 Gb \(42%\) - free 23\.38 Gb \(58%\)|\'E:\\\\ Used Space\'=16\.61Gb;31\.20;38\.00;0\.00;39\.99''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.220;Networking for VMHost;2;ESX3 CRITICAL - Error connecting to server at \'https://192\.168\.50\.220/sdk/webService\': Perhaps host is not a vCenter or ESX server|''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='Sito Finance Evolution;DNS Resolution;0;DNS OK: 0\.005 seconds response time\. www\.finance-evolution\.it returns 31\.11\.32\.195|time=0\.005344s;;;0\.000000''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCELIVE-21CAPB;Uptime;0;System Uptime - 21 day\(s\) 4 hour\(s\) 50 minute\(s\)|uptime=30530''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCETEST-101SIA;Ping;0;OK - 10\.210\.10\.101: rta 16\.672ms, lost 0%|rta=16\.672ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=19\.056ms;;;; rtmin=12\.731ms;;;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVWEBREP - 9\.4;CPU Usage;0;CPU Load 0% \(5 min average\)|\'5 min avg Load\'=0%;85;90;0;100''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVXBS4KL - 226;Memory Usage;0;Memory usage: total:16381\.45 MB - used: 1955\.41 MB \(12%\) - free: 14426\.05 MB \(88%\)|\'Memory usage\'=1955\.41MB;13924\.24;14743\.31;0\.00;16381\.45''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVWEBREP - 9\.4;Uptime;0;System Uptime - 77 day\(s\) 4 hour\(s\) 42 minute\(s\)|uptime=111162''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCELIVE-21CACEIS;Uptime;0;System Uptime - 82 day\(s\) 3 hour\(s\) 49 minute\(s\)|uptime=118309''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.220;Input / Output for VMHost;2;ESX3 CRITICAL - Error connecting to server at \'https://192\.168\.50\.220/sdk/webService\': Perhaps host is not a vCenter or ESX server|''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWICBP - 243;MSSQL Buffer Hit Ratio;0;OK: Buffer Cache Hit Ratio is 100\.0%|buffer_cache_hit_ratio=100\.0%;90:;95:;;''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305035), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='DEVSTO03 - 218;Check Synology Health;0;OK - Synology  \"RS812\+\" \(s/n: \"D7LDN01555\",  \"DSM 5\.2-5644\"\) is in good health|''
Jan 20 16:50:35 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:35 nagiosfe rsyslogd-2177: imuxsock begins to drop messages from pid 1732 due to rate-limiting
Jan 20 16:50:36 nagiosfe nagios: SERVICE ALERT: Finance E-Mail Server;SMTP;OK;SOFT;2;SMTP OK - 0.144 sec. response time
Jan 20 16:50:36 nagiosfe xinetd[1296]: EXIT: nsca status=0 pid=8534 duration=2(sec)
Jan 20 16:50:36 nagiosfe nagios: SERVICE ALERT: Finance E-Mail Server;SMTP;CRITICAL;SOFT;1;CRITICAL - Socket timeout after 10 seconds
Jan 20 16:50:37 nagiosfe rsyslogd-2177: imuxsock lost 1064 messages from pid 1732 due to rate-limiting
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCETEST-20CAPB;Ping;0;OK - 10\.210\.13\.20: rta 52\.288ms, lost 0%|rta=52\.288ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=134\.443ms;;;; rtmin=13\.226ms;;;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='NTB-MELCHIORRE;Drive C: Disk Usage;0;C:\\\\ - total: 72\.96 Gb - used: 47\.23 Gb \(65%\) - free 25\.74 Gb \(35%\)|\'C:\\\\ Used Space\'=47\.23Gb;65\.67;69\.32;0\.00;72\.96''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.160;SRVCITYPAY 2 Memory;0;ESX3 OK - \"SRVCITYPAY 2\" mem usage=3726\.88 MB\(0\.99%\), overhead=55\.07 MB, active=40\.96 MB, swapped=0\.00 MB, swapin=0\.00 MB, swapout=0\.00 MB|mem_usagemb=3726\.88MB;; mem_usage=0\.99%;; mem_overhead=55\.07MB;; mem_active=40\.96MB;; mem_swap=0\.00MB;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='NTB-MELCHIORRE;Drive D: Disk Usage;0;D:\\\\ - total: 72\.18 Gb - used: 30\.03 Gb \(42%\) - free 42\.15 Gb \(58%\)|\'D:\\\\ Used Space\'=30\.03Gb;64\.96;68\.57;0\.00;72\.18''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGCTO02 - 238;Ping;0;OK - 192\.168\.50\.238: rta 0\.354ms, lost 0%|rta=0\.354ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=0\.847ms;;;; rtmin=0\.211ms;;;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWUNIC - 253;Drive C: Disk Usage;0;C:\\\\ - total: 44\.90 Gb - used: 31\.01 Gb \(69%\) - free 13\.89 Gb \(31%\)|\'C:\\\\ Used Space\'=31\.01Gb;35\.02;40\.41;0\.00;44\.90''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVPRTO01 - 232;Ping;0;OK - 192\.168\.50\.232: rta 0\.111ms, lost 0%|rta=0\.111ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=0\.202ms;;;; rtmin=0\.070ms;;;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='NTB-MELCHIORRE;CPU Usage;0;CPU Load 13% \(5 min average\)|\'5 min avg Load\'=13%;85;90;0;100''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVCOGETO01 - 9\.3;Memory Usage;0;Memory usage: total:3398\.12 MB - used: 1029\.93 MB \(30%\) - free: 2368\.18 MB \(70%\)|\'Memory usage\'=1029\.93MB;2888\.40;3058\.31;0\.00;3398\.12''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='Sito Finance Evolution;DNS IP Match;0;DNS OK: 0\.006 seconds response time\. www\.finance-evolution\.it returns 31\.11\.32\.195|time=0\.005630s;;;0\.000000''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVADTO03 - 180;Drive E: Disk Usage;0;E:\\\\ - total: 10\.00 Gb - used: 0\.18 Gb \(2%\) - free 9\.82 Gb \(98%\)|\'E:\\\\ Used Space\'=0\.18Gb;7\.80;9\.50;0\.00;10\.00''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGCTO02 - 238;Memory Usage;0;Memory usage: total:2319\.90 MB - used: 871\.04 MB \(38%\) - free: 1448\.86 MB \(62%\)|\'Memory usage\'=871\.04MB;1971\.92;2087\.91;0\.00;2319\.90''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='Firewall Checkpoint;Ping;0;OK - 192\.168\.50\.254: rta 4\.978ms, lost 0%|rta=4\.978ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=6\.890ms;;;; rtmin=2\.095ms;;;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVKLSVN - 9\.2;Memory Usage;0;Memory usage: total:8189\.36 MB - used: 1367\.80 MB \(17%\) - free: 6821\.56 MB \(83%\)|\'Memory usage\'=1367\.80MB;6960\.96;7370\.43;0\.00;8189\.36''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.244;Port 8 Status;0;OK: Interface RMON Port 08 on unit 1 \(index 8\) is up\.|''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='NEWSRVXBS - 225;Uptime;0;System Uptime - 13 day\(s\) 5 hour\(s\) 30 minute\(s\)|uptime=19050''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.230;Input / Output for VMHost;0;ESX3 OK - io commands aborted=0, io bus resets=0, io read latency=0 ms, write latency=0 ms, kernel latency=0 ms, device latency=0 ms, queue latency=0 ms|io_aborted=0;; io_busresets=0;; io_read=0ms;; io_write=0ms;; io_kernel=0ms;; io_device=0ms;; io_queue=0ms;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWICBP - 243;BARCLAYSDATAMSSQL Log Growths;0;OK: Log Growths is 0\.0|log_growths=0\.0;20;30;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.240;Datastore usage for VMHost;0;ESX3 OK - storages : srvmto03\.storage=34958\.00 MB \(24\.17%\), 218 - Datastore=3376347\.91 MB \(60\.08%\), Storage 211=1156935\.35 MB \(43\.24%\)|srvmto03\.storage=34958\.00MB;; \'218 - Datastore\'=3376347\.91MB;; \'Storage 211\'=1156935\.35MB;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.160;Input / Output for VMHost;0;ESX3 OK - io commands aborted=0, io bus resets=0, io read latency=0 ms, write latency=0 ms, kernel latency=0 ms, device latency=0 ms, queue latency=0 ms|io_aborted=0;; io_busresets=0;; io_read=0ms;; io_write=0ms;; io_kernel=0ms;; io_device=0ms;; io_queue=0ms;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.220;VM Status for VMHost;2;ESX3 CRITICAL - Error connecting to server at \'https://192\.168\.50\.220/sdk/webService\': Perhaps host is not a vCenter or ESX server|''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWICBP - 243;BARCLAYSDATAMSSQL Log Shrinks;0;OK: Log Shrinks is 0\.0|log_shrinks=0\.0;20;30;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVCRONOS01 - 210;Drive C: Disk Usage;0;C:\\\\ - total: 29\.99 Gb - used: 24\.96 Gb \(83%\) - free 5\.03 Gb \(17%\)|\'C:\\\\ Used Space\'=24\.96Gb;25\.49;26\.99;0\.00;29\.99''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVCOGETO01 - 9\.3;Drive E: Disk Usage;0;E:\\\\ - total: 40\.00 Gb - used: 7\.01 Gb \(18%\) - free 32\.99 Gb \(82%\)|\'E:\\\\ Used Space\'=7\.01Gb;31\.20;36\.00;0\.00;40\.00''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCEWEB-103SIA;Drive C: Disk Usage;0;C:\\\\ - total: 39\.90 Gb - used: 30\.74 Gb \(77%\) - free 9\.16 Gb \(23%\)|\'C:\\\\ Used Space\'=30\.74Gb;31\.12;33\.92;0\.00;39\.90''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCECITRIX - 237;Uptime;0;System Uptime - 1 day\(s\) 2 hour\(s\) 39 minute\(s\)|uptime=1599''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.244;Port 8 Bandwidth;0;OK - Current BW in: \.13Mbps Out: \.07Mbps|in=\.139093Mb/s;50\.00;80\.00 out=\.076392Mb/s;50\.00;80\.00''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='NEWSRVXBS - 225;CPU Usage;0;CPU Load 0% \(5 min average\)|\'5 min avg Load\'=0%;85;90;0;100''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.230;VM Status for VMHost;0;ESX3 OK - 6/7 VMs up, overall status=green, connection state=connected, maintenance=no, 125 health issue\(s\), 2 config issue\(s\)|vmcount=6units;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGTWICBP - 243;Drive E: Disk Usage;0;E:\\\\ - total: 30\.00 Gb - used: 12\.68 Gb \(42%\) - free 17\.32 Gb \(58%\)|\'E:\\\\ Used Space\'=12\.68Gb;25\.50;27\.00;0\.00;30\.00''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVPRTO01 - 232;Drive G: Disk Usage;0;G:\\\\ - total: 14\.99 Gb - used: 9\.63 Gb \(64%\) - free 5\.36 Gb \(36%\)|\'G:\\\\ Used Space\'=9\.63Gb;11\.69;13\.49;0\.00;14\.99''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.200;Networking for VMHost;0;ESX3 OK - net receive=0\.00 KB/s, send=10\.00 KB/s, all 2 NICs are connected|net_receive=0\.00KB;; net_send=10\.00KB;; OK_NICs=2;; Bad_NICs=0;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVCRONOS01 - 210;Ping;0;OK - 192\.168\.50\.210: rta 0\.230ms, lost 0%|rta=0\.230ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=0\.374ms;;;; rtmin=0\.168ms;;;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='KFINANCEWEB-103SIA;Memory Usage;0;Memory usage: total:8189\.39 MB - used: 1601\.11 MB \(20%\) - free: 6588\.28 MB \(80%\)|\'Memory usage\'=1601\.11MB;6960\.98;7370\.45;0\.00;8189\.39''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVGCTO02 - 238;Uptime;0;System Uptime - 110 day\(s\) 1 hour\(s\) 22 minute\(s\)|uptime=158482''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='SRVADTO03 - 180;DNS Resolution - 192\.168\.50\.180;0;DNS OK: 0\.005 seconds response time\. 192\.168\.50\.180 returns srvadto03\.finance\.com\.|time=0\.005354s;;;0\.000000''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
Jan 20 16:50:37 nagiosfe ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_externalcommands SET instance_id='1', command_type='30', entry_time=FROM_UNIXTIME(1453305036), command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='192\.168\.50\.240;Networking for VMHost;0;ESX3 OK - net receive=6\.00 KB/s, send=35\.00 KB/s, all 2 NICs are connected|net_receive=6\.00KB;; net_send=35\.00KB;; OK_NICs=2;; Bad_NICs=0;;''
Jan 20 16:50:37 nagiosfe ndo2db: mysql_error: 'Table './nagios/nagios_externalcommands' is marked as crashed and last (automatic?) repair failed'
I have 8k+ lines similar to this.
I saw in some other sites that Mysql is blocking the Alerts of Nagios XI, because it make Nagios XI Busy.
Top
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:
Contact hsmith

Re: Nagios XI Don't Send E-Mail

Post by hsmith »

Maybe we should try to manually repair the database.

Code: Select all

service nagios stop
service mysqld stop
myisamchk -r -f /var/lib/mysql/nagios/*.MYI
myisamchk -r -f /var/lib/mysql/mysql/*.MYI
myisamchk -r -f /var/lib/mysql/nagiosql/*.MYI
service mysqld start
service nagios start
Let's see what that does.
Former Nagios Employee.
me.
Top
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Nagios XI Don't Send E-Mail

Post by Bone8Head »

hsmith wrote:Maybe we should try to manually repair the database.

Code: Select all

service nagios stop
service mysqld stop
myisamchk -r -f /var/lib/mysql/nagios/*.MYI
myisamchk -r -f /var/lib/mysql/mysql/*.MYI
myisamchk -r -f /var/lib/mysql/nagiosql/*.MYI
service mysqld start
service nagios start
Let's see what that does.
After yesterday (I did what you write), I don't see anymore issues report in the messages file in /var/log/ about mysql.
That's the mysql.log file:

Code: Select all

160120 21:58:12 [Note] Event Scheduler: Purging the queue. 0 events
160120 21:58:14  InnoDB: Starting shutdown...
160120 21:58:18  InnoDB: Shutdown completed; log sequence number 0 236094
160120 21:58:18 [Note] /usr/libexec/mysqld: Shutdown complete

160120 21:58:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160120 23:28:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160120 23:28:22  InnoDB: Initializing buffer pool, size = 8.0M
160120 23:28:22  InnoDB: Completed initialization of buffer pool
160120 23:28:25  InnoDB: Started; log sequence number 0 236094
160120 23:28:26 [Note] Event Scheduler: Loaded 0 events
160120 23:28:26 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160121  8:39:26 [Note] /usr/libexec/mysqld: Normal shutdown

160121  8:39:26 [Note] Event Scheduler: Purging the queue. 0 events
160121  8:39:28  InnoDB: Starting shutdown...
160121  8:39:32  InnoDB: Shutdown completed; log sequence number 0 236790
160121  8:39:32 [Note] /usr/libexec/mysqld: Shutdown complete

160121 08:39:32 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160121 08:40:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160121  8:40:48  InnoDB: Initializing buffer pool, size = 8.0M
160121  8:40:48  InnoDB: Completed initialization of buffer pool
160121  8:40:48  InnoDB: Started; log sequence number 0 236790
160121  8:40:49 [Note] Event Scheduler: Loaded 0 events
160121  8:40:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
And I think that's ok now.

That's the messages file right now:

Code: Select all

Jan 21 08:46:09 nagiosfe xinetd[1251]: START: nsca pid=9678 from=::ffff:192.168.50.168
Jan 21 08:46:10 nagiosfe xinetd[1251]: START: nsca pid=9692 from=::ffff:192.168.50.168
Jan 21 08:46:10 nagiosfe xinetd[1251]: EXIT: nsca status=0 pid=9454 duration=6(sec)
Jan 21 08:46:10 nagiosfe nagios: SERVICE ALERT: SRVGTWICBP - 243;gtway_citypayMSSQL Transactions / Sec;CRITICAL;SOFT;1;CRITICAL: Transactions Per Second is -6.5348606098/sec
Jan 21 08:46:10 nagiosfe xinetd[1251]: EXIT: nsca status=0 pid=9678 duration=1(sec)
Jan 21 08:46:11 nagiosfe nagios: SERVICE ALERT: SRVGTWICBP - 243;MSSQL Lock Requests Per Sec;OK;SOFT;2;OK: Lock Requests / Sec is 64.4101416668/sec
Jan 21 08:46:11 nagiosfe nagios: SERVICE ALERT: SRVGTWICBP - 243;MSSQL Page Reads Per Sec;OK;SOFT;2;OK: Page Reads / Sec is 0.0/sec
Jan 21 08:46:11 nagiosfe nagios: SERVICE ALERT: SRVGTWICBP - 243;gtway_citypayMSSQL Transactions / Sec;OK;SOFT;2;OK: Transactions Per Second is 0.118326400581/sec
Jan 21 08:46:11 nagiosfe nagios: SERVICE ALERT: NTB-MELCHIORRE;Drive D: Disk Usage;CRITICAL;SOFT;1;connect to address 192.168.50.1 and port 12489: No route to host
Jan 21 08:46:11 nagiosfe nagios: SERVICE ALERT: NTB-MELCHIORRE;CPU Usage;CRITICAL;SOFT;1;connect to address 192.168.50.1 and port 12489: No route to host
Jan 21 08:46:11 nagiosfe nagios: SERVICE ALERT: NTB-MELCHIORRE;Drive D: Disk Usage;CRITICAL;SOFT;2;connect to address 192.168.50.1 and port 12489: No route to host
Jan 21 08:46:12 nagiosfe nagios: SERVICE ALERT: NTB-MELCHIORRE;Drive D: Disk Usage;OK;SOFT;3;D:\ - total: 72.18 Gb - used: 30.04 Gb (42%) - free 42.14 Gb (58%)
Jan 21 08:46:12 nagiosfe nagios: SERVICE ALERT: NTB-MELCHIORRE;CPU Usage;OK;SOFT;2;CPU Load 15% (5 min average)
Jan 21 08:46:13 nagiosfe nagios: SERVICE ALERT: SRVGTWICBP - 243;GTWAY_DBMSSQL Transactions / Sec;UNKNOWN;SOFT;1;DB-Lib error message 20009, severity 9:
Jan 21 08:46:13 nagiosfe xinetd[1251]: EXIT: nsca status=0 pid=9692 duration=3(sec)
Jan 21 08:46:13 nagiosfe nagios: SERVICE ALERT: NTB-MELCHIORRE;Ping;CRITICAL;SOFT;1;CRITICAL - 192.168.50.1: Host unreachable @ 192.168.50.168. rta nan, lost 100%
Jan 21 08:46:13 nagiosfe nagios: SERVICE ALERT: NTB-MELCHIORRE;CPU Usage;CRITICAL;SOFT;1;connect to address 192.168.50.1 and port 12489: No route to host
Jan 21 08:46:14 nagiosfe nagios: SERVICE ALERT: SRVGTWICBP - 243;GTWAY_DBMSSQL Transactions / Sec;OK;SOFT;2;OK: Transactions Per Second is 0.108928212583/sec
I think that the file is normal now. There are the Service Alert, etc.

The problem is that Nagios is not sending Alerts again...I tried to re-put Sendmail (it was SMTP), but nothing changed.
I tried to reboot 2 times Nagios XI, but it's the same
Top
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Nagios XI Don't Send E-Mail

Post by Bone8Head »

That's the maillog file in /var/log/ (I just replaced the E-Mail domain with xxx.com)

Code: Select all

Jan 21 07:02:13 nagiosfe sendmail[6519]: u0L62B6f006519: from=root, size=4553, class=0, nrcpts=1, msgid=<[email protected]>, relay=root@localhost
Jan 21 07:02:33 nagiosfe sendmail[6567]: u0L62DHJ006567: from=<[email protected]>, size=4828, class=0, nrcpts=1, msgid=<[email protected]>, proto=ESMTP, daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Jan 21 07:02:33 nagiosfe sendmail[6519]: u0L62B6f006519: to=root, ctladdr=root (0/0), delay=00:00:22, xdelay=00:00:20, mailer=relay, pri=34553, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (u0L62DHJ006567 Message accepted for delivery)
Jan 21 07:02:35 nagiosfe sendmail[6617]: u0L62DHJ006567: to=<[email protected]>, ctladdr=<[email protected]> (0/0), delay=00:00:21, xdelay=00:00:02, mailer=local, pri=35054, dsn=2.0.0, stat=Sent
Jan 21 08:00:02 nagiosfe sendmail[18850]: u0L701aQ018850: from=root, size=412, class=0, nrcpts=1, msgid=<[email protected]>, relay=root@localhost
Jan 21 08:00:02 nagiosfe sendmail[18901]: u0L702w9018901: from=<[email protected]>, size=687, class=0, nrcpts=1, msgid=<[email protected]>, proto=ESMTP, daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Jan 21 08:00:02 nagiosfe sendmail[18850]: u0L701aQ018850: to=root, ctladdr=root (0/0), delay=00:00:01, xdelay=00:00:00, mailer=relay, pri=30412, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (u0L702w9018901 Message accepted for delivery)
Jan 21 08:00:02 nagiosfe sendmail[18908]: u0L702w9018901: to=<[email protected]>, ctladdr=<[email protected]> (0/0), delay=00:00:00, xdelay=00:00:00, mailer=local, pri=30913, dsn=2.0.0, stat=Sent
Jan 21 08:40:49 nagiosfe sendmail[1464]: starting daemon (8.14.4): SMTP+queueing@01:00:00
Jan 21 08:40:49 nagiosfe sm-msp-queue[1473]: starting daemon (8.14.4): queueing@01:00:00
Jan 21 08:48:11 nagiosfe sendmail[12132]: u0L7m9Hs012132: Authentication-Warning: localhost.localdomain: apache set sender to [email protected] using -f
Jan 21 08:48:20 nagiosfe sendmail[12132]: u0L7m9Hs012132: [email protected], size=893, class=0, nrcpts=1, msgid=<[email protected]>, relay=apache@localhost
Jan 21 08:48:24 nagiosfe sendmail[12262]: u0L7mLu3012262: from=<[email protected]>, size=1093, class=0, nrcpts=1, msgid=<[email protected]>, proto=ESMTP, daemon=MTA, relay=localhost.localdomain [127.0.0.1]
Jan 21 08:48:24 nagiosfe sendmail[12132]: u0L7m9Hs012132: [email protected], [email protected] (48/48), delay=00:00:15, xdelay=00:00:03, mailer=relay, pri=30893, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (u0L7mLu3012262 Message accepted for delivery)
Jan 21 08:48:25 nagiosfe sendmail[12412]: u0L7mLu3012262: to=<[email protected]>, delay=00:00:03, xdelay=00:00:01, mailer=esmtp, pri=121093, relay=mx1.xxx.com. [217.27.90.51], dsn=2.0.0, stat=Sent (Ok: queued as 5A93446D08)
Top
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:
Contact hsmith

Re: Nagios XI Don't Send E-Mail

Post by hsmith »

Nagios thinks that it was sent just fine by looking at that log. I think it might be time to check mail logs, if that's something you have access to view.
Former Nagios Employee.
me.
Top
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Nagios XI Don't Send E-Mail

Post by Bone8Head »

hsmith wrote:Nagios thinks that it was sent just fine by looking at that log. I think it might be time to check mail logs, if that's something you have access to view.
I can't, but maybe I can request it.
Do you think that our Provider blocks it, or something like that?
But why it doesn't block the Test Mails?
Top
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:
Contact hsmith

Re: Nagios XI Don't Send E-Mail

Post by hsmith »

There may be a certain keyword/phrase that it is looking for on your providers side? Sendmail is often blocked, SMTP is much less often blocked. Try using sendmail, and setting the recipient address to a gmail address. Sendmail will show up in your spam folder, but at least it will show up. This would be a good test of whether or not your emails are making it out.
Former Nagios Employee.
me.
Top
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Nagios XI Don't Send E-Mail

Post by Bone8Head »

hsmith wrote:There may be a certain keyword/phrase that it is looking for on your providers side? Sendmail is often blocked, SMTP is much less often blocked. Try using sendmail, and setting the recipient address to a gmail address. Sendmail will show up in your spam folder, but at least it will show up. This would be a good test of whether or not your emails are making it out.
Unfortunately, Nagios is not sending E-Mail...to my account, and I tried with 2 Gmail accounts with Sendmail-SNMP but Nothing (I checked all Spam folders, etc).
I don't know..
Top
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:
Contact hsmith

Re: Nagios XI Don't Send E-Mail

Post by hsmith »

Only the test email will send then?

Can you go to the Admin Page, and see if you have any checkmarks that are not green under system status?
Former Nagios Employee.
me.
Top
Locked

Return to “Nagios XI”