HI Matthew,
My installations are on Debian Lenny w/ latest updates.
I downloaded the tarball version, did ./configure make and sudo
make install. That’s all very standard. I didn’t see any errors.
Issue (1):
But I don’t see any startup/shutdown scripts in or to put in /
etc/init.d, certainly not where a anything I found on Google said
they would be. I tried building one using:
cd /usr/local/virtuoso-opensource/var/lib/virtuoso/db
nohup /usr/local/virtuoso-opensource/virtuoso-t –f &
Is that correct?
Yes that is correct, although it not needed to use nohup, the -f flag
and the &
If you start virtuoso with:
cd /usr/local/virtuoso-opensource/var/lib/virtuoso/db
/usr/local/virtuoso-opensource/bin/virtuoso-t
It will automatically put itself into the background as a detached
process.
The -f flag means run in the foreground, and the nohup and & create a
detached background process.
Issue (2):
While I see documentation on how to build an RDF view of
relational tables and various SQL commands work like, create table
(in isql), “create database” does not work..
I don’t see any way to create a database… not via isql nor the
conductor web interface.. How is that done? And I saw nothing
about it on the wiki. There’s a lot of nice stuff in there but it
seems to skip the really basic, normal stuff… and I cannot find any
tutorial anywhere on how to use Virtuoso as a relational SQL
database.. much less from php. Any pointers would be greatly
appreciated.
Virtuoso uses separate schemas within a physical database. User
accounts can default to a specific schema and grants are used to
control who can see/do what within the database, just like any normal
SQL RDBMS.
To create a schema, you can just the isql tool or the conductor and
use the "USE" command like:
use mydb;
create table test (id integer not null primary key, val varchar (32))
This will create a separate schema called "mydb" and switch over to
it. All further commands are done within this schema unless fully
qualified like:
select * from db.dba.testtable;
or
select * from db..testtable;
Did you already read this chapter:
http://docs.openlinksw.com/virtuoso/sqlreference.html
If you require completely separate physical databases, you can just
create another directory (like /usr/local/virtuoso-opensource/var/lib/
virtuoso/db2 ) and put a separate virtuoso.ini configuration file in
there. Edit it so it uses different ports for SQL and HTTP access.
This way you can run multiple independent virtuoso instances.
Issue (3):
I hope connecting and working w/ Virtuoso via php won’t be too
difficult. I wish there was examples or a tutorial for this.
Please read this chapter from the wiki that explains how to build the
PHP plugin and deploy it within Virtuoso:
http://www.openlinksw.com/dataspace/dav/wiki/Main/
VirtuosoPHP#Developers:%20building%20Virtuoso%20Open-Source%20with
%20PHP%20support
Hope this gives you some starters. If not enough, just ask for more
info.
Patrick
