[Handle-info] problem: sql backend with postgres using ssl

[Konstantin Rekk <konstantin.rekk@gbv.de>]

Hello,

configured the handle server with 
postgres backend:

in config.dct

without ssl:
"storage_type" = "sql"
"sql_settings" = {
"sql_url" = "jdbc:postgresql://xxx.xxx.xxx.xxx:5432/fedora"
"sql_driver" = "org.postgresql.Driver"
"sql_login" = "xxxx"
"sql_passwd" = "xxxx"
"sql_read_only" = "no"
}

that works

with ssl:
"storage_type" = "sql"
"sql_settings" = {
"sql_url" =
"jdbc:postgresql://xxx.xxx.xxx.xxx:5432/fedora22?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory"
"sql_driver" = "org.postgresql.Driver"
"sql_login" = "xxxx"
"sql_passwd" = "xxxx"
"sql_read_only" = "no"
}

doesnt work.
The sql url should work (works with Quantum DB in Eclipse)

Gives Error:

Got SQL Exception org.postgresql.util.PSQLException: The connection
attempt failed.
HandleException (INTERNAL_ERROR) Error connecting:
org.postgresql.util.PSQLException: The connection attempt failed.
        at
net.handle.server.SQLHandleStorage.getConnection(SQLHandleStorage.java:211)
        at
net.handle.server.SQLHandleStorage.init(SQLHandleStorage.java:141)
        at
net.handle.server.HandleStorageFactory.getStorage(HandleStorageFactory.java:46)
        at net.handle.server.HandleServer.<init>(HandleServer.java:562)
        at
net.handle.server.AbstractServer.getInstance(AbstractServer.java:72)
        at net.handle.server.Main.initialize(Main.java:152)
        at net.handle.server.Main.main(Main.java:75)
Shutting down...

Any Ideas? 

Thank you! 

Yours, Konstantin


-- 
Konstantin Rekk
VZG (GBV), Göttingen, Berlin
0176 2100 6000
030 29003511
skype: krekk1970 
rekk@gbv.de
http://www.gbv.de


_______________________________________________
Handle-Info mailing list
Handle-Info@cnri.reston.va.us
http://www.handle.net/mailman/listinfo/handle-info