Skip to content

Trace. Provide ability to see info about auth plugin which was used for login #7901

Open
@pavel-zotov

Description

@pavel-zotov

Create two users with same name but different auth plugins:

echo create user foo password '123' using plugin Legacy_UserManager; | isql /:employee
echo create user foo password '456' using plugin Srp; | isql /:employee

Run trace with 'log_connections = true'.
Run then:

echo quit; | isql /:employee -user foo -pas 123
echo quit; | isql /:employee -user foo -pas 456

Trace will be like this:

2023-11-07T13:48:16.9750 (8872:00000000042D17C0) ATTACH_DATABASE
        employee (ATT_487, FOO:NONE, NONE, TCPv6:fe80::fcf1:e33c:e924:969d%8/59457)
        C:\FB\60SS\isql.exe:11696
... 
2023-11-07T13:48:23.6620 (8872:00000000042D17C0) ATTACH_DATABASE
        employee (ATT_490, FOO:NONE, NONE, TCPv6:fe80::fcf1:e33c:e924:969d%8/59460)
        C:\FB\60SS\isql.exe:12980
 ...

So, we have no info about what exact plugin was used for 1st and 2nd attachment.
It could be shown like this:

employee (ATT_487, FOO:NONE:Legacy_UserManager, NONE, ...
employee (ATT_490, FOO:NONE:Srp, NONE, ...
...

(but only if there will be appropriate config parameter and it require this, e.g.: "log_auth_plugin = true")

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions