Patrick, Thank you for trying to point me toward help but I am still at a loss at how to connect to Virtuoso from PHP under Apache. I cannot use Virtuoso as a webserver for lack of Shibboleth support and so __virt_internal_dsn() is of no use to me. It might be possible to build a hybrid apache/mysql/php and virtuoso/php application (separated the public and secure areas, accordingly) and using web services between the two.
There has got to be some way to do this.. some documentation somewhere.. I cannot imagine that the only way for a php app to connect is by running under virtuoso's webserver, lacking such a wealth of capabilities. I am getting pretty tired of searching, reading, testing ideas, and coming up empty-handed. There must be some way. Matthew C. Tedder CTRIP, College of Medicine University of Florida -----Original Message----- From: Patrick van Kleef [mailto:[email protected]] Sent: Thu 7/29/2010 4:08 PM To: Matthew Tedder Cc: [email protected] Subject: Re: [Virtuoso-users] Examples of how to connect SQL from PHP (under apache)? HI Matthew, > I need to run my php app under apache for Shibboleth > authentication. (If shibboleth can be done under virtuoso is > something I need to ask later, as I need to just get some things > done right now). Given enough incentive we may implement support for this at some point. We do already support SSO systems like OpenID, and WebID > Is there an example anywhere on how to connect to a Virtuoso > relational store? > > I presume to use generic ODBC and some port number, whatever it is? The port is listed in your virtuoso.ini file: [Parameters] ServerPort = 1111 You indeed can use ODBC to connect from your PHP application to Virtuoso. Please check out: http://docs.openlinksw.com/virtuoso/odbcimplementation.html http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoPHP > > It's too bad there's no PHP PDO (Portable Data Object) module for > it.. because I generally prefer to use that. No biggy. > There is of course pdo-odbc. Patrick
