Subject Re: [Firebird-Java] Re: Denied connections due to character set
Author William L. Thomson Jr.
On Wednesday, February 22, 2017 4:50:35 AM EST you wrote:
> On 2017-02-20 23:47, 'William L. Thomson Jr.' wlt-ml@...
>
> [Firebird-Java] wrote:
> > Something still seems off here. Jaybird 3 will only work with
> > Legacy_Auth if
> > Srp is not specified at all. This means one has no migration path of
> > having
> > both enabled. This is not really ideal.
>
> Again: you need to initialize the security database, then Legacy_Auth
> will also work when Srp is in the list.

I have since switched to Srp entirely. I see you can use Legacy with the new
security database. I was already using a security3.fdb, but seems it was using
old tables. That still worked fine with Flamerobin as it did when I switched to
Srp.

> > In comparison, Flamerobin, can connect via Legacy Auth no matter the
> > order,
> > Legacy_Auth,Srp or Srp,Legacy_Auth both work for Legacy. If Flamerobin
> > can use
> > either, seems Jaybird should as well.
>
> I have tested that earlier, and it is not true. If you have a Firebird 3
> fbclient.dll (and the default configuration for setting AuthClient),
> then Flamerobin will show the exact same error message as Jaybird does.

I cannot get Flamerobine to replicate the connection issues. I tested a few
times. I changed the order put Srp,Legacy, then Legacy, Srp, or just Legacy,
all worked fine for Flamerobin. Once I switched over to Srp, and disabled
legacy entirely. Flamerobin continued to work.

> You are either still connecting with a Firebird 2.5 or earlier
> fbclient.dll (which doesn't support Firebird version 13 protocol nor
> SRP), or the firebird.conf used by the Firebird 3 fbclient.dll (note
> that this is not necessarily the same firebird.conf as in the Firebird
> server install location!) has AuthClient=Legacy_Auth,Srp instead of the
> default of AuthClient=Srp,Legacy_Auth.

I am on Gentoo so libfbclient.so. I packaged both Firebird and Flamerobin on
Gentoo. I know what I have installed. I have not had Firebird 2.5 on my laptop
or desktop for over a year. There is NO chance Flamerobin was using an older
version. The packages are not slotted, one will flat out remove the other.

I never changed any settings on my desktop or laptop. I simply changed
settings on the server. At no time did Flamerobin have issues connecting to
Firebird 3. Either via Legacy or Srp, no matter the order or which was in use,
new security database or legacy tables.

--
William L. Thomson Jr.