topic Re: Groundworks RPM in Operating System - Linux

Groundworks RPM

Piotr Kirklewski — Mon, 09 Feb 2009 15:16:29 GMT

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

Re: Groundworks RPM

Ivan Ferreira — Mon, 09 Feb 2009 15:27:58 GMT

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

Re: Groundworks RPM

Piotr Kirklewski — Mon, 09 Feb 2009 15:36:20 GMT

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

Re: Groundworks RPM

Piotr Kirklewski — Mon, 09 Feb 2009 18:38:21 GMT

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

Re: Groundworks RPM

Steven E. Protter — Mon, 09 Feb 2009 19:10:23 GMT

Shalom

rpmbuild

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

SEP

Re: Groundworks RPM

Piotr Kirklewski — Mon, 09 Feb 2009 19:31:42 GMT

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

Re: Groundworks RPM

Ivan Ferreira — Tue, 10 Feb 2009 13:45:34 GMT

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

Cheers.

Re: Groundworks RPM

Piotr Kirklewski — Tue, 10 Feb 2009 13:50:16 GMT

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