Latest Community MySQL rpms release - 5.0.67 does not work with groundwork-foundation-pro-5.2.1
[
root@QARedHat329b packages]# rpm -qa | grep MySQL
MySQL-devel-community-5.0.67-0.rhel4
MySQL-client-community-5.0.67-0.rhel4
MySQL-server-community-5.0.67-0.rhel4
MySQL-shared-community-5.0.67-0.rhel4
Now manually install 5.2.1 foundation rpm:
[
root@QARedHat329b packages]# rpm -Uvh groundwork-foundation-pro-2.0.1-48.noarch .rpm
Preparing... ########################################### [100%]
Current Java version:
java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Server VM (build 1.5.0_06-b05, mixed mode)
1:groundwork-foundation-p########################################### [100%]
Server IP address: 172.28.113.147
Creating GWCollage database...
MySQL root passwd is not set...
Loading Foundation Schema...
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--Collage - The ultimate data integration framework.
--Copyright (C) 2004-2007 ' at line 1
Loading State and Console Metadata...
ERROR 1146 (42S02) at line 1: Table 'GWCollageDB.MonitorStatus' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'GWCollageDB.Priority' doesn't exist
Loading Generic Metadata for Foundation...
ERROR 1146 (42S02) at line 19: Table 'GWCollageDB.ApplicationType' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'GWCollageDB.SchemaInfo' doesn't exist
Loading Nagios properties...
ERROR 1146 (42S02) at line 20: Table 'GWCollageDB.PropertyType' doesn't exist
Loading System properties...
ERROR 1146 (42S02) at line 20: Table 'GWCollageDB.PropertyType' doesn't exist
Comments in SQL files are no longer parsed correctly
Changed:
--Collage - The ultimate data integration framework.
TO
- Collage - The ultimate data integration framework.
passed the syntax error.
3 dashes in a row are no longer supported either. SO instead of
---------------------
it has to be
- ---------------------------
IWe have updated the scripts for the 5.3 release