[Nagios-users] Nagios + Mysql

[Jason]

did u create this user with access to any host or localhost?
can you start mysql and use this user ?

$ mysql -u username -p nagios

SELECT * FROM host_status;

  ----- Original Message ----- 
  From: wgmachado 
  To: nagios-users 
  Cc: joemarr 
  Sent: Saturday, November 22, 2003 2:22 PM
  Subject: [Nagios-users] RE: [Nagios-users] Nagios + Mysql


  Hi Joe

  I already try this and the result is the same :(

  Another idea ?

  Thanks in advance

  Wagner

        De: "Joe Marr"  

        Para: "'wgmachado'" ,"'nagios-users'"  

        Cópia:  

        Data: Sat, 22 Nov 2003 15:45:16 -0500 

        Assunto: RE: [Nagios-users] Nagios + Mysql 

            

  If you are sure that you have the write permissions, use "flush privileges".



  Hope that helps,



  Joe

  > 

------------------------------------------------------------------------------

  From: nagios-users-admin at lists.sourceforge.net [mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of wgmachado
  Sent: Saturday, November 22, 2003 11:04 AM
  To: nagios-users
  Subject: [Nagios-users] Nagios + Mysql



  > 
  Hi all

  > 


  > 
  In the last 5 days i try use nagios with mysql and when nagios process start i receive this messages:

  > 


  > 
  Nov 22 06:44:39 kirra nagios: Nagios 1.1 starting... (PID=32378) 
  Nov 22 06:44:39 kirra nagios: Finished daemonizing... (New PID=32379) 
  Nov 22 06:44:46 kirra nagios: Caught SIGSEGV, shutting down... 
  Nov 22 06:44:54 kirra nagios: Error: Could not lock status data tables in database 'nagios'

  > 


  > 
  I already chek all the permissions os nagios database, the user used to conect had permission to lock tables (hoststatus, servicestatus and programstatus tables), all nagios configuration files was configured according the nagios documentation.

  > 


  > 
  Someone can help me ?

  > 


  > 
  Regards

  > 


  > 
  Wagner Machado
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20031122/f62114ea/attachment.html>