Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> On 04/04/2012 11:12, Vlad Khorsun wrote: >> Do you have better idea ? > > Yes, I do! > > If encryption detects (at start or after it) that database is in backup > mode, it stops its activity and the next-page-to-encrypt will not advance. > > At merge time, if database is in encrypting st

[Firebird-devel] [FB-Tracker] Created: (CORE-3808) Provide ability to return all columns using RETURNING (eg RETURNING *)

2012-04-04 Thread Mark Rotteveel (JIRA)
Provide ability to return all columns using RETURNING (eg RETURNING *) -- Key: CORE-3808 URL: http://tracker.firebirdsql.org/browse/CORE-3808 Project: Firebird Core Issue Ty

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Ann Harrison
On Wed, Apr 4, 2012 at 8:26 AM, Kjell Rilbe wrote: > > OK, but that doesn't change what its current name seems to imply. > > And it is the tool we have that fixes databases - with the mend option. Not that I'd use it if I had a choice like IBSurgeon, but ... Ann

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Ann Harrison
On Wed, Apr 4, 2012 at 6:42 AM, Dmitry Yemanov wrote: > > > 2. gfix -encrypt {-cryptpar} database > > gfix passes plugin name and parameter in DPB, the rest of activity are > > like in database validation. This implementation looks like most simple > > to implement. > > No DPB hackery, please. G

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Dimitry Sibiryakov
04.04.2012 16:38, Adriano dos Santos Fernandes wrote: > If encryption detects (at start or after it) that database is in backup > mode, it stops its activity and the next-page-to-encrypt will not advance. > > At merge time, if database is in encrypting state, delta may be merged > and encrypted, an

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Adriano dos Santos Fernandes
On 04/04/2012 11:12, Vlad Khorsun wrote: > Do you have better idea ? Yes, I do! If encryption detects (at start or after it) that database is in backup mode, it stops its activity and the next-page-to-encrypt will not advance. At merge time, if database is in encrypting state, delta may be

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> On 04/04/2012 10:32, Vlad Khorsun wrote: >>> On 04/04/2012 10:14, Vlad Khorsun wrote: > Getting half-crypted DB copy is something too exotic :-) Physical backup is "physical backup", i.e. page-level copy of a database. It have nothing common with encryption state, and i

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Adriano dos Santos Fernandes
On 04/04/2012 10:32, Vlad Khorsun wrote: >> On 04/04/2012 10:14, Vlad Khorsun wrote: Getting half-crypted DB copy is something too exotic :-) >>> Physical backup is "physical backup", i.e. page-level copy of a >>> database. It have >>> nothing common with encryption state, and i see no

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> On 04/04/2012 10:14, Vlad Khorsun wrote: >>> Getting half-crypted DB copy is something too exotic :-) >> >> Physical backup is "physical backup", i.e. page-level copy of a >> database. It have >> nothing common with encryption state, and i see no problem if physical >> backup of >> half-e

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Adriano dos Santos Fernandes
On 04/04/2012 10:14, Vlad Khorsun wrote: >> Getting half-crypted DB copy is something too exotic :-) > Physical backup is "physical backup", i.e. page-level copy of a > database. It have > nothing common with encryption state, and i see no problem if physical backup > of > half-encrypted dat

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> I suppose that simultaneous encryption (changing encryption state of DB) > and nbackup will not be possible. Why ? > Getting half-crypted DB copy is something too exotic :-) Physical backup is "physical backup", i.e. page-level copy of a database. It have nothing common with encrypti

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Alex Peshkoff
On 04/04/12 17:26, Claudio Valderrama C. wrote: >>> 3. Use of special utility: fbdbcrypt -encrypt {-cryptpar >>> } {-verbose} local-database >>> Certainly, appropriate support in services will be present. >>> This method looks ugly at first, but it has one great advantage - >>> ability to have s

Re: [Firebird-devel] tool for encryptingdatabaseinitially(andprobably decrypting it)

2012-04-04 Thread Alex Peshkoff
On 04/04/12 15:18, Claudio Valderrama C. wrote: >> -Original Message- >> From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] >> Sent: Martes, 03 de Abril de 2012 6:36 >> >> Of course ! "single-user" operations is BAD in >> *multy-user* software, let not >> create one more... > I

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Kjell Rilbe
Kjell Rilbe skriver: Dmitry Yemanov skriver: Also possible as a secondary option, let's just decide what's better - keep polluting GFIX with new features or create new command-line tools for the every new feature (or a set of features). From a user perspective, "gfix" sounds like a tool to f

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Dmitry Yemanov
Claudio Valderrama C. wrote: > Would it call the INF functions to get that information? I ask because > obviously gfix cannot work like gstat in local mode, IE we don't expect it > to be able to read the page header directly. Yes, isc_database_info() could be a solution here (if we really need a

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Kjell Rilbe
Claudio Valderrama C. skriver: -Original Message- From: Kjell Rilbe [mailto:kjell.ri...@datadia.se] Sent: Miércoles, 04 de Abril de 2012 6:56 From a user perspective, "gfix" sounds like a tool to fix problems with the database, so I'd vote to either change the name to something more ge

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Miércoles, 04 de Abril de 2012 6:42 > To: For discussion among Firebird Developers > > No DPB hackery, please. GFIX could finally start doing > something itself. > For example, run ALTER DATABASE ENCRYPT as

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Claudio Valderrama C.
> -Original Message- > From: Kjell Rilbe [mailto:kjell.ri...@datadia.se] > Sent: Miércoles, 04 de Abril de 2012 6:56 > > From a user perspective, "gfix" sounds like a tool to fix > problems with > the database, so I'd vote to either change the name to something more > generic, e.g. "g

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Kjell Rilbe
Dmitry Yemanov skriver: Also possible as a secondary option, let's just decide what's better - keep polluting GFIX with new features or create new command-line tools for the every new feature (or a set of features). From a user perspective, "gfix" sounds like a tool to fix problems with the da

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Dimitry Sibiryakov
04.04.2012 12:42, Dmitry Yemanov wrote: > let's just decide what's better - > keep polluting GFIX with new features or create new command-line tools > for the every new feature (or a set of features). If the feature is available via Services API, fbsvcmgr already exists. -- SY, SD. --

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Dmitry Yemanov
03.04.2012 11:55, Alex Peshkoff wrote: > To work with encrypted database file we need a tool to encrypt database. > I see 3 possible solutions for it. In all 3 cases some plugin dependent > parameter may be passed to plugin. In all cases one may use decrypt > instead encrypt to make > > 1. ALTER D

Re: [Firebird-devel] tool for encryptingdatabaseinitially(andprobably decrypting it)

2012-04-04 Thread Claudio Valderrama C.
> -Original Message- > From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] > Sent: Martes, 03 de Abril de 2012 6:36 > > Of course ! "single-user" operations is BAD in > *multy-user* software, let not > create one more... I await to see IO numbers with gfix, gbak, gstat, nbackup

[Firebird-devel] [FB-Tracker] Created: (CORE-3807) Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connect

2012-04-04 Thread Dmitry Yemanov (JIRA)
Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connection -