Skip to content
This repository has been archived by the owner on Jun 11, 2024. It is now read-only.

Erfut error: Virtuoso adapter requires the ODBC extension to be loaded. #424

Closed
cfrancois7 opened this issue Mar 23, 2017 · 5 comments
Closed

Comments

@cfrancois7
Copy link

cfrancois7 commented Mar 23, 2017

EDIT:

When I try to access the page on my localhost (localhost/~myName/ontowiki) I got this message in the ontowiki.log:
Erfurt_Store_Adapter_Exception: Virtuoso adapter requires the ODBC extension to be loaded. -> /Users/myName/Sites/ontowiki/vendor/aksw/erfurt/library/Erfurt/Store/Adapter/Virtuoso.php@104

I can properly connect my virtuoso with Isql and I tested the OCDB driver, everything works fine. I just don't know how to run the ODBC extension here.

@cfrancois7 cfrancois7 changed the title Apache Permission denied or Error on bootstrapping application Erfut error: Virtuoso adapter requires the ODBC extension to be loaded. Mar 24, 2017
@cfrancois7
Copy link
Author

The problem seems to not come from php because odbc_connect('VOS', 'dba', 'dba') works fine.

$ make odbctest
Your connection to Virtuoso seems to work fine

@white-gecko
Copy link
Member

Is this on MacOSX?

@pfrischmuth
Copy link
Contributor

Can you please check the phpinfo() output page within your web browser? Is the ODBC extension loaded there? Maybe your CLI PHP uses another configuration file?

@cfrancois7
Copy link
Author

cfrancois7 commented Mar 24, 2017

Yes it is on mac, and yes indeed the odbc extension was not installed with the build-in php5.5 (and It seems to be too complicated to add the extension).
I decided to install from sources through homebrew and now the extension is loaded.

But again, I have to deal with the same problem than Nginx. The time to load a page is very very long. See here the problem with Nginx.

It is normal that the first page of my database (on virtuoso 20 Go) takes a dozen of minutes to load ?
Once again, I don't find a log file with any interesting information : log/ontowiki.log => nothing, erfurt.log => nothing, apache2/error.log => nothing, virtuoso.log => nothing interesting too.

@cfrancois7
Copy link
Author

cfrancois7 commented Mar 28, 2017

You can close this topic. With the packages from homebrew (http24 and php --with-unixodbc) everything is good with ODBC. If there is problem to define the configuration, just use the iODBC administrator tools from OpenLinks.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

4 participants