Troubles with Python API

newer
Memory bloat on concurrency - Any...

倪令斌

8 Aug 2017 8 Aug '17

2:02 p.m.

Hi, I want to set up an API to MonetDBwith Python. I have followed the instructions（https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/Python）and plan to make connection to my DB with this Python statement: import pymonetdb; connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb") But I got the following ERROR: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/__init__.py", line 48, in connect return Connection(*args, **kwargs) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/sql/connections.py", line 55, in __init__ unix_socket=unix_socket, connect_timeout=connect_timeout) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/mapi.py", line 139, in connect self.socket.connect((hostname, port)) File "/usr/lib/python2.7/socket.py", line 228, in meth return getattr(self._sock,name)(*args) socket.error: [Errno 111] Connection refused Do you have a hint for me how to solve this error? Many thanks, Lingbin

Attachments:

attachment.html (text/html — 2.0 KB)

Show replies by date

Ying Zhang

8 Aug 8 Aug

2:51 p.m.

Hai, It works for me (on macOS 10.12.6, with Jul2017 Mercurial source code): $ python2 Python 2.7.13 (default, Mar 17 2017, 09:22:56) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.42.1)] on darwin Type "help", "copyright", "credits" or "license" for more information.

...

...
...
import pymonetdb connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb") cur=connection.cursor() cur.execute("select * from tables") 50 cur.fetchone() (2001, u'schemas', 2000, None, 10, True, 0, 0, 0) cur.fetchone() (2007, u'types', 2000, None, 10, True, 0, 0, 0) quit()

$ pip list --format=columns | grep pymonetdb pymonetdb 1.0.5 Can you tell us which OS you use, and the software versions? Regards, Jennie

...

On 8 Aug 2017, at 16:02, 倪令斌 wrote:

Hi,

I want to set up an API to MonetDBwith Python. I have followed the instructions（https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/Python）and plan to make connection to my DB with this Python statement: import pymonetdb; connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb") But I got the following ERROR: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/__init__.py", line 48, in connect return Connection(*args, **kwargs) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/sql/connections.py", line 55, in __init__ unix_socket=unix_socket, connect_timeout=connect_timeout) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/mapi.py", line 139, in connect self.socket.connect((hostname, port)) File "/usr/lib/python2.7/socket.py", line 228, in meth return getattr(self._sock,name)(*args) socket.error: [Errno 111] Connection refused

Do you have a hint for me how to solve this error?

Many thanks,

Lingbin

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

倪令斌

9 Aug 9 Aug

2:40 a.m.

Thans for your reply! The OS I use is Ubuntu 16.04, and the Python Version is Python2.7.12( the 3.5.2 version is also installed by Ununtu, but the 2.7.12 version is defaulted). Actually, I have followed these steps as yours, but I met the ERROR when I input the command "connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb")". Thanks for your help. Best, lingbin At 2017-08-08 22:51:41, "Ying Zhang" wrote:

...

Hai,

It works for me (on macOS 10.12.6, with Jul2017 Mercurial source code):

$ python2 Python 2.7.13 (default, Mar 17 2017, 09:22:56) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.42.1)] on darwin Type "help", "copyright", "credits" or "license" for more information.

...
...
...
import pymonetdb connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb") cur=connection.cursor() cur.execute("select * from tables") 50 cur.fetchone() (2001, u'schemas', 2000, None, 10, True, 0, 0, 0) cur.fetchone() (2007, u'types', 2000, None, 10, True, 0, 0, 0) quit()

$ pip list --format=columns | grep pymonetdb pymonetdb 1.0.5

Can you tell us which OS you use, and the software versions?

Regards, Jennie

...
On 8 Aug 2017, at 16:02, 倪令斌 wrote:

Hi,

I want to set up an API to MonetDBwith Python. I have followed the instructions（https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/Python）and plan to make connection to my DB with this Python statement: import pymonetdb; connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb") But I got the following ERROR: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/__init__.py", line 48, in connect return Connection(*args, **kwargs) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/sql/connections.py", line 55, in __init__ unix_socket=unix_socket, connect_timeout=connect_timeout) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/mapi.py", line 139, in connect self.socket.connect((hostname, port)) File "/usr/lib/python2.7/socket.py", line 228, in meth return getattr(self._sock,name)(*args) socket.error: [Errno 111] Connection refused

Do you have a hint for me how to solve this error?

Many thanks,

Lingbin

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Ying Zhang

12:23 p.m.

Hai, Which version of MonetDB are you using? Our Jul2017 feature release had some problems on Debian and Ubuntu. I wonder if that could be the cause of your problem. In any case, I’d recommend you to upgrade to Jul2017-SP1. For more information about those releases, please see: https://www.monetdb.org/Downloads/ReleaseNotes Regards, Jennie

...

On 9 Aug 2017, at 04:40, 倪令斌 wrote:

Thans for your reply! The OS I use is Ubuntu 16.04, and the Python Version is Python2.7.12( the 3.5.2 version is also installed by Ununtu, but the 2.7.12 version is defaulted). Actually, I have followed these steps as yours, but I met the ERROR when I input the command "connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb")". Thanks for your help. Best, lingbin

At 2017-08-08 22:51:41, "Ying Zhang" wrote:

...
Hai,

It works for me (on macOS 10.12.6, with Jul2017 Mercurial source code):

$ python2 Python 2.7.13 (default, Mar 17 2017, 09:22:56) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.42.1)] on darwin Type "help", "copyright", "credits" or "license" for more information.

...
...
...
import pymonetdb connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb") cur=connection.cursor() cur.execute("select * from tables") 50 cur.fetchone() (2001, u'schemas', 2000, None, 10, True, 0, 0, 0) cur.fetchone() (2007, u'types', 2000, None, 10, True, 0, 0, 0) quit()

$ pip list --format=columns | grep pymonetdb pymonetdb 1.0.5

Can you tell us which OS you use, and the software versions?

Regards, Jennie

...
On 8 Aug 2017, at 16:02, 倪令斌 wrote:

Hi,

I want to set up an API to MonetDBwith Python. I have followed the instructions（https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/Python）and plan to make connection to my DB with this Python statement: import pymonetdb; connection=pymonetdb.connect(username="monetdb",password="monetdb",hostname="127.0.0.1",database="testdb") But I got the following ERROR: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/__init__.py", line 48, in connect return Connection(*args, **kwargs) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/sql/connections.py", line 55, in __init__ unix_socket=unix_socket, connect_timeout=connect_timeout) File "/home/lingbin/maizegenome/maizedbfarm/testpy/local/lib/python2.7/site-packages/pymonetdb/mapi.py", line 139, in connect self.socket.connect((hostname, port)) File "/usr/lib/python2.7/socket.py", line 228, in meth return getattr(self._sock,name)(*args) socket.error: [Errno 111] Connection refused

Do you have a hint for me how to solve this error?

Many thanks,

Lingbin

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

2702

Age (days ago)

2703

Last active (days ago)

List overview

Download

3 comments

2 participants

participants (2)

Ying Zhang
倪令斌