Thread: jdbc interface problems with jdk1.2
Hello, I have been trying to get a win95 system to connect to a postgresql database on a linux system. The linux system is a debian "potato" system with a 2.2.10 kernel. The version of postgresql is 6.5 I have installed posgresql, created a database "doug", created a user "doug" and given the user a password. The password file was created using the command pg_passwd /var/postgresql/passwd In the postmaster.init file I added PGALLOWTCPIP=yes and in the file pb_hba.conf I added the following line to the end of the file host doug IP.ADDRESS.OF PC 255.255.255.0 password /var/postgres/passwd When I try to run the example.basic example from the PC, I get the following error message: jC:\jdk1.2\DSNBrowse>java example.basic jdbc:postgresql://dragon:5432/doug d oug db PostgreSQL basic test v6.3 rev 1 Starting constructor for basic continueing constructor for basic Connecting to Database URL = jdbc:postgresql://dragon:5432/doug Exception caught. Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: Password authentication failed for user 'doug' Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: Password authentication failed for user 'doug' at postgresql.Driver.connect(Driver.java:112) at java.sql.DriverManager.getConnection(CompiledCode) at java.sql.DriverManager.getConnection(DriverManager.java:137) at example.basic.<init>(basic.java:34) at example.basic.main(basic.java:168) Does anybody have an idea of what I can try to get this working? Thanks, Doug
Doug Thistlethwaite <doug.t@deltanet.com> writes:
> Password authentication failed for user 'doug'
>
> Does anybody have an idea of what I can try to get this working?
This tells you you are getting pretty far: you are making a TCP
connection, and the postmaster is recognizing that the entry for
your IP address in pg_hba demands password authentication. So,
either you are supplying the wrong password from the client end,
or something's wrong with the password file.
There might be more info in the postmaster log file than is reported
to the client --- did you look there?
One potential typo stands out in your message:
> The password file was created using the command pg_passwd
> /var/postgresql/passwd ^^^^^^^^^^
> host doug IP.ADDRESS.OF PC 255.255.255.0 password
> /var/postgres/passwd ^^^^^^^^
Prolly that's just a transcription error in your message, but if
it's real...
regards, tom lane
Yes, that was a typo on my part. I also found out that the MASK should be 255.255.255.255 if I want only the single system to access my database... But that did not fix the problem either. Any more suggestions would be appriciated! Doug Tom Lane wrote: > Doug Thistlethwaite <doug.t@deltanet.com> writes: > > Password authentication failed for user 'doug' > > > > Does anybody have an idea of what I can try to get this working? > > This tells you you are getting pretty far: you are making a TCP > connection, and the postmaster is recognizing that the entry for > your IP address in pg_hba demands password authentication. So, > either you are supplying the wrong password from the client end, > or something's wrong with the password file. > > There might be more info in the postmaster log file than is reported > to the client --- did you look there? > > One potential typo stands out in your message: > > > The password file was created using the command pg_passwd > > /var/postgresql/passwd > ^^^^^^^^^^ > > host doug IP.ADDRESS.OF PC 255.255.255.0 password > > /var/postgres/passwd > ^^^^^^^^ > > Prolly that's just a transcription error in your message, but if > it's real... > > regards, tom lane