Last active
July 31, 2017 13:07
-
-
Save seralf/8772281 to your computer and use it in GitHub Desktop.
This is a simple checklist for installing a Virtuoso Opens Source 7 on ubuntu (debian? sholud be the same) environment.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## VIRTUOSO | |
http://localhost:8890/ | |
http://localhost:8890/sparql | |
http://localhost:8890/conductor | |
#### pre-install: | |
These commands are suggested in the documentation | |
>> sudo aptitude install dpkg-dev build-essential autoconf automake libtool flex bison gperf gawk m4 make odbcinst libxml2-dev libssl-dev libreadline-dev | |
>> sudo aptitude install dpkg-dev build-essential | |
>> sudo aptitude install git | |
#### getting latest sources [ VOS 7] | |
create a directory for sources and move into it | |
>> mkdir -p ~/VOS7_sources/ | |
>> cd ~/VOS7_sources/ | |
get sources: | |
>> sudo git clone git://github.com/openlink/virtuoso-opensource.git | |
checkout latest stable branch: | |
>> cd virtuoso-opensource | |
>> sudo git checkout stable/7 | |
#### installation | |
prepare installation | |
>> sudo ./autogen.sh | |
configure the installation to the path /usr/local/virtuoso, rename the tool isql in isql-v to avoid conflicts with the unix odbc existing one. | |
>> sudo ./configure --prefix=/usr/local/virtuoso/ --with-readline --program-transform-name="s/isql/isql-v/" | |
>> sudo nice make | |
run installation | |
>> sudo make install | |
#### configure | |
edit configuration file | |
>> sudo nano /usr/local/virtuoso/var/lib/virtuoso/db/virtuoso.ini | |
#### RUN! | |
run with a specific configuration file, not as a daemon (useful when developing/debugging) | |
>> cd /usr/local/virtuoso/bin | |
>> sudo ./virtuoso-t -df +configfile /usr/local/virtuoso/var/lib/virtuoso/db/virtuoso.ini | |
#### how-to enable federated queries | |
isql> grant select on "DB.DBA.SPARQL_SINV_2" to “SPARQL”; | |
isql> grant execute on "DB.DBA.SPARQL_SINV_IMP" to "SPARQL"; | |
#### how-to clear a graph | |
* free disk after cleaning triples | |
no supporto: dump, delete the file on disk, and reload the data | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# TODO | |
#### download binaries for Win7 x64 | |
http://sourceforge.net/projects/virtuoso/files/virtuoso/7.0.0/ | |
SEE other instructions |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
checkpoint_interval (0); | |
RDF_GLOBAL_RESET (); | |
checkpoint_interval (60); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* <virtuoso>/scripts */ | |
SPARQL | |
SELECT COUNT(*) AS ?number_of_triples | |
FROM <http://named-graph/ontology/> | |
WHERE { ?s ?p ?o } ; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* <virtuoso>/scripts */ | |
checkpoint_interval (0); | |
RDF_GLOBAL_RESET (); | |
DELETE FROM DB.DBA.load_list ; | |
ld_dir_all ('/RDF', '*.rdf', 'http://named-graph/ontology/'); | |
rdf_loader_run (); | |
checkpoint_interval (60); | |
SELECT ll_file AS file, ll_state AS state, ll_graph AS graph FROM DB.DBA.load_list; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# <virtuoso>/scripts | |
../bin/isql-v 1111 dba dba errors=stdout $1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# <virtuoso>/scripts | |
../bin/virtuoso-t -df +debug +config ../var/lib/virtuoso/db/virtuoso.ini |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# <virtuoso>/scripts | |
../bin/isql-v 1111 dba dba -K |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment