cancel
Showing results for 
Search instead for 
Did you mean: 

Groundworks RPM

 
SOLVED
Go to solution
Piotr Kirklewski
Super Advisor

Groundworks RPM

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

Jesus is the King
7 REPLIES
Ivan Ferreira
Honored Contributor
Solution

Re: Groundworks RPM

You need the src.rpm package and there you can make the modifications. Then build again with rpmbuild.
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?
Piotr Kirklewski
Super Advisor

Re: Groundworks RPM

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

Jesus is the King
Piotr Kirklewski
Super Advisor

Re: Groundworks RPM

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
Jesus is the King
Steven E. Protter
Exalted Contributor

Re: Groundworks RPM

Shalom

rpmbuild

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

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Piotr Kirklewski
Super Advisor

Re: Groundworks RPM

Hi
So I don't need the spec file to create the package ?
Regards
Peter
Jesus is the King
Ivan Ferreira
Honored Contributor

Re: Groundworks RPM

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

Cheers.
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?
Piotr Kirklewski
Super Advisor

Re: Groundworks RPM

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