From: Tom Lane <tgl@sss.pgh.pa.us>
To: Midwest Online <mo@midwestonline.com>
Cc: pgsql-interfaces@postgreSQL.org
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [INTERFACES] getting "fe_setauthsvc: invalid name" error
Date: Fri, 11 Sep 1998 10:16:37 -0400
Message-ID: <8763.905523397@sss.pgh.pa.us> (raw)
In-Reply-To: <35F8B0F4.148A0C4@midwestonline.com>
Midwest Online <mo@midwestonline.com> writes:
> Connection was unsuccessful...
> Error message returned: fe_setauthsvc: invalid name: , ignoring...
> Anybody have any clue why this happens, or what it means? Better yet,
> anybody know how to fix it?
The error message is pretty much useless --- it looks like the actual
error is being overwritten thanks to a bug in PgConnection::Connect().
You might try diking out the last seven lines of that routine (it's
in src/interfaces/libpq++/pgconnection.cc) and seeing if you get a
more useful message.
My guess is that the execution environment is different for your CGI
program, with respect to either username or lack of one of the
environment variables that libpq pays attention to (PGPORT, etc).
Another possibility is that the database server sees the connection
as being made from a different IP address than what you get from the
command line (I dunno enough about "virtual web servers" to know if that
would happen, but it seems possible), and the IP address is not one of
those listed as permitted to connect in the server's host authentication
file.
BTW, hackers: when I looked into pgconnection.cc, I was astonished
and dismayed by the number of instantly visible bugs. This code is in
*horrible* shape --- it's amazing it works at all. Someone is going to
have to adopt libpq++ and give it a close going-over.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, mo@midwestonline.com, pgsql-hackers@postgreSQL.org
Subject: Re: [INTERFACES] getting "fe_setauthsvc: invalid name" error
In-Reply-To: <8763.905523397@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox