Update on this: It looks like this is a problem related to the ODBC configuration because __virt_internal_dsn() is also failing to connect for a Drupal install. I'm wondering if I need to compile virtuoso with the --with-iodbc=/usr/local/iODBC flag? I thought having the iODBC environment variable ODBCINI pointing at an odbc.ini with a [Local Virtuoso] DSN would be enough.
Perhaps someone can clarify how odbc should be configured for __virt_internal_dsn() to work? I'm mostly going off the iodbc.org docs and realizing there is nothing definitive about this in the VOS docs. -Steve On Sat, Mar 21, 2009 at 8:00 PM, Steve Judkins <steve.judk...@gmail.com>wrote: > ok, last question for the weekend. I went ahead and downloaded the > Wordpress package from: > http://download.openlinksw.com/packages/5.0/virtuoso/ > > Because of a number of errors installing, I'm wondering if there is a newer > version? > > Following these instructions: > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/OdsIntegrationWordPress > The errors start when running the WordPress_rdf_views_script.sql file. > This file refers to a number of tables that aren't created yet (e.g. > wp_users, wp_options, etc.). A quick look at the > {virtuoso}/var/lib/virtuoso/vsp/vad//vsp/wordpress/sql/vadinstall.sql shows > that this isn't part of the VAD package setup. > > Also, viewing http://host:port/wordpress <http://host/wordpress>, shows > that Wordpress has a problem connecting to the database with define('DSN', > __virt_internal_dsn());. > > From the log: > 19:16:17 PHP Warning: __virt_internal_dsn() [<a > href='function.--virt-internal-dsn'>function.--virt-internal-dsn</a>]: > Security settings prohibit internal connections as Virtuoso user 'dba' in > /usr/local/virtuoso-opensource/var/lib/virtuoso/vsp/vad/vsp/wordpress/wp-config.php > on line 9 > > If I switch this over to define('DSN', 'Local Virtuso'), the log errors go > away but Wordpress still can't make the connection. > Note: I've confirmed that PHP is running. > > > > > >
