Skip site navigation (1) Skip section navigation (2)

Re: configure script failure with SCO 5.0.7

From: "David P(dot) Lurie" <dbase4(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: configure script failure with SCO 5.0.7
Date: 2004-03-26 01:59:14
Message-ID: c402pd$kol$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-novice
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:16753(dot)1080262892(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> So, what shows up in the postmaster log when this happens?  Is there a
> core file, and if so can you get a stack trace from it?
>
> > I can connect to the server using trusted login from pgAdminIII from my
> > windows box, with template0 and template1 displayed as with the older
> > version, and cywin ports on windows boxes.
>
> Yeah?  Can you connect locally via TCP?  Try
> psql -h localhost template1
> If that works then the problem must be localized to Unix socket access
> ... I have no idea what would cause such a problem though ...
>

No core file because the server doesn't terminate despite the error message.

psql -h localhost template1 works! Was used to mysql where local connection
wasn't tcp socket unless explicitly specified. Still doesn't explain why I
can connect with pgAdminIII from the LAN but not successfully execute
commands.

It must be a socket problem; I found the following post in the postgresql
archives, but no attachment, just his PGP signature, and no new
src/template/sco in the source tree:

  a.. From: Larry Rosenman <ler ( at ) lerctr ( dot ) org>
  b.. To: pgsql-hackers ( at ) postgresql ( dot ) org
  c.. Subject: OpenServer 5.0.7: setsockopt(TCP_NODELAY)?
  d.. Date: Thu, 06 Nov 2003 18:56:31 -0600

----------------------------------------------------------------------------
----

I asked my friends at SCO (who are productizing PG) to test
7.4RC1 on OpenServer 5.0.7, and received this back:

A "make check" fails at createdb with errors in the postmaster logfile:

LOG: setsockopt(TCP_NODELAY) failed: Protocol not available


Plus he needed to add:


if test "$GCC" != yes ; then
   CC="$CC -b elf"
fi
to src/template/sco for 5.0.7.
I downloaded 7.4 RC1 and successfully compiled it on an OpenServer 5.0.7
system.
I am attaching the only change i had to make. This is the file
src/template/sco.
The GCC compiler on OSR5 no longer accepts the "-b elf" argument.

Anyone of the guru's have ideas?


Thanks,
LER

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler ( at ) lerctr ( dot ) org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749





In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2004-03-26 18:04:37
Subject: Re: Equivalent of mssql profiler?
Previous:From: Tom LaneDate: 2004-03-26 01:01:32
Subject: Re: configure script failure with SCO 5.0.7

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group