Thanks Hugh!
I will look at those permissions. I just tried to reinstall fct from
conductor and received the following error:
00000 Errors detected
00000 Installation of "Faceted Browser" was unsuccessful.
The installation of this VAD package has failed.
Please delete the transaction file
/usr/local/var/lib/virtuoso-opensource-7/db//usr/local/var/lib/virtuoso-opensource-7/db/virtuoso.trx
and then restart your database server.
Note: Your database will be in its pre VAD installation state
after you restart.
00000 FATAL
I removed this log file and restarted, and keep receiving the same
error after trying to reinstall the fct vad from the conductor
interface. I think I'm going to try a new build unless there is an
alternative to updating / reinstall fct.
-------------------------------------------------------
Advanced Distributed Learning Initiative
+1.850.266.7100(office)
+1.850.471.1300 (mobile)
jhaag75 (skype)
http://linkedin.com/in/jasonhaag
On Wed, Feb 3, 2016 at 5:08 PM, Hugh Williams <hwilli...@openlinksw.com> wrote:
> Hi Jason,
>
> If RDF_GLOBAL_RESET(0 is run then it will clear all RDF rules and storage
> content, thus the FCT would need to be reinstalled.
>
> I got the same error trying to load a saved faceted view and resolved it by
> granting execute privileges on the function to the the SPARQL user ie
>
> grant execute on "fct_load" to "SPARQL";
>
> 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 Feb 2016, at 21:01, Haag, Jason <jason.haag....@adlnet.gov> wrote:
>>
>> I'm not sure if this is a result of previously doing a global reset
>> though. I just created a faceted view and when I click on it from the
>> fct featured views, I receive the error:
>>
>> Error 42000
>>
>> SR186:SECURITY: No permission to execute procedure fct_load with user
>> ID 107, group ID 107
>>
>> After reading this post, I think I need to do more homework on fct security
>> :-(
>> https://www.mail-archive.com/virtuoso-users@lists.sourceforge.net/msg05775.html
>>
>> -------------------------------------------------------
>> Advanced Distributed Learning Initiative
>> +1.850.266.7100(office)
>> +1.850.471.1300 (mobile)
>> jhaag75 (skype)
>> http://linkedin.com/in/jasonhaag
>>
>>
>> On Wed, Feb 3, 2016 at 2:31 PM, Haag, Jason <jason.haag....@adlnet.gov>
>> wrote:
>>> It looks like this issue was reported before:
>>> https://github.com/openlink/virtuoso-opensource/issues/245
>>>
>>> I did a global reset recently, but have populated it since then.
>>> -------------------------------------------------------
>>> Advanced Distributed Learning Initiative
>>> +1.850.266.7100(office)
>>> +1.850.471.1300 (mobile)
>>> jhaag75 (skype)
>>> http://linkedin.com/in/jasonhaag
>>>
>>>
>>> On Wed, Feb 3, 2016 at 2:07 PM, Hugh Williams <hwilli...@openlinksw.com>
>>> wrote:
>>>> Hi Jason,
>>>>
>>>> What Virtuoso archive did you build against git develop/7 or stable/7 , as
>>>> I just built against develop/7 and it works for me:
>>>>
>>>> SQL> RDF_OBJ_FT_RULE_ADD (null, null, 'All');
>>>>
>>>> Done. -- 18 msec.
>>>> SQL> VT_INC_INDEX_DB_DBA_RDF_OBJ ();
>>>>
>>>> Done. -- 50 msec.
>>>> SQL> urilbl_ac_init_db();
>>>>
>>>> Done. -- 20 msec.
>>>> SQL> s_rank();
>>>>
>>>> Done. -- 223 msec.
>>>> SQL> vad_list_packages ();
>>>> name title version build_date install_date
>>>> VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR
>>>> _______________________________________________________________________________
>>>>
>>>> conductor Virtuoso Conductor 1.00.8754 2015-12-30 16:49 2016-01-27
>>>> 15:48
>>>> fct Faceted Browser 1.13.84 2016-02-03 19:49 2016-02-03 20:02
>>>>
>>>> 2 Rows. -- 11 msec.
>>>> SQL>
>>>>
>>>> Also, did you compile your own FCT vad or download it from somewhere ?
>>>>
>>>> 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 Feb 2016, at 18:35, Haag, Jason <jason.haag....@adlnet.gov> wrote:
>>>>
>>>> Hi Guys,
>>>>
>>>> I have installed fct. Both the text search and entity URI tabs work fine.
>>>> However, the entity label lookup tab doesn't work when any entities are
>>>> typed. I read the post-installation instructions here:
>>>>
>>>> http://docs.openlinksw.com/virtuoso/virtuosospongerfacetinstall.html
>>>>
>>>> Under the section "16.11.4. Post Installation" it states in order to
>>>> activate the Label text box of the Entity Label Lookup tab, to run this
>>>> procedure in iSQL:
>>>>
>>>> urilbl_ac_init_db()
>>>>
>>>> However, when I attempt to run this I receive the following error:
>>>>
>>>> SQLState: 37000
>>>> Message: SQ074: Line 25 (line 24 of "/DAV/VAD/fct/complete_single.sql"):
>>>> SP031: SPARQL compiler: 'define input:inference refers to undefined
>>>> inference rule set "facets"
>>>>
>>>> I'm running VOS on ubuntu, Version: 07.20.3215. Appreciate any tips on
>>>> troubleshooting or enabling this.
>>>>
>>>> Thanks,
>>>>
>>>> J Haag
>>>> ------------------------------------------------------------------------------
>>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>>> Monitor end-to-end web transactions and take corrective actions now
>>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
>>>> Virtuoso-users mailing list
>>>> Virtuoso-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>
>>>>
>
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
