[
http://tracker.firebirdsql.org/browse/CORE-4222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Zotov reopened CORE-4222:
-------------------------------
Reopened temply: usage of auth plugin `Win_Sspi` is NOT reflected in
MON$ATTACHMENTS table.
Steps to reproduce:
1) change firebird.conf to default, connect as 'sysdba/masterkey';
2) issue: CREATE GLOBAL MAPPING TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY
USER TO USER; EXIT;
3) change firebird.conf to:
AuthServer = Win_Sspi,Legacy_Auth,Srp
AuthClient = Win_Sspi,Legacy_Auth,Srp
4) restart FB and try to:
SQL> set list on;
SQL> select
mon$user,mon$remote_host,mon$remote_os_user,mon$client_version,mon$auth_method
CON> from mon$attachments where mon$attachment_id = current_connection;
Output will be:
MON$USER CSPROG\ZOTOV
MON$REMOTE_HOST csprog
MON$REMOTE_OS_USER zotov
MON$CLIENT_VERSION WI-V3.0.0.31929 Firebird 3.0 Release Candidate 1
MON$AUTH_METHOD <null>
----------------------------------------------------------------------
expected: 'Win_Sspi' or like this.
PS. Letter to Alex: 09-JUL-2015 14:53.
> Provide ability to know which auth. method was applied for establishing
> connect
> --------------------------------------------------------------------------------
>
> Key: CORE-4222
> URL: http://tracker.firebirdsql.org/browse/CORE-4222
> Project: Firebird Core
> Issue Type: Improvement
> Components: Engine, Security
> Affects Versions: 3.0 Alpha 1
> Reporter: Pavel Zotov
> Assignee: Dmitry Yemanov
> Priority: Minor
> Fix For: 3.0 Alpha 2
>
>
> Currently we have few plugins for client authentification defined in
> firebird.conf:
> #AuthClient = Srp, Win_Sspi, Legacy_Auth
> When client-3.x is connecting to server-3.x the plugin that is selected can
> be known only if we take this config parameter and analyze it "from left to
> right".
> For the purpoces of testing and debugging it will be useful if such info will
> appear in MON$-tables.
--
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
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
