2 Replies Latest reply on Oct 28, 2019 1:13 PM by gfury

    5.7.28 Crashes With LDAP Authentication

    gfury

      I already have an SR open on this.

       

      I patched one of our instances from 5.7.27 to 5.7.28.  Now when users connect and are authenticated via LDAP, the entire instance crashes.

       

      Does anyone else use LDAP authentication with 5.7.28?

       

      -Greg

        • 1. Re: 5.7.28 Crashes With LDAP Authentication
          Gaz in Oz

          No, but it would help to give more detail.

          . What OS are you running mysql on?

          . What ldap server are you using?

          . How have you setup mysql ldap authentication on the mysql server.

          . What error or errors do you get?

          • 2. Re: 5.7.28 Crashes With LDAP Authentication
            gfury

            Thanks for responding:

             

            The host OS is RHEL7

            LDAP is Oracle Virtual Directory

            Using authentication_ldap_simple plugin.

             

            As soon as an LDAP authenticated user tries to connect,  the mysql process crashes with :

             

            15:08:18 UTC - mysqld got signal 11 ;

            stack_bottom = 7fc92812fe30 thread_stack 0x40000

            /usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xf3521b]

            /usr/sbin/mysqld(handle_fatal_signal+0x461)[0x7e1081]

            /lib64/libpthread.so.0(+0xf5d0)[0x7fca916b35d0]

            /lib64/libssl.so.10(ssl3_ctx_callback_ctrl+0x60)[0x7fc9216b0e70]

            /lib64/libldap-2.4.so.2(+0x39851)[0x7fc921f79851]

            /lib64/libldap-2.4.so.2(+0x367fc)[0x7fc921f767fc]

            /lib64/libldap-2.4.so.2(+0x36beb)[0x7fc921f76beb]

            /lib64/libldap-2.4.so.2(+0x36ccc)[0x7fc921f76ccc]

            /lib64/libldap-2.4.so.2(ldap_int_tls_start+0xe7)[0x7fc921f77c67]

            /lib64/libldap-2.4.so.2(ldap_int_open_connection+0x241)[0x7fc921f50d01]

            /lib64/libldap-2.4.so.2(ldap_new_connection+0x19d)[0x7fc921f6407d]

            /lib64/libldap-2.4.so.2(ldap_open_defconn+0x2f)[0x7fc921f5019f]

            /lib64/libldap-2.4.so.2(ldap_send_initial_request+0x198)[0x7fc921f65388]

            /lib64/libldap-2.4.so.2(ldap_sasl_bind+0xe9)[0x7fc921f5a3c9]

            /lib64/libldap-2.4.so.2(ldap_sasl_bind_s+0x89)[0x7fc921f5a7f9]

            /usr/lib64/mysql/plugin/authentication_ldap_simple.so(_ZN19Ldap_authentication9user_bindERK9Ldap_userb+0x6cd)[0x7fc9221a3c8d]

            /usr/lib64/mysql/plugin/authentication_ldap_simple.so(_ZN26Ldap_authentication_simple17authenticate_userEv+0xc0)[0x7fc9221b1a20]

            /usr/lib64/mysql/plugin/authentication_ldap_simple.so(_ZN19Ldap_authentication32authenticate_user_retrieve_groupEv+0x42c)[0x7fc9221ae27c]

            /usr/lib64/mysql/plugin/authentication_ldap_simple.so(+0x1cd25)[0x7fc9221b1d25]

            /usr/sbin/mysqld[0x7e8205]

            /usr/sbin/mysqld(_Z16acl_authenticateP3THD19enum_server_command+0x1045)[0x7ec365]

            /usr/sbin/mysqld[0xcbfced]

            /usr/sbin/mysqld(_Z22thd_prepare_connectionP3THD+0x68)[0xcc0d38]

            /usr/sbin/mysqld(handle_connection+0x267)[0xdc53e7]

            /usr/sbin/mysqld(pfs_spawn_thread+0x1b4)[0x129b564]

            /lib64/libpthread.so.0(+0x7dd5)[0x7fca916abdd5]

            /lib64/libc.so.6(clone+0x6d)[0x7fca9016502d]