Hi,
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
On Thu, Sep 19, 2013 at 4:34 AM, Balaji M <[email protected]> wrote:
> Hi ,
>
> I have the same issue when connect to encrypted data base 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}"
>
> Thanks and Regards
> Balaji Manickam
>
>
> On Saturday, May 22, 2010 1:52:09 PM UTC+8, Paul wrote:
>
>> Hi,
>>
>> > Most likely the problem is that only simple names are supported in the
>> > "database" property of the connection property. Therefore you can't
>> > append ";CIPHER=..." there. Is that the problem? It looks like there
>> > needs to be some escape mechanism for that. Otherwise there is nothing
>> > special about using ODBC, it should work exactly the same as when
>> > using JDBC. That is, the database password is the combination of the
>> > file password, a space, and the user password.
>>
>> Yes, if I put DBNAME;CIPHER=AES then the database will be created as
>> DBNAME;CIPHER=AES.h2.db
>> If I remove CIPHER=AES, then I can't connect to the db
>> The ODBC said "Communications closed during the authentication; Socket
>> has been closed"
>> Looking at the console H2 it said:
>> "org.h2.jdbc.JdbcSQLException: Wrong user name or password [8004-135]
>> at
>> org.h2.message.DbException.**getJdbcSQLException(**DbException.java:327)
>> at org.h2.message.DbException.**get(DbException.java:167)
>> at org.h2.message.DbException.**get(DbException.java:144)
>> at org.h2.message.DbException.**get(DbException.java:133)
>> at org.h2.engine.Engine.**validateUserAndPassword(**Engine.java:
>> 275)
>> at org.h2.engine.Engine.**getSession(Engine.java:133)
>> at org.h2.engine.Session.**createSession(Session.java:**119)
>> at
>> org.h2.engine.SessionRemote.**connectEmbeddedOrServer(**SessionRemote.java:
>>
>> 239)
>> at
>> org.h2.engine.SessionRemote.**createSession(SessionRemote.**java:217)
>> at org.h2.jdbc.JdbcConnection.<**init>(JdbcConnection.java:111)
>> at org.h2.server.pg.**PgServerThread.process(**PgServerThread.java:
>>
>> 188)
>> at org.h2.server.pg.**PgServerThread.run(**PgServerThread.java:76)
>>
>> at java.lang.Thread.run(Unknown Source)"
>>
>> And this is the trace:
>> Init
>> StartupMessage
>> version 196608 (3.0)
>> param database=DBNAME;CIPHER=AES
>> param user=Db-u5312
>> param DateStyle=ISO
>> param extra_float_digits=2
>> param geqo=on
>> PasswordMessage
>> Query
>> select oid, typbasetype from pg_type where typname = 'lo';
>> Terminate
>> Close
>> Disconnect
>> Close
>> Connect
>> Init
>> StartupMessage
>> version 196608 (3.0)
>> param database=DBNAME
>> param user=Db-u5312
>> param DateStyle=ISO
>> param extra_float_digits=2
>> param geqo=on
>> PasswordMessage
>> Disconnect
>> Close
>>
>>
>>
>> When from Ms Access connecting to ODBC to retrieve the tables, this is
>> the trace:
>> Connect
>> Disconnect
>> Close
>> Connect
>> PG server running on pg://192.168.1.111:5435 (only local connections)
>> Disconnect
>> Close
>> Connect
>> Init
>> StartupMessage
>> version 196608 (3.0)
>> param database=DBNAME
>> param user=Db-u5312
>> param DateStyle=ISO
>> param extra_float_digits=2
>> param geqo=on
>> param client_encoding=UTF8
>> PasswordMessage
>> Query
>> select oid, typbasetype from pg_type where typname = 'lo';
>> Query
>> SELECT Config, nValue FROM MSysConf;
>> Query
>> select relname, nspname, relkind from pg_catalog.pg_class c,
>> pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid =
>> relnamespace order by nspname, relname;
>>
>>
>> > - Unable to link to a table that has a field with primary key or
>> > unique key, for example: id_employee INT AUTO_INCREMENT PRIMARY KEY
>> > The table is shown, but when I select to link it, it says error.
>> > If I make the field INT AUTO_INCREMENT, there is no problem linking to
>> it.
>>
>> When linking to a table with PRIMARY KEY field:
>> The trace:
>> Query
>> select c.relhasrules, c.relkind, c.relhasoids from
>> pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid =
>> c.relnamespace and c.relname = E'ADJUSTSTYLES' and u.nspname =
>> E'PUBLIC';
>> Query
>> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
>> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
>> c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join
>> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like
>> E'ADJUSTSTYLES' and n.nspname like E'PUBLIC') inner join
>> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
>> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
>> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
>> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
>> attnum;
>> Query
>> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
>> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
>> c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join
>> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname =
>> E'ADJUSTSTYLES' and n.nspname = E'PUBLIC') inner join
>> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
>> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
>> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
>> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
>> attnum;
>> Query
>> select c.relname, i.indkey, i.indisunique, i.indisclustered, a.amname,
>> c.relhasrules, n.nspname, c.oid from pg_catalog.pg_index i,
>> pg_catalog.pg_class c, pg_catalog.pg_class d, pg_catalog.pg_am a,
>> pg_catalog.pg_namespace n where d.relname = E'ADJUSTSTYLES' and
>> n.nspname = E'PUBLIC' and n.oid = d.relnamespace and d.oid =
>> i.indrelid and i.indexrelid = c.oid and c.relam = a.oid order by
>> i.indisprimary desc, i.indisunique, n.nspname, c.relname;
>> Query
>> select pg_get_indexdef(20, 1, true);
>> Query
>> select pg_get_indexdef(20, 4, true);
>> Query
>> select pg_get_indexdef(20, 5, true);
>> Query
>> select pg_get_indexdef(20, 7, true);
>> Query
>> select pg_get_indexdef(20, 29, true);
>>
>> The access form:
>> "Reserved error (-7747); there is no message for this error."
>>
>>
>> Trying to link again, the trace is getting long:
>> Connect
>> Init
>> StartupMessage
>> version 196608 (3.0)
>> param database=DBNAME
>> param user=Db-u5312
>> param DateStyle=ISO
>> param extra_float_digits=2
>> param geqo=on
>> param client_encoding=UTF8
>> PasswordMessage
>> Query
>> select oid, typbasetype from pg_type where typname = 'lo';
>> Query
>> select relname, nspname, relkind from pg_catalog.pg_class c,
>> pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid =
>> relnamespace order by nspname, relname;
>> Query
>> select c.relhasrules, c.relkind, c.relhasoids from
>> pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid =
>> c.relnamespace and c.relname = E'ADJUSTSTYLES' and u.nspname =
>> E'PUBLIC';
>> Query
>> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
>> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
>> c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join
>> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like
>> E'ADJUSTSTYLES' and n.nspname like E'PUBLIC') inner join
>> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
>> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
>> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
>> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
>> attnum;
>> Query
>> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
>> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
>> c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join
>> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname =
>> E'ADJUSTSTYLES' and n.nspname = E'PUBLIC') inner join
>> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
>> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
>> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
>> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
>> attnum;
>> Query
>> select c.relname, i.indkey, i.indisunique, i.indisclustered, a.amname,
>> c.relhasrules, n.nspname, c.oid from pg_catalog.pg_index i,
>> pg_catalog.pg_class c, pg_catalog.pg_class d, pg_catalog.pg_am a,
>> pg_catalog.pg_namespace n where d.relname = E'ADJUSTSTYLES' and
>> n.nspname = E'PUBLIC' and n.oid = d.relnamespace and d.oid =
>> i.indrelid and i.indexrelid = c.oid and c.relam = a.oid order by
>> i.indisprimary desc, i.indisunique, n.nspname, c.relname;
>> Query
>> select pg_get_indexdef(20, 1, true);
>> Query
>> select pg_get_indexdef(20, 2, true);
>> Query
>> select pg_get_indexdef(20, 3, true);
>> Query
>> select pg_get_indexdef(20, 4, true);
>> Query
>> select pg_get_indexdef(20, 5, true);
>> Query
>> select pg_get_indexdef(20, 6, true);
>> Query
>> select pg_get_indexdef(20, 7, true);
>> Query
>> select pg_get_indexdef(20, 8, true);
>> Query
>> select pg_get_indexdef(20, 9, true);
>> Query
>> select pg_get_indexdef(20, 10, true);
>> Query
>> select pg_get_indexdef(20, 11, true);
>> Query
>> select pg_get_indexdef(20, 12, true);
>> Query
>> select pg_get_indexdef(20, 13, true);
>> Query
>> select pg_get_indexdef(20, 14, true);
>> Query
>> select pg_get_indexdef(20, 15, true);
>> Query
>> select pg_get_indexdef(20, 16, true);
>> Query
>> select pg_get_indexdef(20, 17, true);
>> Query
>> select pg_get_indexdef(20, 18, true);
>> Query
>> select pg_get_indexdef(20, 19, true);
>> Query
>> select pg_get_indexdef(20, 20, true);
>> Query
>> select pg_get_indexdef(20, 21, true);
>> Query
>> select pg_get_indexdef(20, 22, true);
>> Query
>> select pg_get_indexdef(20, 23, true);
>> Query
>> select pg_get_indexdef(20, 24, true);
>> Query
>> select pg_get_indexdef(20, 25, true);
>> Query
>> select pg_get_indexdef(20, 26, true);
>> Query
>> select pg_get_indexdef(20, 27, true);
>> Query
>> select pg_get_indexdef(20, 28, true);
>> Query
>> select pg_get_indexdef(20, 29, true);
>> Disconnect
>> Close
>>
>>
>> >
>> > > - And the big problem is, when a table has _ (underscore) in the
>> name,
>> > > for example: table name employee_jobs, when trying to link to that
>> > > table, ms access says the table is not exists, very strange why it
>> > > said there is no such table, because I pick the table from the list
>> of
>> > > the tables that shown by ms access.
>> >
>>
>> When linking to a table with the name has _ (underscore):
>> The trace:
>> Connect
>> Init
>> StartupMessage
>> version 196608 (3.0)
>> param database=DBNAME
>> param user=Db-u5312
>> param DateStyle=ISO
>> param extra_float_digits=2
>> param geqo=on
>> param client_encoding=UTF8
>> PasswordMessage
>> Query
>> select oid, typbasetype from pg_type where typname = 'lo';
>> Query
>> select relname, nspname, relkind from pg_catalog.pg_class c,
>> pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid =
>> relnamespace order by nspname, relname;
>> Query
>> select c.relhasrules, c.relkind, c.relhasoids from
>> pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid =
>> c.relnamespace and c.relname = E'PROJECT_DATA' and u.nspname =
>> E'PUBLIC';
>> Query
>> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
>> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
>> c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join
>> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like
>> E'PROJECT\\_DATA' and n.nspname like E'PUBLIC') inner join
>> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
>> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
>> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
>> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
>> attnum;
>>
>> The access form said:
>> "The Microsoft Jet database engine could not find the object
>> 'PUBLIC.PROJECT_DATA'. Make sure the object exists and that you spell
>> its name and the path name correctly."
>>
>> Perhaps because of this: c.relname like E'PROJECT\\_DATA' and
>> n.nspname like E'PUBLIC'
>> Why it search for PROJECT\\_DATA not PROJECT_DATA, the previous query
>> it search for c.relname = E'PROJECT_DATA' and u.nspname = E'PUBLIC'
>>
>>
>> And this is when connecting to a table without underscore and without
>> primary key.
>> Connect successfully:
>> Init
>> StartupMessage
>> version 196608 (3.0)
>> param database=DBNAME
>> param user=Db-u5312
>> param DateStyle=ISO
>> param extra_float_digits=2
>> param geqo=on
>> param client_encoding=UTF8
>> PasswordMessage
>> Query
>> select oid, typbasetype from pg_type where typname = 'lo';
>> Query
>> select relname, nspname, relkind from pg_catalog.pg_class c,
>> pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid =
>> relnamespace order by nspname, relname;
>> Query
>> select c.relhasrules, c.relkind, c.relhasoids from
>> pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid =
>> c.relnamespace and c.relname = E'ADJUSTSTYLES' and u.nspname =
>> E'PUBLIC';
>> Query
>> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
>> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
>> c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join
>> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like
>> E'ADJUSTSTYLES' and n.nspname like E'PUBLIC') inner join
>> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
>> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
>> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
>> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
>> attnum;
>> Query
>> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
>> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
>> c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join
>> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname =
>> E'ADJUSTSTYLES' and n.nspname = E'PUBLIC') inner join
>> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
>> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
>> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
>> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
>> attnum;
>> Query
>> select c.relname, i.indkey, i.indisunique, i.indisclustered, a.amname,
>> c.relhasrules, n.nspname, c.oid from pg_catalog.pg_index i,
>> pg_catalog.pg_class c, pg_catalog.pg_class d, pg_catalog.pg_am a,
>> pg_catalog.pg_namespace n where d.relname = E'ADJUSTSTYLES' and
>> n.nspname = E'PUBLIC' and n.oid = d.relnamespace and d.oid =
>> i.indrelid and i.indexrelid = c.oid and c.relam = a.oid order by
>> i.indisprimary desc, i.indisunique, n.nspname, c.relname;
>> Disconnect
>> Close
>>
>>
>> Thanks for the help
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to h2-database...@**
>> googlegroups.com.
>> For more options, visit this group at http://groups.google.com/**
>> group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en>.
>>
>>
>> --
> 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 [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
