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

Question

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

Notes

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!

Answer 1

How are you starting your Virtuoso database which seems to have been installed on a debian/ubuntu Linux system with an old Virtuoso 6.1.6 bundled version from over a decade ago ?

If the Virtuoso database is running which can typically be determined with command service virtuoso-opensource-6.1 status or ps -ef | grep virtuoso , then the pyodbc connection should work if the host:port , uid and pwd are correct.

Although we would recommend use of our latest Virtuoso 7 open source offers on docker or standalone Linux installer.

Should you want to continue pursuing this issue I would suggest reporting as a Virtuoso open source git issue or on the OpenLink community forum.