Error Using Mysql Database

[Joe Rhett]

This basically means that it couldn't read the mysql login information (or
you didn't define it).  Check file permissions and such.

I know that on my system resources.cfg was installed 640 -- I had to change 
the owner to 'nagios' to solve this problem. You could make it 644 if you 
wanted the whole world to read your mysql authentication information...

On Wed, Nov 19, 2003 at 03:26:27PM -0800, Rhugga wrote:
> 
> I have followed each step in the database configuration but am still 
> getting the following error:
> 
> [1069287426] Nagios 1.1 starting... (PID=12715)
> [1069287426] Finished daemonizing... (New PID=12716)
> [1069287426] Error: Could not connect to MySQL database '' on host '' 
> using username '' and password ''.  Status data will not be saved!
> <snip>
> 
> I have defined the correct database info in the appropriate sections of 
> cgi.cfg and resource.cfg and also commented out the corresponding file 
> definitions:
> # Disable if using MySQL
> #status_file=/usr/local/nagios-1.1/var/status.log
> #comment_file=/usr/local/nagios-1.1/var/comment.log
> #downtime_file=/usr/local/nagios-1.1/var/downtime.log
> #state_retention_file=/usr/local/nagios-1.1/var/status.sav
> 
> What am I missing? I verified that my database user can connect to the 
> local database. The user has full database privs. I created all the 
> tables using the supplied mysql script.
> 
> I build nagios using the following config:
> ./configure --prefix=/usr/local/nagios-1.1 
> --with-mail=/usr/sbin/sendmail --with-init-dir=/etc/init.d 
> --with-lockfile=/var/run/nagios/nagios.lock --with-mysql-xdata 
> --with-file-perfdata --with-mysql-lib=/usr/lib/mysql/mysql 
> --with-mysql-inc=/usr/include/mysql --with-gd-lib=/usr/lib 
> --with-gd-inc=/usr/include
> 
> Thanks,
> CC
> 
> -- 
> Chuck Carson - Sr. Systems Engineer
> Syrrx, Inc.
> 10410 Science Center Drive
> San Diego, CA 92121
> Work: 858.731.3540
> Cell: 858.967.5959
> 
> 
> 
> -------------------------------------------------------
> 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

-- 
Joe Rhett                                                      Chief Geek
JRhett at Isite.Net                                      Isite Services, Inc.


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