From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bob VonMoss <bvonmoss@bigfoot.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.
Date: Wed, 10 Feb 1999 10:22:15 -0500
Message-ID: <11081.918660135@sss.pgh.pa.us> (raw)
In-Reply-To: <36C133EE.87B0D643@bigfoot.com>
Bob VonMoss <bvonmoss@bigfoot.com> writes:
> We've tried:
> host my_db 0.0.0.0 0.0.0.0 ident sameuser
As you already found out, that won't work if you're not running an ident
daemon on your connecting machine. (You aren't *really* running with an
0.0.0.0 mask are you? That means anyone anywhere on the net can get
into your database, if they can reach the machine it's on...)
> host my_db 0.0.0.0 0.0.0.0 password sameuser
See the documentation:
# password: Authentication is done by matching a password supplied in clear
# by the host. If AUTH_ARGUMENT is specified then the password
# is compared with the user's entry in that file (in the $PGDATA
# directory). See pg_passwd(1). If it is omitted then the
# password is compared with the user's entry in the pg_shadow
# table.
Unless your admin made a file named "sameuser" to store Postgres
passwords in, this will not work. I think you want to remove "sameuser".
(Also, did he remember to set a Postgres password for you?)
> I'm hoping that it will eventually work through JDBC, but it doesn't
> work with
> psql -h my-isp.com -d my_db
> Same messages: "User authentication failed"
Even if the host system were correctly configured for password
authentication, this psql invocation would fail since you didn't supply
a username and password. Need -u option.
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, bvonmoss@bigfoot.com
Subject: Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.
In-Reply-To: <11081.918660135@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