On 27-4-2018 04:16, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > I have a linux server with a local Firebird 2.5.8 server and utilities > and the Firebird 3.0.1 client library. I need to connect to a remote > Firebird 3 server as well as the local 2.5 server. > > isql can't connect to the 3 server. I always get > > $ isql-fb fb3server:db -user 123 -password 456 > Statement failed, SQLSTATE = 08004 > connection rejected by remote interface > Use CONNECT or CREATE DATABASE to specify a database > > Is this expected?
ISQL of Firebird 2.5 uses the fbclient of Firebird 2.5, and for a fbclient of Firebird 2.5 to connect to Firebird 3, you need at least four things: - Add Legacy_Auth to the AuthServer setting - Add Legacy_UserManager to the UserManager setting - Create a user account with the legacy user manager. - Set WireCrypt to Enabled (default is Required) If you don't change these settings then a fbclient 2.5 cannot connect because the legacy authentication is not supported, you don't have a legacy authentication user to authenticate, and you can't establish a connection because wire protocol encryption is required (but not supported by the client). See also https://github.com/FirebirdSQL/jaybird/wiki/Jaybird-and-Firebird-3#jaybird-22-and-earlier (these settings will also work for a fbclient 2.5) -- Mark Rotteveel
