Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Dimitry Sibiryakov
26.04.2018 15:14, Mark Rotteveel wrote: I repeat that I find that odd. So do I. But that's the way it works in Firebird. Before 3.0.2 it worked in a little different way and key holder could delay calling of application's callback until it is really needed. Now it is impossible. --

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 15:05, Dimitry Sibiryakov wrote: 26.04.2018 15:01, Mark Rotteveel wrote: Do you mean to say that the database encryption plugin doesn't know about the keyname used for encryption? That seems rather odd.   At the point when encryption plugin knows database key, no application

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 14:56, Dimitry Sibiryakov wrote: 26.04.2018 14:52, Mark Rotteveel wrote: I'm not sure if that may also lead to problems for database encryption plugins that need database-specific information to correctly perform the callback (eg the keyname used?).   It is impossible in any

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Dimitry Sibiryakov
26.04.2018 14:52, Mark Rotteveel wrote: I'm not sure if that may also lead to problems for database encryption plugins that need database-specific information to correctly perform the callback (eg the keyname used?). It is impossible in any case. No encryption plugin that use database info

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 14:28, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 15:23, Mark Rotteveel wrote: I don't receive a callback from Firebird for service operations involving an encrypted database, so I can't respond to it. That's very strange. Is protocol version correct? You should

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 14:28, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 15:23, Mark Rotteveel wrote: I don't receive a callback from Firebird for service operations involving an encrypted database, so I can't respond to it. That's very strange. Is protocol version correct? You should

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 15:09, Mark Rotteveel wrote: On 26-4-2018 13:45, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 14:11, Mark Rotteveel wrote: On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 14:16, Dimitry Sibiryakov wrote: 26.04.2018 14:09, Mark Rotteveel wrote: Encryption keys can be (or IMO should be) database specific, so the callback will need to have database-specific information.   Let me explain: the callback is set by an application. The application must

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Dimitry Sibiryakov
26.04.2018 14:09, Mark Rotteveel wrote: Encryption keys can be (or IMO should be) database specific, so the callback will need to have database-specific information. Let me explain: the callback is set by an application. The application must know exactly which database it will work with and

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 13:45, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 14:11, Mark Rotteveel wrote: On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services connections. _UTILITY_ gstat supports only -h and -e

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 14:11, Mark Rotteveel wrote: On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services connections. _UTILITY_ gstat supports only -h and -e switches. It is not related with protocol but has some

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 12:28, Alex Peshkoff via Firebird-devel wrote: You understood me wrong - database encryption callback is supported in services connections. _UTILITY_ gstat supports only -h and -e switches. It is not related with protocol but has some relation with services manager - this utility

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 11:34, Mark Rotteveel wrote: On 26-4-2018 10:11, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 10:31, Mark Rotteveel wrote: On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2 gstat

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 26-4-2018 10:11, Alex Peshkoff via Firebird-devel wrote: On 04/26/18 10:31, Mark Rotteveel wrote: On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2 gstat functions that will currently work with encrypted

[Firebird-devel] Transactional DDL (who can)

2018-04-26 Thread Dev
https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis 1. We can too (but there are errors: http://tracker.firebirdsql.org/browse/CORE-5763) 2. There ara Firebird in list, but without link to documentation. 3. We can't mix ddl and dml like this (PostgreSql can):

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Alex Peshkoff via Firebird-devel
On 04/26/18 10:31, Mark Rotteveel wrote: On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2 gstat functions that will currently work with encrypted database are print header (-h) and print crypt statistics

Re: [Firebird-devel] Handling of database encryption callback for service operations

2018-04-26 Thread Mark Rotteveel
On 24-4-2018 12:03, Alex Peshkoff via Firebird-devel wrote: Mark sorry but looks like I've already answered this many times - the only 2 gstat functions that will currently work with encrypted database are print header (-h) and print crypt statistics (-e). It was the first time I asked, and I