[Bio2rdf-bugs] [ bio2rdf-Bugs-2802673 ] problem using n32virtuoso.pl

[SourceForge.net <no...@so...>]

Bugs item #2802673, was opened at 2009-06-07 19:49
Message generated for change (Tracker Item Submitted) made by dgrobe
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=814189&aid=2802673&group_id=142631

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: michael grobe (dgrobe)
Assigned to: Nobody/Anonymous (nobody)
Summary: problem using n32virtuoso.pl

Initial Comment:
hello:

i am trying to load the obo.n3 example using n32virtuoso.pl.

i got the error about not having permissions to run

    DB.DBA.SPARQL_INSERT_DICT_CONTENT

and so i tried to follow the directions in

http://code.google.com/p/entitydescriber/wiki/installingvirtuoso

to wit:

In order to do update statements you'll need to go back to the command prompt and navigate to where isql is. It's in the bin directory of your Virtuoso-OpenSource installation 

./bin/isql 1111 dba dba Where 1111 is the port that isql will use, dba is the user name and dba is the password 

This brings up an SQL prompt SQL> 

Enter SQL> GRANT SELECT ON DB.DBA.SPARQL_DELETE_DICT_CONTENT TO "SPARQL"; and enter SQL> GRANT SELECT ON DB.DBA.SPARQL_INSERT_DICT_CONTENT TO "SPARQL"; to gain permission on these procedures. Do the same for any other procedure you want. 

Now ify ou go back to the SPARQL Endpoint: http://localhost:8890/sparql, you will be able to do SPARUL statements like INSERT and DELETE. 

Now the login was successful, and i got the SQL> prompt, but the
command:

grant select on DB.DBA.SPARQL_INSERT_DICT_CONTENT TO "SPARQL";

got me:

*** Error 42S02: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SR136: Bad table name in 
   GRANT / REVOKE DB.DBA.SPARQL_INSERT_DICT_CONTENT.
at line 10 of Top-Level:
grant select on DB.DBA.SPARQL_INSERT_DICT_CONTENT TO "SPARQL"

not clear to whom this should be addressed but at least the Perl
code was in the Bio2RDF pages.

Thanks for whatever help you can give, and in the meantime i guess i'll try the bash install approach.

Michael Grobe
Indiana University

P.S.:  I'm using the freebie version of Virtuoso...

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=814189&aid=2802673&group_id=142631