Windows Trusted Authentication (Win_Sspi) exception on Client PC when Firebird
Server is version 3.0.5
------------------------------------------------------------------------------------------------------
Key: DNET-941
URL: http://tracker.firebirdsql.org/browse/DNET-941
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Environment: Windows 10 Pro Version 1909
Firebird 3.0.5
Reporter: Luciano Mendes
Assignee: Jiri Cincura
Attachments: LOGIN_ERROR.png
ACTUAL RESULT:
Windows Trusted Authentication (Win_Sspi) exception on Client PC when Firebird
Server is version 3.0.5 (See LOGIN_ERROR.png picture attached):
- 335544382 - Invalid clumplet buffer structure: buffer end before end of
clumplet - clumplet too long
EXPECTED RESULT:
No Windows Trusted Authentication (Win_Sspi) exception should be happen on
Client PC when Firebird Server is version 3.0.5
STEPS TO REPRODUCE THE ISSUE:
- Try to connect a Firebird 3.0.5 Database Server from a client PC using
Windows Trusted Authentication (Win_Sspi)
IMPORTANT NOTES:
- This issue does NOT happen when Firebird server version is 2.5.9;
- If the .NET application (FirebirdSql.Data.FirebirdClient 7.5.0) is installed
on the same PC where Firebird 3.0.5 is installed (Server), the .NET application
can authenticate via Windows Trusted Authentication (Win_Sspi) without any
issue;
- The issue is only reproducible if the .NET application is installed on a
client PC;
- The .NET application authentication via user/password (Srp) works perfectly
on both the server PC and the client PC;
- The Windows Trusted Authentication (Win_Sspi) using the native Firebird 3.0.5
(fbclient.dll - FlameRobin) library is working perfectly on both the server PC
and the client PC;
- The issue is the same described in the following Firebird FAQ:
http://www.firebirdfaq.org/faq320/
ENVIRONMENT SETUP
===firebird.conf===
#SETUP
AuthClient = Legacy_Auth, Srp, Win_Sspi
AuthServer = Legacy_Auth, Srp, Win_Sspi
ServerMode = Super
UserManager = Legacy_UserManager, Srp
WireCrypt = Enabled
#PERFORMANCE
DefaultDbCachePages = 30K
FileSystemCacheThreshold = 2M
LockHashSlots = 30011
LockMemSize = 15M
RemoteServicePort = 3050
TempBlockSize = 2M
TempCacheLimit = 3000M
#SECURITY
DatabaseAccess = None
SecurityDatabase = $(dir_secDb)/security3.fdb
=============================
Database Page Size: 8192
=== ADO.NET Connection String ===
var fbConnectionStringBuilder = new FbConnectionStringBuilder
{
Pooling = true,
ServerType = FbServerType.Default,
DataSource = Properties.Settings.Default.Server,
Database = Properties.Settings.Default.Database,
Charset = "WIN1252",
Role = "RDB$ADMIN"
};
================
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
