Hugh,
I seem to be running into problems building the open-source version of
Virtuoso. I'm doing this on a relatively clean intel osx leopard
machine, and have followed the instructions from version 5.0.5's
README to add the following CFLAGs:
CFLAGS="-O -isysroot /Developer/SDKs/MacOSX10.5.sdk -arch ppc -arch
i386 -arch ppc64 -arch x86_64 -mmacosx-version-min=10.5"
export CFLAGS
./configure --disable-dependency-tracking ...
Everything compiled and I ran make check as well, which didn't report
any major errors. After doing sudo make install I noticed that the
default install folder went to /usr/local/virtuoso-opensource, and all
its relevant bin/lib/etc folders made it in there.
Then things got confusing for me...
From the /usr/local/virtuoso-opensource/bin folder, I tried running
isql, and virtuoso-t. Bash returned with a 'command not found', even
when I was in the same folder.
So I added /usr/local/virtuoso-opensource/bin to $PATH, and tried
again. This time it worked (well, at least it shot back localhost:1111
connection errors) , and so I proceeded to the next step, to install
the demo and conductor vad:
cd var/lib/virtuoso/db
virtuoso-t -f &
This time virtuoso-t returned an error, saying that virtuoso-t.lck
already exists, and that it's already running. I tried pointing
firefox at localhost:8890, and as expected it returned with a unable
to connect page.
What did I do wrong here? The only thing I could think of now is the
apache server might be conflicting with it, but I have shut that down
prior to installing virtuoso.
As you can see I haven't even got to installing the dbpedia datasets
yet, but do I just copy out dbpedia.ini from the virtuoso.ini file the
build provides?
Thanks,
Andrew
On Mar 3, 2008, at 1:26 PM, Hugh Williams wrote:
Andrew,
On 03/03/2008 16:27, "Andrew (Chuan) Khoo" <[EMAIL PROTECTED]> wrote:
Thank you Hugh,
First of all I didn't realize there was an open-source version
available. I am now in the process of building it and will use your
scripts when it's done.
[Hugh] I probably should have mentioned that, but I assume you were
using the open-source version. Let me know how you get on loading
the datasets using the scripts.
I have another question: am I able to call SPARQL queries via PHP?
What I would like to have (on my local machine) is the ability to
run php scripts off the apache2 server that's running, and be able
to make query requests to Virtuoso from there. Are there specific
PHP bindings that I can use, or is there a more elegant and
optimized solution?
[Hugh]Just as SPARQL queries can be executed via the Virtuoso SQL
interfaces by preceding the query with the keyword “sparql” ie
“sparql select distinct ?p where { graph <http://localhost:8890/Northwind
> { ?s ?p ?o } } ” for example, the same can be done for the
various SQL Data Access interfaces Virtuoso supports like ODBC,
JDBC, ADO.Net and OLEDB. So you could use PHP with iODBC support
and execute Sparql queries against the Virtuoso database using the
Virtuoso ODBC driver.
Regards
Hugh
Again, thanks for your help. I'm very grateful to the community
here for showing me the ropes to all this!
Regards,
Andrew
On Mar 2, 2008, at 8:14 PM, Hugh Williams wrote:
Hi Andrew,
The attached scripts are what we used for creating the DBpedia
dataset hosted in Virtuoso as follows:
1. Start your Virtuoso server using a configuration file with
the name: dbpedia.ini
2. Put all dbpedia dataset files in a directory called
"data" .
3. Run the pre_install.sh script
4. Run the load_dbpedia.sh script
5. Run the post_install.sh script
Please let us know how you get on ...
Best Regards,
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
>>>
>>> -------- Original Message --------
>>> Subject: [Dbpedia-discussion] setting up DBpedia on local
machine?
>>> Date: Sat, 1 Mar 2008 17:24:53 -0500
>>> From: Andrew (Chuan) Khoo <[EMAIL PROTECTED]>
>>> To: [email protected]
>>>
>>>
>>>
>>> Hi everyone,
>>>
>>> I'm trying to get DBpedia to be installed on my local machine
using a
>>> trial version of Virtuoso. I do not have much experience at
all in
>>> databases and I'm running into all sorts of questions I'm
struggling
>>> to find answers to.
>>>
>>> I've read the other thread a few posts back about Savio
having the
>>> same question, but mine also involves the basic steps in
getting
>>> everything set up.
>>>
>>> What I have are the datasets downloaded already, and I have the
>>> Virtuoso server all ready to go. The question is, how do I
import the
>>> datasets (the .nt files) into Virtuoso? I am very lost
dealing with
>>> the Virtuoso Composer interface and am on the verge of giving
up. The
>>> only database experience I have is with mySQL and phpMyAdmin
so please
>>> bear with my beginner's questions.
>>>
>>> That said, is it for me to dump the .csv versions of the
datasets into
>>> mySQL, and how, if at all possible, will I be able to use
SPARQL to
>>> retrieve data?
>>>
>>> Lastly, and most importantly, are there free alternatives to
Virtuoso
>>> for triple stores/SPARQL execution? I've read in the same
thread that
>>> Luis Stevens has an alternative. Luis, if you can tell me how
you got
>>> your local DBpedia running (preferably with instructions to
guide me
>>> through) with Redland, I will really, really appreciate it.
>>>
>>>
>>> Thanks,
>>> Andrew
>>>
>>>
-------------------------------------------------------------------------
>>> This SF.net email is sponsored by: Microsoft
>>> Defy all challenges. Microsoft(R) Visual Studio 2008.
>>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>>> _______________________________________________
>>> Dbpedia-discussion mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>>
>>>
>>>
<dbpedia-load.tar.gz>
Best Regards,
Hugh Williams
Professional Services
OpenLink Software
Tel: +44 (0)20 8681 7701
Web: http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
