I'm having problems connecting to a MonetDB 5 SQL database via the
Python interface. I am working on a Mac OS X (10.5.6) system, with
python 2.5.1. I downloaded and compiled the Feb 2009 SP2 release from
source and added the appropriate directory to my PYTHONPATH. When
running the connect command, I get some errors:
>>> import MonetSQLdb
>>> x = MonetSQLdb.connect(host='greensburg.local',user='scott',password='notmyrealpassword',lang='sql',dbname='HistoricalData')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "MonetSQLdb/__init__.py", line 131, in __init__
self._mapi = Mapi(kwargs['host'], kwargs['port'], kwargs['user'],
kwargs['password'], kwargs['lang'], kwargs['dbname'])
File "MonetDB/CMapi.py", line 30, in __init__
raise IOError(self.error_str())
IOError: !InvalidCredentialsException:checkCredentials:Invalid
credentials for user 'scott'
I have checked and double checked that my user name and password are
correct: I am able to login to the database from the same machine
using SQL Explorer in Eclipse with the same credentials. The
connection shows up in the merovingian log on the server as being
proxied to the appropriate databse. The weird thing is, it doesn't
show the connection ending until I quit() the python interactive
session, or try connecting again, or do something else with the
connection object (c = x.cursor() also causes a disconnect, and thows
an exception that complains that x is not defined).
Ideas anyone? The only thing I can think of that may be wrong is I'm
not using the same releases of MonetDB for the python library and the
server. mserver5 --version says I'm running MonetDB server v5.6.0
based on kernel v1.24.0 (I can't seem to remember/figure out which
named release this corresponds to). Do the versions need to be the
same?
Thanks,
Scott
