<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><br><div><div>On Dec 8, 2014, at 15:26, François Van Lerberghe <<a href="mailto:frvanlerberghe@gmail.com">frvanlerberghe@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<title>Backup with diagnose fail</title>
<div>
<font face="Verdana"><span style="font-size:12.0px">Hello,<br>
<br>
According to the doc, we can send a sqlexecute command to the server to backup the database.<br>
(<a href="http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:vcomponents:vsql:reference:backup)">http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:vcomponents:vsql:reference:backup)</a><br>
<br>
This seems very useful as I can do a “hot” backup.<br>
<br>
If my SQL command is<br>
BACKUP DATABASE TO absolute_path<br>
all is working well.<br>
<br>
If I send<br>
BACKUP DATABASE TO absolute_path WITH DIAGNOSE<br>
nothing happen and I can see an error in the log file :<br>
“ERROR 0x66503: Database "myDB.vdb" fails on diagnose”<br></span></font></div></blockquote><div><br></div>There is no backup since diagnose failed.</div><div><br><blockquote type="cite"><div><font face="Verdana"><span style="font-size:12.0px">
<br>
I’m working with V4RB v5.6 on MacOS X 10.6.8. The client and server are on the same machine, the server folder is in my Document folder and I do the backup in the Desktop folder.<br>
The permissions of the server folder is : Me:RW, Staff:RW, Everyone:R<br>
The permissions of the server app (vserver_x64) is : Me:RW, Staff:RW, Everyone:R<br>
The permissions of the database folder is : Me:RW, Staff:R, Everyone:R<br>
The permissions of the folder created by the server for the backup is : System:RW, Staff:R, Everyone:R<br>
<br>
And this raise a second question : I can see that the owner of the created backup folder is “System”, despite the fact that the owner of the server app is Me and that the owner of the parent folder (Desktop) is Me. Thus my client app cannot rename, move or delete this folder without admin right !<br>
Is it the attended behavior ? I’m I doing something wrong ?<br>
</span></font></div></blockquote><div><br></div>Obviously you are running vServer as "system service" - it is not running on behalf of any particular user.</div><div><br></div><div apple-content-edited="true"><br></div><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div>-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div></span>
</div>
<br></body></html>