You can translate the question and the replies:

Denodo 7: Capture Logon Information for Failed Logins

How do we capture additional logon information when a connection fails? In our VDP logs we see messages, like the one below. Our challenge is that we do not know how to correlate this with a user account. 8222466 [RMI TCP Connection(5403)-127.0.0.1] ERROR 2021-05-07T11:05:00.158 com.denodo.vdb.security.LDAPDatabaseAuthenticator [] - [LDAP: error code 32 - 0000208D: NameErr: DSID-03100241, problem 2001 (NO_OBJECT), data 0, best match of: 'OU=users,DC=domain,DC=com' ] javax.naming.NameNotFoundException: [LDAP: error code 32 - 0000208D: NameErr: DSID-03100241, problem 2001 (NO_OBJECT), data 0, best match of: 'OU=users,DC=domain,DC=com' ] 8282423 [RMI TCP Connection(5448)-127.0.0.1] ERROR 2021-05-07T11:06:00.115 com.denodo.vdb.security.LDAPDatabaseAuthenticator [] - Not authenticated: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090453, comment: AcceptSecurityContext error, data 52e, v3839 ] javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090453, comment: AcceptSecurityContext error, data 52e, v3839 ]
user
07-05-2021 12:11:42 -0400
code

1 Answer

Hi, I am able to find the logged information for connection attempts, including the Login User name, from the vdp-connections log file. This file is generated by the Denodo Monitor Tool, which I need to [Configure](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/configuring_the_denodo_monitor#configuring-the-denodo-monitor) and [Launch](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/launching_the_denodo_monitor) in addition to my Virtual DataPort Server. Once the Monitor is running, this log will be generated in my <DENODO_MONITOR_HOME>/logs folder. In the event of a loginFailure the related message will be logged, and I will be able to see the given User name from the Login column of the corresponding log line. For more information about what messages will be recorded to each log, please refer to the Knowledge Base Article on [Log Column Details](https://community.denodo.com/kb/en/view/document/Log%20column%20details). Hope this helps!
Denodo Team
07-05-2021 16:12:23 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here