search

jupyterhub / mybinder.org-user-guide

Turn a Git repo into a collection of interactive notebooks. This is Binder's user documentation repository.
https://mybinder.readthedocs.io
BSD 3-Clause "New" or "Revised" License
150 stars 103 forks source link

Problem connecting to virtuoso db using PyODBC when installing virtuoso-opensource with apt.txt #255

Open echatzikyriakidis opened 2 years ago

echatzikyriakidis commented 2 years ago

Bug description

Problem connecting to virtuoso db using PyODBC when installing virtuoso-opensource with apt.txt

Expected behaviour

Successful connection to the virtuoso db using PyODBC

Actual behaviour

Problem occured:

Error: ('S2801', '[S2801] [OpenLink][Virtuoso iODBC Driver]CL033: Connect failed to <host>:<port> = <host>:<port>. (-1) (SQLDriverConnect)

when running:

c = pyodbc.connect('DRIVER=/usr/lib/odbc/virtodbc.so;HOST=<host>:<port>;UID=<uid>;PWD=<pwd>;DATABASE=<db>')

(all \<placeholder> are replaced with real values)

How to reproduce

Use the following repo in binder:

repo: https://github.com/eurostat/NLP4Stat

branch: testing

.binder directory (configuration files): https://github.com/eurostat/NLP4Stat/tree/testing/.binder

apt.txt: https://github.com/eurostat/NLP4Stat/blob/testing/.binder/apt.txt

Help

I think that virtuoso-opensource is not installed correctly in binder underlying system using apt.txt. It seems that is not starting/configured correctly and probably virtuoso.ini configuration is missing.

Please help!

welcome[bot] commented 2 years ago

Thank you for opening your first issue in this project! Engagement like this is essential for open source projects! :hugs:
If you haven't done so already, check out Jupyter's Code of Conduct. Also, please try to follow the issue template as it helps other other community members to contribute more effectively. welcome You can meet the other Jovyans by joining our Discourse forum. There is also an intro thread there where you can stop by and say Hi! :wave:
Welcome to the Jupyter community! :tada: