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

[echatzikyriakidis]

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]]

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. 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: