Subject Re: [firebird-support] isql 2.5 with server 3
Author Mark Rotteveel
On 27-4-2018 04:16, Hamish Moffatt hamish@...
[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
(these settings will also work for a fbclient 2.5)
Mark Rotteveel