Re: Need help getting JDBC setup.

Hi there

I've got something similar, but using the C interface (using libpq)

When I am an ordinary user (no createdb or createuser priv etc) and try to
change my
password with "alter user xyz with password abc" , I get an error that I do not
have
update privs in the pg_shadow table

What I still would like to know is how to allow a not priviledged user to
changed his/her
password from my application

Thanx
Stephen

Peter Mount wrote:

> Hmmm, this is a wierd one. I can't see anything wrong with either your
> pg_hba.conf, nor the java code.
>
> What happens if you change password to crypt in pg_hba.conf? (crypt is
> virtually the same as password)
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council
>
> -----Original Message-----
> From: Marcus Alday [mailto:alday@home.com]
> Sent: Monday, June 26, 2000 10:23 AM
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] Need help getting JDBC setup.
>
> Hi,
>         I'm trying to get the JDBC driver to interface with my database,
> and I
> can't, for the life of me, figure out what's going on. I am hoping one
> of the
> postgresql gurus out there could help me out a little.
>
> I'm running RedHat 6.2, and I'm running the standard Posgresql
> distribution
> that came with RedHat. I believe it's 6.5.2. I have downloaded the JDBC
> drivers
> and installed them at
>
> /usr/lib/pgsql/jdbc6.5.2.jar
>
> I have modified the pg_hba.conf file to have the line
>
> host         all         127.0.0.1     255.255.255.255   password
>
> I have added a user 'client' by doing a 'CREATE USER client SET PASSWORD
> password'
> ( or something like that. The password is not 'password')
>
> Here is the java code I have to try and test this
>
> /**
>  * Code from aw_pgsql_book.pdf pg 191
>  *
> **/
> import java.io.*;
> import java.sql.*;
>
> public class test
> {
>         Connection    conn;
>         Statement     stmt;
>         String        state_code;
>
>         public test() throws ClassNotFoundException,
>                              FileNotFoundException,
>                              IOException,
>                              SQLException
>         {
>                 Class.forName("postgresql.Driver");
>                 conn =
> DriverManager.getConnection("jdbc:postgresql:coffeebreak","client","password
> ");
>
>                 stmt = conn.createStatement();
>
>                 ResultSet res = stmt.executeQuery ( "SELECT * FROM
> coffees");
>                 if(res != null)
>                 {
>                         while(res.next())
>                         {
>                                 String str1 = res.getString(1);
>                                 System.out.println(str1);
>                         }
>                 }
>                 res.close();
>                 stmt.close();
>                 conn.close();
>         }
>
>         public static void main(String args[])
>         {
>                 try
>                 {
>                         test t = new test();
>                 }
>                 catch( Exception e )
>                 {
>                         System.err.println("Exception caught:  " + e );
>                         e.printStackTrace();
>                 }
>         }
> }
>
> And the error I get is this:
>
> Exception caught:  Something unusual has occured to cause the driver to
> fail.
> Please report this exception: java.sql.SQLException: Password
> authentication
> failed for user 'client'
>
> Something unusual has occured to cause the driver to fail. Please report
> this
> exception: java.sql.SQLException: Password authentication failed for
> user 'client'
>         at postgresql.Driver.connect(Driver.java, Compiled Code)
>         at java.sql.DriverManager.getConnection(DriverManager.java,
> Compiled Code)
>         at java.sql.DriverManager.getConnection(DriverManager.java,
> Compiled Code)
>         at test.<init>(test.java, Compiled Code)
>         at test.main(test.java, Compiled Code)
>
> Now I'm not sure why I'm getting an authentication error, as I'm using
> the correct password in my
> code. Does anyone have an idea?
>
> thanks
> marcus alday
>
> alday@home.com