Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Client gets SQLSTATE = 28000 ("user/password not defined") if WireCrypt = Disabled is used on client side. Rather error SQLSTATE = 08006 ("Error occurred... check server firebird.log") should be raised [CORE5822] #6083

Closed
firebird-automations opened this issue May 9, 2018 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

If firebird.conf on client side contains WireCrypt = Disabled and there is some problem with security DB for database being attached then client will get

Statement failed, SQLSTATE = 28000
Your user name and password are not defined\.

===
-- regardless of AuthClient value on server (and client also).

Record with details of failure will be added into firebird.log only if WireCrypt != Disabled (i.e. is commented or assigned to 'Enabled').

PS.
Separate ticket was created after discuss with Alex (privately) about details of CORE4964.

Commits: 9686b3a 7de1b2a FirebirdSQL/fbt-repository@eb02c73

====== Test Details ======

See test for CORE4964: there is code that temp-ly changes content of firebird.conf by adding there WireCrypt =Disabled.
When client makes attach then this new (changed) firerbid.conf will be used and we can check firebird.log for the same messages as should appear in CORE4964.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Fix Version: 3.0.4 [ 10863 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Covered by another test(s)

Test Details: See test for CORE4964: there is code that temp-ly changes content of firebird.conf by adding there WireCrypt =Disabled.
When client makes attach then this new (changed) firerbid.conf will be used and we can check firebird.log for the same messages as should appear in CORE4964.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment