Skip to content

Instantly share code, notes, and snippets.

@major
Created June 15, 2017 14:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save major/5d7bf972ad9c562b33fd3693e41addcb to your computer and use it in GitHub Desktop.
Save major/5d7bf972ad9c562b33fd3693e41addcb to your computer and use it in GitHub Desktop.
Jun 15 13:51:44 infra1 ansible-systemd[10601]: Invoked with no_block=False name=mysql enabled=True daemon_reload=False state=None user=False masked=None
Jun 15 13:51:44 infra1 su[10587]: pam_unix(su-l:session): session closed for user root
Jun 15 13:51:44 infra1 su[10606]: (to root) root on none
Jun 15 13:51:44 infra1 systemd-logind[30]: Existing logind session ID 7 used by new audit session, ignoring
Jun 15 13:51:44 infra1 systemd[1]: Started Session c401 of user root.
Jun 15 13:51:44 infra1 systemd[1]: Starting Session c401 of user root.
Jun 15 13:51:44 infra1 su[10606]: pam_unix(su-l:session): session opened for user root by (uid=0)
Jun 15 13:51:44 infra1 su[10606]: pam_unix(su-l:session): session closed for user root
Jun 15 13:51:44 infra1 su[10615]: (to root) root on none
Jun 15 13:51:44 infra1 systemd-logind[30]: Existing logind session ID 7 used by new audit session, ignoring
Jun 15 13:51:44 infra1 systemd[1]: Started Session c402 of user root.
Jun 15 13:51:44 infra1 systemd[1]: Starting Session c402 of user root.
Jun 15 13:51:44 infra1 su[10615]: pam_unix(su-l:session): session opened for user root by (uid=0)
Jun 15 13:51:44 infra1 su[10615]: pam_unix(su-l:session): session closed for user root
Jun 15 13:51:45 infra1 su[10628]: (to root) root on none
Jun 15 13:51:45 infra1 systemd-logind[30]: Existing logind session ID 7 used by new audit session, ignoring
Jun 15 13:51:45 infra1 systemd[1]: Started Session c403 of user root.
Jun 15 13:51:45 infra1 systemd[1]: Starting Session c403 of user root.
Jun 15 13:51:45 infra1 su[10628]: pam_unix(su-l:session): session opened for user root by (uid=0)
Jun 15 13:51:45 infra1 su[10628]: pam_unix(su-l:session): session closed for user root
Jun 15 13:51:45 infra1 su[10638]: (to root) root on none
Jun 15 13:51:45 infra1 systemd-logind[30]: Existing logind session ID 7 used by new audit session, ignoring
Jun 15 13:51:45 infra1 systemd[1]: Started Session c404 of user root.
Jun 15 13:51:45 infra1 systemd[1]: Starting Session c404 of user root.
Jun 15 13:51:45 infra1 su[10638]: pam_unix(su-l:session): session opened for user root by (uid=0)
Jun 15 13:51:45 infra1 ansible-command[10652]: Invoked with warn=True executable=None chdir=None _raw_params=service mysql start || true
# Reset the root password, at this time there is no password set
mysqladmin --no-defaults --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=127.0.0.1 --user=root password "s
# Setup the root user for MySQL
mysql -u root -h localhost -e "UPDATE mysql.user SET Password=PASSWORD('$rootpass') WHERE User='root';"
mysql -u root -h localhost -e "DELETE FROM mysql.user WHERE user='';"
mysql -u root -h localhost -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('%', 'localhost', '127.0.
mysql -u root -h localhost -e "FLUSH PRIVILEGES;"
# Create a marker file to ensure this script is not run again
touch /etc/mysql/rhel_configured
service mysql stop removes=None creates=/etc/mysql/rhel_configured _uses_shell=True
Jun 15 13:51:45 infra1 systemd[1]: Starting MariaDB database server...
Jun 15 13:51:45 infra1 systemd[10670]: Failed at step NAMESPACE spawning /bin/sh: Invalid argument
Jun 15 13:51:45 infra1 systemd[1]: mariadb.service: control process exited, code=exited status=226
Jun 15 13:51:45 infra1 systemd[1]: Failed to start MariaDB database server.
Jun 15 13:51:45 infra1 systemd[1]: Unit mariadb.service entered failed state.
Jun 15 13:51:45 infra1 systemd[1]: mariadb.service failed.
Jun 15 13:51:45 infra1 ansible-command[10652]: [WARNING] Consider using service module rather than running service
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment