Обсуждение: Re: [ADMIN] DB Access Restrictions

Поиск
Список
Период
Сортировка

Re: [ADMIN] DB Access Restrictions

От
Bruce Momjian
Дата:
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
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: [ADMIN] DB Access Restrictions

От
Barry Lind
Дата:
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
>>
>>
>>
>
>
>