I am using python-monetdb 11.16.0.7. I created my database farm and database according to instructions given below (source:
http://www.monetdb.org/Documentation/monetdbd)
% monetdbd start /home/my-dbfarm
% monetdb create my-first-db
Then I tried to connect to the database using the below mentioned command in python(
https://pypi.python.org/pypi/python-monetdb/). Upon doing so I am getting the below mentioned error:
>import monetdb.sql >connection=monetdb.sql.connect(username="monetdb",password="monetdb",hostname="localhost",database="my-first-db");
File "/usr/local/lib/python2.7/dist-packages/monetdb/sql/__init__.py", line 28, in connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/monetdb/sql/connections.py", line 58, in __init__
unix_socket=unix_socket)
File "/usr/local/lib/python2.7/dist-packages/monetdb/mapi.py", line 93, in connect
self.socket.connect((hostname, port))
File "/usr/lib/python2.7/socket.py", line 224, in meth
return getattr(self._sock,name)(*args)
socket.error: [Errno 111] Connection refused
Can someone please help me with this?
Also my my-first-db resides inside my db-farm? I am not getting as to what should I do?