Mysql tables are empty

[Nathan]

Dear All,

I have the following setup:
- Fedora core 5
- Nagios 2.5
- Mysql 5.0.22
- Apache 2.0

What I did and results:
- Nagios, Apache, cgi worked fine with log file system
- Successfully compiled Nagios with mysql support, this what I did,
./configure --prefix=/usr/local/nagios --with-cgiurl=/nagios/cgi-bin --with-
htmurl=/nagios/ --with-nagios-user=nagios --with-nagios-group=nagios --with-
command-group=nagios --with-mysql-status
- I have created 12 tables, followed the script under contrib dir
- I have verified mysql works fine, the tables are there, and entered some  
  sample data manually
- I modified the cgi.cfg, resource.cfg and nagios.cfg as below.
(1)I added the followings to cgi.cfg:
   xsddb_host=localhost
   xsddb_port=3306
   xsddb_database=nagios
   xsddb_username=root
   xsddb_password=nagios
(2)I added the followings to resource.cfg:
   xsddb_host=localhost
   xsddb_port=3306
   xsddb_database=nagios
   xsddb_username=root
   xsddb_password=nagios
   xsddb_optimize_data=1
   xsddb_optimize_interval=1

(3)I commented out the following lines in nagios.cfg:
   # downtime_file=/usr/local/nagios/var/downtime.dat
   # comment_file=/usr/local/nagios/var/comments.dat
   # status_file=/usr/local/nagios/var/status.dat

- I turned on debuggin with "--enable-DEBUG5", and there is not a single  
  mysql related actions

My problem and questions:
- I started Nagios, and checked the tables, all are empty
- I noticed that the log file(status.dat) is still get updated even after I 
  commented out in the nagios.cfg file, WHY ?
- Does the nagios distribution have mysql interface functions like, 
mysql_connect and so, on because my "find" utility could not locate any of 
those interface functions.
- Have I missed anything to enable looging into mysql
- DO I need to tweak any privilages, or settings
- What files contain the implementation of the interface to mysql

Please help me to understand the mystery of Nagios-mysql. your help is 
greately appreciated, thanks in advance,

Nathan.


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null