Re: [Virtuoso-users] hosting_php.so
Steve Judkins wrote: [] The issue may be particular to how PHP packages are installed on Ubuntu. It's been over 3 months since I tried it but I vaguely recall the problem was the directory where the php.ini was expecting the extension_dir to load plug-ins from. Ubuntu debian packages had moved around (cleaned up) where some of the plug-ins and their config.ini files are placed (e.g. /etc/php5/apache2/conf.d/). I couldn't get Virtuoso's hosted PHP to find them. Beware. Ubuntu's php5 build is lacking the configure options: --enable-maintainer-zts \ --with-tsrm-pthreads \ so attempting to use the standard system-wide PHP library with Virtuoso on Ubuntu is probably unwise. From a quick inspection of their debian/rules file, I can see they move extension modules around the filesystem (mentions of --with-jpeg-dir=shared,/usr \ --with-xpm-dir=shared,/usr/X11R6 \ --with-png-dir=shared,/usr \ ...) However, when virtuoso starts, if it can't load a module listed in php.ini, it does tell you (in the virtuoso.log) what it was looking for. Example: 16:25:33 PHP Warning: PHP Startup: Unable to load dynamic library '../hosting/php/apc.so' - ../hosting/php/apc.so: cannot open shared object file: No such file or directory in Unknown on line 0 HTH, ~Tim -- Tim Haynes Product Development Consultant OpenLink Software http://www.openlinksw.com/
Re: [Virtuoso-users] hosting_php.so
Steve Judkins wrote: While we are on this topic... Does connecting an from an external install of php via iODBC give you exactly the same functionality? Do the Wordpress and Drupal scripts (for ODS integration) work without requiring the php hosting? Hi, I see no reason why you couldn't host in apache and use Virtuoso just for the data backend, if you wanted: for example, drupal's settings.php contains a line $db_url = 'odbc://drupal:ignored@Local Virtuoso/drupal'; I plan on trying this again soon but my last effort to use the php hosting stalled because I couldn't get some of my required php plugins working properly. How so? For the record, I have a php-5.2.10 I built myself as per that VirtBldPHP webpage, with custom APC module from source - so something's possible, for sure. Regards, ~Tim -- Tim Haynes Product Development Consultant OpenLink Software http://www.openlinksw.com/
Re: [Virtuoso-users] hosting_php.so
On Thu, Jul 16, 2009 at 8:31 AM, Tim Haynes tim.hay...@openlinksw.co.ukwrote: I see no reason why you couldn't host in apache and use Virtuoso just for the data backend, if you wanted: for example, drupal's settings.php contains a line $db_url = 'odbc://drupal:ignored@Local Virtuoso/drupal'; Thats good to hear Tim. I plan on trying this again soon but my last effort to use the php hosting stalled because I couldn't get some of my required php plugins working properly. How so? For the record, I have a php-5.2.10 I built myself as per that VirtBldPHP webpage, with custom APC module from source - so something's possible, for sure. The issue may be particular to how PHP packages are installed on Ubuntu. It's been over 3 months since I tried it but I vaguely recall the problem was the directory where the php.ini was expecting the extension_dir to load plug-ins from. Ubuntu debian packages had moved around (cleaned up) where some of the plug-ins and their config.ini files are placed (e.g. /etc/php5/apache2/conf.d/). I couldn't get Virtuoso's hosted PHP to find them. Since I'm probably forgetting something, the best way to reproduce it would be to set up a Ubuntu LAMP server with the curl extension working. Then attempt to use the same PHP script that connects with curl via LAMP or Virtuoso hosted PHP. -Steve
Re: [Virtuoso-users] hosting_php.so
Sebastian Hellmann wrote: Hi, here some feedback: I finally succeeded. Besides the --enable-php5 option, ./configure also needs --with-iodbc=/path/to/iODBC otherwise compilation will fail Good news! Then it is also necessary to copy the libphp5.so, which is mentioned in the ini (Load7 = attach, libphp5.so), to the hosting directory. the file can be found somewhere in the compiled php folder. hosting_php.so is in place after make install. Yes, this is true. Also any PHP extensions you wish to use must be copied into hosting/php or similar. I hope my findings will make it into the docu at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSBldPHP Actually they are already in the upcoming document I'm working on :) Thanks for your help, now I will try to create the ontowiki vad. Good luck - let us know if you need a further hand by all means :) ~Tim -- Tim Haynes Product Development Consultant OpenLink Software http://www.openlinksw.com/
Re: [Virtuoso-users] hosting_php.so
While we are on this topic... Does connecting an from an external install of php via iODBC give you exactly the same functionality? Do the Wordpress and Drupal scripts (for ODS integration) work without requiring the php hosting? I plan on trying this again soon but my last effort to use the php hosting stalled because I couldn't get some of my required php plugins working properly. Steve On Wed, Jul 15, 2009 at 6:47 AM, Tim Haynes tim.hay...@openlinksw.co.ukwrote: Sebastian Hellmann wrote: Hi, here some feedback: I finally succeeded. Besides the --enable-php5 option, ./configure also needs --with-iodbc=/path/to/iODBC otherwise compilation will fail Good news! Then it is also necessary to copy the libphp5.so, which is mentioned in the ini (Load7 = attach, libphp5.so), to the hosting directory. the file can be found somewhere in the compiled php folder. hosting_php.so is in place after make install. Yes, this is true. Also any PHP extensions you wish to use must be copied into hosting/php or similar. I hope my findings will make it into the docu at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSBldPHP Actually they are already in the upcoming document I'm working on :) Thanks for your help, now I will try to create the ontowiki vad. Good luck - let us know if you need a further hand by all means :) ~Tim -- Tim Haynes Product Development Consultant OpenLink Software http://www.openlinksw.com/ -- Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] hosting_php.so
Sebastian Hellmann wrote: ok, still no luck with 5.0.11 here is some output: cat config.log | grep php $ ./configure --prefix=/opt/virtuoso-opensource-5.0.11 --with-readline=/usr/lib/libreadline.so --with-php5=/opt/lib/php5 config.status:912: creating binsrc/hosting/php/Makefile php4_CFLAGS='' php4_LDFLAGS='' php5_CFLAGS='' php5_LDFLAGS='' cat config.log | grep PHP HAVE_PHP4_FALSE='' HAVE_PHP4_TRUE='#' HAVE_PHP5_FALSE='' HAVE_PHP5_TRUE='#' The log can be found here: http://db0.aksw.org/downloads/config.log Still no hosting_php.so in sight anywhere. Maybe the plugin path in the ini is wrong? [] I've just been reminded: it should be --enable-php5=/opt/lib/php5, rather than --with; this would explain why configure effectively ignores your directive in the log. Could you try this? Cheers, ~Tim -- Tim Haynes Product Development Consultant OpenLink Software http://www.openlinksw.com/
Re: [Virtuoso-users] hosting_php.so
Sebastian Hellmann wrote: Thanks for your help Tim. I still didn't succeed. Could you verify the steps I took and see if I'm missing anything: sudo su Downloaded iodbc latest version ./configure --prefix=/opt/lib/iODBC make make install Downloaded php-5.2.10 ./configure --prefix=/opt/lib/php5 --enable-maintainer-zts --with-tsrm-pt… …hreads --enable-embed=shared --disable-static --with-config-file-path=. --disa… …ble-cgi --disable-cli --disable-ipv6 --disable-pdo --without-mysql --without-p… …ear --with-zlib --with-iodbc=/opt/lib/iODBC make make install Downloaded virtuoso-opensource-6.0.0-tp1 ./configure --prefix=/opt/virtuoso-opensource-6.0.0-tp1 --with-readline=/u… …sr/lib/libreadline.so --with-php5=/opt/lib/php5 make make install You're along the right lines here; the critical --with-php5=somewhere bit, and the configure command for php5, seem correct. I could not find a file called hosting_php.so anywhere, what could I be doing wrong? If needed, I could also provide the compile logs. It might be easiest to see the config.log for virtuoso - search backwards through it for `php' and look for obvious errors. Or post a copy on the list and we'll have a look. Furthermore, I tried the debian package by Will Daniels, but it seems to come without php Do you think it would be better to try with Virtuoso 5.0.11 ? I'm using 5.0.11 as a baseline in my own tests here, so it might be wisest if you can't get 6.0.0-tp1 cranking easily. Regards, ~Tim -- Tim Haynes Product Development Consultant OpenLink Software http://www.openlinksw.com/
Re: [Virtuoso-users] hosting_php.so
ok, still no luck with 5.0.11 here is some output: cat config.log | grep php $ ./configure --prefix=/opt/virtuoso-opensource-5.0.11 --with-readline=/usr/lib/libreadline.so --with-php5=/opt/lib/php5 config.status:912: creating binsrc/hosting/php/Makefile php4_CFLAGS='' php4_LDFLAGS='' php5_CFLAGS='' php5_LDFLAGS='' cat config.log | grep PHP HAVE_PHP4_FALSE='' HAVE_PHP4_TRUE='#' HAVE_PHP5_FALSE='' HAVE_PHP5_TRUE='#' The log can be found here: http://db0.aksw.org/downloads/config.log Still no hosting_php.so in sight anywhere. Maybe the plugin path in the ini is wrong? [Plugins] LoadPath= /opt/virtuoso-opensource-5.0.11/lib/virtuoso/hosting Load1= plain, wikiv Load2= plain, mediawiki Load3= plain, creolewiki Load4= plain, im ;Load5= plain, wbxml2 ;Load6= plain, hslookup Load7= attach, libphp5.so Load8= Hosting, hosting_php.so ;Load9= Hosting,hosting_perl.so ;Load10= Hosting,hosting_python.so ;Load11= Hosting,hosting_ruby.so ;Load12= msdtc,msdtc_sample Regards, Sebastian Tim Haynes schrieb: Sebastian Hellmann wrote: Thanks for your help Tim. I still didn't succeed. Could you verify the steps I took and see if I'm missing anything: sudo su Downloaded iodbc latest version ./configure --prefix=/opt/lib/iODBC make make install Downloaded php-5.2.10 ./configure --prefix=/opt/lib/php5 --enable-maintainer-zts --with-tsrm-pt… …hreads --enable-embed=shared --disable-static --with-config-file-path=. --disa… …ble-cgi --disable-cli --disable-ipv6 --disable-pdo --without-mysql --without-p… …ear --with-zlib --with-iodbc=/opt/lib/iODBC make make install Downloaded virtuoso-opensource-6.0.0-tp1 ./configure --prefix=/opt/virtuoso-opensource-6.0.0-tp1 --with-readline=/u… …sr/lib/libreadline.so --with-php5=/opt/lib/php5 make make install You're along the right lines here; the critical --with-php5=somewhere bit, and the configure command for php5, seem correct. I could not find a file called hosting_php.so anywhere, what could I be doing wrong? If needed, I could also provide the compile logs. It might be easiest to see the config.log for virtuoso - search backwards through it for `php' and look for obvious errors. Or post a copy on the list and we'll have a look. Furthermore, I tried the debian package by Will Daniels, but it seems to come without php Do you think it would be better to try with Virtuoso 5.0.11 ? I'm using 5.0.11 as a baseline in my own tests here, so it might be wisest if you can't get 6.0.0-tp1 cranking easily. Regards, ~Tim
Re: [Virtuoso-users] hosting_php.so
Thanks for your help Tim. I still didn't succeed. Could you verify the steps I took and see if I'm missing anything: sudo su Downloaded iodbc latest version ./configure --prefix=/opt/lib/iODBC make make install Downloaded php-5.2.10 ./configure --prefix=/opt/lib/php5 --enable-maintainer-zts --with-tsrm-pt… …hreads --enable-embed=shared --disable-static --with-config-file-path=. --disa… …ble-cgi --disable-cli --disable-ipv6 --disable-pdo --without-mysql --without-p… …ear --with-zlib --with-iodbc=/opt/lib/iODBC make make install Downloaded virtuoso-opensource-6.0.0-tp1 ./configure --prefix=/opt/virtuoso-opensource-6.0.0-tp1 --with-readline=/u… …sr/lib/libreadline.so --with-php5=/opt/lib/php5 make make install I could not find a file called hosting_php.so anywhere, what could I be doing wrong? If needed, I could also provide the compile logs. Furthermore, I tried the debian package by Will Daniels, but it seems to come without php Do you think it would be better to try with Virtuoso 5.0.11 ? Thanks for your help, Sebastian, AKSW Tim Haynes schrieb: Sebastian Hellmann wrote: Hi all, I'm currently analising the structure of Virtuoso, PHP and VAD, because I'm trying to create an OntoWiki VAD. My problem is that I could not locate hosting_php.so Specs: Ubuntu 9.04, I compiled it myself, standard options. I tried version 6.0-tp1 and also 5.011 13:27:46 { Loading plugin 7: Type `Hosting', file `hosting_php.so' in `/opt/virtuoso-opensource-6.0.0-tp1/lib/virtuoso/hosting' 13:27:46 FAILED plugin 7: Unable to locate file } I used find . | grep hosting_php, but could not find it anywhere. Should it not be created automatically? You need to specify ./configure --with-php5=/usr/local/php5 so it finds a version of php5 which was built with the correct options. I've just updated the documentation at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSBldPHP (note: our required options for building PHP5 have changed a bit) and will be adding a more comprehensive document on Virtuoso+PHP shortly. As a second issue. I tried to analyze the mediawiki_fs.vad . It would be nice to see be able to see the inside and the VAD ticket to reuse it. Is the source of the VAD for it or another php project like phpBB or Wordpress available. There's a Tutorial on PHP hosting that incorporates a WebCalendar project: http://demo.openlinksw.com/tutorial/hosting/ho_s_30/ho_s_30.vsp http://localhost:8890/tutorial/hosting/ho_s_30/ho_s_30.vsp then have a rummage around in binsrc/tutorial/hosting/ especially binsrc/tutorial/hosting/ho_s_30/WebCalendar/ HTH, ~Tim
Re: [Virtuoso-users] hosting_php.so
Sebastian Hellmann wrote: Hi all, I'm currently analising the structure of Virtuoso, PHP and VAD, because I'm trying to create an OntoWiki VAD. My problem is that I could not locate hosting_php.so Specs: Ubuntu 9.04, I compiled it myself, standard options. I tried version 6.0-tp1 and also 5.011 13:27:46 { Loading plugin 7: Type `Hosting', file `hosting_php.so' in `/opt/virtuoso-opensource-6.0.0-tp1/lib/virtuoso/hosting' 13:27:46 FAILED plugin 7: Unable to locate file } I used find . | grep hosting_php, but could not find it anywhere. Should it not be created automatically? You need to specify ./configure --with-php5=/usr/local/php5 so it finds a version of php5 which was built with the correct options. I've just updated the documentation at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSBldPHP (note: our required options for building PHP5 have changed a bit) and will be adding a more comprehensive document on Virtuoso+PHP shortly. As a second issue. I tried to analyze the mediawiki_fs.vad . It would be nice to see be able to see the inside and the VAD ticket to reuse it. Is the source of the VAD for it or another php project like phpBB or Wordpress available. There's a Tutorial on PHP hosting that incorporates a WebCalendar project: http://demo.openlinksw.com/tutorial/hosting/ho_s_30/ho_s_30.vsp http://localhost:8890/tutorial/hosting/ho_s_30/ho_s_30.vsp then have a rummage around in binsrc/tutorial/hosting/ especially binsrc/tutorial/hosting/ho_s_30/WebCalendar/ HTH, ~Tim -- Tim Haynes Product Development Consultant OpenLink Software http://www.openlinksw.com/