Trying to accomplish SSO from Windows

Поиск
Список
Период
Сортировка
От Bryan Montgomery
Тема Trying to accomplish SSO from Windows
Дата
Msg-id AANLkTinWun8RQ1Vw0JEsNXzx_HhAqGYAQj6LGTutvEG6@mail.gmail.com
обсуждение исходный текст
Ответы Re: Trying to accomplish SSO from Windows
Список pgsql-jdbc
Hello,
I've been looking for some examples on how to connect to a linux postgresql database from a java client running on Windows. The Jaas seems to be getting the credentials from my windows logon, but then the jdbc driver is blowing up with some sun classes looking for a non-existent file.

Hopefully there is some way to resolve this issue!

Thanks - Bryan.
Java code:
      try {
            Class.forName("org.postgresql.Driver");
            String url = "jdbc:postgresql://host.lab2k.net/nrgdb?loglevel=2&kerberosServerName=HTTP&jaasApplicationName=LoginJaas";
            Connection con = DriverManager.getConnection(url);
        } catch (Exception ex) {
            Logger.getLogger(LoginJaas.class.getName()).log(Level.SEVERE, null, ex);
        }

JAAS config:
LoginJaas {
com.sun.security.auth.module.Krb5LoginModule required debug=true useTicketCache=true;
};

Output:
16:13:56.374 (1) PostgreSQL 8.4 JDBC4 (build 701)
16:13:56.374 (1) Trying to establish a protocol version 3 connection to poe3b.lab2k.net:5432
16:13:56.405 (1)  FE=> StartupPacket(user=montgomeryb, database=nrgdb, client_encoding=UNICODE, DateStyle=ISO, extra_float_digits=2)
16:13:56.405 (1)  <=BE AuthenticationReqGSS
Debug is  true storeKey false useTicketCache true useKeyTab false doNotPrompt false ticketCache is null isInitiator true KeyTab is null refreshKrb5Config is false principal is null tryFirstPass is false useFirstPass is false storePass is false clearPass is false
Acquire TGT from Cache
Principal is Bryan@LAB2K.NET
Commit Succeeded

org.postgresql.util.PSQLException: GSS Authentication failed
        at org.postgresql.gss.GssAction.run(MakeGSS.java:152)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:337)
        at org.postgresql.gss.MakeGSS.authenticate(MakeGSS.java:48)
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:378)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:393)
        at org.postgresql.Driver.connect(Driver.java:267)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at javaapplication1.LoginJaas.main(LoginJaas.java:62)
SQLException: SQLState(08006)
Jul 8, 2010 4:13:56 PM javaapplication1.LoginJaas main
SEVERE: null
org.postgresql.util.PSQLException: GSS Authentication failed
        at org.postgresql.gss.GssAction.run(MakeGSS.java:152)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:337)
        at org.postgresql.gss.MakeGSS.authenticate(MakeGSS.java:48)
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:378)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:393)
        at org.postgresql.Driver.connect(Driver.java:267)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at javaapplication1.LoginJaas.main(LoginJaas.java:62)
Caused by: GSSException: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified))
        at sun.security.jgss.krb5.Krb5NameElement.getInstance(Krb5NameElement.java:110)
        at sun.security.jgss.krb5.Krb5MechFactory.getNameElement(Krb5MechFactory.java:80)
        at sun.security.jgss.GSSManagerImpl.getNameElement(GSSManagerImpl.java:188)
        at sun.security.jgss.GSSNameImpl.getElement(GSSNameImpl.java:428)
        at sun.security.jgss.GSSNameImpl.init(GSSNameImpl.java:157)
        at sun.security.jgss.GSSNameImpl.<init>(GSSNameImpl.java:127)
        at sun.security.jgss.GSSNameImpl.<init>(GSSNameImpl.java:111)
        at sun.security.jgss.GSSManagerImpl.createName(GSSManagerImpl.java:113)
        at org.postgresql.gss.GssAction.run(MakeGSS.java:93)
        ... 16 more
getConnection failed: org.postgresql.util.PSQLException: GSS Authentication failed

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Graham Leggett
Дата:
Сообщение: Re: Picking up strange queries for "pg_catalog"
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Trying to accomplish SSO from Windows