On 2019-05-15 17:56, sbailey@... [Firebird-Java]
wrote:

> I am trying to use Jaybird 4 for connecting to a Firebird 4 Beta 1
> database through DBSchema [1].
>
> I cannot get it to work and reported the issue to DBSchema support.
> After trying a few of their suggestions, they suspect a problem with
> Jaybird and recommended that I come to this group to report the issue.
>
> Attempts to connect always produce this error:
>
> Connectivity Error
>
> Error occured during login, please check server firebird.log for
> details
> Error occured during login, please check server firebird.log for
> details [SQLState:080006, ISC error code:335545106]
>
> java.sql.SQLException: Error occurred during login, please check
> server firebird.log for details [SQLState:08006, ISC error
> code:335545106]

> and firebird.log says this:
>
> STEVE-PREC Wed May 15 06:56:51 2019
> Authentication error
> No matching plugins on server
>
> Any suggestions for fixing this will be gratefully received.

The error suggests that you have configured Firebird 4 to only enable
Legacy_Auth (setting AuthServer in firebird.conf). Jaybird 4 by default
only tries Srp256 and Srp authentication and no only tries Legacy_Auth
if explicitly configured, as described in the release notes.

You either need to reconfigure Firebird to use Srp256 (and make sure the
create your users using the Srp plugin), or you need to explicitly
specify connection property authPlugins=Legacy_Auth to instruct Jaybird
to try Legacy_Auth to connect.

See also:

* Jaybird 4 release notes:

** "What's new in Jaybird 4" > "Authentication plugin improvements" >
"Default authentication plugins" at
https://www.firebirdsql.org/file/documentation/drivers_documentation/java/4.0.0-beta-1/release_notes.html#default-authentication-plugins

** and "Compatibility changes" > "Removed Legacy_Auth from default
authentication plugins" at
https://www.firebirdsql.org/file/documentation/drivers_documentation/java/4.0.0-beta-1/release_notes.html#removed-legacy_auth-from-default-authentication-plugins

* FAQ entry "Connecting to Firebird" > "Common connection errors" >
"Error occurred during login, please check server firebird.log for
details (335545106)" at
https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html#error-occurred-during-login-please-check-server-firebird.log-for-details-335545106

I'll see if I need to further refine the text of the Compatibility
Changes in the release notes to explicitly call out this error.

Mark