You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The pure-java implementation cannot connect to Firebird 3.0.0.29934 with LegacyAuth option enabled, the native protocol is able to connect.
It looks like Jaybird uses an authentication protocol that is too outdated for LegacyAuth (it sends the password in the clear, while the native library sends a hashed password). If possible we should fix this for Jaybird 2.2, so people can start trying out FB 3 from Java without resorting to the native implementation.
Exception thrown when connection:
Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544472. Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:123)
at org.firebirdsql.jdbc.AbstractDriver.connect(AbstractDriver.java:130)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jdbc94.TestJDBC94.main(TestJDBC94.java:13)
Caused by: org.firebirdsql.gds.GDSException: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2215)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2165)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.internalAttachDatabase(AbstractJavaGDSImpl.java:453)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(AbstractJavaGDSImpl.java:406)
at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:91)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:482)
at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:69)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:120)
The text was updated successfully, but these errors were encountered:
Alex will fix this in Firebird 3 so the unencrypted password is allowed again for LegacyAuth. I looked at the algorithm used for the legacy encrypted password, but that is very hard to translate to a working Java version (which is probably why it wasn't done before).
As there is a workaround: use native this will not be fixed. I will keep this ticket open for the time being to check it at a later time.
Submitted by: @mrotteveel
The pure-java implementation cannot connect to Firebird 3.0.0.29934 with LegacyAuth option enabled, the native protocol is able to connect.
It looks like Jaybird uses an authentication protocol that is too outdated for LegacyAuth (it sends the password in the clear, while the native library sends a hashed password). If possible we should fix this for Jaybird 2.2, so people can start trying out FB 3 from Java without resorting to the native implementation.
Exception thrown when connection:
Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544472. Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:123)
at org.firebirdsql.jdbc.AbstractDriver.connect(AbstractDriver.java:130)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jdbc94.TestJDBC94.main(TestJDBC94.java:13)
Caused by: org.firebirdsql.gds.GDSException: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2215)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2165)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.internalAttachDatabase(AbstractJavaGDSImpl.java:453)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(AbstractJavaGDSImpl.java:406)
at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:91)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:482)
at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:69)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:120)
The text was updated successfully, but these errors were encountered: