Re: [Virtuoso-users] connecting VOS to Postgres

tp://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 1 Oct 2010, at 01:04, Kurt J wrote: > >> Hello, >> >> I'm interested in doing some RDF Views stuff with VO

[Virtuoso-users] connecting VOS to Postgres

? We want to avoid a "dump" and make it such that changes to the Postgres DB propagate to the RDF View almost instantly. Thanks, Kurt J

[Virtuoso-users] virtuoso gobbling 400% of cpu

queries made somehow??? So i know what caused the horrible cpu usage? thnx, Kurt J

Re: [Virtuoso-users] strange time out on simple query

ts#"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xsi:schemaLocation="http://www.w3.org/2001/sw/DataAccess/rf1/result2.xsd";> >   >   >   >   >   >   CARLOS LYRA >   >   > * Closing connection #0 > > Best Regards > Hugh Wi

Re: [Virtuoso-users] strange time out on simple query

sing connection #0 does this imply a funky Apache setting??? On Wed, Oct 7, 2009 at 4:59 PM, Kurt J wrote: > Hello, > > A user made me aware of this on the DBtune/myspace endpoint > http://virtuoso.dbtune.org/sparql > > this query: > > SELECT ?s WHERE { <http://dbtune.org

[Virtuoso-users] strange time out on simple query

Hello, A user made me aware of this on the DBtune/myspace endpoint http://virtuoso.dbtune.org/sparql this query: SELECT ?s WHERE { ?s } runs fine through the web interface but then seems to timeout in all other instances

Re: [Virtuoso-users] some problems w/ dbtune/myspace and vos

Hi Hugh, After a long WE, i just got back and tried to reproduce this dead-locking... with no luck. So that's a mystery. I've re-enabled the odbc sparql inserts and we'll see if it gets back to dead lock again. > load via the ODBC connection and not if you load directly via isql can > you creat

Re: [Virtuoso-users] some problems w/ dbtune/myspace and vos

l) Kernel \r on an \m > uname -a Linux parrot 2.6.18-128.1.6.el5 #1 SMP Wed Apr 1 09:10:25 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux Thanks! -Kurt J

[Virtuoso-users] some problems w/ dbtune/myspace and vos

. Well, it's a sunny day outside - gonna put the computer away for now - will do more debugging tomorrow or tuesday. Just wanted to ring the calvary straight away ;-) -Kurt J

[Virtuoso-users] loading a very large rdf file

Hi, I'm trying to load a large rdf file (~84mb) in iSQL i try: DB.DBA.RDF_LOAD_RDFXML_MT(file_to_string('/www/virtuoso/jamendo.rdf'), '', 'http://localhost.test/jamendo'); I get the following: SQLState: 39000 Message: FA008: File '/www/virtuoso/jamendo.rdf' too long, cannot return string cont

[Virtuoso-users] SNORQL explorer

Hello, How can i put a SNORQL interface on top of my Virtuoso instance ala http://dbpedia.org/snorql/ googling for snorql points me to some other explorers but no download page or anything. i understand it is part of D2R... do i just use this? ??? thanks! -kurt

Re: [Virtuoso-users] inserting a local rdf file into the store

>> after closing the odbc connection the graph is empty!  any idea what gives? > > Just in case: Perhaps the commands were run in a transaction and you > forgot to do `connection.commit()`? hehe. you're right. my mistake. i needed to call connect.commit() sorry, odbc nb :-)

Re: [Virtuoso-users] inserting a local rdf file into the store

be of some help to others... cheers, kurt j On Mon, Jun 15, 2009 at 5:20 PM, Kurt J wrote: >> In [61]: connect.execute('''DB.DBA.RDF_LOAD_RDFXML (file_to_string >> ('/test-virtuoso/cmn2.rdf'), '', 'http://mygraph.com') ; ''&#

Re: [Virtuoso-users] inserting a local rdf file into the store

7;, '#SCHU3') In [7]: connect.close() In [8]: connect = pyodbc.connect('DSN=SysVirt;UID=dba;PWD=dba;HOST=localhost:1112') In [9]: connect.execute('''sparql select * from <http://mygraphfunky.com> where {?s ?p ?o }''') Out[9]: In [10]: for r in Out[9]: print r : after closing the odbc connection the graph is empty! any idea what gives? -kurt j

Re: [Virtuoso-users] inserting a local rdf file into the store

     Rebecca > nodeID://110006 >       http://www.w3.org/2001/vcard-rdf/3.0#Family >             Jones > nodeID://110006 >       http://www.w3.org/2001/vcard-rdf/3.0#Given >            Sarah > nodeID://110007 >       http://www.w3.org/2001/vcard-rdf/3.0#Family >            

Re: [Virtuoso-users] inserting a local rdf file into the store

in case there is another option in my virtuoso.ini file that might be wrong, it is here: http://pastebin.com/m7494e063 cheers, kurt j On Mon, Jun 15, 2009 at 10:58 AM, Kurt J wrote: > Hi Hugh, > > thanks but this still does not seem to work.  from the virtuoso.ini file: > &

Re: [Virtuoso-users] inserting a local rdf file into the store

ot;db" folder assuming this is in > your DirsAllowed param ... > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > > > On 12 Jun 20

[Virtuoso-users] inserting a local rdf file into the store

sparql load into <http://test.cmn.graph>''') (no 'file://') and this crashed virtuoso 5.11 w/ a segfault. just fyi. thanks, Kurt J

Re: [Virtuoso-users] executing sql from python script

Hi Patrick, > Add the following lines to your /etc/odbc.ini > >        [Local Virtuoso] >        Driver  = /PREFIX/lib/virtodbc_r.so >        Address = localhost: > > where PREFIX is replaced by the full path you installed your virtuoso > and also assuming you use port in virtuoso.ini (is

[Virtuoso-users] executing sql from python script

s to write sql to a file and then call isql from the command line. I think this would be fine, but seems there should be a better way... thanks, -Kurt J

Re: [Virtuoso-users] swallowing another triple store

>> Is there a clever way to make virtuoso swallow another triple store? >> Say i have another sparql endpoint somewhere and i want to point >> virtuoso there and tell it to suck up all the d

[Virtuoso-users] swallowing another triple store

Hi Again, Is there a clever way to make virtuoso swallow another triple store? Say i have another sparql endpoint somewhere and i want to point virtuoso there and tell it to suck up all the data. -Kurt J

[Virtuoso-users] rdf input options

uery from a script rather than the web interface? - kurt j

Re: [Virtuoso-users] using the vad wiki package

make virtuoso listen on port 80. not sure why this made the wiki package fail and everything else work, but that seems to be the case. sorry for the big waste of time!!! thanks for all your help! -kurt On Sat, Mar 21, 2009 at 9:57 AM, Kurt J wrote: > whoops :-) > > here's

Re: [Virtuoso-users] using the vad wiki package

's a lot of university bureaucracy to deal w/ tho... is a copy of the virtuoso.db file sufficient? i could put this on another public server... thanks! -kurt j On Fri, Mar 20, 2009 at 6:56 PM, Ted Thibodeau Jr wrote: > Hi, Kurt -- > > > On Mar 20, 2009, at 09:42 AM, Kurt J wro

Re: [Virtuoso-users] using the vad wiki package

section as I do believe the > localhost:8890 [URIQA] DynamicLocal= 1 DefaultHost = localhost:8890 tried changin this to hostname:80 and got the same old error. -kurt j On Tue, Mar 17, 2009 at 12:08 AM, Hugh Williams wrote: > Kurt, > > On 16 Mar 2009, at 18:27

Re: [Virtuoso-users] using the vad wiki package

second command returns nothing. is this right? what should be in host.conf? sorry i'm a server admin noob :-) -kurt On Tue, Mar 17, 2009 at 1:19 PM, Tim Haynes wrote: > Hugh Williams wrote: >> >> Kurt, >> >> On 16 Mar 2009, at 18:27, Kurt J wrote: >> >>>

Re: [Virtuoso-users] using the vad wiki package

nksw.com/dataspace/dav/wiki/Main/OdsWiki > 4. > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/OdsWikiGettingStarted > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: h

Re: [Virtuoso-users] using the vad wiki package

haha! learned how to do foxyproxy thru ssh tunnel! here's the exact specs: * Version: 05.10.3037 * Build: Mar 13 2009 and wiki 1.05.4388/ 2009-03-13 cheers, kurt j On Mon, Mar 16, 2009 at 4:09 PM, Kurt J wrote: > garr!  looks like my vnc server just crashed a

Re: [Virtuoso-users] using the vad wiki package

garr! looks like my vnc server just crashed and i can only access my virtuoso install from uni. won't be able to look at it til next week. but as i remember it's virtuoso 5.0.10 on linux built like 3 days ago wiki 1.05 cheers, kurt j On Mon, Mar 16, 2009 at 3:10 PM, Hugh Willi

[Virtuoso-users] using the vad wiki package

om "/wiki/main/" or from the ODS Execution of "/wiki/main/Main" failed. SQL Error: 42WV9 [11002] Path /wiki/main/Main to resource must start from "/wiki/main/" any ideas? am i missing something obvious? couldn't find any documentation for the wiki VAD... -kurt j

[Virtuoso-users] min requirements for oss virtuoso and disk usage

llion triples and ./share/virtuoso/vad is about 132mb... seem reasonable? seems small to me :-) Thanks, Kurt J

Re: [Virtuoso-users] using /about/

ing /about/html was an appropriate way to do this. however it would not work for me. the best i could get was info about xsd style sheets. if i understood Kingsley's email, this is because the rdf returned by http://dbtune.org/data/<> doesn't include foaf:topicOf properties. cheers,

Re: [Virtuoso-users] using /about/

/about/ i would want to generate static rdf files (ie http://dbtune.org/cmn/data/WAGN.rdf) and host them? is this what is done on dbpedia? is there a fancy programmatic way of doing this from the rdf store? -kurt On Thu, Feb 5, 2009 at 6:08 PM, Kingsley Idehen wrote: > On 2/5/09 12:31 PM,

Re: [Virtuoso-users] using /about/

Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > > > On 5 Feb 2009, at 17:31, Kurt J wrote: > > Hi, > So far i've been totally unsuccessful using the /about/ f

Re: [Virtuoso-users] using /about/

; before, so are you still setting this on that server ? > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > > > On 5 Feb 2009, at 1

[Virtuoso-users] using /about/

UPDATE and SPARQL_SPONGE roles i've done grant execute on DB.DBA.RDF_SPONGE_UP to "SPARQL"; any ideas what could be going wrong? perhaps some other magical grant execute command? cheers, kurt j

Re: [Virtuoso-users] enabling sparql LOAD command

ing else ? > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > > > On 4 Feb 2009, at 15:24, Kurt J wrote: > > Hi Li

[Virtuoso-users] enabling sparql LOAD command

Hi List, I recently learned from Hugh about a fix to enable sparql insert in VOS... grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL" grant execute on SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE is there a similar command that would enable LOAD via the sparql point? Cheers, Kurt J

Re: [Virtuoso-users] question about html representations of RDF

whoo! that did the trick. thanks hugh! :-) On Tue, Feb 3, 2009 at 2:04 PM, Hugh Williams wrote: > Kurt, > On 3 Feb 2009, at 12:53, Kurt J wrote: > >> sounds very useful. however it doesn't seem to be working :( after >> adding SPARQL_UPDATE to SPARQL in the conduc

Re: [Virtuoso-users] question about html representations of RDF

nsert in graph <http://dbtune.org/cmn/resource> {<http://dbtune.org/cmn/resource/kurtjx> <http://purl.org/onotology/classicalmusicnav#influencedBy> <http://dbtune.org/cmn/resource/WAGN>} any idea what i'm missing? cheers, kurt j On Tue, Feb 3, 2009 at 12:27 PM, Hugh W

Re: [Virtuoso-users] question about html representations of RDF

_REWRITE_RULE_LIST > Can you also provide more details on these redirects from apache to Virtuoso > ? > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http:

Re: [Virtuoso-users] question about html representations of RDF

> Do you have the SPARQL_SPONGE role enabled for SQL USER "SPARQL" ? This is > ROLE isn't granted by default for security reasons. under System Admin -> User Accounts -> SPARQL -> Account Roles -> Selected SPARQL_SELECT SPARQL_SPONGE sort of unrelated question, adding the role SPARQL_UPDATE to S

Re: [Virtuoso-users] question about html representations of RDF

en chucked into the deep end and i'm trying to stay afloat ;) my plan, eventually, is to get comfortable w/ virtuoso and switch off apache and proxy to the swi-prolog servers from virtuoso. cheers, kurt j

Re: [Virtuoso-users] question about html representations of RDF

esponse as far as i can tell cheers! -kurt j

Re: [Virtuoso-users] question about html representations of RDF

information resources, hence > my comment above (which is how you make a conduit into the specific resource > description graph). so this was my intent. i sort of inferred from the northwind examples that html pages could be created on the fly from rdf in the data store usng this method. thanks for you help! -kurt j

[Virtuoso-users] question about html representations of RDF

nced properties, some foaf, and links to dbpedia which do appear in the RDF my rewrite rule is: /cmn/page/(.*)$ to /rdfdesc/description.vsp?g=http://dbtune.org/cmn/resource/$U1 any assistance would be greatly appreciated. cheers, kurt j

Re: [Virtuoso-users] making virtuoso look like dbpedia

&format=%24accept i think the trick was specifying '$U1' in 'format' mode rather than 'sparql' mode... cheers, kurt On Thu, Jan 29, 2009 at 4:46 PM, Kurt J wrote: > Hi Kingsley, > > Thanks for your quick reply - I understand this sparql-redirect > co

Re: [Virtuoso-users] making virtuoso look like dbpedia

an #CAGE as i expected. settings are rulelist: *main* pattern: REGEX matching: Normal result format: auto http response: internal redirect what am i doing wrong? cheers, kurt j On Wed, Jan 28, 2009 at 7:37 PM, Kingsley Idehen wrote: > On 1/28/09 2:06 PM, Kurt J wrote: >> >>

[Virtuoso-users] making virtuoso look like dbpedia

fandsparql.html but i haven't found what i'm looking for yet (i think). cheers! kurt j