[h2] Wrong user/password, in AUTO_SERVER mode

[Goran Schwarz]

Hi there!



Banging my head here. So what am I doing wrong???

Error: org.h2.jdbc.JdbcSQLException: Wrong user name or password (but only
in auto_server mode, when connecting using TCP url)





Starting database in embedded mode from my application (at a server process,
at Linux Redhat 7):

My app starts using the following URL:

jdbc:h2:file:/asetune/data/SYB_SEK_MXGT25_2017-06-29;DATABASE_TO_UPPER=false
;MAX_COMPACT_TIME=2000;COMPRESS=TRUE;AUTO_SERVER=TRUE;WRITE_DELAY=5000





Lock file looks like: (where I can pick up the port number)

more /asetune/data/SYB_SEK_MXGT25_2017-06-29.lock.db

#FileLock

#Thu Jun 29 15:37:45 CEST 2017

hostName=sek-asetune.sek.se

id=15cf41266f6db8fd631ad1919b0cc4bbe7917a833ed

method=file

server=10.46.31.181\:45280





Now I want to connect to the database from another tool (possibly at another
computer, or a PC running windows)

But for simplicity I use "org.h2.tools.Shell" on the same machine to test
connectivity.



OK: And it works with FILE URL:

[***@sek-asetune lib]$ java -cp h2-1.4.194.jar org.h2.tools.Shell -url
'jdbc:h2:file:/asetune/data/SYB_SEK_MXGT25_2017-06-29;DATABASE_TO_UPPER=fals
e;AUTO_SERVER=TRUE' -user sa -password ''



Welcome to H2 Shell 1.4.194 (2017-03-10)

Exit with Ctrl+C

Commands are case insensitive; SQL statements end with ';'

help or ? Display this help

list Toggle result list / stack trace mode

maxwidth Set maximum column width (default is 100)

autocommit Enable or disable autocommit

history Show the last 20 statements

quit or exit Close the connection and exit



sql> select * from INFORMATION_SCHEMA.CATALOGS;

CATALOG_NAME

SYB_SEK_MXGT25_2017-06-29

(1 row, 13 ms)

sql> exit

Connection closed

[***@sek-asetune lib]$



FAIL: But if FAILS with TCP URL:

[***@sek-asetune lib]$ java -cp h2-1.4.194.jar org.h2.tools.Shell -url
'jdbc:h2:tcp://sek-asetune.sek.se:45280/asetune/data/SYB_SEK_MXGT25_2017-06-
29;DATABASE_TO_UPPER=false;AUTO_SERVER=TRUE' -user sa -password ''

Exception in thread "main" org.h2.jdbc.JdbcSQLException: Wrong user name or
password [28000-194]

at
org.h2.message.DbException.getJdbcSQLException(DbException.java:345)

at org.h2.message.DbException.get(DbException.java:179)

at org.h2.message.DbException.get(DbException.java:155)

at org.h2.message.DbException.get(DbException.java:144)

at
org.h2.server.TcpServer.checkKeyAndGetDatabaseName(TcpServer.java:509)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:123)

at java.lang.Thread.run(Thread.java:745)



at org.h2.engine.SessionRemote.done(SessionRemote.java:629)

at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:134)

at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:453)

at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:334)

at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:116)

at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:100)

at org.h2.Driver.connect(Driver.java:69)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at org.h2.tools.Shell.runTool(Shell.java:148)

at org.h2.tools.Shell.main(Shell.java:81)

[***@sek-asetune lib]$



Obviously the port are up and running. If it would have been the wrong port
I would have got error message similar to:

org.h2.jdbc.JdbcSQLException: Connection is broken:
"java.net.ConnectException: Connection refused (Connection refused):
sek-asetune.sek.se:45289" [90067-194]





What the heck am I doing wrong???

I was assuming that AUTO_SERVER=TRUE started up a port that "another
process" could connect to, using the same user/password.



Thanks for your help

/Goran Schwarz