[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

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,

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

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 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

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. gset or

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

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

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
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

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 await to see IO

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 -encryptplugin {-cryptpar parameter} {-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

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 encryption

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-encrypted database

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 see no problem if

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, and

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 firebi...@yandex.ru wrote: 2. gfix -encryptplugin {-cryptparparameter} 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.

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 kjell.ri...@datadia.se 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

[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

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 state,