Message-ID: <3985CB73.F8716221@wgcr.org>
Date: Mon, 31 Jul 2000 14:54:44 -0400
From: Lamar Owen <lamar.owen@wgcr.org>
MIME-Version: 1.0
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
CC: David Lloyd-Jones <david.lloyd-jones@attcanada.ca>,
	pgsql-interfaces@postgresql.org, Oliver Elphick <olly@lfix.co.uk>
Subject: Re: PSQL Working, but PGAccess Not Connecting.
References: <200007310553.e6V5r5A23948@linda.lfix.co.uk>
	<002a01bffab9$4bcd6930$77647bd8@WORKGROUP>
	<3985941D.DBD94A92@alumni.caltech.edu>
	<004d01bffb0c$203162b0$6d6b7bd8@WORKGROUP>
	<3985AA0F.337454B0@alumni.caltech.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Thomas Lockhart wrote:
 
> > Do I want to add a "-i" somewhere inside it?
 
> Sure, if it isn't there already. I haven't looked at the script
> recently, but I recall that the predecessor had some commented-out lines
> to illustrate where this kind of thing should occur.
 
> Perhaps the "-i" is disabled by default to enhance out-of-the-box
> network security?

[I'm going to reply to this one rather than all the previous ones. 
Sorry for the delay in responding, but I just got back from a 'working'
vacation, and had alot of front-burner items to handle before I could
get on my notebook. And, last night I was going to get online, but a
thunderstorm outbreak prevented me....]

David, if you're running 6.5.3 that came with RH 6.2, there should
already be a '-i' on the postmaster startup line in
/etc/rc.d/init.d/postgresql.  If, however, you're running 7.0.2, the
whole startup has changed.  Look in
/var/lib/pgsql/data/postmaster.opts.default (IIRC) for a '-i' -- the
7.0.2 RPM's start postmaster through pgctl.

If you not running 7.0.2, you really should investigate upgrading. 
AOLserver's performance takes a leap against 7 versus 6.5, for some
reason that I've not been able to fathom.

As to the network unreachable errors, you have a network configuration
problem somewhere that is causing your machine to not work with TCP/IP,
for some reason.  

The default startup in the RPM's has been, since 6.5.2 or so, to enable
the -i -- and the reason -i wasn't enabled before wasn't so much
security as it was the fact the no one bothered to add -i to the startup
file after PostgreSQL 6.3 changed the default to require -i for TCP/IP
connections.

Also, if you have Apache installed, AOLserver will have serious trouble
binding port 80 (even if Apache is not running).

HTH

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