Received: from smtp.cwia.com (smtp.cwia.com [208.25.60.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id RAA60617
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 23 Jul 1999 17:16:35 -0400 (EDT)
	(envelope-from doug@dupreeinc.com)
Received: from dupree3.dupreeinc.com (root@fuser251.pop4.cwia.com
	[199.107.165.251])
	by smtp.cwia.com (8.8.5/8.8.5) with ESMTP id OAA03367;
	Fri, 23 Jul 1999 14:16:25 -0700 (PDT)
Received: from dupreeinc.com (dougpc.dupreeinc.com [192.168.154.13])
	by dupree3.dupreeinc.com (8.8.6 (PHNE_14041)/8.8.6) with ESMTP id
	OAA00161; Fri, 23 Jul 1999 14:13:35 -0700 (PDT)
Message-ID: <3798DAE3.93528B14@dupreeinc.com>
Date: Fri, 23 Jul 1999 14:13:07 -0700
From: Doug Thistlethwaite <doug@dupreeinc.com>
X-Mailer: Mozilla 4.6 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Peter Mount <peter@retep.org.uk>
CC: Doug Thistlethwaite <doug@dupree3.dupreeinc.com>,
	pgsql-interface <pgsql-interfaces@postgreSQL.org>, doug.t@deltanet.com
Subject: Re: [INTERFACES] Connection from win95 to postgresql using JDBC
	andjdk1.2
References: <Pine.LNX.4.10.9907231806090.4429-100000@maidast.retep.org.uk>
Content-Type: multipart/alternative;
	boundary="------------785ED6137BE6A1A932966B2D"


--------------785ED6137BE6A1A932966B2D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Peter,

Glad you have your system back up and running! :)

I have already tried this and I received the same results as I did
without the line (Auth failure).

Your previous message stated that:

> I'm now used to the more recent backends, which use the "ALTER USER" sql
> statement, and the passwords are now stored in a hidden system table,
> which is why my examples above don't have a file name in them.
>

How do I load my original passwords into this hidden system file?  I
added the password for doug using the following command:

pg_passwd /var/postgres/passwd

<Enter User Name> Doug
<Enter User Password> db

I did not see anything in the docs about setting passwords into the
system table.  Is there a different way to enter passwords now for
postgres access?  The system password for user 'doug' is not 'db' like I
set it in the pg_passwd command.

Thanks,

Doug

Peter Mount wrote:

> On Fri, 23 Jul 1999, Doug Thistlethwaite wrote:
>
> [snip]
> > host         doug        207.155.49.102 255.255.255.255  password
> > /var/postgres/passwd
>
> Try it without anything after the password keyword, ie
>
> host doug 207.155.49.102 255.255.255.255 password
>
> --
>        Peter T Mount peter@retep.org.uk
>       Main Homepage: http://www.retep.org.uk
> PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
>  Java PDF Generator: http://www.retep.org.uk/pdf

--------------785ED6137BE6A1A932966B2D
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Peter,
<p>Glad you have your system back up and running! :)
<p>I have already tried this and I received the same results as I did without
the line (Auth failure).
<p>Your previous message stated that:
<blockquote TYPE=CITE>
<pre>I'm now used to the more recent backends, which use the "ALTER USER" sql
statement, and the passwords are now stored in a hidden system table,
which is why my examples above don't have a file name in them.</pre>
</blockquote>

<p><br>How do I load my original passwords into this hidden system file?&nbsp;
I added the password for doug using the following command:
<p>pg_passwd /var/postgres/passwd
<p>&lt;Enter User Name> Doug
<br>&lt;Enter User Password> db
<p>I did not see anything in the docs about setting passwords into the
system table.&nbsp; Is there a different way to enter passwords now for
postgres access?&nbsp; The system password for user 'doug' is not 'db'
like I set it in the pg_passwd command.
<p>Thanks,
<p>Doug
<p>Peter Mount wrote:
<blockquote TYPE=CITE>On Fri, 23 Jul 1999, Doug Thistlethwaite wrote:
<p>[snip]
<br>> host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; doug&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
207.155.49.102 255.255.255.255&nbsp; password
<br>> /var/postgres/passwd
<p>Try it without anything after the password keyword, ie
<p>host doug 207.155.49.102 255.255.255.255 password
<p>--
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Peter T Mount peter@retep.org.uk
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Main Homepage: <a href="http://www.retep.org.uk">http://www.retep.org.uk</a>
<br>PostgreSQL JDBC Faq: <a href="http://www.retep.org.uk/postgres">http://www.retep.org.uk/postgres</a>
<br>&nbsp;Java PDF Generator: <a href="http://www.retep.org.uk/pdf">http://www.retep.org.uk/pdf</a></blockquote>
</html>

--------------785ED6137BE6A1A932966B2D--