--> Failed authentication

2020-07-27T12:46:09.784970Z 257639 [Note] [MY-011754] [Server] Plugin authentication_ldap_simple reported: 'Setting LDAP user name as : App1_Dev_Admin_User1'
2020-07-27T12:46:09.785028Z 257639 [Note] [MY-013342] [Server] Plugin authentication_ldap_simple reported: 'Get user proxy: configured mapping info:   App1_DEV_Admin=App1_DEV_Admin,App1_DEV_Write=App1_DEV_Write,App1_DEV_Read=App1_DEV_Read'
2020-07-27T12:46:09.785050Z 257639 [Note] [MY-011755] [Server] Plugin authentication_ldap_simple reported: 'User authentication data: #  App1_DEV_Admin=App1_DEV_Admin,App1_DEV_Write=App1_DEV_Write,App1_DEV_Read=App1_DEV_Read size: 90'
2020-07-27T12:46:09.785059Z 257639 [Note] [MY-011778] [Server] Plugin authentication_ldap_simple reported: 'Ldap_authentication::initialize: getting connection from pool. '
2020-07-27T12:46:09.785075Z 257639 [Note] [MY-011788] [Server] Plugin authentication_ldap_simple reported: ' Ldap_connection_pool::get pooled connection key: 15958533827190810'
2020-07-27T12:46:09.785090Z 257639 [Note] [MY-011764] [Server] Plugin authentication_ldap_simple reported: 'LDAP authentication object creation time_stamp: 15958533827190810 dn: CN=MySQLTestUser4,OU=Test,DC=base,DC=int'
ldap_sasl_bind_s
ldap_sasl_bind
ldap_send_initial_request
ldap_send_server_request
ldap_result ld 0x72ad490 msgid 17
wait4msg ld 0x72ad490 msgid 17 (infinite timeout)
wait4msg continue ld 0x72ad490 msgid 17 all 1
** ld 0x72ad490 Connections:
* host: scpldaps.base.int  port: 636  (default)
  refcnt: 2  status: Connected
  last used: Mon Jul 27 14:46:09 2020


** ld 0x72ad490 Outstanding Requests:
 * msgid 17,  origid 17, status InProgress
   outstanding referrals 0, parent count 0
  ld 0x72ad490 request count 1 (abandoned 0)
** ld 0x72ad490 Response Queue:
   Empty
  ld 0x72ad490 response count 0
ldap_chkResponseList ld 0x72ad490 msgid 17 all 1
ldap_chkResponseList returns ld 0x72ad490 NULL
ldap_int_select
2020-07-27T12:48:28.960364Z 257779 [Note] [MY-011754] [Server] Plugin authentication_ldap_simple reported: 'Setting LDAP user name as : App1_Dev_Admin_User1'
2020-07-27T12:48:28.960418Z 257779 [Note] [MY-013342] [Server] Plugin authentication_ldap_simple reported: 'Get user proxy: configured mapping info:   App1_DEV_Admin=App1_DEV_Admin,App1_DEV_Write=App1_DEV_Write,App1_DEV_Read=App1_DEV_Read'
2020-07-27T12:48:28.960432Z 257779 [Note] [MY-011755] [Server] Plugin authentication_ldap_simple reported: 'User authentication data: #  App1_DEV_Admin=App1_DEV_Admin,App1_DEV_Write=App1_DEV_Write,App1_DEV_Read=App1_DEV_Read size: 90'
2020-07-27T12:48:28.960441Z 257779 [Note] [MY-011778] [Server] Plugin authentication_ldap_simple reported: 'Ldap_authentication::initialize: getting connection from pool. '
2020-07-27T12:48:28.960454Z 257779 [Note] [MY-011788] [Server] Plugin authentication_ldap_simple reported: ' Ldap_connection_pool::get pooled connection key: 15958533827190078'
2020-07-27T12:48:28.960464Z 257779 [Note] [MY-011764] [Server] Plugin authentication_ldap_simple reported: 'LDAP authentication object creation time_stamp: 15958533827190078 dn: CN=MySQLTestUser4,OU=Test,DC=base,DC=int'
ldap_sasl_bind_s
ldap_sasl_bind
ldap_send_initial_request
ldap_new_connection 1 1 0
ldap_int_open_connection
ldap_connect_to_host: TCP scpldaps.base.int:636
ldap_new_socket: 58
ldap_prepare_socket: 58
ldap_connect_to_host: Trying 10.22.12.108:636
ldap_pvt_connect: fd: 58 tm: -1 async: 0
attempting to connect: 
connect success
TLS trace: SSL_connect:before SSL initialization
TLS trace: SSL_connect:SSLv3/TLS write client hello
TLS trace: SSL_connect:SSLv3/TLS write client hello
TLS trace: SSL_connect:SSLv3/TLS read server hello
TLS certificate verification: depth: 1, err: 0, subject: /DC=int/DC=base/CN=SIXINTCA256, issuer: /DC=int/DC=base/CN=SIXINTCA256
TLS certificate verification: depth: 0, err: 0, subject: /CN=milpwadi03.base.int, issuer: /DC=int/DC=base/CN=SIXINTCA256
TLS trace: SSL_connect:SSLv3/TLS read server certificate
TLS trace: SSL_connect:SSLv3/TLS read server key exchange
TLS trace: SSL_connect:SSLv3/TLS read server certificate request
TLS trace: SSL_connect:SSLv3/TLS read server done
TLS trace: SSL_connect:SSLv3/TLS write client certificate
TLS trace: SSL_connect:SSLv3/TLS write client key exchange
TLS trace: SSL_connect:SSLv3/TLS write change cipher spec
TLS trace: SSL_connect:SSLv3/TLS write finished
TLS trace: SSL_connect:SSLv3/TLS write finished
TLS trace: SSL_connect:SSLv3/TLS read change cipher spec
TLS trace: SSL_connect:SSLv3/TLS read finished
TLS: hostname (scpldaps.base.int) does not match common name in certificate (milpwadi03.base.int).
TLS: can't connect: TLS: hostname does not match CN in peer certificate.
ldap_err2string
2020-07-27T12:48:28.987303Z 257779 [ERROR] [MY-011800] [Server] Plugin authentication_ldap_simple reported: 'LDAP user bind has failed:  LDAP error: Can't contact LDAP server'
ldap_err2string
2020-07-27T12:48:28.987547Z 257779 [Note] [MY-011804] [Server] Plugin authentication_ldap_simple reported: 'Failed to search user full dn:  LDAP error: Can't contact LDAP server'
ldap_msgfree
2020-07-27T12:48:28.987769Z 257779 [Note] [MY-011783] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::put connection in pushed in the pool'
2020-07-27T12:48:28.987899Z 257779 [Note] [MY-011779] [Server] Plugin authentication_ldap_simple reported: 'Ldap_authentication::de_initialize putting back connection in the pool'
2020-07-27T12:48:28.988036Z 257779 [Note] [MY-011805] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::reinit'
2020-07-27T12:48:28.988143Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827190078'
2020-07-27T12:48:28.988277Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827189409'
2020-07-27T12:48:28.988425Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827188665'
2020-07-27T12:48:28.988569Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827187957'
2020-07-27T12:48:28.988687Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827187305'
2020-07-27T12:48:28.988816Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827186532'
2020-07-27T12:48:28.988996Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827185957'
2020-07-27T12:48:28.989131Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827185414'
2020-07-27T12:48:28.989251Z 257779 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958533827184615'

--> Start shutdown

2020-07-27T12:49:44.474252Z 257855 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.21-commercial).
2020-07-27T12:49:44.905136Z 0 [Note] [MY-010067] [Server] Giving 5 client threads a chance to die gracefully
2020-07-27T12:49:44.908063Z 0 [Note] [MY-010117] [Server] Shutting down slave threads
2020-07-27T12:49:44.914701Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 6
2020-07-27T12:49:44.914735Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2020-07-27T12:49:44.918153Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2020-07-27T12:49:46.919305Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 4 remaining clients
2020-07-27T12:49:46.919382Z 0 [Warning] [MY-010909] [Server] /u00/app/mysql/product/latest/bin/mysqld: Forcing close of thread 257600  user: 'dbsnmp'.
2020-07-27T12:49:46.923025Z 0 [Warning] [MY-010909] [Server] /u00/app/mysql/product/latest/bin/mysqld: Forcing close of thread 257779  user: ''.
2020-07-27T12:49:46.923054Z 0 [Warning] [MY-010909] [Server] /u00/app/mysql/product/latest/bin/mysqld: Forcing close of thread 257639  user: ''.
2020-07-27T12:49:46.923110Z 0 [Warning] [MY-010909] [Server] /u00/app/mysql/product/latest/bin/mysqld: Forcing close of thread 15  user: 'dbsnmp'.
2020-07-27T12:49:46.923917Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
read1msg: ld 0x72ad490 msgid 17 all 1

--> Shutdown hangs for about 12 minutes (720 seconds)

ldap_err2string
2020-07-27T13:01:39.190050Z 257639 [ERROR] [MY-011800] [Server] Plugin authentication_ldap_simple reported: 'LDAP user bind has failed:  LDAP error: Can't contact LDAP server'
ldap_err2string
2020-07-27T13:01:39.190157Z 257639 [Note] [MY-011804] [Server] Plugin authentication_ldap_simple reported: 'Failed to search user full dn:  LDAP error: Can't contact LDAP server'
ldap_msgfree
ldap_err2string
2020-07-27T13:01:39.190190Z 257639 [ERROR] [MY-011798] [Server] Plugin authentication_ldap_simple reported: 'LDAP authentication failed or group retrieval failed:  LDAP error: Can't contact LDAP server'
2020-07-27T13:01:39.190207Z 257639 [Note] [MY-011782] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::put connection is freeing. '
ldap_free_request (origid 17, msgid 17)
ldap_free_connection 1 1
ldap_free_connection: actually freed
2020-07-27T13:01:39.190776Z 257639 [Note] [MY-011779] [Server] Plugin authentication_ldap_simple reported: 'Ldap_authentication::de_initialize putting back connection in the pool'
2020-07-27T13:01:39.191150Z 257639 [Note] [MY-010926] [Server] Access denied for user 'App1_Dev_Admin_User1'@'localhost' (using password: YES)
2020-07-27T13:01:41.080123Z 257779 [Note] [MY-011784] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_creator::Ldap_connection_creator'
2020-07-27T13:01:41.080208Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080230Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080239Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080252Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.080349Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080360Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080368Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080376Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.080476Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080489Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080496Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080505Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.080570Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080580Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080587Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080595Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.080639Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080649Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080667Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080675Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.080713Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080722Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080729Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080736Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.080795Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080805Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080812Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080819Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.080903Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.080916Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.080923Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.080930Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.081035Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.081047Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.081054Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.081062Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.081111Z 257779 [Note] [MY-013339] [Server] Plugin authentication_ldap_simple reported: 'Reserved port for ldaps using ldaps'
2020-07-27T13:01:41.081121Z 257779 [Note] [MY-011746] [Server] Plugin authentication_ldap_simple reported: 'LDAP TLS configuration'
2020-07-27T13:01:41.081128Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
2020-07-27T13:01:41.081135Z 257779 [Note] [MY-011765] [Server] Plugin authentication_ldap_simple reported: 'Certificate name: /u00/app/mysql/etc/ssl/SIXINTCA256.pem'
ldap_create
ldap_url_parse_ext(ldaps://scpldaps.base.int:636)
2020-07-27T13:01:41.081186Z 257779 [Note] [MY-013342] [Server] Plugin authentication_ldap_simple reported: 'Get user proxy: configured mapping info:   App1_DEV_Admin=App1_DEV_Admin,App1_DEV_Write=App1_DEV_Write,App1_DEV_Read=App1_DEV_Read'
2020-07-27T13:01:41.081197Z 257779 [Note] [MY-011755] [Server] Plugin authentication_ldap_simple reported: 'User authentication data: #  App1_DEV_Admin=App1_DEV_Admin,App1_DEV_Write=App1_DEV_Write,App1_DEV_Read=App1_DEV_Read size: 90'
2020-07-27T13:01:41.081205Z 257779 [Note] [MY-011778] [Server] Plugin authentication_ldap_simple reported: 'Ldap_authentication::initialize: getting connection from pool. '
2020-07-27T13:01:41.081215Z 257779 [Note] [MY-011788] [Server] Plugin authentication_ldap_simple reported: ' Ldap_connection_pool::get pooled connection key: 15958549010811741'
2020-07-27T13:01:41.081228Z 257779 [Note] [MY-011764] [Server] Plugin authentication_ldap_simple reported: 'LDAP authentication object creation time_stamp: 15958549010811741 dn: CN=MySQLTestUser4,OU=Test,DC=base,DC=int'
ldap_sasl_bind_s
ldap_sasl_bind
ldap_send_initial_request
ldap_new_connection 1 1 0
ldap_int_open_connection
ldap_connect_to_host: TCP scpldaps.base.int:636
ldap_new_socket: 31
ldap_prepare_socket: 31
ldap_connect_to_host: Trying 10.22.12.108:636
ldap_pvt_connect: fd: 31 tm: -1 async: 0
attempting to connect: 
connect success
TLS trace: SSL_connect:before SSL initialization
TLS trace: SSL_connect:SSLv3/TLS write client hello
TLS trace: SSL_connect:SSLv3/TLS write client hello
TLS trace: SSL_connect:SSLv3/TLS read server hello
TLS certificate verification: depth: 1, err: 0, subject: /DC=int/DC=base/CN=SIXINTCA256, issuer: /DC=int/DC=base/CN=SIXINTCA256
TLS certificate verification: depth: 0, err: 0, subject: /C=CH/L=Zuerich/O=SIX Group AG/OU=CIT-OX/CN=scpldaps.base.int, issuer: /DC=int/DC=base/CN=SIXINTCA256
TLS trace: SSL_connect:SSLv3/TLS read server certificate
TLS trace: SSL_connect:SSLv3/TLS read server key exchange
TLS trace: SSL_connect:SSLv3/TLS read server certificate request
TLS trace: SSL_connect:SSLv3/TLS read server done
TLS trace: SSL_connect:SSLv3/TLS write client certificate
TLS trace: SSL_connect:SSLv3/TLS write client key exchange
TLS trace: SSL_connect:SSLv3/TLS write change cipher spec
TLS trace: SSL_connect:SSLv3/TLS write finished
TLS trace: SSL_connect:SSLv3/TLS write finished
TLS trace: SSL_connect:SSLv3/TLS read change cipher spec
TLS trace: SSL_connect:SSLv3/TLS read finished
ldap_open_defconn: successful
ldap_send_server_request
ldap_result ld 0x7efc18216260 msgid 1
wait4msg ld 0x7efc18216260 msgid 1 (infinite timeout)
wait4msg continue ld 0x7efc18216260 msgid 1 all 1
** ld 0x7efc18216260 Connections:
* host: scpldaps.base.int  port: 636  (default)
  refcnt: 2  status: Connected
  last used: Mon Jul 27 15:01:41 2020


** ld 0x7efc18216260 Outstanding Requests:
 * msgid 1,  origid 1, status InProgress
   outstanding referrals 0, parent count 0
  ld 0x7efc18216260 request count 1 (abandoned 0)
** ld 0x7efc18216260 Response Queue:
   Empty
  ld 0x7efc18216260 response count 0
ldap_chkResponseList ld 0x7efc18216260 msgid 1 all 1
ldap_chkResponseList returns ld 0x7efc18216260 NULL
ldap_int_select
read1msg: ld 0x7efc18216260 msgid 1 all 1
read1msg: ld 0x7efc18216260 msgid 1 message type bind
read1msg: ld 0x7efc18216260 0 new referrals
read1msg:  mark request completed, ld 0x7efc18216260 msgid 1
request done: ld 0x7efc18216260 msgid 1
res_errno: 0, res_error: <>, res_matched: <>
ldap_free_request (origid 1, msgid 1)
ldap_parse_sasl_bind_result
ldap_parse_result
ldap_msgfree
ldap_search_ext
put_filter: "sAMAccountName=App1_Dev_Admin_User1"
put_filter: default
put_simple_filter: "sAMAccountName=App1_Dev_Admin_User1"
ldap_build_search_req ATTRS: *
ldap_send_initial_request
ldap_send_server_request
ldap_result ld 0x7efc18216260 msgid 2
wait4msg ld 0x7efc18216260 msgid 2 (infinite timeout)
wait4msg continue ld 0x7efc18216260 msgid 2 all 1
** ld 0x7efc18216260 Connections:
* host: scpldaps.base.int  port: 636  (default)
  refcnt: 2  status: Connected
  last used: Mon Jul 27 15:01:41 2020


** ld 0x7efc18216260 Outstanding Requests:
 * msgid 2,  origid 2, status InProgress
   outstanding referrals 0, parent count 0
  ld 0x7efc18216260 request count 1 (abandoned 0)
** ld 0x7efc18216260 Response Queue:
   Empty
  ld 0x7efc18216260 response count 0
ldap_chkResponseList ld 0x7efc18216260 msgid 2 all 1
ldap_chkResponseList returns ld 0x7efc18216260 NULL
ldap_int_select
read1msg: ld 0x7efc18216260 msgid 2 all 1
read1msg: ld 0x7efc18216260 msgid 2 message type search-entry
read1msg: ld 0x7efc18216260 msgid 2 message type search-result
read1msg: ld 0x7efc18216260 0 new referrals
read1msg:  mark request completed, ld 0x7efc18216260 msgid 2
request done: ld 0x7efc18216260 msgid 2
res_errno: 0, res_error: <>, res_matched: <>
ldap_free_request (origid 2, msgid 2)
adding response ld 0x7efc18216260 msgid 2 type 101:
ldap_parse_result
ldap_get_dn
ldap_msgfree
2020-07-27T13:01:41.098161Z 257779 [Note] [MY-011796] [Server] Plugin authentication_ldap_simple reported: 'CN=App1_DEV_Admin_User1,OU=Test,DC=base,DC=int'
2020-07-27T13:01:41.098231Z 257779 [Note] [MY-011764] [Server] Plugin authentication_ldap_simple reported: 'LDAP authentication object creation time_stamp: 15958549010811741 dn: CN=App1_DEV_Admin_User1,OU=Test,DC=base,DC=int'
ldap_sasl_bind_s
ldap_sasl_bind
ldap_send_initial_request
ldap_send_server_request
ldap_result ld 0x7efc18216260 msgid 3
wait4msg ld 0x7efc18216260 msgid 3 (infinite timeout)
wait4msg continue ld 0x7efc18216260 msgid 3 all 1
** ld 0x7efc18216260 Connections:
* host: scpldaps.base.int  port: 636  (default)
  refcnt: 2  status: Connected
  last used: Mon Jul 27 15:01:41 2020
** ld 0x7efc18216260 Outstanding Requests:
 * msgid 3,  origid 3, status InProgress
   outstanding referrals 0, parent count 0
  ld 0x7efc18216260 request count 1 (abandoned 0)
** ld 0x7efc18216260 Response Queue:
   Empty
  ld 0x7efc18216260 response count 0
ldap_chkResponseList ld 0x7efc18216260 msgid 3 all 1
ldap_chkResponseList returns ld 0x7efc18216260 NULL
ldap_int_select
read1msg: ld 0x7efc18216260 msgid 3 all 1
read1msg: ld 0x7efc18216260 msgid 3 message type bind
read1msg: ld 0x7efc18216260 0 new referrals
read1msg:  mark request completed, ld 0x7efc18216260 msgid 3
request done: ld 0x7efc18216260 msgid 3
res_errno: 0, res_error: <>, res_matched: <>
ldap_free_request (origid 3, msgid 3)
ldap_parse_sasl_bind_result
ldap_parse_result
ldap_msgfree
2020-07-27T13:01:41.100335Z 257779 [Note] [MY-013332] [Server] Plugin authentication_ldap_simple reported: 'Special handling for group search, {GA} not found'
2020-07-27T13:01:41.100450Z 257779 [Note] [MY-013237] [Server] Plugin authentication_ldap_simple reported: 'Group search rebinding via root DN: CN=MySQLTestUser4,OU=Test,DC=base,DC=int '
2020-07-27T13:01:41.100557Z 257779 [Note] [MY-011764] [Server] Plugin authentication_ldap_simple reported: 'LDAP authentication object creation time_stamp: 15958549010811741 dn: CN=MySQLTestUser4,OU=Test,DC=base,DC=int'
ldap_sasl_bind_s
ldap_sasl_bind
ldap_send_initial_request
ldap_send_server_request
ldap_result ld 0x7efc18216260 msgid 4
wait4msg ld 0x7efc18216260 msgid 4 (infinite timeout)
wait4msg continue ld 0x7efc18216260 msgid 4 all 1
** ld 0x7efc18216260 Connections:
* host: scpldaps.base.int  port: 636  (default)
  refcnt: 2  status: Connected
  last used: Mon Jul 27 15:01:41 2020
** ld 0x7efc18216260 Outstanding Requests:
 * msgid 4,  origid 4, status InProgress
   outstanding referrals 0, parent count 0
  ld 0x7efc18216260 request count 1 (abandoned 0)
** ld 0x7efc18216260 Response Queue:
   Empty
  ld 0x7efc18216260 response count 0
ldap_chkResponseList ld 0x7efc18216260 msgid 4 all 1
ldap_chkResponseList returns ld 0x7efc18216260 NULL
ldap_int_select
read1msg: ld 0x7efc18216260 msgid 4 all 1
read1msg: ld 0x7efc18216260 msgid 4 message type bind
read1msg: ld 0x7efc18216260 0 new referrals
read1msg:  mark request completed, ld 0x7efc18216260 msgid 4
request done: ld 0x7efc18216260 msgid 4
res_errno: 0, res_error: <>, res_matched: <>
ldap_free_request (origid 4, msgid 4)
ldap_parse_sasl_bind_result
ldap_parse_result
ldap_msgfree
2020-07-27T13:01:41.102698Z 257779 [Note] [MY-011757] [Server] Plugin authentication_ldap_simple reported: 'Group search information base DN: OU=Test,DC=base,DC=int scope: 2 filter: (&(objectClass=group)(member=CN=App1_DEV_Admin_User1,OU=Test,DC=base,DC=int)) attribute: cn'
ldap_search_ext
put_filter: "(&(objectClass=group)(member=CN=App1_DEV_Admin_User1,OU=Test,DC=base,DC=int))"
put_filter: AND
put_filter_list "(objectClass=group)(member=CN=App1_DEV_Admin_User1,OU=Test,DC=base,DC=int)"
put_filter: "(objectClass=group)"
put_filter: simple
put_simple_filter: "objectClass=group"
put_filter: "(member=CN=App1_DEV_Admin_User1,OU=Test,DC=base,DC=int)"
put_filter: simple
put_simple_filter: "member=CN=App1_DEV_Admin_User1,OU=Test,DC=base,DC=int"
ldap_build_search_req ATTRS: cn
ldap_send_initial_request
ldap_send_server_request
ldap_result ld 0x7efc18216260 msgid 5
wait4msg ld 0x7efc18216260 msgid 5 (infinite timeout)
wait4msg continue ld 0x7efc18216260 msgid 5 all 1
** ld 0x7efc18216260 Connections:
* host: scpldaps.base.int  port: 636  (default)
  refcnt: 2  status: Connected
  last used: Mon Jul 27 15:01:41 2020
** ld 0x7efc18216260 Outstanding Requests:
 * msgid 5,  origid 5, status InProgress
   outstanding referrals 0, parent count 0
  ld 0x7efc18216260 request count 1 (abandoned 0)
** ld 0x7efc18216260 Response Queue:
   Empty
  ld 0x7efc18216260 response count 0
ldap_chkResponseList ld 0x7efc18216260 msgid 5 all 1
ldap_chkResponseList returns ld 0x7efc18216260 NULL
ldap_int_select
read1msg: ld 0x7efc18216260 msgid 5 all 1
read1msg: ld 0x7efc18216260 msgid 5 message type search-entry
read1msg: ld 0x7efc18216260 msgid 5 message type search-result
read1msg: ld 0x7efc18216260 0 new referrals
read1msg:  mark request completed, ld 0x7efc18216260 msgid 5
request done: ld 0x7efc18216260 msgid 5
res_errno: 0, res_error: <>, res_matched: <>
ldap_free_request (origid 5, msgid 5)
adding response ld 0x7efc18216260 msgid 5 type 101:
ldap_parse_result
2020-07-27T13:01:41.105280Z 257779 [Note] [MY-013338] [Server] Plugin authentication_ldap_simple reported: 'User group retrieval: Group object has user information'
ldap_first_attribute
ldap_get_values_len
2020-07-27T13:01:41.105545Z 257779 [Note] [MY-011763] [Server] Plugin authentication_ldap_simple reported: 'Searched group name: App1_DEV_Admin'
2020-07-27T13:01:41.105608Z 257779 [Note] [MY-013340] [Server] Plugin authentication_ldap_simple reported: 'Get user proxy'
2020-07-27T13:01:41.105715Z 257779 [Note] [MY-013342] [Server] Plugin authentication_ldap_simple reported: 'Get user proxy: configured mapping info:   App1_DEV_Admin=App1_DEV_Admin,App1_DEV_Write=App1_DEV_Write,App1_DEV_Read=App1_DEV_Read'
2020-07-27T13:01:41.105764Z 257779 [Note] [MY-013344] [Server] Plugin authentication_ldap_simple reported: 'Process group proxy mapping'
2020-07-27T13:01:41.105917Z 257779 [Note] [MY-013351] [Server] Plugin authentication_ldap_simple reported: 'Getting next mapping information'
2020-07-27T13:01:41.105987Z 257779 [Note] [MY-013352] [Server] Plugin authentication_ldap_simple reported: 'Parsing mapping, current state: 0  delimiter char: = '
2020-07-27T13:01:41.106094Z 257779 [Note] [MY-013355] [Server] Plugin authentication_ldap_simple reported: 'Trimming left spaces'
2020-07-27T13:01:41.106202Z 257779 [Note] [MY-013356] [Server] Plugin authentication_ldap_simple reported: 'Checking if current characters is quote'
2020-07-27T13:01:41.106316Z 257779 [Note] [MY-013352] [Server] Plugin authentication_ldap_simple reported: 'Parsing mapping, current state: 4  delimiter char: = '
2020-07-27T13:01:41.106363Z 257779 [Note] [MY-013346] [Server] Plugin authentication_ldap_simple reported: 'Processing delimiter'
2020-07-27T13:01:41.106476Z 257779 [Note] [MY-013352] [Server] Plugin authentication_ldap_simple reported: 'Parsing mapping, current state: 2  delimiter char: = '
2020-07-27T13:01:41.106613Z 257779 [Note] [MY-013352] [Server] Plugin authentication_ldap_simple reported: 'Parsing mapping, current state: 0  delimiter char: , '
2020-07-27T13:01:41.106717Z 257779 [Note] [MY-013355] [Server] Plugin authentication_ldap_simple reported: 'Trimming left spaces'
2020-07-27T13:01:41.106765Z 257779 [Note] [MY-013356] [Server] Plugin authentication_ldap_simple reported: 'Checking if current characters is quote'
2020-07-27T13:01:41.106869Z 257779 [Note] [MY-013352] [Server] Plugin authentication_ldap_simple reported: 'Parsing mapping, current state: 4  delimiter char: , '
2020-07-27T13:01:41.106995Z 257779 [Note] [MY-013346] [Server] Plugin authentication_ldap_simple reported: 'Processing delimiter'
2020-07-27T13:01:41.107046Z 257779 [Note] [MY-013353] [Server] Plugin authentication_ldap_simple reported: 'Parsing mapping info, LDAP group: App1_DEV_Admin MySQL proxy: App1_DEV_Admin'
ldap_msgfree
2020-07-27T13:01:41.107283Z 257779 [Note] [MY-011756] [Server] Plugin authentication_ldap_simple reported: 'User is authenticated as: App1_DEV_Admin external user: App1_DEV_Admin'
2020-07-27T13:01:41.107332Z 257779 [Note] [MY-011783] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::put connection in pushed in the pool'
2020-07-27T13:01:41.107445Z 257779 [Note] [MY-011779] [Server] Plugin authentication_ldap_simple reported: 'Ldap_authentication::de_initialize putting back connection in the pool'
2020-07-27T13:01:41.164991Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2020-07-27T13:01:42.069679Z 0 [Note] [MY-010120] [Server] Binlog end
2020-07-27T13:01:42.568542Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'audit_log'
2020-07-27T13:01:42.592203Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_no_login'
2020-07-27T13:01:42.592413Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'authentication_ldap_simple'
2020-07-27T13:01:42.592527Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010811741'
ldap_free_connection 1 1
ldap_send_unbind
TLS trace: SSL3 alert write:warning:close notify
ldap_free_connection: actually freed
2020-07-27T13:01:42.594647Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010811069'
2020-07-27T13:01:42.594770Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010810271'
2020-07-27T13:01:42.594909Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010808784'
2020-07-27T13:01:42.595029Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010807907'
2020-07-27T13:01:42.595146Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010807041'
2020-07-27T13:01:42.595254Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010806347'
2020-07-27T13:01:42.595362Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010805647'
2020-07-27T13:01:42.595478Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010804616'
2020-07-27T13:01:42.595593Z 0 [Note] [MY-011787] [Server] Plugin authentication_ldap_simple reported: 'Ldap_connection_pool::deinit: deleting connection key 15958549010803334'
2020-07-27T13:01:43.596942Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'validate_password'
2020-07-27T13:01:43.604434Z 0 [Warning] [MY-011068] [Server] The syntax 'validate password plugin' is deprecated and will be removed in a future release. Please use validate_password component instead.
2020-07-27T13:01:43.608635Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2020-07-27T13:01:43.630064Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2020-07-27T13:01:43.630366Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2020-07-27T13:01:43.630499Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2020-07-27T13:01:43.630684Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2020-07-27T13:01:43.630789Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2020-07-27T13:01:43.630902Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-07-27T13:01:43.631085Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2020-07-27T13:01:43.632688Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2020-07-27T13:01:43.636219Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2020-07-27T13:01:43.638041Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2020-07-27T13:01:43.638159Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2020-07-27T13:01:43.638269Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2020-07-27T13:01:43.638374Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2020-07-27T13:01:43.638479Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2020-07-27T13:01:43.638583Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2020-07-27T13:01:43.638706Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2020-07-27T13:01:43.638812Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-07-27T13:01:43.638954Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-07-27T13:01:43.639068Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2020-07-27T13:01:43.639184Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-07-27T13:01:43.639307Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2020-07-27T13:01:43.639422Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-07-27T13:01:43.639537Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2020-07-27T13:01:43.639650Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-07-27T13:01:43.639762Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-07-27T13:01:43.639883Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-07-27T13:01:43.640018Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-07-27T13:01:43.640127Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-07-27T13:01:43.640237Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-07-27T13:01:43.640348Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-07-27T13:01:43.640468Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2020-07-27T13:01:43.640587Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2020-07-27T13:01:43.640697Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2020-07-27T13:01:43.640810Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2020-07-27T13:01:43.640936Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2020-07-27T13:01:43.643852Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2020-07-27T13:01:43.656588Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /u02/mysqldata/mysqld1/ib_buffer_pool
2020-07-27T13:01:43.668326Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 200727 15:01:43
2020-07-27T13:01:43.797637Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2020-07-27T13:01:53.391337Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 44990695
2020-07-27T13:01:53.392707Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2020-07-27T13:01:53.392860Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2020-07-27T13:01:53.392999Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2020-07-27T13:01:53.393134Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2020-07-27T13:01:53.393296Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2020-07-27T13:01:53.394512Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2020-07-27T13:01:53.394823Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2020-07-27T13:01:53.466246Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2020-07-27T13:01:53.493014Z 0 [System] [MY-010910] [Server] /u00/app/mysql/product/latest/bin/mysqld: Shutdown complete (mysqld 8.0.21-commercial)  MySQL Enterprise Server - Commercial.