Any ideas? It's getting urgent here, as the entire monitoring system is down now.
Thanks. -- Toni Van Remortel System Engineer @ Precision Operations NV +32 3 451 92 20 - [email protected] > -----Original Message----- > From: [email protected] [mailto:opsview-users- > [email protected]] On Behalf Of Toni Van Remortel > Sent: Friday, June 19, 2009 8:13 AM > To: Opsview Users > Subject: Re: [opsview-users] Upgrade to 3.1 fails > > > > Can you please do the following within mysql and send the output? > > > > show create table roles; > mysql> show create table roles\G > *************************** 1. row *************************** > Table: roles > Create Table: CREATE TABLE `roles` ( > `id` int(11) NOT NULL auto_increment, > `name` varchar(128) NOT NULL, > `fixedname` varchar(16) NOT NULL, > PRIMARY KEY (`id`), > UNIQUE KEY `fixedname` (`fixedname`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > 1 row in set (0.10 sec) > > show create table monitoringservers; > > mysql> show create table monitoringservers\G > *************************** 1. row *************************** > Table: monitoringservers > Create Table: CREATE TABLE `monitoringservers` ( > `id` int(11) NOT NULL auto_increment, > `name` varchar(64) NOT NULL, > `host` int(11) default NULL, > `role` enum('Master','Slave') default 'Slave', > `activated` int(11) NOT NULL default '1', > `uncommitted` int(11) NOT NULL default '0', > PRIMARY KEY (`id`), > UNIQUE KEY `name` (`name`), > KEY `monitoringservers_host_fk` (`host`) > ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 > 1 row in set (0.01 sec) > > _______________________________________________ > Opsview-users mailing list > [email protected] > http://lists.opsview.org/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
