search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
159 stars 65 forks source link

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

Closed firebird-automations closed 3 years ago

firebird-automations commented 3 years ago

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: FirebirdSQL/NETProvider@aa16eb3eb18bb420f172986fae9837242ed71218

firebird-automations commented 3 years ago
Modified by: @luronumen Attachment: Error\.png \[ 13531 \]
firebird-automations commented 3 years ago

Commented by: @mrotteveel

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

firebird-automations commented 3 years ago

Commented by: @luronumen

Hi Mark,

Yes I meant 335544472! Thanks for point this!

Best Regards, Luciano

firebird-automations commented 3 years ago

Commented by: @cincuranet

What's your connection string?

firebird-automations commented 3 years ago

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 commented 3 years ago
Modified by: @cincuranet status: Open \[ 1 \] =\> In Progress \[ 3 \]
firebird-automations commented 3 years ago
Modified by: @cincuranet priority: Critical \[ 2 \] =\> Major \[ 3 \] Fix Version: vNext \[ 10982 \]
firebird-automations commented 3 years ago
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 commented 3 years ago

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 commented 3 years ago

Commented by: @cincuranet

No it's not in alpha1.

firebird-automations commented 3 years ago

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 commented 3 years ago

Commented by: @cincuranet

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

firebird-automations commented 3 years ago

Commented by: @luronumen

Retest result on version 8.0.0-alpha3: PASSED!

Thank you very much for the fix Jiri!

Best Regards, Luciano