Home > Archive > PostgreSQL JDBC > December 2005 > JDBC / JBoss connection problem on Debian









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author JDBC / JBoss connection problem on Debian
Joost Kraaijeveld

2005-12-23, 9:23 am

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

Greg Patnude

2005-12-29, 11:23 am

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
>



Greg Patnude

2005-12-29, 11:23 am

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
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com