Problems connecting over tcp-ip BUG?

From: Fredrik Wendt <fredrik(dot)wendt(at)linknet(dot)se>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problems connecting over tcp-ip BUG?
Date: 2002-03-10 00:51:08
Message-ID: 3C8AADFC.5030902@linknet.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all!

I've tried searching both documentation and mailing lists for an answer
to what I'm doing wrong, but I can't find anything.

The problem (summary): I can't connect from another host, using password
or ident.

The setup for password is:

> cat pg_hba.conf | grep upfab
> host upfab 213.64.136.11 255.255.255.0 password

Looking in pg_shadow, the passwd field it shows thePassword.

> usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd
> |valuntil
> --------+--------+-----------+--------+--------+---------+------------+----------------------
> upfab | 1005|f |f |f |f |C0mp4q
> |

I connect with

> new Database("jdbc:postgresql://svearike.org/upfab", "upfab", "C0mp4q");

And finally, the error I get is:

> Something unusual has occured to cause the driver to fail. Please
> report this exception: Exception: java.sql.SQLException: Password
> authentication failed for user 'upfab'

HOWEVER! As I wrote this e-mail, I tested with another password,
'c0mp4q'. This gave me another error:

> Something unusual has occured to cause the driver to fail. Please
> report this exception: Exception: java.sql.SQLException: ERROR: No
> such function 'pg_encoding_to_char' with the specified attributes

I guess this is because the driver's intended for another version of
Postgres. BUT am I missing something or are you not supposed to use
capital C as the first letter in a password?

/
Fredrik Wendt

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fredrik Wendt 2002-03-10 01:08:18 Problems connecting over tcp-ip BUG?
Previous Message Dave Cramer 2002-03-09 15:41:33 Re: NullPointer at ResultSet.java:113