Re: [Virtuoso-users] Obtain list of knowledge graphs in iSQL

Hi, > is there any isql command to list the URIs of the knowledge graphs currently > in triple store? There are instructions to load and delete graphs, but I > cannot find one to list those currently loaded. > You can try the following command in isql: SQL> sparql select distinct ?g where {

Re: [Virtuoso-users] Loading arbitrary XML?

ulk loading data into the Virtuoso database in a variety of formats: http://vos.openlinksw.com/owiki/wiki/VOS/VirtBulkRDFLoader Patrick --- Patrick van Kleef Program Manager OpenLink Software http://www.openlinksw.com/ http://twitter.com/openlink/ _

Re: [Virtuoso-users] Can't create ldp:Resource from Turtle file

> [1] > http://download3.openlinksw.com/uda/vad-packages/7.2/ods_framework_dav.vad > http://download3.openlinksw.com/uda/vad-vos-packages/7.2/ods_framework_dav.vad > [2] > http://download3.openlinksw.com/uda/vad-packages/7.2/ods_briefcase_dav.vad http://download3.openlinksw.com/

Re: [Virtuoso-users] Unable to start VOS : error libssl

ckage. The only solution is to recompile / relink your virtuoso binary against this new version of openssl. Patrick --- Patrick van Kleef Program Manager OpenLink Software http://www.openlinksw.com/ http://twitter.com/openlink/

Re: [Virtuoso-users] Virtuoso Open Source Edition 7.2.5-dev compile failure: no member named 'mp_alloc_file' in 'struct mem_pool_s'

✔, xz ✔ > Recommended: jpeg ✔, libpng ✔, libtiff ✔, freetype ✔ > Optional: fontconfig ✘, little-cms ✘, little-cms2 ✘, libwmf ✘, librsvg ✘, > liblqr ✘, openexr ✘, ghostscript ✘, webp ✘, openjpeg ✘, fftw ✘, pango ✘, perl > ✘ > ==> Requirements > Optional: x11 ✘ Our curr

Re: [Virtuoso-users] URGENT! Insert error in Virtuoso 7.2.2!

strip the binaries: export DEB_BUILD_OPTIONS="nostrip noopt” next edit the debian/rules file and add the following line to the DEB_CONFIGURE_EXTRA_FLAGS= setting: —with-debug \ then do a clean build of the

Re: [Virtuoso-users] SQL Error on insert with virtuoso 7.2.1

build the first time, the clean option is functional. I will fix this for the next release > Am I missing something? Did some thing changed with release? Because building > develop/7 branch latest state on 27th of November worked with these steps. Patrick Patrick --- Pa

Re: [Virtuoso-users] Send SPARQL queries via C# ?

iterated over. Patrick Patrick --- Patrick van Kleef Program Manager OpenLink Software http://www.openlinksw.com/ http://twitter.com/openlink/ -- ___ Virtuoso-users mai

Re: [Virtuoso-users] traps: virtuoso-t[54165] general protection ip:931aa7 sp:7f9b34d2eda0 error:0 in virtuoso-t[400000+c00000]

r algorithm. If the crash happens again, the following commands can be used to provide call stack information to OpenLink: $ gdb virtuso-t core gdb> bt Patrick --- Patrick van Kleef Program Manager OpenLink Software http://www.openlinksw.com/ http://twitter.com/openlink/

Re: [Virtuoso-users] Virtuoso 7.2.0 terminated with signal SIGSEGV, Segmentation fault.

Hi Piret, > On 24 Nov 2015, at 10:00, Piret Lattikas wrote: > > Hi Hugh. > > I have no additional settings set on my build. For building virtuoso debian > packages from latest github develop/7 branch source I do the following: > > 1. I have a clean ubuntu 14.04 virtual machine setup > 2. I in

Re: [Virtuoso-users] quick exact label search through all languages

super fast results: http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=prefix+dbpedia%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0Aselect+*+where+%7B%0D%0A++%3Fs+rdfs%3Alabel+%3Fl+.%0D%0A++FILTER%28b

Re: [Virtuoso-users] Virtuoso DBpedia load - parsing errors

unately it appears there was either a problem with a lot of pages they crawled for this BTC 2014 dataset, or they cut out part of the page. In any case i examined a number of lines that failed and

Re: [Virtuoso-users] Virtuoso DBpedia load - parsing errors

g/1999/02/22-rdf-syntax-ns#XMLLiteral> . > > Also tried to load using different errors bits, the same result: > DB.DBA.TTLP_MT (file_to_string_output > ('/workingDir/btc2014_unzipped/01/data.nq-9'), '', 'http://fake.org&#x

Re: [Virtuoso-users] v07.20.3213 installed and cannot access Web Application Server

Hi, > I have just installed version 07.20.3213 in a Linux CentOS, started it, but I > cannot access the “Web Application Server” form the conductor UI. > It returns the following error: > > Error 42S22 > SQ063: No column v_properties. > while executing the following statement: > #line 33242 "/DA

Re: [Virtuoso-users] SPARQL update question

Hi Boris, > I'm working with Virtuoso version 07.10.3208 on Linux > (x86_64-unknown-linux-gnu), Single Server Edition. > I have to do some postprocessing processess (via scripts) and I need to > do lot of queries like this > DEFINE sql:log-enable 3 DELETE { GRAPH >

Re: [Virtuoso-users] Question about Sparql query (Virtuoso)

Hi Esra, > I installed Virtuoso on Windows. Now I want to work with Sparql queries > (connected to Openlink Virtuoso on cmd). > > I have an rdf file called 'example.rdf'. I want to run this Sparql query: > > SPARQL PREFIX ore: PREFIX > dc: SELECT distin

Re: [Virtuoso-users] R on Virtuoso Server

HI Esra, > I would like to ask if it is possible to run R script > (http://www.r-project.org/) on Virtuoso server. Thanks! You can interface between R and Virtuoso using the RODBC package: http://cran.r-project.org/package=RODBC This uses the Virtuoso ODBC driver to connect to the Vi

Re: [Virtuoso-users] Issue in compiling Virtuoso with Perl

Hi Julien, > > I try to compile Virtuoso with the option "--enable-perl" and I fall on this > error during the "make" step : > > libtool: compile: gcc -DHAVE_CONFIG_H -I. -I../../../libsrc/Dk > -fno-strict-aliasing -O2 -Wall -DNDEBUG -DPOINTER_64 > -I/home/jenkins/build-virtuoso-packaging/vi

Re: [Virtuoso-users] ASSUME ???

HI Jerven, > What is the ASSUME variable that you added in 6.1.7 ? > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/ > > I can't find any reference to this in the SPARQL 1.1 query standard. > Is this a virtuoso specific extension? I passed your question to the virtuoso development t

Re: [Virtuoso-users] strafter and strbefore

HI Erich, > Are STRAFTER and STRBEFORE supported in Virtuoso 6.1.6 or is it time to > go to Virtuoso 7? - Erich These two functions are in the upcoming 6.1.7 version OpenLink is about to release. https://github.com/openlink/virtuoso-opensource/commit/46344d4d7007ae7f11473e249a43dce

Re: [Virtuoso-users] Negative xsd:date issue

Hi Julien, > > Yes I saw your previous answer this morning. Thank you very much for your > quick answer and to let me know when the bug will be solved. This bug has been fixed and is available on both the develop/6 and develop/7 branches on github. Patrick > I replied to the email you sent

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

Hi Sumit, > [root@rdesc db]# df -T > FilesystemType 1K-blocks Used Available Use% Mounted on > /dev/sda1 ext4 5039616 3946896836720 83% / > tmpfstmpfs 8165184 0 8165184 0% /dev/shm > /dev/sda7 ext4 4619200140364 4244188 4% /home > /

Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to localhost:1111

Hi Sumit, > [root@rdesc db]# /usr/local/virtuoso-opensource/bin/virtuoso-t -f -c > /usr/local/virtuoso-opensource/bin/virtuoso.ini > >Sun Mar 24 2013 > 20:15:51 { Loading plugin 1: Type `plain', file `wikiv' in > `/usr/local/virtuoso-opensource/lib/virtuoso/hosting' > 20:15:51

Re: [Virtuoso-users] HTTP Request Size in Virtuoso

Hello Burak Yönyül, > I cannot execute queries which are greater than a few kilobytes on Virtuoso. > I've loaded example drugbank dataset into Virtuoso Opensource 6.1 and I'm > trying to execute the query in the file I've attached here, on my local > drugbank dataset with the sparql endpoint

Re: [Virtuoso-users] HTTP Request Size in Virtuoso

Hello Burak Yönyül, > I cannot execute queries which are greater than a few kilobytes on Virtuoso. > I've loaded example drugbank dataset into Virtuoso Opensource 6.1 and I'm > trying to execute the query in the file I've attached here, on my local > drugbank dataset with the sparql endpoint

Re: [Virtuoso-users] correct upstart config file

tuoso - Upstart script for Virtuoso Open Source Edition 6.1 description "virtuoso" author "Patrick van Kleef " # When to start the service start on runlevel [2345] # When to stop the service stop on runlevel [016] # Automaticall

Re: [Virtuoso-users] Problem with FILTER NOT EXISTS and MINUS

HI Nate, > I get following error when I try to execute any query containing FILTER > NOT EXISTS or MINUS: > > SPARQL Error: [unixODBC][OpenLink][Virtuoso iODBC Driver][Virtuoso > Server]SQ074: Line 47: SP031: SPARQL: Internal error: 'output:valmode' > declaration conflicts with 'output:format' ()

Re: [Virtuoso-users] Connecting to Virtuoso

Hi Nate, > I have installed virtuoso from the debian repository on my olinuxino > board when I run the odbctest script [1] from ontowiki with php-cli the > connection works. If I invoke it from the browser I get: > > Connection failed - Something is wrong with your configuration. Used > connectio

Re: [Virtuoso-users] MINUS and TRANSITIVE problem

Hi Icaro and Percy, We are looking into this issue and i hope to have an answer for both of you shortly. Patrick --- OpenLink > > I am experiencing the same problem. > > Can anyone help us? > > Best Regards, > Ícaro Medeiros. > > On Tue, Mar 13, 2012 at 10:56 AM, Percy Enrique Rivera Salas

Re: [Virtuoso-users] Simple html escape functions?

HI Will, > I'm looking for some simple XML/HTML escape functions amongst Virtuoso's > built-in functions, but I can't find anything other than http_value (http_url > etc.) which are awkward to use for a string result (via string_output_string). > > Ideally I was expecting to find something simi

Re: [Virtuoso-users] Light mode parameter

HI Alex, is it possible someone to explain the role of the light mode parameter in virtuoso.ini file and what services affect? I am looking to lower the reserved memory for virtuoso without compromise the query performance (i.e., lowering the number of buffers). Does it affect the query

Re: [Virtuoso-users] Conductor not loaded

Hi Adrian, >> The error from above is indication the compilation of the server was not >> completely done as >> http://local.virt/vspx_expand - 404 not exists means that are not >> included the built-in XSL-t >> in the server. > > tnx yep, was just talking to PvK on IRC and we figured out that it

Re: [Virtuoso-users] SPARQL FILTER by xsd types

HI Quintin, > I have a bit of weirdness though it's been resolved/worked-around. > > A query that looks like: > prefix ont: > select ?dq { GRAPH { ?li ont:code "S" . ?li ont:liHasDQ ?dq . > ?dq ont:Quantity ?qty . ?dq ont:Quantity "0"^^xsd:int } } > > Or with a filter: > prefix

Re: [Virtuoso-users] Fatal error installing Demo package

Hi Peter, > I'm trying to install the VAD package Demo through Conductor 6.01.3127 > (System Admin -> Packages -> Demo -> Install) > > It's failing to install and returning the following Fatal Error: > > 0 Errors detected > 0 Installation of "Demo Database" was unsuccessful. > The

Re: [Virtuoso-users] Encoding and bif:contains

Hi Alexandre, > Anyone from the Virtuoso team knows how to solve this (if that can be solved) I have forwarded your questions internally. I hope to have some answers for you soon. Patrick -- OpenLink Software smime.p7s Description: S/MIME cryptographic signature

Re: [Virtuoso-users] Null character escape in wide string literals?

Hi Will, > I am trying to figure out the correct way to escape a null character in a > wide > string literal for Virtuoso. For narrow literals with c-escapes turned on I > can > use \0 as expected. But in a wide literal (e.g. N'null\0escape') Virtuoso > complains with SQ074 "Invalid wide stri

Re: [Virtuoso-users] Long read issues with PHP odbc

HI Will, > > OK forget this, it's definitely a PHP problem. > > Sorry for the noise. > If you can tell me what is going wrong with PHP, i still maybe able to help by sending them a bugfix if need be. Patrick --- Maintainer iODBC

Re: [Virtuoso-users] ResultSet to Java Collection

Hi Alex, > > is there any method available in virtuoso driver 4 for jdbc to get the result > of a query to a java collection. I am interested to make a difference set > operation and I would like to avoid the iteration over the results. > > Moreover, could someone point me the javadocs of the r

Re: [Virtuoso-users] tweaking default language settings?

Hi Joe, > I am importing some RDF/XML triples that have both language and > XMLLiteral datatype specified. The behavior is different depending on > language: "en" triples are stored with no language tag, and with the > XMLLiteral datatype, whereas non-"en" triples are stored with their > given lan

Re: [Virtuoso-users] Virtuoso v6.1.5 (Open Source Edition) missing file sparqlwords.gperf

Hi Rex, > Failed to build for me, Makefile's seem to reference some non-existent (and > seemingly otherwise unused sparqlwords.gperf file). I patched it out (see > attached patch). Thanks for reporting this issue. When you use the tarball, the sparqlwords.h is already generated, so you do not

Re: [Virtuoso-users] Help with virtuoso

Hi Nestor, Hello, I'm new with Virtuoso software. I'm using the Virtuoso 6.1 open source version for ubuntu. I'm trying to import one .nt dump file to my virtuoso server but i can't find the correct way to achieve it. I first try it with a ISQL sentence like this: ld_dir('/usr/share/virt

Re: [Virtuoso-users] How to disconnect SPARQL USER

HI Maxime, When i run the http_pending_req(); request during a sparl-end-point requests, nothing is return. The http_pending_req() returns a vector e.g.: SQL> select http_pending_req(); VARCHAR ___

Re: [Virtuoso-users] How to disconnect SPARQL USER

Hi Maxime, I can disconnect Virtuoso's users (isql, php odbc, jdbc jena), but SPARQL-End-Point is insensitive to the order disconnect_user ('USER'); even using %. What is the way to disconnect? For HTTP requests you can use the http_kill command. http://docs.openlinksw.com/virtuoso/fn_ht

Re: [Virtuoso-users] Priviliged admin user

Hi Maxime, I wonder if the DBA has a dedicated cannal to connect to Virtuoso. Indeed, DBA as the admin user of Virtuoso, it is the only one who can run some commands (disconnect, backup ...) and if all threads are used by other applications, it can't connect and run a request, not privileg

Re: [Virtuoso-users] Renaming a big graph

Hi Martin, will the database binary format be backwards compatible, i.e. can we just copy our 6.1.3-pre database over into 6.1.4's working directory? Please read the README.UPGRADE file from the 6.1.4 source tree. There was a potential problem with some types of XML fragments that could br

Re: [Virtuoso-users] Signal 11 while uploading a large file

HI Vanessa, I installed the latest version of virtuoso on my Mac Lion. I modified virtuoso.ini to use up to 4GB of memory (I have 8GB), however when I am uploading the DBpedia infoboxes it fails after a couple of hours or more. 00:48:36 PL LOG: Loader started 00:48:36 PL LOG: No more files

Re: [Virtuoso-users] Query not parsed via PHP but works in iSQL

Hi Norman, thanks for your reply. I am using Mac OS X 10.7.2 (Darwin macbook- pro.local 11.2.0 Darwin Kernel Version 11.2.0: Tue Aug 9 20:54:00 PDT 2011; root:xnu-1699.24.8~1/RELEASE_X86_64 x86_64) with stock PHP 5.3.6 built against iODBC. I have attached the odbc trace log. The query in q

Re: [Virtuoso-users] Query not parsed via PHP but works in iSQL

HI Norman, Hi, I got a query that uses bif:contains filter (see below). When I issue it via PHP_ODBC using the "sparql" prefix keyword, it cannot be parsed. It works however, in iSQL and via PHP_ODBC using "SPARQL_EVAL" function. The issue occurs with both, Virtuoso OpenSource 6.1.3 and 6

Re: [Virtuoso-users] Segfault with Virtuoso 6.1.2 / 6.1.3

Hi Cédric, sometimes our Virtuoso server segfaults on a sparql query. When we were using version 6.1.2, the error on the log was: 09:24:48 GPF: bitmap.c:1552 next/prev of non-valid bit pos With version 6.1.3, the error is now: 12:35:34 Invalid bit position on index: RDF_QUAD_POGS 12:35:34 GPF:

Re: [Virtuoso-users] [Dbpedia-discussion] 502 Proxy Error on SPARQL Query

HI Gerber, I asked this question some time ago on the DBpedia Mailing List. I would still be very grateful if anybody could tell me the setting I need to change in order to avoid the 502 Proxy Error. I want to fix that for the DBpedia Live Endpoint. The fix i made was not a Virtuoso setti

Re: [Virtuoso-users] Regexp_replace pattern matching with variable substitution

HI Peter, I'm using Virtuoso regexp_replace to strip newline and whitespace characters from an xml file before passing it to xtree_doc. My pattern to match is: 'I need to preserve the value matched by [0-9] in the replacement string. eg: regexp_replace(string,'regexp_replace(string,'valu

Re: [Virtuoso-users] Unstable endpoint

Hi Arne, I was requested by Hugh Williams and Jens Lehmann to send an email to this mailing list regarding the unstable performance of the dbpedia sparql endpoint. I’m currently working on a project for the EU that requires me to use LOD to retrieve information about cities and Eurostat dat

Re: [Virtuoso-users] Missing ldap related functions ?

Hi, I was trying to setup the ldap backend for ldap authentication using the conductor web interface, and when I tested, I received an error message stating: "SR185: Undefined procedure DB.DBA.ldap_search" I'm using the version 6.1.2 packaged for ubuntu natty (11.04). Am I missing something, di

Re: [Virtuoso-users] [Virtuoso-devel] Upgrading Virtuoso and Proxy reversing

Hi Houda, I am trying to upgrade my Virtuoso server from version 1.6.2 to version 1.6.3 by simply installing the Version 1.6.3 using ./ configure -prefix=/Path/OldVirtuoso. But, I get this error after several attempts to start server on port (this port is not busy by any application in

Re: [Virtuoso-users] [Virtuoso-devel] Upgrading Virtuoso and Proxy reversing

HI Houda, I am trying to upgrade my Virtuoso server from version 1.6.2 to version 1.6.3 by simply installing the Version 1.6.3 using ./ configure -prefix=/Path/OldVirtuoso. But, I get this error after several attempts to start server on port (this port is not busy by any application in

Re: [Virtuoso-users] HTTPS setup on Localhost

HI Daniel, I'm trying to get HTTPS to work with Virtuoso. I'm following these two documentation pages: 1) X.509 certificate Generation http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtGenerateX509Cert 2) Guide for Setting Up the Virtuoso HTTPS Listener using File System to host Certifica

Re: [Virtuoso-users] Virtuoso Open-Source Edition, Version 6.1.3

Hi Matteo, I am running a virtuoso OSE 6.1.2 on an old box, and now I am in the process to move the data on a newer machine, and maybe it's time to upgrade to 6.1.3. Is it possible to move the database files (or perform the backup with the instructions at [2]) and get the newer machine ru

Re: [Virtuoso-users] SPARQL Query using "SERVICE"

HI Boris, Now, I'm having this error Virtuoso 42000 Error SR186: No permission to execute procedure DB.DBA.SPARQL_SINV_IMP with user ID 106, group ID 106 Try: GRANT EXECUTE on DB.DBA.SPARQL_SINV_IMP to SPARQL_SELECT; But you should really consider upgrading this installation to 6.1.3

Re: [Virtuoso-users] New version with very slow free text search

Hi Bruno. I upgraded to Version 06.01.3.3127-pthreads linux and some queries that ran on 4 seconds or less are now taking 45 seconds. Also, the commercial version Version 06.02.3129-pthreads have similar problems. One query that got a lot worse was: sparql define input:inference

Re: [Virtuoso-users] starting virtuoso under mac os x

Hi Joe, Patrick: Commenting out those plugins solves it. Thanks! And I'll keep in mind Tim's advice about building directly from source if I see subsequent problems. For the record, the Macports version of Virtuoso doesn't build and I reported a bug about it here: https://trac.macports.org/t

Re: [Virtuoso-users] starting virtuoso under mac os x

HI Joe, In any case, this is just a partial startup log - you should expect a small delay while it creates an empty database and possibly installs the Conductor VAD package into it, followed by: ... 16:48:10 INFO: Checkpoint finished, log reused 16:48:12 INFO: HTTP/WebDAV server online at 8

Re: [Virtuoso-users] starting virtuoso under mac os x

Hi Joe, I have Fink's virtuoso installed, Version 6.1.2.3127-pthreads as of Apr 29 2011 Compiled for Darwin (i386-apple-darwin10.7.0) When I try to start the server (with or without sudo privileges), I get messages like below (copied to the log file as well). However, trying to connect via i

Re: [Virtuoso-users] Sorting in SPARQL XML result format

Hi Jonas, i have a problem with sorting again :) given the dataset in the attachment, when i do the query SELECT DISTINCT ?resourceUri FROM WHERE { ?resourceUri . ?resou

Re: [Virtuoso-users] Sorting in SPARQL XML result format

Hi Jonas, i have a problem with sorting again :) given the dataset in the attachment, when i do the query SELECT DISTINCT ?resourceUri FROM WHERE { ?resourceUri . ?resourceU

Re: [Virtuoso-users] "No remap dp for a dirty buffer" error

HI Mohamed, I'm Mohamed Morsey, I'm working on DBpedia-Live in the AKSW group of the University of Leipzig. After running DBpedia-Live application for a while (something like 14 Hrs), Virtuoso crashes and gives that error message "GPF: insert.c:1172 In compact, no remap dp for a dirty buffer

Re: [Virtuoso-users] Change number of connection?

Hi, On May 19, 2011, at 5:09 PM, Nguyen Mau Quoc Hoan wrote: How could I configure the limit number connection of virtuoso server? I checked the virtuoso configuration and I saw the limit number connection is 10. Now I want to increase it for my project. How could I do it It depends on w

Re: [Virtuoso-users] Subgraphs or SPARQL views

HI Mohammed, I'm Mohamed Morsey, I'm one of the DBpedia developers team of Leipzig university, and I'm currently working in DBpedia live. We divide the triples of DBpedia live into 2 separate parts, one part for dynamic triples, i.e. the triples that should be updated upon live extraction, in wh

Re: [Virtuoso-users] Best Configuration Parameters

Hi Concetto, I'm using virtuoso 6.12 on a machine with 8 CPUs and 32G of ram. I need to work with a database of 43G (of nt type) and I can use only one hardisk. I assume you have seen we released 6.1.3 in opensource last month, so i would advice you to upgrade when possible. My questio

Re: [Virtuoso-users] SPARQL Update string literals

Hi Lars, I'm sending the following SPARQL Update statement to Virtuoso: insert data into classes/ifs.xtm> { "MM'S LUNCH & CATERING" .

Re: [Virtuoso-users] bif:contains function not working

HI Dimitris, Sorry, it was easy after all :) now, something extra, we have about 3-4M triples that we update occasionally by clearing the gragh and inserting the new triples. 1) does the index affect the clear/update procedure? and if it does, are there any commands to call before / after to

Re: [Virtuoso-users] bif:contains function not working

Hi Dimitris, Sorry, it was easy after all :) now, something extra, we have about 3-4M triples that we update occasionally by clearing the gragh and inserting the new triples. 1) does the index affect the clear/update procedure? and if it does, are there any commands to call before / after

Re: [Virtuoso-users] bif:contains function not working

Hi Dimitris, i have a problem with the bif:contains function. It does not work and i could find if there is any configuration options to enable it. Server/Virtuoso: version 06.01.3127, on Linux (x86_64-pc-linux-gnu), Single Edition SPARQL Endpoint: http://el.dbpedia.org/sparql For the sa

Re: [Virtuoso-users] No of graphs created and performance

HI Abhi, In my project, when I persist an entity I create a new graph for each entity persisted. Will the performance degrade due to the huge no of graphs crated? This depends how queries are written and what is the distribution of the data is. Principally performance would not degrade

Re: [Virtuoso-users] sparql and conductor on different port

HI Pierre, Next you add a "New directory to this line", click on "Type" radio button and choose "Sparql access point" from the dropdown list and press Next button. Set "Path" to /sparql and press the "Save Changes" button to store. At this point you have created: http://my.example.com:8

Re: [Virtuoso-users] sparql and conductor on different port

Hi Pierre, Although I have been looking through the documentation, I could not find if it is possible to have the sparql endpoint on a different port than the conductor ? For security reason I would like to keep my conductor listening on a different port and be able to publish my sparql endp

Re: [Virtuoso-users] nquads dump -- and possible bug in rdfbox.c

Hi William, I've adapted some of the example routines for doing an nquads dump and load, the recipe is here: https://bitbucket.org/ww/virtuoso/src/tip/sql/nq_dump.sql One thing that I encountered is there seems to be no good way to tell if a variable is a blank node from within a stored pr

Re: [Virtuoso-users] Problem adding external datasource

Hi Claus, As I've seen on the list that someone recently managed to get RDF views working with spatial queries, I also wanted to give it another try. However, when I go to: Conductor->Database->External Data Sources -> Configure Data Sources then whenever I click on any of the add dsn buttons

Re: [Virtuoso-users] Writing Custom SPARQL Extension Functions?

HI Jamey, Does Virtuoso provide some supported way to write one's own custom SPARQL extension functions (http://www.w3.org/TR/rdf-sparql-query/#extensionFunctions )? Yes, there are actually two options: Firstly, you can create a stored procedure in Virtuoso PL and call it using the sql:

Re: [Virtuoso-users] Support for Lines and Polygons in Virtuoso's Geospatial Extensions

Hi Jamey, In playing with a trial copy of Virtuoso 6.2 (Commercial Edition), I've noticed that it appears that its geospatial capabilities only cover points. For example: SQL> select st_geomfromtext('LINESTRING(3 4,10 50,20 25)'); *** Error 37000: [Virtuoso Driver][Virtuoso Server]GEO..

Re: [Virtuoso-users] Trippi connector

Hi Alex, This one goes to Virtuoso devs. Is there a release or are there plans to develop a Trippi Connector for Virtuoso Triple Store? http://trippi.sourceforge.net/implementation-guide.html I would like to test Fedora Commons Repository backed by Virtuoso OS both as its relational databa

Re: [Virtuoso-users] BUG Ubuntu 64bits -- GPF: bitmap.c:1552 next/prev of non-valid bit pos

HI Remi, It is my first post on this mailing list so do not hesitate to tell me if you need more information or anything else ;) Here is the trouble, after starting Virtuoso on an ubuntu server, and after a while (a day or so) I got this error : 04:34:49 Checkpoint started 04:35:05 Checkpoint

Re: [Virtuoso-users] Installing open source viruoso

Hi Luka, I am trying to create a web application in PHP which would use a semantic storage. Virtuoso seems the most powerful tool to use but I have problems and questions regarding it's installation... I'm using WinXP 32b and I can't figure out the easiest way to install it. I don't need

Re: [Virtuoso-users] Virtuoso PHP Hosting on Mac OS X 10.6

Hi Norman, I am having the same problem as described by David in an earlier post to this list (which I am quoting below). Is there a solution available meanwhile? The problem basically is, that PHP SAPI is built as an .so file of type MH_BUNDLE but ld expects a MH_DYLIB. PHP uses its own

Re: [Virtuoso-users] Jena Provider. Tag 248 not defined

HI Roberto, I'm experiencing the following exception: com.hp.hpl.jena.shared.JenaException: Can not create ResultSet.:virtuoso.jdbc3.VirtuosoException: Tag 248 not defined. When performing this query on a local copy of the DBPedia: SELECT ?o count(?o) WHERE { ?x a

Re: [Virtuoso-users] backslash character within URI

HI Florian, I did some semantic web crawling and I gathered information on football clubs from freebase and dbpedia. In the dbpedia data, there is an individual that's equivalent (owl:sameAs) http://dbpedia.org/resource/Chelsea_F.C. , namely http://dbpedia.org/resource/Chelse_FC\ (note the bac

Re: [Virtuoso-users] virtuoso-opensource-6.1.2.tar.gz: broken or out of date vad packages?

Hi Martin, We download the virtuoso-opensource-6.1.2.tar.gz snapshot from sourceforge, and installed the debian package in it on a debian (lenny) Linux system. In contradiction to the product working fine so far, we have some issues with the vad packages that come with the snapshot. Ins

Re: [Virtuoso-users] GPF - Virtuoso Database Server going offline

Hi Roosevelt, we are experiencing downtime at our Virtuoso Database Server. The message being generated at the log file is listed below: 14:23:49 GPF: bitmap.c:1552 next/prev of non-valid bit pos This is an assert in the code to prevent the possibility of data corruption. If you restart

Re: [Virtuoso-users] Virtuoso SQL, how can I get the last insert ID? (dentity)

Hi Matthew, Normally I’d use a PDO function for this but it says it isn’t supported for this database.. I am trying to migrate data over from SQL server and other sources but need to adjust table relationships to new identity keys. I think you are looking for the identity_value() func

Re: [Virtuoso-users] Backup_online malformed command appears to HANG server

HI Roosevelt, running a backup_online command with a dot ('.') left a pending process. And after issuing a backup_context_clear() the whole server seemed to hang. Below the step to do it: Done. -- 271 msec. SQL> backup_context_clear(); Done. -- 271 msec. SQL> backup_online('./bkp_',1000

Re: [Virtuoso-users] does backup_online() do a checkpoint internally?

Hi Aldo, By looking at the checkpoint audit trail I can inferr that each time backup_online() is run, it will create a checkpoint. It also makes sense from an intuitive standpoint. However, by looking at the docs, I found this snippet: SQL> backup_context_clear (); SQL> checkpoint; SQL> backup

Re: [Virtuoso-users] Conductor > System Admin > Monitor; Getting these values programatically

Hi Aldo, Is there any way to get the various values appearing in Conductor > System Admin > Monitor via PL code? If yes, how? which ones? The requirement is feeding these values into a corporate database monitor. These values are all selectable using the SYS_STAT function e.g.: SQL> sele

Re: [Virtuoso-users] Specifying a different folder for backups

Hi Aldo, Can the above be accomplished via configuration? You can do this with the backup_online command using the isql tool: backup_online ('mybackup-#', 100, 0, vector('backupdir1', 'backupdir2')); The conductor allows you to do the same and can add this to the scheduler so an i

Re: [Virtuoso-users] source_uri for file resources in vad stickers

Hi Jamey, Has there been any progress on this? Your analysis of the dtd was correct. This is exactly what this attribute was supposed to do, although we never used this construction in our own vad packages. I have committed a permanent fix for the upcoming VOS 6.1.3 release. I have att

Re: [Virtuoso-users] php hosting with virtuoso on Leopard

HI David, I'm am not having success in getting php hosting up on Mac OS 10.5. Following the instructions here http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSBldPHP , I am getting a link error. I can't figure out how to get a dylib out of the php build process. configure:23970: /usr

Re: [Virtuoso-users] Problems loading the DBpedia dump (very long URIs)

Hi Jörn, after having a lot trouble with our group internal DBpedia mirror, I decided to do a fresh install. I downloaded all the files (we only need a subset of the dbpedia: {en,de}) and followed this guide yesterday: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoade

Re: [Virtuoso-users] In SQL how can I reference my tables?

HI Matthew, It shows my database "studies" at the same level as "DB", "PUMP", "UDDI", "VAD", etc. Clicking down to the tables, it shows them as: studies.DBA.studies I used the default DBA account (for now). I didn't modify any defaults of installation from the tarball, to keep things si

Re: [Virtuoso-users] Examples of how to connect SQL from PHP (under apache)?

HI Matthew, Thank you for trying to point me toward help but I am still at a loss at how to connect to Virtuoso from PHP under Apache. I cannot use Virtuoso as a webserver for lack of Shibboleth support and so __virt_internal_dsn() is of no use to me. It might be possible to build a hy

Re: [Virtuoso-users] Examples of how to connect SQL from PHP (under apache)?

HI Matthew, I need to run my php app under apache for Shibboleth authentication. (If shibboleth can be done under virtuoso is something I need to ask later, as I need to just get some things done right now). Given enough incentive we may implement support for this at some point. We do

Re: [Virtuoso-users] Issues with Getting Started..

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

Re: [Virtuoso-users] EF support improvements

Hi Alexander, And the last thing. What about EF4 support? We hope to roll first set of enhancements for this into virtuoso next week. Patrick

  1   2   >