R: error in nagiosql install

[Marco Borsani]

That was the problem !
Thank you very much, now it has been solved.

Right now I just have an error on nagiosql web site... in the "Tools"
section I have the messages (see the attach) :
Could not open directory /etc/nagios
Could not open directory /etc/nagios/import
But I have installed Nagios under /usr/local/nagios like always and I do not
find any section to change this setting in the nagiosql pages (to point to
the other directory).

Marco


-----Messaggio originale-----
Da: Giorgio Zarrelli [mailto:zarrelli at linux.it] 
Inviato: martedì 26 aprile 2011 10:49
A: Marco Borsani
Cc: zarrelli at linux.it; 'Nagios Users List'
Oggetto: [Nagios-users] error in nagiosql install

Hi,

googling I found that the 'mysql.servers' error might be a mysql privileges
bug that you can fix running  the

mysql_fix_privilege_tables

script.

See this bug report:

http://bugs.mysql.com/bug.php?id=28680

Or you can use this workaround creating the servers table by hands with the
following statement (you have to log on your console and enter the mysql
cli):

CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';


http://forums.mysql.com/read.php?11,142598,160503#msg-160503


Giorgio
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Conf_import.jpg
Type: image/jpeg
Size: 71463 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20110426/9171704c/attachment.jpg>
-------------- next part --------------
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
-------------- next part --------------
_______________________________________________
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