[MonetDB-users] Kettle and MonetDB
Hello, I have just installed Kettle 3.1 on my Archlinux machine. I wanted to use it with MonetDB but when i try to create a JDBC connection i get the following message: Error connecting to database [MonetDB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Server challenge string unusable! Challenge contains too few tokens: !an internal error has occurred, please try again later I have merovingian running in the back and created a database "pentaho". See status below: bash-3.2# monetdb status -l pentaho pentaho: location: /usr/local/MonetDB/var/MonetDB5/dbfarm/pentaho database name: pentaho state: running locked: no scenarios: mal sql msql connections: mapi:monetdb://myhost:50001/ start count: 3 stop count: 2 crash count: 0 current uptime: 51m 10s average uptime: 13m 12s maximum uptime: 14m 42s minimum uptime: 11m 41s last crash: (unknown) last start: 2009-02-21 13:03:00 average of crashes in the last start attempt: 0 average of crashes in the last 10 start attempts: 0.00 average of crashes in the last 30 start attempts: 0.00 Can anybody help me with this. I already use the lates .jar (monetdb-1.9-jdbc). Kind Regards, Dennis -- View this message in context: http://www.nabble.com/Kettle-and-MonetDB-tp22141036p22141036.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 21-02-2009 13:57:16 -0800, denvro wrote:
Hello,
I have just installed Kettle 3.1 on my Archlinux machine. I wanted to use it with MonetDB but when i try to create a JDBC connection i get the following message:
Error connecting to database [MonetDB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database
Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Server challenge string unusable! Challenge contains too few tokens: !an internal error has occurred, please try again later
This is actually a bug in the protocol, JDBC doesn't expect an error to be thrown. Your problem is not with JDBC, but with merovingian or the database: "an internal error has occurred, please try again later"
I have merovingian running in the back and created a database "pentaho". See status below:
Can you look in merovingian.log to see what it reports for database pentaho?
Thanx for the reply, This is how the merovingian.log looks like after a clean reboot and trying to make a new connection in Kettle: TME 2009-02-23 03:58:54 MSG merovingian[1951]: Merovingian 0.8 starting ... MSG merovingian[1951]: monitoring dbfarm /usr/local/MonetDB/var/MonetDB5/dbfarm MSG merovingian[1951]: listening for TCP connections on myhost:50000 MSG merovingian[1951]: listening for UDP messages on myhost:50000 MSG merovingian[1951]: listening for UNIX connections on /usr/local/MonetDB/var/MonetDB5/dbfarm/.merovingian_control MSG merovingian[1951]: discovered neighbour 10.0.2.15 MSG merovingian[1951]: discovered neighbour database demo at mapi:monetdb://myhost:50000/ (refresh from 10.0.2.15 in 660 seconds) MSG merovingian[1951]: discovered neighbour database pentaho at mapi:monetdb://myhost:50000/ (refresh from 10.0.2.15 in 660 seconds) MSG merovingian[1951]: refresh from 10.0.2.15 for database demo MSG merovingian[1951]: refresh from 10.0.2.15 for database pentaho MSG merovingian[1951]: starting database 'pentaho', up min/avg/max: 701/1677/3449, crash average: 0.00 0.00 0.00 (3-3=0) MSG pentaho[2158]: executing '/usr/local/MonetDB/bin/mserver5' for database 'pentaho' MSG pentaho[2158]: # MonetDB server v5.8.4, based on kernel v1.26.4 MSG pentaho[2158]: # Serving database 'pentaho', using 1 thread MSG pentaho[2158]: # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked MSG pentaho[2158]: # Copyright (c) 1993-July 2008 CWI. MSG pentaho[2158]: # Copyright (c) August 2008- MonetDB B.V., all rights reserved MSG pentaho[2158]: # Visit http://monetdb.cwi.nl/ for further information MSG pentaho[2158]: # Listening for connection requests on mapi:monetdb://myhost:50001/ MSG merovingian[1951]: proxying client 127.0.0.1:55370 for database 'pentaho' to mapi:monetdb://myhost:50001/ MSG merovingian[1951]: starting a proxy failed: cannot get address for hostname 'myhost': Success TME 2009-02-23 04:04:17 ERR merovingian[1951]: client error: cannot get address for hostname 'myhost': Success I entered "localhost" as hostname for the connection, but it looks like he's trying to do something with "myhost"? Fabian Groffen wrote:
On 21-02-2009 13:57:16 -0800, denvro wrote:
Hello,
I have just installed Kettle 3.1 on my Archlinux machine. I wanted to use it with MonetDB but when i try to create a JDBC connection i get the following message:
Error connecting to database [MonetDB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database
Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Server challenge string unusable! Challenge contains too few tokens: !an internal error has occurred, please try again later
This is actually a bug in the protocol, JDBC doesn't expect an error to be thrown. Your problem is not with JDBC, but with merovingian or the database:
"an internal error has occurred, please try again later"
I have merovingian running in the back and created a database "pentaho". See status below:
Can you look in merovingian.log to see what it reports for database pentaho?
------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://www.nabble.com/Kettle-and-MonetDB-tp22141036p22160384.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 23-02-2009 04:11:52 -0800, denvro wrote:
Thanx for the reply,
This is how the merovingian.log looks like after a clean reboot and trying to make a new connection in Kettle:
MSG pentaho[2158]: # Listening for connection requests on mapi:monetdb://myhost:50001/ MSG merovingian[1951]: proxying client 127.0.0.1:55370 for database 'pentaho' to mapi:monetdb://myhost:50001/ MSG merovingian[1951]: starting a proxy failed: cannot get address for hostname 'myhost': Success TME 2009-02-23 04:04:17 ERR merovingian[1951]: client error: cannot get address for hostname 'myhost': Success
Here is the real problem.
I entered "localhost" as hostname for the connection, but it looks like he's trying to do something with "myhost"?
Your system is configured to be called "myhost", wheras it is not reachable as "myhost". Perhaps an entry for myhost is missing in your /etc/hosts file.
participants (2)
-
denvro -
Fabian Groffen