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

FbException.ErrorCode is always returning 335544721 when try to open a connection with an invalid username/password [DNET1007] #921

Closed
firebird-automations opened this issue Jan 13, 2021 · 13 comments

Comments

@firebird-automations
Copy link

Submitted by: @luronumen

Attachments:
Error.png

ACTUAL RESULT
FbException.ErrorCode is always returning 335544721 when try to open a connection with an invalid username/password:

335544721
Unable to complete network request to host
No message for error code 35544721 found

EXPECTED RESULT
FbException.ErrorCode should return 33554472 error code when try to open a connection with an invalid username/password:

33554472
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

STEPS TO REPRODUCE THIS ISSUE:
- Try to open a connection to a Firebird 3.0 database with an invalid username/password.

ENVIRONMENT SETUP
==========databases.conf==========
CHRONOS_CIN = D:\APPLICATIONS\LURONUMEN\DB\CHRONOS_CIN.FDB
{
AuthServer = Srp
SecurityDatabase = CHRONOS_CIN
UserManager = Srp
}
==========firebird.conf==========
#⁠SETUP
UserManager = Srp, Legacy_UserManager
WireCrypt = Enabled
#⁠PERFORMANCE
DefaultDbCachePages = 30K
FileSystemCacheThreshold = 2M
LockHashSlots = 30011
LockMemSize = 15M
TempBlockSize = 2M
TempCacheLimit = 3000M
#⁠SECURITY
DatabaseAccess = None

Commits: aa16eb3

@firebird-automations
Copy link
Author

Modified by: @luronumen

Attachment: Error.png [ 13531 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Error code 33554472 is not a valid Firebird error code, did you mean 335544472?

@firebird-automations
Copy link
Author

Commented by: @luronumen

Hi Mark,

Yes I meant 335544472!
Thanks for point this!

Best Regards,
Luciano

@firebird-automations
Copy link
Author

Commented by: @cincuranet

What's your connection string?

@firebird-automations
Copy link
Author

Commented by: @luronumen

Hi Jiri

this is the connection string:

"pooling=True;client library=D:\\APPLICATIONS\\LURONUMEN\\GIT\\SOLUTION\\CHRONOS\\DESKTOP\\bin\\Debug\\Plugins\\FBCLIENT\\FBCLIENT.DLL;server type=Default;data http://source=CINMOTO.MOT.COM;initial catalog=CHRONOS_CIN;character set=WIN1252;role name=RDB$ADMIN;user id=CINMOTO\\wlm070;password=6543215"

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

priority: Critical [ 2 ] => Major [ 3 ]

Fix Version: vNext [ 10982 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: In Progress [ 3 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 8.0.0.0 [ 10970 ]

Fix Version: vNext [ 10982 ] =>

@firebird-automations
Copy link
Author

Commented by: @luronumen

Retest result on version 8.0.0-alpha1: FAILED!

Hi Jiri,

Could you please confirm if this fix is available in this NuGet package: https://www.nuget.org/packages/FirebirdSql.Data.FirebirdClient/8.0.0-alpha1

Thanks in advance,
Luciano

@firebird-automations
Copy link
Author

Commented by: @cincuranet

No it's not in alpha1.

@firebird-automations
Copy link
Author

Commented by: @luronumen

Hi Jiri,
Now all makes sense. Please let me know when we have a new test version (alpha2?) so I can help you validate this fix.

Best regards,
Luciano

@firebird-automations
Copy link
Author

Commented by: @cincuranet

You can test the build with this commit from https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/actions/runs/530703170.

@firebird-automations
Copy link
Author

Commented by: @luronumen

Retest result on version 8.0.0-alpha3: PASSED!

Thank you very much for the fix Jiri!

Best Regards,
Luciano

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

No branches or pull requests

2 participants