Re: [ADMIN] DB Access Restrictions

From: Barry Lind <barry(at)xythos(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tim Ellis <Tim(dot)Ellis(at)gamet(dot)com>, vwebtest(at)webhart(dot)deepnet(dot)cx, pgsql-admin(at)postgresql(dot)org, PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [ADMIN] DB Access Restrictions
Date: 2002-08-22 03:45:50
Message-ID: 3D645E6E.3070801@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

The development version on the website has the mentioned fix. The
problem that the fix fixes happens when using certain character sets
like multibyte character sets.

thanks,
--Barry

Bruce Momjian wrote:

>The jdbc that comes with 7.2.X should work fine, as well as the jdbc on
>the CVS server. In fact, some one reported a problem with the jdbc MD5
>code recently, but I know others were using it fine.
>
>JDBC folks, is MD5 working, and is that MD5 fix recently posted in the
>current CVS of jdbc?
>
>---------------------------------------------------------------------------
>
>Tim Ellis wrote:
>
>
>>>If your network is not secure, I recommend MD5. In fact, we recommend
>>>MD5 with encrypted_passwords enabled in postgresql.conf in almost all
>>>cases. Encrypted passwords will be the default in 7.3.
>>>
>>>
>>psql seems to work flawlessly with MD5 passwords, which is no great
>>surprise.
>>
>>The JDBC client doesn't seem to work. I had to go back to "password."
>>
>>Is there something the client has to do with JDBC to make MD5 passwords
>>work? The particular client I'm talking about is DB Visualizer.
>>
>>--
>>Tim Ellis
>>Senior Database Architect
>>Gamet, Inc.
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>>
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-08-22 04:47:38 Re: OT: password encryption (salt theory)
Previous Message Bruce Momjian 2002-08-22 02:38:03 Re: DB Access Restrictions

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rudianto Sugiyarto 2002-08-22 03:55:38 from UNIX to postgresql in Linux
Previous Message Bruce Momjian 2002-08-22 02:38:03 Re: DB Access Restrictions