<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII"> <meta name=Generator content="Microsoft Word 11 (filtered medium)">  <style>  </style> </head> <body lang=EN-US link=blue vlink=purple> <div class=Section1> All,<o:p></o:p> <o:p> </o:p> nagios with mysql is now working great.<o:p></o:p> <o:p> </o:p> I noticed the following error in my apache error log:<o:p></o:p> <o:p> </o:p> [Mon Sep 13 11:11:18 2004] [notice] Accept mutex: fcntl (Default: fcntl)<o:p></o:p> ld.so.1: tac.cgi: fatal: libmysqlclient.so.14: open failed: No such file or dire<o:p></o:p> ctory<o:p></o:p> [Mon Sep 13 11:11:28 2004] [error] [client 135.116.141.207] Premature end of scr<o:p></o:p> ipt headers: /usr/local/nagios/sbin/tac.cgi<o:p></o:p> ld.so.1: status.cgi: fatal: libmysqlclient.so.14: open failed: No such file or d<o:p></o:p> irectory<o:p></o:p> [Mon Sep 13 11:11:30 2004] [error] [client 135.116.141.207] Premature end of scr<o:p></o:p> ipt headers: /usr/local/nagios/sbin/status.cgi<o:p></o:p> ld.so.1: tac.cgi: fatal: libmysqlclient.so.14: open failed: No such file or dire<o:p></o:p> ctory<o:p></o:p> [Mon Sep 13 11:11:32 2004] [error] [client 135.116.141.207] Premature end of scr<o:p></o:p> ipt headers: /usr/local/nagios/sbin/tac.cgi<o:p></o:p> [Mon Sep 13 11:23:46 2004] [notice] SIGHUP received. Attempting to restart<o:p></o:p> [Mon Sep 13 11:23:46 2004] [notice] Apache/1.3.31 (Unix) mod_ssl/2.8.19 OpenSSL/<o:p></o:p> 0.9.7d configured -- resuming normal operations<o:p></o:p> [Mon Sep 13 11:23:46 2004] [notice] Accept mutex: fcntl (Default: fcntl)<o:p></o:p> ld.so.1: tac.cgi: fatal: libmysqlclient.so.14: open failed: No such file or dire<o:p></o:p> ctory<o:p></o:p> <o:p> </o:p> The fix was to add the following to my httpd.conf file:<o:p></o:p> LoadModule env_module libexec/mod_env.so<o:p></o:p> AddModule mod_env.c<o:p></o:p> <IfModule mod_env.c><o:p></o:p> SetEnv LD_LIBRARY_PATH /usr/local/lib/mysql:/usr/local/lib:/usr/lib<o:p></o:p> </IfModule><o:p></o:p> <o:p> </o:p> Bill<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center tabindex=-1> </div> From: Winkles, William (Bill) [mailto:billwinkles@lucent.com] Sent: Monday, September 13, 2004 10:26 AM To: nagios-devel@lists.sourceforge.net Subject: [Nagios-devel] Nagios and mysql config files<o:p></o:p> </div> <o:p> </o:p> Can anyone send me some working Nagios config files that are setup for mysql --with-mysql-xdata support?<o:p></o:p> <o:p> </o:p> 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.<o:p></o:p> <o:p> </o:p> 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.<o:p></o:p> <o:p> </o:p> Thanks.<o:p></o:p> <o:p> </o:p> Bill<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> </div> </body> </html>