Page 1 of 1
ndo.sock
Posted: Mon Jan 16, 2017 4:41 pm
by kcarlson
Hello
Was having issues previously with ndo2db not running and my dashboard showing the database backend not running as well. After going through troubleshooting steps was told to remove /usr/local/nagios/var/ndo.sock. Came in today to the same issue as before with no resolve until once again removing this file and restarting the service. I was wondering if this is going to be something I will have to do periodically from now on.
Thanks!
Re: ndo.sock
Posted: Mon Jan 16, 2017 5:06 pm
by rkennedy
I believe it's just a graphical error for the database backend if you're on 5.4, can you please post /usr/local/nagiosxi/var/xi-sys.cfg for us to look at?
Additionally, are you using mysql or mariadb? mysql -V will tell us.
Re: ndo.sock
Posted: Tue Jan 17, 2017 8:53 am
by kcarlson
I am on 5.4
Code: Select all
apachegroup='apache'
apacheuser='apache'
chownbin='/bin/chown'
groupaddbin='/usr/sbin/groupadd'
groupdelbin='/usr/sbin/groupdel'
htpasswdbin='/usr/bin/htpasswd'
httpdconfdir='/etc/httpd/conf.d'
httpdconf='/etc/httpd/conf/httpd.conf'
httpdroot='/var/www/html'
httpd='httpd'
ntpd='ntpd'
crond='crond'
mkdirbin='/bin/mkdir'
mrtgcfg='/etc/mrtg/mrtg.cfg'
mysqld='mariadb'
mysqlpass='nagiosxi'
pgsqlrootpass='postgres'
pgsqlpass='nagiosxi'
nagioscmdgroup='nagcmd'
nagiosgroup='nagios'
nagiosuser='nagios'
nagioswebpwd='nagiosadmin'
nagioswebuser='nagiosadmin'
phpconfd='/etc/php.d'
phpini='/etc/php.ini'
proddir='/usr/local/nagiosxi'
useraddbin='/usr/sbin/useradd'
usermodbin='/usr/sbin/usermod'
userdelbin='/usr/sbin/userdel'
mibsdir='/usr/share/snmp/mibs'
phpconfdcli='/etc/php.d'
cfg__base_url='/nagiosxi'
cfg__root_dir='/usr/local/nagiosxi'
cfg__script_dir='/usr/local/nagiosxi/scripts'
cfg__xidpe_dir='/usr/local/nagios/var/spool/xidpe/'
cfg__perfdata_spool='/usr/local/nagios/var/spool/perfdata/'
cfg__nom_checkpoints_dir='/usr/local/nagiosxi/nom/checkpoints/nagioscore/'
cfg__use_https=0
cfg__port_number=0
cfg__dbtype=''
cfg__dbserver='localhost'
cfg__db_conn_persistent=1
cfg__db_info__nagiosxi__dbtype='mysql'
cfg__db_info__nagiosxi__dbserver=''
cfg__db_info__nagiosxi__user='nagiosxi'
cfg__db_info__nagiosxi__pwd='n@gweb'
cfg__db_info__nagiosxi__db='nagiosxi'
cfg__db_info__nagiosxi__dbmaint__max_auditlog_age=30
cfg__db_info__nagiosxi__dbmaint__max_commands_age=480
cfg__db_info__nagiosxi__dbmaint__max_events_age=480
cfg__db_info__nagiosxi__dbmaint__optimize_interval=60
cfg__db_info__nagiosxi__dbmaint__repair_interval=0
cfg__db_info__ndoutils__dbtype='mysql'
cfg__db_info__ndoutils__dbserver='localhost'
cfg__db_info__ndoutils__user='ndoutils'
cfg__db_info__ndoutils__pwd='n@gweb'
cfg__db_info__ndoutils__db='nagios'
cfg__db_info__ndoutils__dbmaint__max_externalcommands_age=7
cfg__db_info__ndoutils__dbmaint__max_logentries_age=90
cfg__db_info__ndoutils__dbmaint__max_statehistory_age=730
cfg__db_info__ndoutils__dbmaint__max_notifications_age=90
cfg__db_info__ndoutils__dbmaint__max_timedevents_age=5
cfg__db_info__ndoutils__dbmaint__max_systemcommands_age=5
cfg__db_info__ndoutils__dbmaint__max_servicechecks_age=5
cfg__db_info__ndoutils__dbmaint__max_hostchecks_age=5
cfg__db_info__ndoutils__dbmaint__max_eventhandlers_age=5
cfg__db_info__ndoutils__dbmaint__optimize_interval=60
cfg__db_info__ndoutils__dbmaint__repair_interval=0
cfg__db_info__nagiosql__dbtype='mysql'
cfg__db_info__nagiosql__dbserver='localhost'
cfg__db_info__nagiosql__user='nagiosql'
cfg__db_info__nagiosql__pwd='n@gweb'
cfg__db_info__nagiosql__db='nagiosql'
cfg__db_info__nagiosql__dbmaint__max_logbook_age=480
cfg__db_info__nagiosql__dbmaint__optimize_interval=60
cfg__db_info__nagiosql__dbmaint__repair_interval=0
cfg__db_prefix__ndoutils='nagios_'
cfg__db_prefix__nagiosxi='xi_'
cfg__db_prefix__nagiosql='tbl_'
cfg__component_info__nagioscore__cgi_dir='/usr/local/nagios/sbin'
cfg__component_info__nagioscore__import_dir='/usr/local/nagios/etc/import'
cfg__component_info__nagioscore__plugin_dir='/usr/local/nagios/libexec'
cfg__component_info__nagioscore__cgi_config_file='/usr/local/nagios/etc/cgi.cfg'
cfg__component_info__nagioscore__cmd_file='/usr/local/nagios/var/rw/nagios.cmd'
cfg__component_info__nagioscore__log_file='/usr/local/nagios/var/nagios.log'
cfg__component_info__nagioscore__nom_checkpoint_interval=1440
cfg__component_info__pnp__perfdata_dir='/usr/local/nagios/share/perfdata'
cfg__component_info__pnp__share_dir='/usr/local/nagios/share/pnp'
cfg__component_info__pnp__direct_url='/nagios/pnp'
cfg__component_info__pnp__username='nagiosxi'
cfg__component_info__pnp__password='nagiosadmin'
cfg__component_info__perfdata__rrdtool_path='/usr/bin/rrdtool'
cfg__component_info__nagiosql__dir='/var/www/html/nagiosql'
cfg__component_info__nagiosql__direct_url='/nagiosql'
cfg__component_info__nagiosql__username='nagiosxi'
cfg__component_info__nagiosql__password='n@gweb'
cfg__component_info__nagvis__share_dir='/usr/local/nagios/share/nagvis'
cfg__component_info__nagvis__direct_url='/nagios/nagvis'
cfg__component_info__nagvis__username='nagiosadmin'
cfg__component_info__nagvis__password='nagiosadmin'
cfg__demo_mode=0
cfg__dashlet_refresh_multiplier=1000
cfg__dashlet_refresh_rates__available_updates=86400
cfg__dashlet_refresh_rates__systat_eventqueuechart=5
cfg__dashlet_refresh_rates__sysstat_monitoringstats=30
cfg__dashlet_refresh_rates__systat_monitoringperf=30
cfg__dashlet_refresh_rates__sysstat_monitoringproc=30
cfg__dashlet_refresh_rates__perfdata_chart=60
cfg__dashlet_refresh_rates__network_outages=30
cfg__dashlet_refresh_rates__host_status_summary=60
cfg__dashlet_refresh_rates__service_status_summary=60
cfg__dashlet_refresh_rates__hostgroup_status_overview=60
cfg__dashlet_refresh_rates__hostgroup_status_grid=60
cfg__dashlet_refresh_rates__servicegroup_status_overview=60
cfg__dashlet_refresh_rates__servicegroup_status_grid=60
cfg__dashlet_refresh_rates__hostgroup_status_summary=60
cfg__dashlet_refresh_rates__servicegroup_status_summary=60
cfg__dashlet_refresh_rates__sysstat_componentstates=7
cfg__dashlet_refresh_rates__sysstat_serverstats=5
cfg__dashlet_refresh_rates__network_outages_summary=30
cfg__dashlet_refresh_rates__network_health=30
cfg__dashlet_refresh_rates__host_status_tac_summary=30
cfg__dashlet_refresh_rates__service_status_tac_summary=30
cfg__dashlet_refresh_rates__feature_status_tac_summary=30
cfg__dashlet_refresh_rates__admin_tasks=60
cfg__dashlet_refresh_rates__getting_started=60
cfg__dashlet_refresh_rates__pagetop_alert_content=30
cfg__dashlet_refresh_rates__tray_alert=30
cfg__memcached_enable=0
cfg__memcached_hosts__0='127.0.0.1'
cfg__memcached_hosts__1='192.168.1.3'
cfg__memcached_port=11211
cfg__memcached_compress=0
cfg__memcached_ttl=10
cfg__use_basic_authentication=0
cfg__subsystem_basic_auth_username='nagiosxi'
cfg__subsystem_basic_auth_password='somepassword'
cfg__default_language='en_US'
cfg__default_theme=''
cfg__languages__en_US='English'
cfg__default_instance_id=1
cfg__default_result_records=100000
cfg__online_help_url='https://support.nagios.com/'
cfg__feedback_url='https://api.nagios.com/feedback/'
cfg__privacy_policy_url='https://www.nagios.com/legal/privacypolicy/'
cfg__db_version=113
cfg__subsystem_ticket='12345'
cfg__htaccess_file='/usr/local/nagiosxi/etc/htpasswd.users'
cfg__htpasswd_path='/usr/bin/htpasswd'
cfg__enable_analytics=1
xiver='5.4.0'
distro='CentOS'
version='7.2.1511'
ver='7'
architecture='x86_64'
dist='el7'
arch='x86_64'
php_extension_dir='/usr/lib64/php/modules'
cfg__base_url='/nagiosxi'
cfg__root_dir='/usr/local/nagiosxi'
cfg__script_dir='/usr/local/nagiosxi/scripts'
cfg__xidpe_dir='/usr/local/nagios/var/spool/xidpe/'
cfg__perfdata_spool='/usr/local/nagios/var/spool/perfdata/'
cfg__nom_checkpoints_dir='/usr/local/nagiosxi/nom/checkpoints/nagioscore/'
cfg__use_https=0
cfg__port_number=0
cfg__dbtype=''
cfg__dbserver='localhost'
cfg__db_conn_persistent=1
cfg__db_info__nagiosxi__dbtype='mysql'
cfg__db_info__nagiosxi__dbserver=''
cfg__db_info__nagiosxi__user='nagiosxi'
cfg__db_info__nagiosxi__pwd='n@gweb'
cfg__db_info__nagiosxi__db='nagiosxi'
cfg__db_info__nagiosxi__dbmaint__max_auditlog_age=30
cfg__db_info__nagiosxi__dbmaint__max_commands_age=480
cfg__db_info__nagiosxi__dbmaint__max_events_age=480
cfg__db_info__nagiosxi__dbmaint__optimize_interval=60
cfg__db_info__nagiosxi__dbmaint__repair_interval=0
cfg__db_info__ndoutils__dbtype='mysql'
cfg__db_info__ndoutils__dbserver='localhost'
cfg__db_info__ndoutils__user='ndoutils'
cfg__db_info__ndoutils__pwd='n@gweb'
cfg__db_info__ndoutils__db='nagios'
cfg__db_info__ndoutils__dbmaint__max_externalcommands_age=7
cfg__db_info__ndoutils__dbmaint__max_logentries_age=90
cfg__db_info__ndoutils__dbmaint__max_statehistory_age=730
cfg__db_info__ndoutils__dbmaint__max_notifications_age=90
cfg__db_info__ndoutils__dbmaint__max_timedevents_age=5
cfg__db_info__ndoutils__dbmaint__max_systemcommands_age=5
cfg__db_info__ndoutils__dbmaint__max_servicechecks_age=5
cfg__db_info__ndoutils__dbmaint__max_hostchecks_age=5
cfg__db_info__ndoutils__dbmaint__max_eventhandlers_age=5
cfg__db_info__ndoutils__dbmaint__optimize_interval=60
cfg__db_info__ndoutils__dbmaint__repair_interval=0
cfg__db_info__nagiosql__dbtype='mysql'
cfg__db_info__nagiosql__dbserver='localhost'
cfg__db_info__nagiosql__user='nagiosql'
cfg__db_info__nagiosql__pwd='n@gweb'
cfg__db_info__nagiosql__db='nagiosql'
cfg__db_info__nagiosql__dbmaint__max_logbook_age=480
cfg__db_info__nagiosql__dbmaint__optimize_interval=60
cfg__db_info__nagiosql__dbmaint__repair_interval=0
cfg__db_prefix__ndoutils='nagios_'
cfg__db_prefix__nagiosxi='xi_'
cfg__db_prefix__nagiosql='tbl_'
cfg__component_info__nagioscore__cgi_dir='/usr/local/nagios/sbin'
cfg__component_info__nagioscore__import_dir='/usr/local/nagios/etc/import'
cfg__component_info__nagioscore__plugin_dir='/usr/local/nagios/libexec'
cfg__component_info__nagioscore__cgi_config_file='/usr/local/nagios/etc/cgi.cfg'
cfg__component_info__nagioscore__cmd_file='/usr/local/nagios/var/rw/nagios.cmd'
cfg__component_info__nagioscore__log_file='/usr/local/nagios/var/nagios.log'
cfg__component_info__nagioscore__nom_checkpoint_interval=1440
cfg__component_info__pnp__perfdata_dir='/usr/local/nagios/share/perfdata'
cfg__component_info__pnp__share_dir='/usr/local/nagios/share/pnp'
cfg__component_info__pnp__direct_url='/nagios/pnp'
cfg__component_info__pnp__username='nagiosxi'
cfg__component_info__pnp__password='nagiosadmin'
cfg__component_info__perfdata__rrdtool_path='/usr/bin/rrdtool'
cfg__component_info__nagiosql__dir='/var/www/html/nagiosql'
cfg__component_info__nagiosql__direct_url='/nagiosql'
cfg__component_info__nagiosql__username='nagiosxi'
cfg__component_info__nagiosql__password='n@gweb'
cfg__component_info__nagvis__share_dir='/usr/local/nagios/share/nagvis'
cfg__component_info__nagvis__direct_url='/nagios/nagvis'
cfg__component_info__nagvis__username='nagiosadmin'
cfg__component_info__nagvis__password='nagiosadmin'
cfg__demo_mode=0
cfg__dashlet_refresh_multiplier=1000
cfg__dashlet_refresh_rates__available_updates=86400
cfg__dashlet_refresh_rates__systat_eventqueuechart=5
cfg__dashlet_refresh_rates__sysstat_monitoringstats=30
cfg__dashlet_refresh_rates__systat_monitoringperf=30
cfg__dashlet_refresh_rates__sysstat_monitoringproc=30
cfg__dashlet_refresh_rates__perfdata_chart=60
cfg__dashlet_refresh_rates__network_outages=30
cfg__dashlet_refresh_rates__host_status_summary=60
cfg__dashlet_refresh_rates__service_status_summary=60
cfg__dashlet_refresh_rates__hostgroup_status_overview=60
cfg__dashlet_refresh_rates__hostgroup_status_grid=60
cfg__dashlet_refresh_rates__servicegroup_status_overview=60
cfg__dashlet_refresh_rates__servicegroup_status_grid=60
cfg__dashlet_refresh_rates__hostgroup_status_summary=60
cfg__dashlet_refresh_rates__servicegroup_status_summary=60
cfg__dashlet_refresh_rates__sysstat_componentstates=7
cfg__dashlet_refresh_rates__sysstat_serverstats=5
cfg__dashlet_refresh_rates__network_outages_summary=30
cfg__dashlet_refresh_rates__network_health=30
cfg__dashlet_refresh_rates__host_status_tac_summary=30
cfg__dashlet_refresh_rates__service_status_tac_summary=30
cfg__dashlet_refresh_rates__feature_status_tac_summary=30
cfg__dashlet_refresh_rates__admin_tasks=60
cfg__dashlet_refresh_rates__getting_started=60
cfg__dashlet_refresh_rates__pagetop_alert_content=30
cfg__dashlet_refresh_rates__tray_alert=30
cfg__memcached_enable=0
cfg__memcached_hosts__0='127.0.0.1'
cfg__memcached_hosts__1='192.168.1.3'
cfg__memcached_port=11211
cfg__memcached_compress=0
cfg__memcached_ttl=10
cfg__use_basic_authentication=0
cfg__subsystem_basic_auth_username='nagiosxi'
cfg__subsystem_basic_auth_password='somepassword'
cfg__default_language='en_US'
cfg__default_theme=''
cfg__languages__en_US='English'
cfg__default_instance_id=1
cfg__default_result_records=100000
cfg__online_help_url='https://support.nagios.com/'
cfg__feedback_url='https://api.nagios.com/feedback/'
cfg__privacy_policy_url='https://www.nagios.com/legal/privacypolicy/'
cfg__db_version=113
cfg__subsystem_ticket='12345'
cfg__htaccess_file='/usr/local/nagiosxi/etc/htpasswd.users'
cfg__htpasswd_path='/usr/bin/htpasswd'
cfg__enable_analytics=1
make_j_flag='16
mariadb
Code: Select all
[root@nagios var]# mysql -V
mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1
Re: ndo.sock
Posted: Tue Jan 17, 2017 12:30 pm
by avandemore
The answer is no, manually removing the file in not normal. Do you have a reference ticket or thread?
Re: ndo.sock
Posted: Tue Jan 17, 2017 12:34 pm
by kcarlson
Here is the original thread that I opened on this issue. On page 2 it was suggested that I remove that file.
https://support.nagios.com/forum/viewto ... 16&t=41830
Re: ndo.sock
Posted: Tue Jan 17, 2017 2:10 pm
by dwhitfield
kcarlson wrote:I was wondering if this is going to be something I will have to do periodically from now on.
If I understand your issue correctly, this is being fixed in 5.4.1. I linked to
https://support.nagios.com/forum/viewto ... 0&start=30 in the thread you linked to, but the additional about the fix was added on Jan 5 (rather than Jan 4). I do not have an ETA on 5.4.1 other than "soon".
Re: ndo.sock
Posted: Thu Jan 19, 2017 9:36 am
by kcarlson
Thank you, this answers my question. I believe this thread can be locked now.
Re: ndo.sock
Posted: Thu Jan 19, 2017 11:33 am
by rkennedy
Going to lock this one up. Feel free to make a new thread if you have questions in the future.