Thursday, October 13, 2016, 8:38:32 AM, Lester Caine wrote:
> OK I've put a new machine together using the latest builds via SUSE
> which has given me Nginx, PHP7 and Firebird3. Firebird is working
> locally and after a couple of problems Nginx and PHP7 are talking since
> they package manager did not complete the configuration.
> Now I need to configure FB3 so that it can be accessed from the other
> machines on the network which are still running 2.1 and 2.5 and will be
> for some time to come. I've done the 'Legacy Authentication' settings,
> but I'm still not able to log in from FlameRobin on another machine.
> It's a little confusing since SYSDBA existed and I've reset the password
> to one of my normal ones (suse is using isql-fb to avoid clash with
> mysql) but I'm getting to the point where I need something working and
> the 'improvements' in FB3 seem to be fighting against that. :( I've gone
> through the same setup on a machine which has a desktop, but flamerobin
> dies on that machine so I'm no further forward ...
What you might have missed:
1. Did you install the passwords (including SYSDBA) with the clause
USING PLUGIN Legacy_UserManager ? If not, your CREATE | ALTER
USER statements install them by default as SRP users and the
legacy logins won't work. You can check by querying SEC$USERS.
2. Did you configure the UserManager parameter? By default it is
Srp. If you want Legacy_Auth to be available, you need to configure it
3. Did you modify the WireCrypt parameter from Required to Enabled
(or Disabled)? You need to do that for legacy clients because only
the Fb3 client knows about wire encryption.
Remember that legacy passwords won't be checked beyond 8 characters.