Backup with diagnose fail

[Ivan Smahin]

On Dec 8, 2014, at 15:26, François Van Lerberghe <frvanlerberghe at gmail.com> wrote:

> Hello,
> 
> According to the doc, we can send a sqlexecute command to the server to backup the database.
> (http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:vcomponents:vsql:reference:backup)
> 
> This seems very useful as I can do a “hot” backup.
> 
> If my SQL command is
>     BACKUP DATABASE TO absolute_path
> all is working well.
> 
> If I send
>     BACKUP DATABASE TO absolute_path WITH DIAGNOSE
> nothing happen and I can see an error in the log file :
>     “ERROR 0x66503: Database "myDB.vdb" fails on diagnose”

There is no backup since diagnose failed.

> 
> 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.
> The permissions of the server folder is : Me:RW, Staff:RW, Everyone:R
> The permissions of the server app (vserver_x64) is : Me:RW, Staff:RW, Everyone:R
> The permissions of the database folder is : Me:RW, Staff:R, Everyone:R
> The permissions of the folder created by the server for the backup  is : System:RW, Staff:R, Everyone:R
> 
> 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 !
> Is it the attended behavior ? I’m I doing something wrong ?

Obviously you are running vServer as "system service" - it is not running on behalf  of any particular user.


-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20141208/0870c856/attachment.html>