Issue Details (XML | Word | Printable)

Key: GWMON-46
Type: Bug Bug
Status: Resolved
Resolution: Fixed
Priority: Important Important
Assignee: Richard Barry-Smith
Reporter: Richard Barry-Smith
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
GroundWork Monitor Open Source

Latest Community MySQL rpms release - 5.0.67 does not work with groundwork-foundation-pro-5.2.1

Created: 12/Aug/08 03:16 PM   Updated: 13/Aug/08 09:26 AM
Component/s: Other
Affects Version/s: Legacy
Fix Version/s: 5.3 Alpha 1

Time Tracking:
Not Specified

Environment: RH4-32bit


 Description  « Hide
 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

 

 All   Comments   Work Log   Change History      Sort Order:
Richard Barry-Smith added a comment - 13/Aug/08 09:26 AM
This issue will be address with the 5.3 rpms.

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