Page 1 of 2
Restarted server and got OID generation failed (DBD ERROR:
Posted: Mon May 11, 2015 2:36 pm
by gdolidze
So i restarted the server and all the oracle DB server had alerts coming up all saying this error
OID generation failed (DBD ERROR: OCISessionBegin)
I also noticed this error in the logs
2015-05-11 13:26:09ndomod: Error writing to data sink! Some output may get lost...
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:02 pm
by ssax
Post the output of these commands:
Post or PM me the content of your /etc/hosts.
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:05 pm
by gdolidze
you want the outputs from nagios server or the DB clients?
On the nagios server /etc/hosts is empty as in default
ndo2db us running and
hostname is nagiosxi.cfjh.org
Nagios log says this
ndomod: Error writing to data sink! Some output may get lost...
ndomod: Please check remote ndo2db log, database connection or SSL Parameters
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:22 pm
by ssax
/etc/hosts should have:
Code: Select all
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
If that's not in there, add it and restart nagios and ndo2db.
Code: Select all
service nagios stop
service ndo2db restart
service nagios start
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:25 pm
by gdolidze
ya that is the only thing in hosts
when i did ndo2db i got cannot open /usr/local/nagios/var/ndo2db.lock for reading: no such file or directory
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:26 pm
by lmiltchev
Is MySQL local or offloaded to a remote server? Can you show us the "/usr/local/nagios/etc/ndo2db.cfg" file? Hide sensitive info.
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:30 pm
by gdolidze
everything is remote.
Code: Select all
ck_file=/usr/local/nagios/var/ndo2db.lock
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/usr/local/nagios/var/ndo.sock
tcp_port=5668
db_servertype=mysql
db_host=localhost
db_port=3306
db_name=nagios
db_prefix=nagios_
db_user=ndoutils
db_pass=n@gweb
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:43 pm
by jdalrymple
gdolidze wrote:everything is remote.
This indicates otherwise:
Are you sure?
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:44 pm
by gdolidze
I am monitoring remote server which have DB on it.
after a simple restart i got this error, i tried restoring but didn't work.
Re: Restarted server and got OID generation failed (DBD ERR
Posted: Mon May 11, 2015 3:55 pm
by jdalrymple
I'd be alarmed about how the configuration got changed. This is the document that outlines the process of offloading the db:
http://assets.nagios.com/downloads/nagi ... Server.pdf
I would review all the parts of that document before making any change, and furthermore I'd make a close analysis to identify why the problem came up in the first place. Rebooting a server shouldn't make changes to a cfg file.