Nagios and mysql config files

[Winkles, William (Bill)]

All,

 

nagios with mysql is now working great.

 

I noticed the following error in my apache error log:

 

[Mon Sep 13 11:11:18 2004] [notice] Accept mutex: fcntl (Default: fcntl)

ld.so.1: tac.cgi: fatal: libmysqlclient.so.14: open failed: No such file or
dire

ctory

[Mon Sep 13 11:11:28 2004] [error] [client 135.116.141.207] Premature end of
scr

ipt headers: /usr/local/nagios/sbin/tac.cgi

ld.so.1: status.cgi: fatal: libmysqlclient.so.14: open failed: No such file
or d

irectory

[Mon Sep 13 11:11:30 2004] [error] [client 135.116.141.207] Premature end of
scr

ipt headers: /usr/local/nagios/sbin/status.cgi

ld.so.1: tac.cgi: fatal: libmysqlclient.so.14: open failed: No such file or
dire

ctory

[Mon Sep 13 11:11:32 2004] [error] [client 135.116.141.207] Premature end of
scr

ipt headers: /usr/local/nagios/sbin/tac.cgi

[Mon Sep 13 11:23:46 2004] [notice] SIGHUP received.  Attempting to restart

[Mon Sep 13 11:23:46 2004] [notice] Apache/1.3.31 (Unix) mod_ssl/2.8.19
OpenSSL/

0.9.7d configured -- resuming normal operations

[Mon Sep 13 11:23:46 2004] [notice] Accept mutex: fcntl (Default: fcntl)

ld.so.1: tac.cgi: fatal: libmysqlclient.so.14: open failed: No such file or
dire

ctory

 

The fix was to add the following to my httpd.conf file:

LoadModule env_module         libexec/mod_env.so

AddModule mod_env.c

<IfModule mod_env.c>

        SetEnv LD_LIBRARY_PATH /usr/local/lib/mysql:/usr/local/lib:/usr/lib

</IfModule>

 

Bill

 

 

 

  _____  

From: Winkles, William (Bill) [mailto:billwinkles at lucent.com] 
Sent: Monday, September 13, 2004 10:26 AM
To: nagios-devel at lists.sourceforge.net
Subject: [Nagios-devel] Nagios and mysql config files

 

Can anyone send me some working Nagios config files that are setup for mysql
--with-mysql-xdata support?

 

I have successfully compiled Nagios with mysql.  I created the db and tables
in mysql, and I can see the hostname of the device I added to the Nagios cfg
files in the mysql db.  It shows up in several tables, such as hostname,
hoststatus, and service status.  Everything looks fine in the Nagios.log
file and I think it is working.

 

I can load Nagios in my browser, but none of the cgi scripts work.  Not sure
what is going wrong here, but would like to look at some working cfg files
for this type of setup.  Any other suggestions are appreciated.

 

Thanks.

 

Bill

 

 

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20040913/bc8f9b42/attachment.html>