Re: [Firebird-devel] Firebird 4 and ODS 12

[Alex Peshkoff via Firebird-devel]

On 31.05.2019 12:09, Emil Totev wrote:


On Fri, 31 May 2019 at 11:49, 
> wrote:


On 30.05.2019 18:09, Emil Totev wrote:
> I wonder would it be possible to make Firebird 4 work with ODS 12
> (Firebird 3) databases?
>
> Before Firebird 3 it was relatively easy to upgrade your Firebird
> server - your databases could stay in the old ODS and be
upgraded one
> by one, and it was easier to go back in case of incompatibilities.
> But when you upgrade the server to Firebird 3, you have to
upgrade all
> its databases to the new ODS at the same time, and it is much
harder
> to go back. I believe this holds the upgrade to Firebird 3 for
many of
> us.
>
> Now with Firebird 4 the situation seems the same. I was hoping
the new
> plugin architecture could help with this, so I copied an
engine12.dll
> to the plugins directory of Firebird 4 beta, and added two lines in
> the respective databases.conf entry for the ODS 12 database:
> ? ? ?Providers = Engine12
> ? ? ?SecurityDatabase = $(dir_secDb)/security4.fdb
> This made it possible to connect to the database, but every
attempt to
> execute a statement ended up with 'Interface IStatement version too
> old: expected 4, found 3'.
>
> Would it be very difficult to provide version 4 compatible
engine12.dll?

Yes, we will ensure that engine12 works with FB4. That's great
that you
have made this test, please register appropriate bug in the tracker.


Are you planning to provide the compatible engine12.dll as part of 
Firebird 4, or in the next point release of Firebird 3?


In the point release or snapshot build.



I had to add the second line with Security Database, because I got 
'Missing security context' without it. I don't think this should be 
necessary.


Yes, one more bug.

And I think it should be possible to use security3.fdb as well, with 
the proper provider in the definition.




Also to be fixed.




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 and ODS 12

[Emil Totev]

On Fri, 31 May 2019 at 11:49, 
wrote:

> On 30.05.2019 18:09, Emil Totev wrote:
> > I wonder would it be possible to make Firebird 4 work with ODS 12
> > (Firebird 3) databases?
> >
> > Before Firebird 3 it was relatively easy to upgrade your Firebird
> > server - your databases could stay in the old ODS and be upgraded one
> > by one, and it was easier to go back in case of incompatibilities.
> > But when you upgrade the server to Firebird 3, you have to upgrade all
> > its databases to the new ODS at the same time, and it is much harder
> > to go back. I believe this holds the upgrade to Firebird 3 for many of
> > us.
> >
> > Now with Firebird 4 the situation seems the same. I was hoping the new
> > plugin architecture could help with this, so I copied an engine12.dll
> > to the plugins directory of Firebird 4 beta, and added two lines in
> > the respective databases.conf entry for the ODS 12 database:
> > ? ? ?Providers = Engine12
> > ? ? ?SecurityDatabase = $(dir_secDb)/security4.fdb
> > This made it possible to connect to the database, but every attempt to
> > execute a statement ended up with 'Interface IStatement version too
> > old: expected 4, found 3'.
> >
> > Would it be very difficult to provide version 4 compatible engine12.dll?
>
> Yes, we will ensure that engine12 works with FB4. That's great that you
> have made this test, please register appropriate bug in the tracker.
>
>
Are you planning to provide the compatible engine12.dll as part of Firebird
4, or in the next point release of Firebird 3?

I had to add the second line with Security Database, because I got 'Missing
security context' without it. I don't think this should be necessary. And I
think it should be possible to use security3.fdb as well, with the proper
provider in the definition.

Regards
Emil
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 and ODS 12

[Alex Peshkoff via Firebird-devel]

On 30.05.2019 20:38, Dimitry Sibiryakov wrote:

30.05.2019 18:01, Alex Peshkoff via Firebird-devel wrote:
Not necessary. Provider is changed in databases.conf for particular 
database.


  Yes, but auth module has usage of current version of provider 
hardcoded.




In a case of FB4 server it will be Engine13 because auth module in use 
is from FB4, not FB3. For SRP it's moreover inside firebird.exe.


But you are right in general - other places should be checked, like 
mapping, users management and other related things.


A.



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 and ODS 12

[Dimitry Sibiryakov]

30.05.2019 18:01, Alex Peshkoff via Firebird-devel wrote:

Not necessary. Provider is changed in databases.conf for particular database.


  Yes, but auth module has usage of current version of provider hardcoded.


--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 and ODS 12

[Alex Peshkoff via Firebird-devel]

On 30.05.2019 18:47, Dimitry Sibiryakov wrote:

30.05.2019 17:09, Emil Totev wrote:

      SecurityDatabase = $(dir_secDb)/security4.fdb


  You must use security3.fdb with ODS 12 in this case.




Not necessary. Provider is changed in databases.conf for particular 
database. Security database should be available when working with ODS13, 
and taking into an account that problems take place in IStatement it is 
available. What I do not understand is why this line needed at all.






Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 and ODS 12

[Dimitry Sibiryakov]

30.05.2019 17:09, Emil Totev wrote:

      SecurityDatabase = $(dir_secDb)/security4.fdb


  You must use security3.fdb with ODS 12 in this case.


--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 and ODS 12

[Alex Peshkoff via Firebird-devel]

On 30.05.2019 18:09, Emil Totev wrote:
I wonder would it be possible to make Firebird 4 work with ODS 12 
(Firebird 3) databases?


Before Firebird 3 it was relatively easy to upgrade your Firebird 
server - your databases could stay in the old ODS and be upgraded one 
by one, and it was easier to go back in case of incompatibilities.
But when you upgrade the server to Firebird 3, you have to upgrade all 
its databases to the new ODS at the same time, and it is much harder 
to go back. I believe this holds the upgrade to Firebird 3 for many of 
us.


Now with Firebird 4 the situation seems the same. I was hoping the new 
plugin architecture could help with this, so I copied an engine12.dll 
to the plugins directory of Firebird 4 beta, and added two lines in 
the respective databases.conf entry for the ODS 12 database:

     Providers = Engine12
     SecurityDatabase = $(dir_secDb)/security4.fdb
This made it possible to connect to the database, but every attempt to 
execute a statement ended up with 'Interface IStatement version too 
old: expected 4, found 3'.


Would it be very difficult to provide version 4 compatible engine12.dll?


Yes, we will ensure that engine12 works with FB4. That's great that you 
have made this test, please register appropriate bug in the tracker.





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel