Thread: Re: postgres RPM build on Suse linux 6.2

Re: postgres RPM build on Suse linux 6.2

From
Lamar Owen
Date:
[I've been working with Jef Peeraer on building the RPM's on SuSE Linux,
and ran across what I think is an autoconf issue.  The configure script
complained that it couldn't find the tk config script
(/usr/lib/tkConfig.sh on most tk installs), which botched the whole
build in an obscure place.]

>Subject : postgres RPM build on a Suse 6.2 machine.
>Tk is installed, but it is maybe the location that matters :
>/usr/X11R6/lib/tkConfig.sh. 
>Is a part of this path hard coded somewhere ? ( auto-configure ). 

Bruce, I seem to recall that the PATH_TO_WISH issue with pgaccess
prompted some autoconf stuff -- is this related?  

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2

From
Bruce Momjian
Date:
> [I've been working with Jef Peeraer on building the RPM's on SuSE Linux,
> and ran across what I think is an autoconf issue.  The configure script
> complained that it couldn't find the tk config script
> (/usr/lib/tkConfig.sh on most tk installs), which botched the whole
> build in an obscure place.]
> 
> >Subject : postgres RPM build on a Suse 6.2 machine.
> >Tk is installed, but it is maybe the location that matters :
> >/usr/X11R6/lib/tkConfig.sh. 
> >Is a part of this path hard coded somewhere ? ( auto-configure ). 
> 
> Bruce, I seem to recall that the PATH_TO_WISH issue with pgaccess
> prompted some autoconf stuff -- is this related?  

Not related, I think.  PATH_TO_WISH is just set to @WISH@ in the actual
executable.  I never touched the tkConfig stuff.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2

From
Lamar Owen
Date:
Bruce Momjian wrote:
> > Bruce, I seem to recall that the PATH_TO_WISH issue with pgaccess
> > prompted some autoconf stuff -- is this related?
> 
> Not related, I think.  PATH_TO_WISH is just set to @WISH@ in the actual
> executable.  I never touched the tkConfig stuff.

Ok.  I'm going to have to do some digging -- there are a multitude of
other X11-related configure shenanigans I'm going to have to take care
of for building the RPMs on SuSE.  I eventually hope to have it where
people can rebuild the RPM set with a simple 'rpm --rebuild' instead of
what some are having to do now.  On RedHat Intel, Sparc, or Alpha, the
--rebuild is enough -- but RedHat is not the only RPM-based distribution
(nor is linux the only OS that can have RPM installed....).  Time to buy
CheapBytes' Mondo CD pack (five linux distributions on CD)....

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2

From
Tom Lane
Date:
Lamar Owen <lamar.owen@wgcr.org> writes:
> [I've been working with Jef Peeraer on building the RPM's on SuSE Linux,
> and ran across what I think is an autoconf issue.  The configure script
> complained that it couldn't find the tk config script
> (/usr/lib/tkConfig.sh on most tk installs), which botched the whole
> build in an obscure place.]

--with-tclconfig and/or --with-tkconfig should fix this.  I forget
whether those are in 6.5.* though.

Since we also look for "wish" in the PATH, it would be nice if we could
ask wish where the tcl/tk config files are, instead of having to search
for them ourselves.  But AFAIK you can't fire up a wish without having
an X display for it to connect to ... and configure can't assume that.
        regards, tom lane


Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2

From
Vince Vielhaber
Date:
On 22-Nov-99 Tom Lane wrote:
> Lamar Owen <lamar.owen@wgcr.org> writes:
>> [I've been working with Jef Peeraer on building the RPM's on SuSE Linux,
>> and ran across what I think is an autoconf issue.  The configure script
>> complained that it couldn't find the tk config script
>> (/usr/lib/tkConfig.sh on most tk installs), which botched the whole
>> build in an obscure place.]
> 
> --with-tclconfig and/or --with-tkconfig should fix this.  I forget
> whether those are in 6.5.* though.
> 
> Since we also look for "wish" in the PATH, it would be nice if we could
> ask wish where the tcl/tk config files are, instead of having to search
> for them ourselves.  But AFAIK you can't fire up a wish without having
> an X display for it to connect to ... and configure can't assume that.

I added --with-tkconfig somewhere around March 4, 1999.  That's the date
on my patch file anyway.  Does that help any?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null # include <std/disclaimers.h>       Have you
seenhttp://www.pop4.net?       Online Campground Directory    http://www.camping-usa.com      Online Giftshop
Superstore   http://www.cloudninegifts.com
 
==========================================================================




Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2

From
Lamar Owen
Date:
Vince Vielhaber wrote:
> > --with-tclconfig and/or --with-tkconfig should fix this.  I forget
> > whether those are in 6.5.* though.
> I added --with-tkconfig somewhere around March 4, 1999.  That's the date
> on my patch file anyway.  Does that help any?

Well, I told the guy to symlink /usr/X11/lib/tkConfig.sh to
/usr/lib/tkConfig.sh to assist in troubleshooting the build -- and
that's when we run up against the X stuff. He is confirming that he
indeed has the X11 development headers and libs installed.

The long term solution is to add distribution-specific configure lines
to the spec file, selected with RPM directives.  We just have to figure
out the configure options and other shenanigans for each distribution,
then put the appropriate directives in place.  Once we get his system
building the RPM's reliably, then we'll do the --with-tkconfig etc
directives in the spec file, with the selector directives inline.  At
that point, whether you are on RedHat or SuSE, you just type 'rpm
--rebuild postgresql-6.5.3-x.src.rpm' and the entire build, install, and
packaging operations are executed in a fully automatic fashion,
producing installable binary RPM's.  At least that's my goal ;-).

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


Mandrake RPMs (was RPM build on Suse linux 6.2)

From
Thomas Lockhart
Date:
> Ok.  I'm going to have to do some digging -- there are a multitude of
> other X11-related configure shenanigans I'm going to have to take care
> of for building the RPMs on SuSE.  I eventually hope to have it where
> people can rebuild the RPM set with a simple 'rpm --rebuild' instead of
> what some are having to do now.  On RedHat Intel, Sparc, or Alpha, the
> --rebuild is enough -- but RedHat is not the only RPM-based distribution
> (nor is linux the only OS that can have RPM installed....).  Time to buy
> CheapBytes' Mondo CD pack (five linux distributions on CD)....

I've sent off mail to the Mandrake folks regarding the Postgres RPMs;
will let you know what I find out. Current problems:

1) they don't have the latest release. I asked whether they had a
mechanism for releasing updates to packages over and above the limited
number I see on their site.

2) they seem to have omitted the .src.rpm from their distro, so I
can't see how they build their i586-specific packages.

btw, they show the same /usr/lib/pgsql permissions problem.
                    - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


Re: Mandrake RPMs (was RPM build on Suse linux 6.2)

From
Lamar Owen
Date:
On Mon, 22 Nov 1999, Thomas Lockhart wrote:
> > --rebuild is enough -- but RedHat is not the only RPM-based distribution
> > (nor is linux the only OS that can have RPM installed....).  Time to buy
> > CheapBytes' Mondo CD pack (five linux distributions on CD)....
> I've sent off mail to the Mandrake folks regarding the Postgres RPMs;
> will let you know what I find out. Current problems:
> 1) they don't have the latest release. I asked whether they had a
> mechanism for releasing updates to packages over and above the limited
> number I see on their site.

The last Mandrake release is for the Cooker development setup (go to
rpmfind.net, Mandrake Cooker, pull up a RPM list by name, and go to the P's.). 
They last put in 6.5.2-1 in Cooker.  And Cooker has the src.rpm.

> btw, they show the same /usr/lib/pgsql permissions problem.

Yeah, that one is going to bite us one day.  There was never a documented need
to change it before.  It is changed in my local copy of the spec file already,
so it will go into the next build (as the gruesome HOWTO gets canned at the
same time.... I didn't want to look _too_ eager to find an excuse to release
another RPM set so soon after our HOWTO discussion and resolution....). 

Do you have a preference as to doing a quick bugfix RPM release versus waiting
a little to get other bugs squashed at the same time?

Can you forward Mandrake's reply to me??

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


Re: Mandrake RPMs (was RPM build on Suse linux 6.2)

From
Thomas Lockhart
Date:
> > > --rebuild is enough -- but RedHat is not the only RPM-based distribution
> > > (nor is linux the only OS that can have RPM installed....).  Time to buy
> > > CheapBytes' Mondo CD pack (five linux distributions on CD)....
> > I've sent off mail to the Mandrake folks regarding the Postgres RPMs;
> > will let you know what I find out. Current problems:
> > 1) they don't have the latest release. I asked whether they had a
> > mechanism for releasing updates to packages over and above the limited
> > number I see on their site.
> The last Mandrake release is for the Cooker development setup (go to
> rpmfind.net, Mandrake Cooker, pull up a RPM list by name, and go to the P's.).
> They last put in 6.5.2-1 in Cooker.  And Cooker has the src.rpm.

I'm just using yours for now. Interesting: on my new laptop it builds
*i686* rpms, since the Mandrake /usr/lib/rpm/rpmrc is very aggressive
about matching the build machine. I have created a /root/.rpmrc to
override this, but I'm planning on posting some optimized RPMs at
postgresql.org.

We might also want to consider building some non-locale-enabled RPMs
so folks can get the speed boost if they aren't using non-ascii
English.

I've changed a couple of lines in the spec file; diffs included below.

> Can you forward Mandrake's reply to me??

Sure. Haven't heard from them yet...

                   - Thomas

--
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California*** postgresql-6.5.3-1.spec    Fri Nov  5 20:33:29 1999
--- postgresql-6.5.3-2mdk.spec    Tue Nov 23 13:57:45 1999
***************
*** 1,7 ****
  Summary: The PostgreSQL server programs.
  Name: postgresql
  Version: 6.5.3
! Release: 1
  Copyright: BSD
  Group: Applications/Databases
  Source0: ftp://ftp.postgresql.org/pub/postgresql-%{version}.tar.gz
--- 1,7 ----
  Summary: The PostgreSQL server programs.
  Name: postgresql
  Version: 6.5.3
! Release: 2mdk
  Copyright: BSD
  Group: Applications/Databases
  Source0: ftp://ftp.postgresql.org/pub/postgresql-%{version}.tar.gz
***************
*** 253,259 ****

  ## Removed the code for the data subpackage.

! mkdir -p $RPM_BUILD_ROOT/var/lib/pgsql

  # tests. There are many files included here that are unnecessary, but include
  # them anyway for completeness.
--- 253,259 ----

  ## Removed the code for the data subpackage.

! install -d -m 0700 $RPM_BUILD_ROOT/var/lib/pgsql

  # tests. There are many files included here that are unnecessary, but include
  # them anyway for completeness.
***************
*** 387,393 ****
  /usr/lib/pgsql/plpgsql.so
  %attr(-,postgres,postgres) %dir /usr/lib/pgsql/backup
  /usr/lib/pgsql/backup/pg_dumpall_new
! %attr(-,postgres,postgres) %dir /var/lib/pgsql

  %files devel
  %defattr(-,root,root)
--- 387,393 ----
  /usr/lib/pgsql/plpgsql.so
  %attr(-,postgres,postgres) %dir /usr/lib/pgsql/backup
  /usr/lib/pgsql/backup/pg_dumpall_new
! %attr(700,postgres,postgres) %dir /var/lib/pgsql

  %files devel
  %defattr(-,root,root)

Re: Mandrake RPMs (was RPM build on Suse linux 6.2)

From
Lamar Owen
Date:
Thomas Lockhart wrote:
> > They last put in 6.5.2-1 in Cooker.  And Cooker has the src.rpm.
> 
> I'm just using yours for now. Interesting: on my new laptop it builds
> *i686* rpms, since the Mandrake /usr/lib/rpm/rpmrc is very aggressive
> about matching the build machine. I have created a /root/.rpmrc to
> override this, but I'm planning on posting some optimized RPMs at
> postgresql.org.

Sounds good.  Yeah, Mandrake has been quite aggressive on the CPU
optimization front -- however, I still have some 486's running here, so
the i386 binaries work for me.  If we want to distribute i586 and i686
versions, I have no complaints.

I looked at the Mandrake Cooker spec file -- and there are differences
all over the place -- most noticeably in the truncation of the
Changelog.  The most notable difference is in the use of bzip2 to
compress the man pages.

> We might also want to consider building some non-locale-enabled RPMs
> so folks can get the speed boost if they aren't using non-ascii
> English.

On my TODO list for the next RPM release (which is looking to be sooner
than I had expected....).

> I've changed a couple of lines in the spec file; diffs included below.

Looks familiar -- fixing the permissions bug, and bumping the version.

> > Can you forward Mandrake's reply to me??
> Sure. Haven't heard from them yet...

Thanks.  I had e-mailed Axalon Bloodstone directly, as he did the
packaging for the Cooker RPM. 

Also, Jef and I got the RPM's built, installed, and running under SuSE
6.2. I'm going to put up a page on ramifordistat detailing the steps and
packages needed.  Man, SuSE is far different from RedHat!
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11