Communication closed during authentication;Socket has been closed

[Balaji M]

Hi ,

I have the  same issue  when connect to encrypted database . iam getting  "Communication closed during authentication;Socket has been closed " error .

Please help
Connection string iam using "ODBC;DSN=;SERVER=localhost;DATABASE=GE04;CIPHER=AES;PORT=5435;UID=admin;PWD=abc123 abc123;DRIVER={PostgreSQL Unicode}"

Note : with out Encrypting the database i can connect.

Thanks and Regards
Balaji Manickam

[Thomas Mueller]

Hi,

Please don't double post. Here my answer again (in case somebody else searches for this):

Sorry, you can not use "CIPHER=AES" in the ODBC connection string. This is only allowed in the JDBC database URL. 

You would need to set the database name to "GE04;CIPHER=AES", but I'm not sure if this is possible or how to do it.

Or, as a workaround, you could start the PgServer with an undocumented feature "key" that allows mapping of one database URL to another:

    java org.h2.tools.Server -pg -key GE04 "~/temp/ge04;cipher=aes"

I will need to document this as follows:

To map an ODBC database name to a different JDBC database name, use the option "-key" when starting the server. Please note only one mapping is allowed. The following will map the ODBC database named "TEST" to the database URL "jdbc:h2:~/data/test;cipher=aes":

    java org.h2.tools.Server -pg -key TEST "~/data/test;cipher=aes"

Regards,
Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.