Re: [firebird-support] gbak of encrypted database

2018-04-30 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
Hello,

 gbak does not support encryption in the standard Firebird 3.0
distribution.

In IBSurgeon's plugin implementation there is a gbak support,  with
transparent encryption of backups with the same key.
https://ib-aid.com/en/firebird-encryption-plugin-framework/

And restored database from the encrypted backup is also encrypted,
otherwise it will be a security hole.

If you're implementing your own plugin,  you can implement whatever you
need.

Regards,
Alexey Kovyazin
IBSurgeon



вт, 1 мая 2018 г., 3:24 Hamish Moffatt ham...@risingsoftware.com
[firebird-support] :

>
>
> If a db is encrypted with Firebird 3 encryption, is a backup made with
> gbak also encrypted?
>
>
> https://www.firebirdsql.org/file/community/conference-2016/encrypting-firebird-databases.pdf
> implies you need to encrypt your backup afterwards so that means no.
>
> Will a restored db from that backup be encrypted automatically or would
> you have to run 'ALTER DATABASE ENCRYPT ...' on the new db afterwards if
> you want it encrypted also?
>
> thanks
>
> Hamish
>
> 
>


[firebird-support] isql 2.5 with server 3

2018-04-30 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
I have a linux server with a local Firebird 2.5.8 server and utilities 
and the Firebird 3.0.1 client library. I need to connect to a remote 
Firebird 3 server as well as the local 2.5 server.

isql can't connect to the 3 server. I always get

$ isql-fb fb3server:db -user 123 -password 456
Statement failed, SQLSTATE = 08004
connection rejected by remote interface
Use CONNECT or CREATE DATABASE to specify a database

Is this expected?


I can connect from Python (fdb) ok so the client library is definitely 
working.


Hamish



[firebird-support] gbak of encrypted database

2018-04-30 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
If a db is encrypted with Firebird 3 encryption, is a backup made with 
gbak also encrypted?

https://www.firebirdsql.org/file/community/conference-2016/encrypting-firebird-databases.pdf
 
implies you need to encrypt your backup afterwards so that means no.


Will a restored db from that backup be encrypted automatically or would 
you have to run 'ALTER DATABASE ENCRYPT ...' on the new db afterwards if 
you want it encrypted also?



thanks

Hamish