Subject Re: [firebird-support] gbak fails to backup
Author Helen Borrie
At 07:14 PM 17/08/2006, you wrote:
>linux, fb1.5.1 classic, login = fred
>I have 2 databases I want to backup
>this works:
>-rw-rw-rw- 1 fred fred 2473984 Aug 17 09:25 yyy.fdb
>gbak -v -user sysdba -pass masterkey -backup yyy.fdb /tmp/yyy.fbk
>this doesn't:
>-rwxr--r-- 1 firebird firebird 10092544 Aug 8 13:59 xxx.fdb
>gbak -v -user sysdba -pass masterkey -backup xxx.fdb /tmp/xxx.fbk
>gbak: ERROR: lock conflict on no wait transaction
>gbak: ERROR: no permission for read-write access to database xxx.fdb
>gbak: Exiting before completion due to errors
>gbak: ERROR: cannot open backup file /tmp/xxx.fbk
>gbak: Exiting before completion due to errors
>It's a file permission problem as changing the second case to -rw-rw-rw-
>allows it to work
>but I don't see why it should happen. I'm not accessing the file directly
>but via the firebird server,
>running as firebird, which does have full permission

No, you're not. A local connect to Classic is a direct connection to
the *file* and does not go via any "server", i.e. it doesn't go through xinetd.