Problems connecting over tcp-ip BUG?
От | Fredrik Wendt |
---|---|
Тема | Problems connecting over tcp-ip BUG? |
Дата | |
Msg-id | 3C8AADFC.5030902@linknet.se обсуждение исходный текст |
Список | 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
В списке pgsql-jdbc по дате отправления: