Hi,
I also tried this, but after the restore I'm getting "Error 42000 DA010:
Can't store the file '/DAV/VAD/conductor/main_tabs.vspx-m': DAV error
-29" when I try to access the conductor.
Cheers,
Mats
On Wed, Jun 2, 2010 at 2:51 AM, Hugh Williams <[email protected]
<mailto:[email protected]>> wrote:
Hi Bob,
Yes, you can just copy the restore-tmp.db to virtuoso.db, this being
what the restart.sh script with the AMIs do, and I should have
included in my mini instructions in the previous email:
# more restart.sh
#!/bin/sh
# This script is invoked from Virtuoso PL to restart the server
# during a database restore operation
[ ! -f restore-tmp.db ] && {
echo "There is no new database to restart with"
exit 1
}
# Is there a previous database? If so, move it away
[ -f virtuoso.db ] && {
# Make sure the server is not running
[ -f virtuoso.lck ] && {
while [ -f virtuoso.lck ]; do
echo "Waiting for the server to complete shut down..."
sleep 1
done
sleep 2
}
# Make sure the transaction log is truncated - PL takes care of this
[ -s virtuoso.trx ] && {
echo "The database has not been checkpointed before shutdown"
exit 1
}
# Rename the old database
mv virtuoso.db virtuoso.db~ || exit 1
}
# Database (if any) has been checkpointed, so this should always be safe
#rm -f virtuoso.log virtuoso.pxa virtuoso.tdb virtuoso.trx
rm -f virtuoso.pxa virtuoso.tdb virtuoso.trx
# Move the database in place
mv restore-tmp.db virtuoso.db || {
echo "Failed to rename restore-tmp.db to virtuoso.db"
exit 1
}
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 1 Jun 2010, at 16:21, Bob Ferris wrote:
> Hi Hugh,
>
> thanks a lot for that summarized instruction again. Now I end up
with a
> restore-tmp.db of the amount of 59,9 GB, but how to merge the
> restore-tmp.db with my existing virtuoso.db?
> Or should I just set restore-tmp.db as default db in my virtuoso.ini?
>
> Cheers,
>
>
> Bob
>
> PS: I patched also /opt/virtuoso/install/restart.sh with a
symlink to my
> local init script. It works so far.
>
> Am 20.05.2010 13:47, schrieb Hugh Williams:
>> 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]
<mailto:[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
>>>>>
