Hi Rose,


On 10/19/2013 12:17 PM, Rose Beck wrote:
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?


Are you sure monetdbd is running?

Can you use mclient to connect to the database?


 - Gijs