Postgres Pro
Downloads
Home   >   mailing lists

Thread: JDBC / JBoss connection problem on Debian

JDBC / JBoss connection problem on Debian

From
Joost Kraaijeveld
Date:
Hi,

After an update of my Debian Etch AMD64 I could suddenly not use the
"postgres" account with an empty password to connect from JBoss to my
database, which used to work OK. I only could get it working again after
I changed the following line in pg_hba.conf:

...
host    all         all         127.0.0.1/32          md5

to
..
host    all         all         127.0.0.1/32          trust

Besides that I do not know if there are any security implications I
should be worried about: what could be the cause of the problem?

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl

Re: JDBC / JBoss connection problem on Debian

From
"Greg Patnude"
Date:
I'd guess that upgrading your OS altered your MD5 encryption / decryption
algorithyms or more likely -- the "salt" ...

Did your try changing the password for the postgres account in both the
shell account and in postgres ?

"Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl> wrote in message
news:1135347327.6002.12.camel@localhost.localdomain...
> Hi,
>
> After an update of my Debian Etch AMD64 I could suddenly not use the
> "postgres" account with an empty password to connect from JBoss to my
> database, which used to work OK. I only could get it working again after
> I changed the following line in pg_hba.conf:
>
> ...
> host    all         all         127.0.0.1/32          md5
>
> to
> ..
> host    all         all         127.0.0.1/32          trust
>
> Besides that I do not know if there are any security implications I
> should be worried about: what could be the cause of the problem?
>
> TIA
>
> --
> Groeten,
>
> Joost Kraaijeveld
> Askesis B.V.
> Molukkenstraat 14
> 6524NB Nijmegen
> tel: 024-3888063 / 06-51855277
> fax: 024-3608416
> e-mail: J.Kraaijeveld@Askesis.nl
> web: www.askesis.nl
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>

Re: JDBC / JBoss connection problem on Debian

From
"Greg Patnude"
Date:
I'd guess that upgrading your OS altered your MD5 encryption / decryption
algorithyms or more likely -- the "salt" ...

Did your try changing the password for the postgres account in both the
shell account and in postgres ?

"Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl> wrote in message
news:1135347327.6002.12.camel@localhost.localdomain...
> Hi,
>
> After an update of my Debian Etch AMD64 I could suddenly not use the
> "postgres" account with an empty password to connect from JBoss to my
> database, which used to work OK. I only could get it working again after
> I changed the following line in pg_hba.conf:
>
> ...
> host    all         all         127.0.0.1/32          md5
>
> to
> ..
> host    all         all         127.0.0.1/32          trust
>
> Besides that I do not know if there are any security implications I
> should be worried about: what could be the cause of the problem?
>
> TIA
>
> --
> Groeten,
>
> Joost Kraaijeveld
> Askesis B.V.
> Molukkenstraat 14
> 6524NB Nijmegen
> tel: 024-3888063 / 06-51855277
> fax: 024-3608416
> e-mail: J.Kraaijeveld@Askesis.nl
> web: www.askesis.nl
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>