Mark, thanks for the heads up .

Trying to use the service manager was a last/unknown resort as I never
used it .

The problem was (I guess) using a network connection. Using a local one
just did it.

root@camaleeon:/opt/firebird/bin# ./gbak -user SYSDBA -password
'mypassword' -c -v mybackup-file.fbk mydb

It was a hard ride to digest the Migration Guide in two days.

Thank you.

Pablo


On 8/24/18 4:05 AM, Mark Rotteveel mark@...
[firebird-support] wrote:

> On 24-8-2018 03:14, pablos@... [firebird-support] wrote:
>>
>>
>> Hi .
>> I'm migrating from v2.5.8 to v 3.0.3.2900 . From LI-V2.5.8.27089
>> Firebird 2.5 to LI-V3.0.3.32900 Firebird 3.0 (debian stretch (9) ).
>>
>> As for "application level and services" I have no issues so far.
>>
>> What is worrying me is restore a db with local users, as I cannot do it
>> even with server SYSDBA user. I backup with no issues, but I haven't
>> figure how to restore the db.
>>
>>
>> root@camaleeon:/opt/firebird/bin# ./gbak -user SYSDBA -password
>> 'mypassword' -c -v -se service_mgr  mybackup-file.fbk  myhost:mydb
>> gbak:opened file mybackup.fbk
>> gbak:transportable backup -- data in XDR format
>> gbak:        backup file is compressed
>> gbak:backup version is 10
>> gbak: ERROR:unavailable database
>> gbak: ERROR:    failed to create database myhost:mydb
>> gbak: ERROR:    Exiting before completion due to errors
>> gbak:Exiting before completion due to errors
>>
>> I also create that database with same name and those local users .
>
> I you are restoring using the service manager, then you should use
>
> ../gbak -user SYSDBA -password 'mypassword' -c -v -se myhost:service_mgr
> mybackup-file.fbk mydb
>
> That is, the hostname should be part of the -se switch value, not part
> of the database path.
>
> Mark
>