How can I put data into mysql?

[Javier Garcia]

Hi Leung,

please, show the error mensage writed in nagios.log. Nevertheless, you can
try the following:

Are you sure that you can connetc with your data base?
 Try, mysql -u nagios -p yourdb

are you sure that nagios is your user in mysql?

The onwer of cgi.cfg file (and maybe of the others) must be the user onwer
of the nagios process. You can see that making a top in your system when
nagios is up. Typically, the user is nagios. After that, you have to
change the permisions, type  chmod 600 cgi.cfg

I hope that this help

j.

----
Javier Garcia
SuSE Linux C.A.
jgarcia at suse.com.ve
0416-4703388


On Wed, 14 Apr 2004, LEUNG Wing Yee 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.
>
> Regards,
> Mil
>
>
>  
>
>
> -------------------------------------------------------
> 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_id=1470&alloc_id=3638&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
>



-------------------------------------------------------
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