Nagios Support Forum

Posted: **Tue Sep 22, 2015 2:08 pm**

I have a Centos v7 server, fresh install. I have been building nagios core from scratch.

I have Nagios 4 up and running with nagios-4.1.1 and v 2.1.1 of the plugins. No issues there.

I downloaded ndoutils-2.0.0.tar.gz and compilied. Basically, I looked at a lot of doc, but this is roughly the recipe I followed http://joesteinkamp.com/setting-up-ndou ... on-centos/

I have the database created and installdb did run but I got an error about not finding nagios_dbversion, but a "show tables;" did show the table listed. and the rest of the script completed.

however, now when I start the service, I get the following error. I feel like I checked every path and password multiple times.

Code: Select all

nagios]# /usr/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg 
Support for the specified database server is either not yet supported, or was not found on your system.

I could use a little advice on where to go next. Thanks.

below is the output of the ndo2db and ndomod cfg's and my.cnf.

Code: Select all

# cat /usr/local/nagios/etc/ndo2db.cfg | grep -v \^\# | grep -v \^\$
lock_file=/var/run/nagios/ndo2db.lock
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/var/run/nagios/ndo.sock
tcp_port=5668
use_ssl=0
db_servertype=mysql
db_host=localhost
db_port=3306                                                                                       
db_name=nagios                                                                                     
db_prefix=nagios_                                                                                  
db_user=ndouser                                                                                    
db_pass=ndoPa55w0rd                                                                                
max_timedevents_age=1440                                                                           
max_systemcommands_age=10080                                                                       
max_servicechecks_age=10080                                                                                              
max_hostchecks_age=10080                                                                                                                                                                                   
max_eventhandlers_age=44640                                                                                                                                                                                                  
max_externalcommands_age=44640                                                                                                                                                                                                                   
max_notifications_age=44640                                                                                                                                                                                                                      
max_contactnotifications=44640                                                                                                                                                                                                                           
max_contactnotificationmethods=44640                                                                                                                                                                                                                                  
max_logentries_age=129600                                                                                                                                                                                                                                             
max_acknowledgements_age=44640                                                                                                                                                                                                                                                 
debug_level=0                                                                                                                                                                                                                                                                  
debug_verbosity=1                                                                                                                                                                                                                                                              
debug_file=/var/run/nagios/ndo2db.debug                                                                                                                                                                                                                                        
max_debug_file_size=1000000

Code: Select all

# cat /usr/local/nagios/etc/ndomod.cfg | grep -v \^\# | grep -v \^\$                                                                                                                                                                                  
instance_name=default                                                                                                                                                                                                                                                          
output_type=unixsocket                                                                                                                                                                                                                                                         
output=/var/run/nagios/ndo.sock                                                                                                                                                                                                                                                
tcp_port=5668                                                                                                                                                                                                                                                                  
use_ssl=0                                                                                                                                                                                                                                                                      
output_buffer_items=5000                                                                                                                                                                                                                                                       
buffer_file=/var/run/nagios/ndomod.tmp                                                                                                                                                                                                                                         
file_rotation_interval=14400                                                                                                                                                                                                                                                   
file_rotation_timeout=60                                                                                                                                                                                                                                                       
reconnect_interval=15                                                                                                                                                                                                                                                          
reconnect_warning_interval=15                                                                                                                                                                                                                                                  
acknowledgement_data=1
adaptive_contact_data=1
adaptive_host_data=1
adaptive_program_data=1
adaptive_service_data=1
aggregated_status_data=1
comment_data=1
contact_status_data=1
downtime_data=1
event_handler_data=1
external_command_data=1
flapping_data=1
host_check_data=1
host_status_data=1
log_data=1
main_config_data=1
notification_data=1
object_config_data=1
process_data=1
program_status_data=1
retention_data=1
service_check_data=1
service_status_data=1
statechange_data=1
system_command_data=1
timed_event_data=1
config_output_options=2

Code: Select all

# cat my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

Posted: **Tue Sep 22, 2015 3:17 pm**

In ndo2db let's adjust some stuff.

Code: Select all

db_host=127.0.0.1
debug_level=1
debug_verbosity=1

Then let's see what pops up in your debug file. Make sure /var/run/nagios exists and is writable by the nagios user.

Posted: **Tue Sep 22, 2015 3:36 pm**

for fun, recreated database, here are the results when I run installdb

Code: Select all

# ./installdb -u ndouser -p ndoPa55w0rd -d nagios -h localhost
DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist at ./installdb line 51.                                                                                                                                                                                
** Creating tables for version 2.0.1                                                                                                                                                                                                                                           
     Using mysql.sql for installation...                                                                                                                                                                                                                                       
** Updating table nagios_dbversion                                                                                                                                                                                                                                             
Done!

Code: Select all

# ls -alh /var/run/nagios
total 296K
drwxr-xr-x  2 nagios nagios   60 Sep 22 14:22 .
drwxr-xr-x 39 root   root   1.2K Sep 22 14:13 ..
-rw-r--r--  1 nagios nagios 294K Sep 22 14:22 ndomod.tmp

Code: Select all

cat ndo2db.cfg | grep -v \^\# | grep -v \^\$
lock_file=/var/run/nagios/ndo2db.lock
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/var/run/nagios/ndo.sock
tcp_port=5668
use_ssl=0
db_servertype=mysql
db_host=127.0.0.1
db_port=3306
db_name=nagios
db_prefix=nagios_
db_user=ndouser
db_pass=ndoPa55w0rd
max_timedevents_age=1440
max_systemcommands_age=10080
max_servicechecks_age=10080
max_hostchecks_age=10080
max_eventhandlers_age=44640
max_externalcommands_age=44640
max_notifications_age=44640
max_contactnotifications=44640
max_contactnotificationmethods=44640
max_logentries_age=129600
max_acknowledgements_age=44640
debug_level=1
debug_verbosity=1
debug_file=/var/run/nagios/ndo2db.debug
max_debug_file_size=1000000

Code: Select all

# /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg 
Support for the specified database server is either not yet supported, or was not found on your system.

Posted: **Tue Sep 22, 2015 3:39 pm**

forgot to add when I try to start ndo2db I get no debug log file

Code: Select all

# /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg 
Support for the specified database server is either not yet supported, or was not found on your system.
# ls /var/run/nagios/
#

Posted: **Wed Sep 23, 2015 10:58 am**

Can you run the following commands and post the output so we can review it?

Code: Select all

echo 'show tables;' | mysql -t -u ndouser -pndoPa55w0rd nagios
ll /var/lib/mysql
ll /var/lib/mysql/nagios
tail -50 /var/log/mariadb/mariadb.log

Thanks

Posted: **Tue Sep 29, 2015 3:54 pm**

tgriep wrote:Can you run the following commands and post the output so we can review it?
Code: Select all
echo 'show tables;' | mysql -t -u ndouser -pndoPa55w0rd nagios
ll /var/lib/mysql
ll /var/lib/mysql/nagios
tail -50 /var/log/mariadb/mariadb.log
Thanks

Here is the requested information, Thanks.

Code: Select all

[root@localhost mariadb]# echo 'show tables;' | mysql -t -u ndouser -pndoPa555555w0rd nagios
+----------------------------------------+
| Tables_in_nagios                       |
+----------------------------------------+
| nagios_acknowledgements                |
| nagios_commands                        |
| nagios_commenthistory                  |
| nagios_comments                        |
| nagios_configfiles                     |
| nagios_configfilevariables             |
| nagios_conninfo                        |
| nagios_contact_addresses               |
| nagios_contact_notificationcommands    |
| nagios_contactgroup_members            |
| nagios_contactgroups                   |
| nagios_contactnotificationmethods      |
| nagios_contactnotifications            |
| nagios_contacts                        |
| nagios_contactstatus                   |
| nagios_customvariables                 |
| nagios_customvariablestatus            |
| nagios_dbversion                       |
| nagios_downtimehistory                 |
| nagios_eventhandlers                   |
| nagios_externalcommands                |
| nagios_flappinghistory                 |
| nagios_host_contactgroups              |
| nagios_host_contacts                   |
| nagios_host_parenthosts                |
| nagios_hostchecks                      |
| nagios_hostdependencies                |
| nagios_hostescalation_contactgroups    |
| nagios_hostescalation_contacts         |
| nagios_hostescalations                 |
| nagios_hostgroup_members               |
| nagios_hostgroups                      |
| nagios_hosts                           |
| nagios_hoststatus                      |
| nagios_instances                       |
| nagios_logentries                      |
| nagios_notifications                   |
| nagios_objects                         |
| nagios_processevents                   |
| nagios_programstatus                   |
| nagios_runtimevariables                |
| nagios_scheduleddowntime               |
| nagios_service_contactgroups           |
| nagios_service_contacts                |
| nagios_service_parentservices          |
| nagios_servicechecks                   |
| nagios_servicedependencies             |
| nagios_serviceescalation_contactgroups |
| nagios_serviceescalation_contacts      |
| nagios_serviceescalations              |
| nagios_servicegroup_members            |
| nagios_servicegroups                   |
| nagios_services                        |
| nagios_servicestatus                   |
| nagios_statehistory                    |
| nagios_systemcommands                  |
| nagios_timedeventqueue                 |
| nagios_timedevents                     |
| nagios_timeperiod_timeranges           |
| nagios_timeperiods                     |
+----------------------------------------+
[root@localhost mariadb]# ll /var/lib/mysql
total 28712
-rw-rw----. 1 mysql mysql    16384 Sep 22 16:27 aria_log.00000001
-rw-rw----. 1 mysql mysql       52 Sep 22 16:27 aria_log_control
-rw-rw----. 1 mysql mysql 18874368 Sep 22 16:27 ibdata1
-rw-rw----. 1 mysql mysql  5242880 Sep 22 16:27 ib_logfile0
-rw-rw----. 1 mysql mysql  5242880 Sep 18 17:42 ib_logfile1
drwx------. 2 mysql mysql     4096 Sep 18 17:42 mysql
srwxrwxrwx  1 mysql mysql        0 Sep 22 16:27 mysql.sock
drwx------  2 mysql mysql     8192 Sep 22 16:24 nagios
drwx------. 2 mysql mysql     4096 Sep 18 17:42 performance_schema
[root@localhost mariadb]# ll /var/lib/mysql/nagios
total 988
-rw-rw---- 1 mysql mysql    65 Sep 22 15:43 db.opt
-rw-rw---- 1 mysql mysql  9100 Sep 22 16:24 nagios_acknowledgements.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_acknowledgements.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_acknowledgements.MYI
-rw-rw---- 1 mysql mysql  8746 Sep 22 16:24 nagios_commands.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_commands.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_commands.MYI
-rw-rw---- 1 mysql mysql  9340 Sep 22 16:24 nagios_commenthistory.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_commenthistory.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_commenthistory.MYI
-rw-rw---- 1 mysql mysql  9220 Sep 22 16:24 nagios_comments.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_comments.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_comments.MYI
-rw-rw---- 1 mysql mysql  8726 Sep 22 16:24 nagios_configfiles.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_configfiles.MYD
-rw-rw---- 1 mysql mysql  2048 Sep 22 16:24 nagios_configfiles.MYI
-rw-rw---- 1 mysql mysql  8760 Sep 22 16:24 nagios_configfilevariables.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_configfilevariables.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_configfilevariables.MYI
-rw-rw---- 1 mysql mysql  9262 Sep 22 16:24 nagios_conninfo.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_conninfo.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_conninfo.MYI
-rw-rw---- 1 mysql mysql  8760 Sep 22 16:24 nagios_contact_addresses.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contact_addresses.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_contact_addresses.MYI
-rw-rw---- 1 mysql mysql  8748 Sep 22 16:24 nagios_contactgroup_members.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contactgroup_members.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_contactgroup_members.MYI
-rw-rw---- 1 mysql mysql  8768 Sep 22 16:24 nagios_contactgroups.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contactgroups.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_contactgroups.MYI
-rw-rw---- 1 mysql mysql  8856 Sep 22 16:24 nagios_contact_notificationcommands.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contact_notificationcommands.MYD
-rw-rw---- 1 mysql mysql  2048 Sep 22 16:24 nagios_contact_notificationcommands.MYI
-rw-rw---- 1 mysql mysql  9000 Sep 22 16:24 nagios_contactnotificationmethods.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contactnotificationmethods.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_contactnotificationmethods.MYI
-rw-rw---- 1 mysql mysql  8928 Sep 22 16:24 nagios_contactnotifications.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contactnotifications.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_contactnotifications.MYI
-rw-rw---- 1 mysql mysql 10026 Sep 22 16:24 nagios_contacts.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contacts.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_contacts.MYI
-rw-rw---- 1 mysql mysql  9240 Sep 22 16:24 nagios_contactstatus.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_contactstatus.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_contactstatus.MYI
-rw-rw---- 1 mysql mysql  8844 Sep 22 16:24 nagios_customvariables.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_customvariables.MYD
-rw-rw---- 1 mysql mysql  2048 Sep 22 16:24 nagios_customvariables.MYI
-rw-rw---- 1 mysql mysql  8870 Sep 22 16:24 nagios_customvariablestatus.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_customvariablestatus.MYD
-rw-rw---- 1 mysql mysql  2048 Sep 22 16:24 nagios_customvariablestatus.MYI
-rw-rw---- 1 mysql mysql  8596 Sep 22 16:24 nagios_dbversion.frm
-rw-rw---- 1 mysql mysql    20 Sep 22 16:24 nagios_dbversion.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:27 nagios_dbversion.MYI
-rw-rw---- 1 mysql mysql  9490 Sep 22 16:24 nagios_downtimehistory.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_downtimehistory.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_downtimehistory.MYI
-rw-rw---- 1 mysql mysql  9380 Sep 22 16:24 nagios_eventhandlers.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_eventhandlers.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_eventhandlers.MYI
-rw-rw---- 1 mysql mysql  8812 Sep 22 16:24 nagios_externalcommands.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_externalcommands.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_externalcommands.MYI
-rw-rw---- 1 mysql mysql  9166 Sep 22 16:24 nagios_flappinghistory.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_flappinghistory.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_flappinghistory.MYI
-rw-rw---- 1 mysql mysql  9660 Sep 22 16:24 nagios_hostchecks.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hostchecks.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hostchecks.MYI
-rw-rw---- 1 mysql mysql  8738 Sep 22 16:24 nagios_host_contactgroups.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_host_contactgroups.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_host_contactgroups.MYI
-rw-rw---- 1 mysql mysql  8718 Sep 22 16:24 nagios_host_contacts.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_host_contacts.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_host_contacts.MYI
-rw-rw---- 1 mysql mysql  9108 Sep 22 16:24 nagios_hostdependencies.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hostdependencies.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hostdependencies.MYI
-rw-rw---- 1 mysql mysql  8778 Sep 22 16:24 nagios_hostescalation_contactgroups.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hostescalation_contactgroups.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hostescalation_contactgroups.MYI
-rw-rw---- 1 mysql mysql  8758 Sep 22 16:24 nagios_hostescalation_contacts.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hostescalation_contacts.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hostescalation_contacts.MYI
-rw-rw---- 1 mysql mysql  9148 Sep 22 16:24 nagios_hostescalations.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hostescalations.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hostescalations.MYI
-rw-rw---- 1 mysql mysql  8730 Sep 22 16:24 nagios_hostgroup_members.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hostgroup_members.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hostgroup_members.MYI
-rw-rw---- 1 mysql mysql  8756 Sep 22 16:24 nagios_hostgroups.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hostgroups.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hostgroups.MYI
-rw-rw---- 1 mysql mysql  8732 Sep 22 16:24 nagios_host_parenthosts.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_host_parenthosts.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_host_parenthosts.MYI
-rw-rw---- 1 mysql mysql 16028 Sep 22 16:24 nagios_hosts.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hosts.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_hosts.MYI
-rw-rw---- 1 mysql mysql 19464 Sep 22 16:24 nagios_hoststatus.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_hoststatus.MYD
-rw-rw---- 1 mysql mysql  2048 Sep 22 16:24 nagios_hoststatus.MYI
-rw-rw---- 1 mysql mysql  8684 Sep 22 16:24 nagios_instances.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_instances.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_instances.MYI
-rw-rw---- 1 mysql mysql  8972 Sep 22 16:24 nagios_logentries.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_logentries.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_logentries.MYI
-rw-rw---- 1 mysql mysql  9168 Sep 22 16:24 nagios_notifications.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_notifications.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_notifications.MYI
-rw-rw---- 1 mysql mysql  8766 Sep 22 16:24 nagios_objects.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_objects.MYD
-rw-rw---- 1 mysql mysql  2048 Sep 22 16:24 nagios_objects.MYI
-rw-rw---- 1 mysql mysql  8948 Sep 22 16:24 nagios_processevents.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_processevents.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_processevents.MYI
-rw-rw---- 1 mysql mysql 10174 Sep 22 16:24 nagios_programstatus.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_programstatus.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_programstatus.MYI
-rw-rw---- 1 mysql mysql  8706 Sep 22 16:24 nagios_runtimevariables.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_runtimevariables.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_runtimevariables.MYI
-rw-rw---- 1 mysql mysql  9332 Sep 22 16:24 nagios_scheduleddowntime.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_scheduleddowntime.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_scheduleddowntime.MYI
-rw-rw---- 1 mysql mysql  9626 Sep 22 16:24 nagios_servicechecks.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_servicechecks.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_servicechecks.MYI
-rw-rw---- 1 mysql mysql  8750 Sep 22 16:24 nagios_service_contactgroups.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_service_contactgroups.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_service_contactgroups.MYI
-rw-rw---- 1 mysql mysql  8730 Sep 22 16:24 nagios_service_contacts.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_service_contacts.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_service_contacts.MYI
-rw-rw---- 1 mysql mysql  9178 Sep 22 16:24 nagios_servicedependencies.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_servicedependencies.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_servicedependencies.MYI
-rw-rw---- 1 mysql mysql  8790 Sep 22 16:24 nagios_serviceescalation_contactgroups.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_serviceescalation_contactgroups.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_serviceescalation_contactgroups.MYI
-rw-rw---- 1 mysql mysql  8770 Sep 22 16:24 nagios_serviceescalation_contacts.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_serviceescalation_contacts.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_serviceescalation_contacts.MYI
-rw-rw---- 1 mysql mysql  9220 Sep 22 16:24 nagios_serviceescalations.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_serviceescalations.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_serviceescalations.MYI
-rw-rw---- 1 mysql mysql  8748 Sep 22 16:24 nagios_servicegroup_members.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_servicegroup_members.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_servicegroup_members.MYI
-rw-rw---- 1 mysql mysql  8768 Sep 22 16:24 nagios_servicegroups.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_servicegroups.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_servicegroups.MYI
-rw-rw---- 1 mysql mysql  8756 Sep 22 16:24 nagios_service_parentservices.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_service_parentservices.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_service_parentservices.MYI
-rw-rw---- 1 mysql mysql 11766 Sep 22 16:24 nagios_services.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_services.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_services.MYI
-rw-rw---- 1 mysql mysql 19544 Sep 22 16:24 nagios_servicestatus.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_servicestatus.MYD
-rw-rw---- 1 mysql mysql  2048 Sep 22 16:24 nagios_servicestatus.MYI
-rw-rw---- 1 mysql mysql  9174 Sep 22 16:24 nagios_statehistory.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_statehistory.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_statehistory.MYI
-rw-rw---- 1 mysql mysql  9110 Sep 22 16:24 nagios_systemcommands.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_systemcommands.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_systemcommands.MYI
-rw-rw---- 1 mysql mysql  8914 Sep 22 16:24 nagios_timedeventqueue.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_timedeventqueue.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_timedeventqueue.MYI
-rw-rw---- 1 mysql mysql  9104 Sep 22 16:24 nagios_timedevents.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_timedevents.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_timedevents.MYI
-rw-rw---- 1 mysql mysql  8760 Sep 22 16:24 nagios_timeperiods.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_timeperiods.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_timeperiods.MYI
-rw-rw---- 1 mysql mysql  8794 Sep 22 16:24 nagios_timeperiod_timeranges.frm
-rw-rw---- 1 mysql mysql     0 Sep 22 16:24 nagios_timeperiod_timeranges.MYD
-rw-rw---- 1 mysql mysql  1024 Sep 22 16:24 nagios_timeperiod_timeranges.MYI
[root@localhost mariadb]# tail -n 50 /var/log/mariadb/mariadb.log 
150922 11:27:35 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150922 13:46:20 [Note] /usr/libexec/mysqld: Normal shutdown

150922 13:46:20 [Note] Event Scheduler: Purging the queue. 0 events
150922 13:46:20  InnoDB: Starting shutdown...
150922 13:46:21  InnoDB: Shutdown completed; log sequence number 1597981
150922 13:46:21 [Note] /usr/libexec/mysqld: Shutdown complete

150922 13:46:21 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150922 13:48:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150922 13:48:58 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 2011 ...
150922 13:48:58 InnoDB: The InnoDB memory heap is disabled
150922 13:48:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150922 13:48:58 InnoDB: Compressed tables use zlib 1.2.7
150922 13:48:58 InnoDB: Using Linux native AIO
150922 13:48:58 InnoDB: Initializing buffer pool, size = 128.0M
150922 13:48:58 InnoDB: Completed initialization of buffer pool
150922 13:48:58 InnoDB: highest supported file format is Barracuda.
150922 13:48:59  InnoDB: Waiting for the background threads to start
150922 13:49:00 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 1597981
150922 13:49:00 [Note] Plugin 'FEEDBACK' is disabled.
150922 13:49:00 [Note] Server socket created on IP: '0.0.0.0'.
150922 13:49:00 [Note] Event Scheduler: Loaded 0 events
150922 13:49:00 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
150922 16:27:07 [Note] /usr/libexec/mysqld: Normal shutdown

150922 16:27:07 [Note] Event Scheduler: Purging the queue. 0 events
150922 16:27:07  InnoDB: Starting shutdown...
150922 16:27:08  InnoDB: Shutdown completed; log sequence number 1597991
150922 16:27:08 [Note] /usr/libexec/mysqld: Shutdown complete

150922 16:27:08 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150922 16:27:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150922 16:27:09 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 12191 ...
150922 16:27:09 InnoDB: The InnoDB memory heap is disabled
150922 16:27:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150922 16:27:09 InnoDB: Compressed tables use zlib 1.2.7
150922 16:27:09 InnoDB: Using Linux native AIO
150922 16:27:09 InnoDB: Initializing buffer pool, size = 128.0M
150922 16:27:09 InnoDB: Completed initialization of buffer pool
150922 16:27:09 InnoDB: highest supported file format is Barracuda.
150922 16:27:09  InnoDB: Waiting for the background threads to start
150922 16:27:10 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 1597991
150922 16:27:10 [Note] Plugin 'FEEDBACK' is disabled.
150922 16:27:10 [Note] Server socket created on IP: '0.0.0.0'.
150922 16:27:10 [Note] Event Scheduler: Loaded 0 events
150922 16:27:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
[root@localhost mariadb]#

Posted: **Tue Sep 29, 2015 4:28 pm**

One thing to try is to edit the ndo2db.cfg file and change the following from

Code: Select all

db_host=127.0.0.1

to

Code: Select all

db_host=localhost

To see if that helps out.

Also, could you post your /etc/my.cnf file so we can review it?
Thanks

Nagios Support Forum

NDOUTILS 2.0.0 cannot start

NDOUTILS 2.0.0 cannot start

Re: NDOUTILS 2.0.0 cannot start

Re: NDOUTILS 2.0.0 cannot start

Re: NDOUTILS 2.0.0 cannot start

Re: NDOUTILS 2.0.0 cannot start

Re: NDOUTILS 2.0.0 cannot start

Re: NDOUTILS 2.0.0 cannot start