amitk
2012-04-27 13:27:53 UTC
amitk [http://community.zenoss.org/people/amitk] created the discussion
"zenoss core 4 - ERROR 1146 (42S02) at line 5: Table 'mysql.servers' doesn't exist"
To view the discussion, visit: http://community.zenoss.org/message/66115#66115
--------------------------------------------------------------
Hi,
I tried to install core 4 which gave me following error. I checked the mysql database and I don't see events database.
what's wrong here?
Thanks,
Amit
[***@testwks1 ~]# rpm -ivh ~kshirsaa/zenoss-4.1.70-1482.el5.x86_64.rpm
Preparing...               ########################################### [100%]
  1:zenoss                ########################################### [100%]
grep: /home/zenoss/.bashrc: No such file or directory
[***@testwks1 ~]#
[***@testwks1 ~]#
[***@testwks1 ~]#
[***@testwks1 ~]# service zenoss start
Zenoss not initialized. Performing first-boot initialization...
Fresh install pre steps
Stopping snmpd:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â [Â OKÂ ]
Starting snmpd:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â [Â OKÂ ]
mysql: Unknown OS character set 'ISO-8859-15'.
mysql: Switching to the default character set 'latin1'.
mysql: Unknown OS character set 'ISO-8859-15'.
mysql: Switching to the default character set 'latin1'.
ERROR 1146 (42S02) at line 5: Table 'mysql.servers' doesn't exist
Dropping database: zodb_session
Creating database: zodb_session
Failed to create ZODB session database
mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| mysql             |
| test              |
| zodb_session      |
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql          |
+---------------------------+
| columns_priv             |
| db                       |
| func                     |
| help_category            |
| help_keyword             |
| help_relation            |
| help_topic               |
| host                     |
| proc                     |
| procs_priv               |
| tables_priv              |
| time_zone                |
| time_zone_leap_second    |
| time_zone_name           |
| time_zone_transition     |
| time_zone_transition_type |
| user                     |
+---------------------------+
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/66115#66115]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"zenoss core 4 - ERROR 1146 (42S02) at line 5: Table 'mysql.servers' doesn't exist"
To view the discussion, visit: http://community.zenoss.org/message/66115#66115
--------------------------------------------------------------
Hi,
I tried to install core 4 which gave me following error. I checked the mysql database and I don't see events database.
what's wrong here?
Thanks,
Amit
[***@testwks1 ~]# rpm -ivh ~kshirsaa/zenoss-4.1.70-1482.el5.x86_64.rpm
Preparing...               ########################################### [100%]
  1:zenoss                ########################################### [100%]
grep: /home/zenoss/.bashrc: No such file or directory
[***@testwks1 ~]#
[***@testwks1 ~]#
[***@testwks1 ~]#
[***@testwks1 ~]# service zenoss start
Zenoss not initialized. Performing first-boot initialization...
Fresh install pre steps
Stopping snmpd:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â [Â OKÂ ]
Starting snmpd:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â [Â OKÂ ]
mysql: Unknown OS character set 'ISO-8859-15'.
mysql: Switching to the default character set 'latin1'.
mysql: Unknown OS character set 'ISO-8859-15'.
mysql: Switching to the default character set 'latin1'.
ERROR 1146 (42S02) at line 5: Table 'mysql.servers' doesn't exist
Dropping database: zodb_session
Creating database: zodb_session
Failed to create ZODB session database
mysql> show databases;
+--------------------+
| Database          |
+--------------------+
| information_schema |
| mysql             |
| test              |
| zodb_session      |
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql          |
+---------------------------+
| columns_priv             |
| db                       |
| func                     |
| help_category            |
| help_keyword             |
| help_relation            |
| help_topic               |
| host                     |
| proc                     |
| procs_priv               |
| tables_priv              |
| time_zone                |
| time_zone_leap_second    |
| time_zone_name           |
| time_zone_transition     |
| time_zone_transition_type |
| user                     |
+---------------------------+
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/66115#66115]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]