Search found 4 matches

by fpjohn
Thu Aug 23, 2012 3:44 pm
Forum: Nagios XI
Topic: SQL error on various pages, new install
Replies: 8
Views: 3395

Re: SQL error on various pages, new install

ah ok. made the change and it did run. however the problem is still there. here's the results from the run... -> -> DROP TABLE nagios_programstatus; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ne...
by fpjohn
Thu Aug 23, 2012 1:42 pm
Forum: Nagios XI
Topic: SQL error on various pages, new install
Replies: 8
Views: 3395

Re: SQL error on various pages, new install

It seems to work ok, but stalls when it gets to the last line... I let it sit there for a few minutes but it never moved passed it. If I hit enter I get this: > > ) ENGINE=MyISAM COMMENT='Current program status information';"|mysql -pnagiosxi nagios ERROR 1045 (28000): Access denied for user 'r...
by fpjohn
Thu Aug 23, 2012 12:44 pm
Forum: Nagios XI
Topic: SQL error on various pages, new install
Replies: 8
Views: 3395

Re: SQL error on various pages, new install

Hi Scott,

Thanks for the reply... I ran the first command a few times and it didn't solve the issue.

The second part, I'm not sure i'm doing this in the right place. When I do the first line, I get this: -bash: syntax error near unexpected token `)'
by fpjohn
Wed Aug 22, 2012 6:37 pm
Forum: Nagios XI
Topic: SQL error on various pages, new install
Replies: 8
Views: 3395

SQL error on various pages, new install

Hi, Just joined up here, the company I work for tasked me with evaluating Nagios. I got the setup complete and the initial configuration done. I'm noticing this error message all over the place on our system though and I can't seem to get any monitors going (just trying to do a simple ping monitor f...