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.