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

2022-05-04 Thread Patrick van Kleef via Virtuoso-users
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?

2019-09-10 Thread Patrick van Kleef
lk 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/ ___ Virtuos

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

2018-09-19 Thread Patrick van Kleef
w.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/uda/vad-vos-packages/7.2/ods_briefcase_d

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

2016-01-19 Thread Patrick van Kleef
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 VOS tree,

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

2015-12-10 Thread Patrick van Kleef
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 --- Patrick van Kleef

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

2015-12-09 Thread Patrick van Kleef
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]

2015-12-01 Thread Patrick van Kleef
ithm. 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] quick exact label search through all languages

2015-10-08 Thread Patrick van Kleef
urce%2F%3E%0D%0Aselect+*+where+%7B%0D%0A++%3Fs+rdfs%3Alabel+%3Fl+.%0D%0A++FILTER%28bif%3Acontains%28%3Fl%2C+%22%27%E8%B4%9D%E6%8B%89%E5%85%8B%C2%B7%E5%A5%A5%E5%B7%B4%E9%A9%AC%27%22%29%29.%0D%0A%7D=text%2Fhtml_redir_for_subjs=121_redir_for_hrefs==3=on Patrick --- Patrick van Kleef Program Man

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

2015-09-18 Thread Patrick van Kleef
kind of errors do not occur when then dumping the data, but that does not help you at this point. One thing you can do is to edit the files and change http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral to http://www.w3.org/1999/02/22-rdf-syntax-ns#PlainLiteral That would allo

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

2015-09-17 Thread Patrick van Kleef
> waste of time trying to find all lines with errors and remove them by hands. > Can't find anything related to this in the documentation. I have reproduced the problem in-house and i am currently talking to development to provide a solution to this problem. I will advice as soon as a p

Re: [Virtuoso-users] SPARQL update question

2014-10-21 Thread Patrick van Kleef
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] R on Virtuoso Server

2014-04-14 Thread Patrick van Kleef
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

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

2014-04-14 Thread Patrick van Kleef
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:http://www.openarchives.org/ore/terms/ PREFIX

Re: [Virtuoso-users] ASSUME ???

2013-07-29 Thread Patrick van Kleef
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 team

Re: [Virtuoso-users] strafter and strbefore

2013-06-03 Thread Patrick van Kleef
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.

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

2013-04-11 Thread Patrick van Kleef
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 to

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

2013-03-25 Thread Patrick van Kleef
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 WikiV

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

2012-12-17 Thread Patrick van Kleef
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

2012-12-17 Thread Patrick van Kleef
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

2012-12-06 Thread Patrick van Kleef
virtuoso author Patrick van Kleef pkl...@openlinksw.com # When to start the service start on runlevel [2345] # When to stop the service stop on runlevel [016] # Automatically restart process if crashed respawn # Virtuoso will fork

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

2012-11-15 Thread Patrick van Kleef
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' () in

Re: [Virtuoso-users] Connecting to Virtuoso

2012-11-08 Thread Patrick van Kleef
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 connection

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

2012-08-17 Thread Patrick van Kleef
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 similar

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

2012-05-22 Thread Patrick van Kleef
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] SPARQL FILTER by xsd types

2012-05-22 Thread Patrick van Kleef
HI Quintin, I have a bit of weirdness though it's been resolved/worked-around. A query that looks like: prefix ont: ontStuff select ?dq { GRAPH http://stuff { ?li ont:code S . ?li ont:liHasDQ ?dq . ?dq ont:Quantity ?qty . ?dq ont:Quantity 0^^xsd:int } } Or with a filter: prefix ont:

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

2012-05-10 Thread Patrick van Kleef
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?

2012-04-26 Thread Patrick van Kleef
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 string

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

2012-04-16 Thread Patrick van Kleef
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] tweaking default language settings?

2012-03-18 Thread Patrick van Kleef
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 language

Re: [Virtuoso-users] ResultSet to Java Collection

2012-03-18 Thread Patrick van Kleef
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

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

2012-03-16 Thread Patrick van Kleef
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] Priviliged admin user

2012-02-13 Thread Patrick van Kleef
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

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

2012-02-13 Thread Patrick van Kleef
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] Renaming a big graph

2012-02-09 Thread Patrick van Kleef
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

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

2011-12-29 Thread Patrick van Kleef
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

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

2011-11-08 Thread Patrick van Kleef
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

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

2011-11-03 Thread Patrick van Kleef
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

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

2011-11-02 Thread Patrick van Kleef
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

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

2011-11-02 Thread Patrick van Kleef
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

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

2011-10-03 Thread Patrick van Kleef
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: 'n[0-9]:(\n|\s)' I need to preserve the value matched by [0-9] in the replacement string. eg:

Re: [Virtuoso-users] Unstable endpoint

2011-09-21 Thread Patrick van Kleef
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

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

2011-07-11 Thread Patrick van Kleef
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, did

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

2011-06-29 Thread Patrick van Kleef
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

Re: [Virtuoso-users] HTTPS setup on Localhost

2011-06-28 Thread Patrick van Kleef
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

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

2011-06-24 Thread Patrick van Kleef
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

Re: [Virtuoso-users] SPARQL Query using SERVICE

2011-06-20 Thread Patrick van Kleef
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

2011-05-31 Thread Patrick van Kleef
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

2011-05-25 Thread Patrick van Kleef
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

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

2011-05-25 Thread Patrick van Kleef
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

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

2011-05-25 Thread Patrick van Kleef
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:

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

2011-05-23 Thread Patrick van Kleef
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] Sorting in SPARQL XML result format

2011-05-23 Thread Patrick van Kleef
Hi Jonas, i have a problem with sorting again :) given the dataset in the attachment, when i do the query SELECT DISTINCT ?resourceUri FROM http://example.com/activities/ WHERE { ?resourceUri http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.notu.be/aair#Activity . ?resourceUri

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

2011-05-23 Thread Patrick van Kleef
Hi Jonas, i have a problem with sorting again :) given the dataset in the attachment, when i do the query SELECT DISTINCT ?resourceUri FROM http://example.com/activities/ WHERE { ?resourceUri http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://xmlns.notu.be/aair#Activity .

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

2011-05-19 Thread Patrick van Kleef
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

Re: [Virtuoso-users] Subgraphs or SPARQL views

2011-05-13 Thread Patrick van Kleef
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

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

2011-03-24 Thread Patrick van Kleef
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

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

2011-03-24 Thread Patrick van Kleef
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

2011-03-24 Thread Patrick van Kleef
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] SPARQL Update string literals

2011-03-24 Thread Patrick van Kleef
Hi Lars, I'm sending the following SPARQL Update statement to Virtuoso: insert data into file:/C:/Bouvet/OntopiaServer/apache-tomcat/common/ classes/ifs.xtm { http://psi.ontopia.net/customers/ifs/ su5566629993 http://www.w3.org/2000/01/rdf-schema#label MM'S LUNCH CATERING

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

2011-03-17 Thread Patrick van Kleef
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

2011-02-11 Thread Patrick van Kleef
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:

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

2011-02-10 Thread Patrick van Kleef
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

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

2011-01-27 Thread Patrick van Kleef
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

Re: [Virtuoso-users] Problem adding external datasource

2011-01-20 Thread Patrick van Kleef
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] Support for Lines and Polygons in Virtuoso's Geospatial Extensions

2010-12-02 Thread Patrick van Kleef
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

Re: [Virtuoso-users] Trippi connector

2010-11-30 Thread Patrick van Kleef
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

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

2010-11-03 Thread Patrick van Kleef
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

2010-10-28 Thread Patrick van Kleef
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-opensource-6.1.2.tar.gz: broken or out of date vad packages?

2010-09-10 Thread Patrick van Kleef
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.

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

2010-08-24 Thread Patrick van Kleef
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()

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

2010-08-23 Thread Patrick van Kleef
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

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

2010-08-21 Thread Patrick van Kleef
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

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

2010-08-09 Thread Patrick van Kleef
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:

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

2010-08-07 Thread Patrick van Kleef
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:

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

2010-08-06 Thread Patrick van Kleef
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 simple.

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

2010-08-02 Thread Patrick van Kleef
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

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

2010-07-29 Thread Patrick van Kleef
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..

2010-07-27 Thread Patrick van Kleef
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 /

Re: [Virtuoso-users] EF support improvements

2010-07-23 Thread Patrick van Kleef
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

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

2010-07-21 Thread Patrick van Kleef
HI Jamey, The vad_sticker.dtd file in the Virtuoso source code (and the documentation at http://docs.openlinksw.com/virtuoso/VAD.html) appears to indicate that file resource elements in vad stickers will accept a source_uri attribute. When this attribute is populated, I would expect the

Re: [Virtuoso-users] DB.DBA.RDF_GEO_FILL exits with error

2010-07-14 Thread Patrick van Kleef
Hi Claus, The first time the after a DB start DB.DBA.RDF_GEO_FILL () is called, the error occurs after less than a half a minute. On consecutive attempts it then only takes a few seconds. The error occurs independent of whether resources carry the virtuoso specific geo-literals. However,

Re: [Virtuoso-users] Mac re-install error

2010-07-14 Thread Patrick van Kleef
Hi Nico, I installed virtuoso already once on another server. But this time I have some problems while compiling. This files are not there, and they are not in the files I downloaded. The source archive does not have this file either, but sometimes external tools like editors etc create

Re: [Virtuoso-users] how to run virtuoso without client

2010-07-10 Thread Patrick van Kleef
Hi Bin, I have virtuoso installed in a linux server, every time I have to log into the server from another pc using putty and run the virtuoso...but once the putty connection is disconnected, the virtuoso in the linux is terminated simultaneously, How can I keep the virtuoso running when I

Re: [Virtuoso-users] select statement and limit

2010-07-08 Thread Patrick van Kleef
Hi Nikolaos, I am using Virtuoso 6.1 as a relational database backend (so far). I see in the select statement reference http://docs.openlinksw.com/virtuoso/SELECTSTMT.html that the LIMIT construct (found e.g. in mysql) is not supported. How would I submit an sql query of the form:

Re: [Virtuoso-users] HTTP-Proxy settings for Virtuoso Sponger

2010-06-17 Thread Patrick van Kleef
Hi Johannes, I'm trying to use a locally installed Virtuoso Sponger with both data from intranet and the internet. So far I can only use it to extract RDF from intranet sources. Is there a way to configure the Sponger to use an HTTP proxy for external URLs? This can be done on a

Re: [Virtuoso-users] Virtuoso server on Debian with apache proxying

2010-05-25 Thread Patrick van Kleef
this and the ProxyHTMLUrlMap is. Thank you very much for providing me the configuration file. No problem. I will add this as a suggestion into the documentation so others may benefit. Patrick 2010/5/23 Patrick van Kleef vos.ad...@openlinksw.com Hi Nicolas, I'm trying to access virtuoso

Re: [Virtuoso-users] Virtuoso server on Debian with apache proxying

2010-05-25 Thread Patrick van Kleef
HI Nicolas, Going further on investigation, I've some little problems: 1- strange caracters appearing on the conductor screen (A like symbol on capture of virtuoso conductor screen) Will need to have a look using your method of proxy rewrite to see what it produces. I did not notice

Re: [Virtuoso-users] Virtuoso server on Debian with apache proxying

2010-05-23 Thread Patrick van Kleef
Hi Nicolas, I'm trying to access virtuoso server through an apache server, using mod_proxy. Calling http://www.mysite.net/virtuoso, it should redirect on my local server on 88.191.91.72:8890 http://88.191.91.72:8890 NameVirtualHost 88.191.91.72 VirtualHost 88.191.91.72 ServerName

Re: [Virtuoso-users] ADO.NET provider DateTime bug(?)

2010-04-15 Thread Patrick van Kleef
HI Alexander, Previously I stored DateTime values as strings and casted them to xsd:dateTime dynamically at query time. Then according to Ivan's advice I reimplemented SPARUL part to cast DateTime values when they are added to the store. But now ADO.NET http://ADO.NET provider returns

Re: [Virtuoso-users] Redland Python bindings with Virtuoso 6.1

2010-03-29 Thread Patrick van Kleef
Hi Chris, I'm back on the trail to get redland working with virtuoso storage. I want to be able to use virtuoso as a backend from python (and probably c++ later on)! I'm still having issues with the librdf 1.0.10 version. I can connect using pyodbc to virtuoso with unixodbc installed. I am

Re: [Virtuoso-users] V6.1.0 Reasoning and index with strange error

2010-02-11 Thread Patrick van Kleef
Hi Sebastian, I experimented with the new reasoning features and there are some issues. I already solved them and just want to give you some feedback. The features and the speed of reasoning are quite awesome, good work thumbs up. Here is one small question: If my:trans is a transitive

Re: [Virtuoso-users] Windows build manual

2010-02-05 Thread Patrick van Kleef
Hi Alexander, Is there any more up-to-date build manual for Windows that this? The scripts are all up to date in both win32 and win64 directories, and while doc may need some attention, for the most part it should give you reasonable idea of how to perform a build yourself. However

Re: [Virtuoso-users] FYI: Dbpedia-Live Reports Could Not Connect to Host

2010-01-21 Thread Patrick van Kleef
Hi Stephen, I noticed all of the directly accessed resources at dbpedia-live.openlinksw.com http://dbpedia-live.openlinksw.com weren't working. Here's what it's been saying for at least several resources: *Address:* http://dbpedia-live.openlinksw.com/page/Dauphin_commun_%C3%A0_bec_court

Re: [Virtuoso-users] OS X 10.6.2: Exceeded maximum number of file descriptors in FD_SET.

2010-01-19 Thread Patrick van Kleef
Hi Ceriel, As soon as the virtuoso.log mentions Exceeded maximum number of file descriptors in FD_SET. in a testing environment (=few users), how should the OS or virtuoso or the OS be reconfigured? There are three posibilities: 1. Your ulimit / kernel settings are too small for your

Re: [Virtuoso-users] problem loading RDF...

2010-01-18 Thread Patrick van Kleef
HI Egon, I am trying to load a RDF document (made with a PHP script from a MySQL database) into Virtuoso with isql, but running into this exception: SQL DB.DBA.RDF_LOAD_RDFXML_MT(file_to_string_output('/tmp/compounds.rdf', 'http://pele.farmbio.uu.se/chembl'); *** Error 37000: [Virtuoso

Re: [Virtuoso-users] How to download Virtuoso open source 6.0 ?

2010-01-15 Thread Patrick van Kleef
Hi Wenxiu, Thanks for your contribution on Virtuoso! I am wondering how to download virtuoso open source verison 6.0, seems the latest version in both Sourceforge and CVS is 5.0.12. Virtuoso 6.0.0 was downloadable from the virtuoso-devel section of Sourceforge. We are in the process of

Re: [Virtuoso-users] Problems building 6.0.0 ODBC driver on OSX 10.6

2009-12-23 Thread Patrick van Kleef
Hi Ryan, I am trying to compile virtuoso-opensource 6.0.0 on a 32-bit Intel Mac running OSX 10.6. Everything goes fine until it gets to the ODBC driver, at which point I run into the following error: ld: warning: in .libs/virt_vers_r.o, file is not of required architecture ld: warning: in

Re: [Virtuoso-users] Newbie questions

2009-12-21 Thread Patrick van Kleef
Hi Eddy, 2. Has any-one an idea if and when the form-designer of OAT would be re-activated ? Don't get data into the widgets. We have scheduled to fix form designer in the next week or so. I will let you know as soon as i have an ETA from development. Patrick

Re: [Virtuoso-users] Querying the currently used indexes

2009-12-14 Thread Patrick van Kleef
HI Sebastian, currently I am using the following query to determine the indexes that are in use: SELECT DISTINCT SUBSTRING(ISS_KEY_NAME,10,4) FROM SYS_INDEX_SPACE_STATS WHERE ISS_KEY_TABLE='DB.DBA.RDF_QUAD' AND

Re: [Virtuoso-users] Virtuoso 6.0.1

2009-12-09 Thread Patrick van Kleef
Hi Xavier, with KDE 4.4's feature freeze coming up I would like to know when Virtuoso 6.0.1 will be released. KDE 4.4 will be the first release of KDE which depends on Virtuoso and I would like for packagers to package Virtuoso 6 rather than 5. However, 6.0 does contain at least one

  1   2   >