Nagios and mysql config files
Winkles, William (Bill)
billwinkles at lucent.com
Mon Sep 13 21:39:39 CEST 2004
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>
More information about the Developers
mailing list