How can I put data into mysql?

[Marc Powell]

LEUNG Wing Yee <mailto:010465845 at stu.vtc.edu.hk> wrote:
> Dear All,
> 
> I successfully compiled Nagios with mysql support.
> And I made a few changes in the configuration files.
> Then I created 12 tables using the  scripts given in
> /contrib/database. 
> 
> (1)I added the following lines in cgi.cfg:
> xsddb_host=localhost
> xsddb_port=3306
> xsddb_database=mydb
> xsddb_username=nagios
> xsddb_password=nagios
> 
> (2)I added the following lines in resource.cfg:
> xsddb_host=localhost
> xsddb_port=3306
> xsddb_database=mydb
> xsddb_username=nagios
> xsddb_password=nagios
> xsddb_optimize_data=1
> 
> (3)I commented this line in resource.cfg:
> # downtime_file=/usr/local/nagios/var/downtime.log
> # comment_file=/usr/local/nagios/var/comment.log
> # status_file=/usr/local/nagios/var/status.log
> ....
> 
> But there is no data in the tables. Have I missed any important steps?
> Please help. Thanks very much.


If you only want status data in mysql then that should be it. Are the
tables owned/writable by the nagios user? Is there anything informative
in either nagios.log or mysql's logs? What configure switches did you
use? Did you specify database support for _only_ status data?

--
Marc


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
_______________________________________________
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