Hi Bob, I have just noticed the "./virtuoso" reference in the run_executable call that is being made which means that "virtuoso" symlink must be created in the directory where the Virtuoso Database resides as is the case to the Virtuoso AMIs and Virtuoso commercial installers the AMIs use, but it not the case for the open source builds as they don't use the commercial packaging structure, thus this symlink has to be made manually. The restart.sh script also does not exist for the open source builds thus the server has to be restarted manually after the restore.
Basically the ec2ext VAD was originally written for use with the Virtuoso prebuilt AMIs and thus makes certain assumptions about the configuration. To get this to work with an open source binary the following changes need to be manually made: 1. A "virtuoso" symlink to the Virtuoso binary executable (virtuoso-t) must exist in the directory the database it run/started from 2. The entries "SafeExecitables=0" and "DbaExecitables=/bin/sh" needs to be added to the "Parameters" section of the Virtuoso Configuration file (virtuoso.ini) 3. The Virtuoso server will need to be manually restarted after the restore Note it will also not work on Windows unless cygwin or similar is installed such that the the "sh" shell it requires is available ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 20 May 2010, at 08:43, Bob Ferris wrote: > Hi Hugh, > > I'm running Ubuntu 10.04 x64. I could execute the ./virtuoso-t ... > command on my terminal (but with an absolute path to my related vos > installation), but (as far as know) you wouldn't have normally a > virtuoso(-t) in your db directory. Furthermore, you should also pay > attention re. the init script for virtuoso (I used one from the > conStruct install definition, maybe it is originally from OpenLink ;) ). > In the procedures.sql script it is somewhere /opt/install/restart.sh (or > so). > Another question: is the restore-tmp.db the temporary datebase file, > which I should configure in virtuoso.ini, or would that dump transferred > into virtuoso.db? > > Cheers, > > zazi > > > Am 20.05.2010 04:07, schrieb Hugh Williams: >> HI Bob, >> >> Assuming you are running on a Unix OS, It would be easiest to create a >> virtuoso symlink to virtuoso-t and ensure its location is in your PATH >> environment variable setting such that the "virtuoso" executable can be >> located as expected and then not need to make any changes to the sql scripts >> or other. >> >> Please confirm the OS you are using, and we can try the same restore locally >> ... >> >> Best Regards >> Hugh Williams >> Professional Services >> OpenLink Software >> Web: http://www.openlinksw.com >> Support: http://support.openlinksw.com >> Forums: http://boards.openlinksw.com/support >> Twitter: http://twitter.com/OpenLink >> >> On 19 May 2010, at 23:14, Bob Ferris wrote: >> >>> Hi, >>> >>> I thought I got the code of ec2etxs, which produces the error - it is in >>> DAV/VAD/ec2exts/sql/procedures.sql of the WebDAV repository: >>> >>> _status := run_executable ('/bin/sh', 1, '-c', sprintf( >>> './virtuoso -r "%s" -B "%s" -c restore-tmp.ini>restore.log 2>&1', >>> _b_prefix, _b_dir)); >>> >>> I changed it to ./virtuoso-t, but restore.log still noticed "/bin/sh: >>> ./virtuoso: not found" >>> >>> I tried it serveral times with serveral server restarts. I think it did >>> not update my file, or? >>> >>> Cheers, >>> >>> zazi >>> >>> PS: I also changed the server restart to my local init script >>> >>> Am 19.05.2010 23:08, schrieb Bob Ferris: >>>> Hi, >>>> >>>> sadly I stepped into the next error message: >>>> >>>> ERROR Failed to reassemble the database. Please check the file >>>> restore.log in the database directory. (BUP07) >>>> >>>> restore.log: >>>> >>>> /bin/sh: ./virtuoso: not found. >>>> >>>> (I tried it serveral times: started from the init-script and locally) >>>> >>>> Cheers, >>>> >>>> zazi >>>> >>>> Am 19.05.2010 23:03, schrieb Kingsley Idehen: >>>>> Bob Ferris wrote: >>>>>> Hi, >>>>>> >>>>>> Am 19.05.2010 20:43, schrieb Bob Ferris: >>>>>>> Hi Kingsley, >>>>>>> >>>>>>> Am 19.05.2010 17:12, schrieb Kingsley Idehen: >>>>>>>> Bob Ferris wrote: >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> I tried to deploy the MusicBrainz backup, which is available for EC2 >>>>>>>>> AMI installation on my local vos-5.0.14/ vos-6.1.1 installation(s). On >>>>>>>>> both I got the following error after it fetched the backup-files (the >>>>>>>>> "continue" step): >>>>>>>>> >>>>>>>>> ERROR SR406: Running of file '/bin/sh' is not allowed in >>>>>>>>> run_executable(). (42000) >>>>>>>>> >>>>>>>>> Any chance to change this somewhere? >>>>>>>>> >>>>>>>>> Cheers, >>>>>>>>> >>>>>>>>> Bob >>>>>>>>> >>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Virtuoso-users mailing list >>>>>>>>> [email protected] >>>>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>>>>>>>> >>>>>>>> Check you INI for this line (edit accordingly if different): >>>>>>>> >>>>>>>> DbaExecutables = /bin/tar,/bin/sh >>>>>>>> >>>>>>>> >>>>>>>> That's how you control what can be executed at the OS level (e.g. the >>>>>>>> backup restore routine). >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> Did you mean the virtuoso.ini of my installation or the >>>>>>> musicbrainz-backup-descriptor.ini? I didn't found this parameter at both >>>>>>> files. I added this parameter continuously to both files, without any >>>>>>> success. At the virtuoso.ini I added it below [Database]. >>>>>>> >>>>>>> Cheers, >>>>>>> >>>>>>> zazi >>>>>>> >>>>>> >>>>>> I found the mistake, there wasn't the following parameter set: >>>>>> >>>>>> SafeExecutables = 0 >>>>> >>>>> Ah! >>>>> >>>>> OpenLink Staff: please note re. trouble shooting guide. This is a very >>>>> tricky one! >>>>> >>>>> Kingsley >>>>>> Cheers, >>>>>> >>>>>> zazi >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> 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
