Issue Details (XML | Word | Printable)

Key: JDBC-635
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Agris Skuja
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Jaybird JDBC Driver

Can not connect to firebird DB using specific usernames

Created: 04/Dec/20 09:46 AM   Updated: 17/Jan/21 09:46 AM
Component/s: JDBC driver
Affects Version/s: Jaybird 3.0.9, Jaybird 4.0.1
Fix Version/s: Jaybird 3.0.10, Jaybird 4.0.2, Jaybird 5

Environment:
Firebird 3.0.7 (on Linux x64)
Openjdk 15
Issue Links:
Relate
 


 Description  « Hide
We are preparing to migrate from Firebird 2.5 to 3.0.
We encountered strange behaviour when connecting from Java using latest Jaybird 3 (also tried latest 4.x) to Firebird 3.
All test users can connect fine except two users. I installed fresh Firebird 3.0.7 on separate server and initialized new security DB and created those two specific users. Without any luck.
Connections from isql, PHP7, IBExpert work just fine. Connections fail only from Java.

Steps to reproduce:
1. connect to any Firebird 3 database using Srp/Srp256 authorisation.
2. Execute statement:
CREATE USER "DAVIDS" PASSWORD 'aaa123' ACTIVE;
3. Using Java(Jaybird) try to connect to this DB with user "DAVIDS" and password "aaa123"
4. Result:
java.sql.SQLInvalidAuthorizationSpecException: Your user name and password are not defined. Ask your database administrator to set up a Firebird login. [SQLState:28000, ISC error code:335544472]

Firebird 3.0.7 (on Linux x64)
Openjdk 15
Jaybird 4.0.1 and Jaybird 3.0.9


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel made changes - 04/Dec/20 04:33 PM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s Jaybird 3.0.10 [ 10932 ]
Fix Version/s Jaybird 4.0.2 [ 10950 ]
Fix Version/s Jaybird 5 [ 10871 ]
Resolution Fixed [ 1 ]
Jiri Cincura made changes - 04/Dec/20 06:47 PM
Link This issue relate to DNET-986 [ DNET-986 ]
Mark Rotteveel made changes - 17/Jan/21 09:46 AM
Status Resolved [ 5 ] Closed [ 6 ]