Mike, how is the postmaster started? (postmaster is the postgresql
backend server)
There is an option the postmaster needs in order to allow
network connections.
Example, looking at the process list (ps ax):
/usr/local/pgsql/bin/postmaster -i -D /web/pgsql
The "-i" option seen here allows tcp connections, without it, quite a few
of the software's can't connect. If you don't see this "-i" option, that
may be your problem.
A typical startup command for the postmaster looks like this (but all on
one line!):
su - postgres -c "/usr/local/pgsql/bin/postmaster -i -D /web/pgsql
>logfile 2>&1 &"
On Fri, 28 Jun 2002, Mike Starke wrote:
I am attempting to get SQL-Ledger up and running and am running
into a few problems as it pertains to postgreSQL.
I have done the following:
1. As the user postgres (I'm on a debian sysem btw), I have done:
'createuser mike'
2. As the user 'mike' I have done:
'createdb mydb'
3. I can, as user 'mike' do:
'psql mydb'
and get to the command line utility.
4. I have also ensured that I have the line"
'tcpip_socket = 1'
in /etc/postgresql.conf
5. I have mucked around in /etc/postgresql/pg_hba.conf a bit and not sure
what I have done in there.
At any rate, when I fire up
http://localhost/sqlledger.admin.pl, login, and then try
to "Create Dataset" under the user 'mike', my linux (mike) password, and connect to 'mydb',
I get the following error:FATAL 1: IDENT authentication failed for user "mike".
I'm suspect my problems lie within pg_hba.conf, but whatever I do (thinking it is wide open)
I continue to get the same error message.
Can anyone offer some guidance here?
v/r
Mike
________________________________________________
See
http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)