DB support

Jared Brick jared.brick at convergia.net
Wed Nov 19 00:43:37 CET 2003


But why isn't the name of the database showing up? It's '' rather than
'nagios' and as far as I know the user has full rights to everything in
that DB. How can I check if he has the lock table privilege?

Thank you,

Jared

On Tue, 2003-11-18 at 18:27, Jason Martin wrote:
> -----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
> 



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





More information about the Users mailing list