Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24032

Password's are getting logged in the db log when installing openstack.

    XMLWordPrintable

    Details

      Description

      Password's are getting logged while installing openstack in the event of creating users of the openstack component.

      We have enabled following parameters in the '/etc/my.cnf.d/server.cnf' file
      'plugin_load_add', 'sql_errlog'
      'sql_error_log_rotate', '1'
      'slow_query_log', '1'
      'long_query_time' 10

      Here is the db log after the installation of openstack where the passwords are getting printed

      Version: '10.3.17-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 50110 MariaDB Server
      2020-10-21 10:16:45 root[root] @ localhost [] ERROR 1396: Operation CREATE USER failed for 'novadb'@'localhost' : CREATE USER 'novadb'@'localhost' IDENTIFIED BY 'l9OxJ46JNixySVWDiV58'
      2020-10-21 10:16:45 root[root] @ localhost [] ERROR 1396: Operation CREATE USER failed for 'novadb'@'127.0.0.1' : CREATE USER 'novadb'@'127.0.0.1' IDENTIFIED BY 'l9OxJ46JNixySVWDiV58'
      2020-10-21 10:16:45 root[root] @ localhost [] ERROR 1396: Operation CREATE USER failed for 'novadb'@'::1' : CREATE USER 'novadb'@'::1' IDENTIFIED BY 'l9OxJ46JNixySVWDiV58'

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              biplab Kumar Biplab Singh
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: