Groundworks RPM

[Piotr Kirklewski]

wget http://superb-east.dl.sourceforge.net/sourceforge/gwmos/groundwork-monitor-os-5.1.3-3.rhel5.i386.tar.gz

This file: groundwork-foundation-pro-1.6.1-67.noarch.rpm contains a GWCollageDB.sql file which has a bad syntax so the creation of tables in the database fails during the installation.

There are two problems with this file:


1.It has -- signs instead of ## so the lines are not commented and mysql doesn't know what to do with them and is coming with syntax error.

2. after you substitute all -- with ## you must decide which line to remove starting at line 439:

438 CREATE TABLE HostStatus

439 (
440 HostStatusID INTEGER NOT NULL,
441 HostStatusID INTEGER NOT NULL AUTO_INCREMENT,

Otherwise mysql will complain about duplicated column name.

I've done all of that and when I run the file manually then everythink works fine.

The question is how to replace/edit the file in the rpm package.

Please advice

Regards

Peter

[Ivan Ferreira · Accepted solution]

You need the src.rpm package and there you can make the modifications. Then build again with rpmbuild.

[Piotr Kirklewski]

Hi Ivan

Thanks for the tip.
You can earn additional 10 points if you show me step by step how to do that:)

Regards
Peter

[Piotr Kirklewski]

So I extracted the files:

rpm2cpio your_package_rpm.rpm | cpio -idmv

Edited GWCollageDB.sql and want to turn it into rpm again.

Anyone knows how ?

Regards

Peter

[Steven E. Protter]

Shalom

rpmbuild

You need to install the rpmbuild rpm and dependencies or use yum install to build the rpm.

SEP

[Piotr Kirklewski]

Hi
So I don't need the spec file to create the package ?
Regards
Peter

[Ivan Ferreira]

You do need the spec file, search here http://archive.groundworkopensource.com/groundwork-opensource/branches or ask on a groundwork developer mailling list.

Cheers.

[Piotr Kirklewski]

Yes I know it by now.
I drooped it and went to groundworks 5.3 which is so much better.
Regards
Peter