Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

Nagios XI Don't Send E-Mail

https://support.nagios.com/forum/viewtopic.php?t=36566

Page 2 of 7

Re: Nagios XI Don't Send E-Mail

Posted: Wed Jan 20, 2016 10:51 am
by rkennedy
I also notice the 'skip' button is clicked by the notifications, did someone else change any of the configuration?

Re: Nagios XI Don't Send E-Mail

Posted: Wed Jan 20, 2016 10:54 am
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.

Re: Nagios XI Don't Send E-Mail

Posted: Wed Jan 20, 2016 12:13 pm
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.

Re: Nagios XI Don't Send E-Mail

Posted: Thu Jan 21, 2016 2:49 am
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

Re: Nagios XI Don't Send E-Mail

Posted: Thu Jan 21, 2016 2:56 am
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)

Re: Nagios XI Don't Send E-Mail

Posted: Thu Jan 21, 2016 10:12 am
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.

Re: Nagios XI Don't Send E-Mail

Posted: Thu Jan 21, 2016 11:20 am
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?

Re: Nagios XI Don't Send E-Mail

Posted: Thu Jan 21, 2016 11:23 am
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.

Re: Nagios XI Don't Send E-Mail

Posted: Sat Jan 23, 2016 4:11 pm
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..

Re: Nagios XI Don't Send E-Mail

Posted: Mon Jan 25, 2016 10:52 am
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?
All times are UTC-05:00
Page 2 of 7

Powered by phpBB® Forum Software © phpBB Limited