Hi Laurent,
The “DB.DBA.SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE” function is built into
the binary and this not displayed as part for the database schema.
If as indicated you have performed the require grants for SPARQL_UPDATE
privileges, then please enable tracing on the Virtuoso server to see what query
is being executed that is failing using the “trace_on()” function as detailed
at:
http://docs.openlinksw.com/virtuoso/fn_trace_on.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 3 Aug 2015, at 23:37, Laurent Alquier <[email protected]> wrote:
>
> Hello
>
> I am troubleshooting an issue as I am trying to connect a Virtuoso instance
> to Semantic Mediawiki (latest SMW with Virtuoso Community Edition 7.2.1
> binaries on windows).
>
> The PHP script to refresh semantic mediawiki properties throws an 'Error 500:
> Query refused' on the first SPARQL UPDATE query.
>
> This seems to be pointing to access control issues.
>
> I applied recommended roles to the SPARQL account, in particular on
> DB.DBA.SPARQL_INSERT_DICT_CONTENT as suggested here:
>
> https://github.com/SemanticMediaWiki/SemanticMediaWiki/blob/master/build/travis/virtuoso-sparql-permission.sql
>
> <https://github.com/SemanticMediaWiki/SemanticMediaWiki/blob/master/build/travis/virtuoso-sparql-permission.sql>
>
> I tried looking for that procedure in the Database tab of Conductor (logged
> in as dba) and I couldn't find it.
>
> Is it normal this package is missing from the Database tab?
> If not, is it part of a package I forgot to install or something I obviously
> overlooked?
>
> --
> - Laurent Alquier
> http://www.linfa.net
> <http://www.linfa.net/>------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users