error in nagiosql install

Giorgio Zarrelli zarrelli at linux.it
Tue Apr 26 10:49:10 CEST 2011


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


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