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
