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?