Bugs item #2805368, was opened at 2009-06-12 12:39
Message generated for change (Comment added) made by vzzzbx
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2805368&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Mapi
Group: Java CVS Head
Status: Closed
Resolution: Invalid
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Fabian (mr-meltdown)
Summary: Mapi: JDBC cannot connect:
Initial Comment:
The JDBC client 1.10 seems to not be able to connect to the May2009 release
monetdb instances?
The following error is given:
Exception in thread "main" java.sql.SQLException:
InvalidCredentialsException:checkCredentials:invalid credentials for user
'monetdb'
at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:220)
at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:159)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
In the May2009 branch I could find a possible cause in MapiSocket.java (line
424-457) where the password is overriden which might have been set at line 400.
Fabian, could you have a look?
----------------------------------------------------------------------
Comment By: Wouter Alink (vzzzbx)
Date: 2009-06-12 14:16
Message:
Hmmm,
Vault keys where probably the cause of my confusion:
When you do not specify a vault-key, starting mserver5 will cause a
warning (which asks you to set it)
If you do set the vault-key, then the database that has just been created
will become unusable (user 'monetdb' cannot login), so you first have to
delete the respective dbfarm folder after setting the vault-key.
Perhaps a warning in monet5.conf would be nice, which would say something:
"warning: changing the vault-key will make all existing databases
inaccessible".
And another experiment i just did showed another bug, when setting an
zero-size vault-key, MonetDB correctly warns about the zero-sized key, but
crashes upon first attempt to connect to it with an mclient.
$ touch ~/opt/MonetDB-stable-debug/etc/monetdb.secret
$ mserver5 --dbname=aap --dbinit="include sql;" --set mapi_port=50100
# MonetDB server v5.12.0, based on kernel v1.30.0
# Serving database 'aap', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
#warning: your vault key is too short (0), enlarge your vault key!
# Listening for connection requests on mapi:monetdb://127.0.0.1:50100/
# MonetDB/SQL module v2.30.0 loaded
>Floating point exception
----------------------------------------------------------------------
Comment By: Fabian (mr-meltdown)
Date: 2009-06-12 14:08
Message:
This must have been a database that once was a trunk thinghy, as it speaks
proto 9, so it's not the previous release, which spoke proto 8.
----------------------------------------------------------------------
Comment By: Wouter Alink (vzzzbx)
Date: 2009-06-12 14:05
Message:
For the record:
RD 1244801341680: read final block: 56 bytes
RX 1244801341680: HbbH4Fxu:mserver:9:RIPEMD160,SHA256,SHA1,MD5:LIT:SHA512:
RD 1244801341680: inserting prompt
TD 1244801341693: write final block: 67 bytes
TX 1244801341693:
BIG:monetdb:{SHA1}b1c047bf133001d81e91d985b777c7ceee17ce9c:sql:aap:
RD 1244801341694: read final block: 85 bytes
RX 1244801341694: !InvalidCredentialsException:checkCredentials:invalid
credentials for user 'monetdb'
RD 1244801341694: inserting prompt
----------------------------------------------------------------------
Comment By: Wouter Alink (vzzzbx)
Date: 2009-06-12 14:03
Message:
found it: database was corrupted. unfortunately I cannot reproduce how the
database got corrupted. will close this bugreport. (and reopen when i can
reproduce)
----------------------------------------------------------------------
Comment By: Fabian (mr-meltdown)
Date: 2009-06-12 13:46
Message:
can you please let JDBC make a debug-log and attach/mail?
----------------------------------------------------------------------
Comment By: Wouter Alink (vzzzbx)
Date: 2009-06-12 12:54
Message:
my mistake... misinterpreted the code. There's nothing wrong in MapiSocket,
at least not what I described. But I still don't know why I can't connect.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2805368&group_id=56967
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
