FBCopy

[Paulo Geloramo]

FBCopy
http://fbexport.sourceforge.net/

I'm doing tests with FBCopy to copy:
Firebird 3.0 for Firebird 2.5
and
Firebird 2.5 for Firebird 3.0
But it is returning error -923 as below:
Any suggestion?

I tested the connection of the databases in IBExpert and it's ok.

It also worked to copy:
Firebird 2.5 for Firebird 2.5
and
Firebird 3.0 for Firebird 3.0
=====
FBCopy.bat
set isc_user=SYSDBA
set isc_password=masterkey
fbcopy S localhost/3025:DB25 localhost/3050:DB30
pause
=====
Connecting to: 'localhost/3025' as 'SYSDBA'...Connected.
Reading charset: WIN1252, disconnecting...ok.
Reconnecting with new charset...Connected.
Connecting to: 'localhost/3050' as 'SYSDBA'...ERROR!
*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed

SQL Message : -923
Connection not established

Engine Code : 335544421
Engine Message :
connection rejected by remote interface
=======================================
=======================================
FBCopy.bat
set isc_user=SYSDBA
set isc_password=masterkey
fbcopy S localhost/3050:DB30 localhost/3025:DB25
pause
=====
Connecting to: 'localhost/3050' as 'SYSDBA'...ERROR!
*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed

SQL Message : -923
Connection not established

Engine Code : 335544421
Engine Message :
connection rejected by remote interface
=====
--
Paulo Geloramo

[Mark Rotteveel]

On 2021-05-14 20:07, Paulo Geloramo wrote:
> FBCopy
> http://fbexport.sourceforge.net/
>
> I'm doing tests with FBCopy to copy:
> Firebird 3.0 for Firebird 2.5
> and
> Firebird 2.5 for Firebird 3.0
> But it is returning error -923 as below:

> Engine Code : 335544421
> Engine Message :
> connection rejected by remote interface

This probably means that you're using a Firebird 2.5 or earlier
fbclient.dll, or you only have a Legacy_Auth SYSDBA, and your Firebird
3.0 is configured with WireCrypt = Required (the server default). Relax
it to WireCrypt = Enabled in firebird.conf and restart Firebird.

Mark

[Paulo Geloramo]

Mark, thanks for the feedback.

=======
set isc_user=SYSDBA
set isc_password=masterkey
set path=%ProgramFiles(x86)%\Firebird\Firebird_3_0

fbcopy S localhost/3050:DB30 localhost/3025:DB25

=======
Firebird 2.5 install in Port 3025
Firebird 3.0 install in Port 3050
=======
firebird.conf
WireCrypt = Enabled
=======
ERROR:

Connecting to: 'localhost/3050' as 'SYSDBA'...ERROR!
*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed

Engine Code : 335545106
Engine Message :
unknown ISC error 335545106
======
--
Paulo Geloramo

Em sex., 14 de mai. de 2021 às 16:48, Mark Rotteveel
<ma...@lawinegevaar.nl> escreveu:

> --
> You received this message because you are subscribed to the Google Groups "firebird-support" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
> To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/fd0c4c5b1d839a88a1d5025fa8451c12%40lawinegevaar.nl.

[Mark Rotteveel]

On 14-05-2021 22:53, Paulo Geloramo wrote:
> Mark, thanks for the feedback.

> Engine Code : 335545106
> Engine Message :
> unknown ISC error 335545106

This is error "Error occurred during login, please check server
firebird.log for details".

If I have to guess, the log probably contains "No matching plugins on
server". This means that your AuthServer is set to Srp , set it to
Srp,Legacy_Auth .

Alternatively, make sure you have a Firebird 3 fbclient.dll installed
instead of a Firebird 2.5 or earlier, and that you have a SYSDBA created
by the Srp UserManager.

Mark
--
Mark Rotteveel

[Paulo Geloramo]

Mark, that was exactly it, it worked.
Thank you for your help.
It looked like this:
====
=============
FB25
firebird.conf
RemoteServicePort = 3025
-------------
FB30
firebird.conf
AuthServer = Srp, Legacy_Auth
WireCrypt = Enabled
RemoteServicePort = 3050
ServerMode = Super
=============
FBCopy.bat

set isc_user=SYSDBA
set isc_password=masterkey
set path=%ProgramFiles(x86)%\Firebird\Firebird_3_0
fbcopy S localhost/3050:DB30 localhost/3025:DB25

pause
============
--
Paulo Geloramo
Brazil

Em sáb., 15 de mai. de 2021 às 03:30, Mark Rotteveel
<ma...@lawinegevaar.nl> escreveu:

> --
> You received this message because you are subscribed to the Google Groups "firebird-support" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

> To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/2b3a1c73-7cfa-d139-a6b9-72f4a1c3c37b%40lawinegevaar.nl.