DB support

[Jason Martin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You need to grant the nagios user the 'lock table' privilege on all of 
it's tables in MySQL.

- -Jason Martin

On Tue, 18 Nov 2003, Jared Brick wrote:

> Hello,
> 
> I'm trying to set up Nagios 1.1 with mysql db support and nagmin 2.0.6,
> I have followed the instructions and did the set up in resource.cfg and
> cgi.cfg. However, I keep getting this error:
> 
> nagios: Error: Could not lock status data tables in database ''
> 
> I have in resource.cfg:
> xsddb_host=localhost
> xsddb_port=3306
> xsddb_database=nagios
> xsddb_username=nagios
> xsddb_password=nagios
> xsddb_optimize_data=1
> xsddb_optimize_interval=3600
> 
> Has anyone seen this before? Am I missing a setting somewhere?
> 
> Thank you,
> 
> Jared
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> 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
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.3.3 (GNU/Linux)
Comment: pgpenvelope 2.10.2 - http://pgpenvelope.sourceforge.net/

iD8DBQE/uqrsl2ODWuqVSBMRAi+aAJ9Xld16FAZ6d5j1/wE9sZaHcCmY9wCeJtMc
Y7EBdNwky/HUTU9m0Hm3Chk=
=GE5z
-----END PGP SIGNATURE-----


-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?  SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
_______________________________________________
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