networking-midonet

mysql access denied on centos jobs

Bug #1855516 reported by YAMAMOTO Takashi on 2019-12-07

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	networking-midonet	New	Critical	Unassigned

Bug Description

eg. https://zuul.opendev.org/t/openstack/build/74edbdf496c046cf8830223346299cb3/logs

2019-12-07 04:15:57.428 | + ./stack.sh:main:1063 : configure_database
2019-12-07 04:15:57.431 | + lib/database:configure_database:126 : configure_database_mysql
2019-12-07 04:15:57.433 | + lib/databases/mysql:configure_database_mysql:69 : local my_conf mysql slow_log
2019-12-07 04:15:57.435 | + lib/databases/mysql:configure_database_mysql:70 : echo_summary 'Configuring and starting MySQL'
2019-12-07 04:15:57.437 | + ./stack.sh:echo_summary:452 : [[ -t 3 ]]
2019-12-07 04:15:57.438 | + ./stack.sh:echo_summary:458 : echo -e Configuring and starting MySQL
2019-12-07 04:15:57.441 | + lib/databases/mysql:configure_database_mysql:72 : is_ubuntu
2019-12-07 04:15:57.443 | + functions-common:is_ubuntu:494 : [[ -z rpm ]]
2019-12-07 04:15:57.445 | + functions-common:is_ubuntu:497 : '[' rpm = deb ']'
2019-12-07 04:15:57.448 | + lib/databases/mysql:configure_database_mysql:74 : is_suse
2019-12-07 04:15:57.450 | + functions-common:is_suse:463 : is_opensuse
2019-12-07 04:15:57.452 | + functions-common:is_opensuse:470 : [[ -z CentOS ]]
2019-12-07 04:15:57.454 | + functions-common:is_opensuse:474 : [[ CentOS =~ (openSUSE) ]]
2019-12-07 04:15:57.457 | + functions-common:is_suse:463 : is_suse_linux_enterprise
2019-12-07 04:15:57.459 | + functions-common:is_suse_linux_enterprise:482 : [[ -z CentOS ]]
2019-12-07 04:15:57.461 | + functions-common:is_suse_linux_enterprise:486 : [[ CentOS =~ (^SUSE) ]]
2019-12-07 04:15:57.463 | + lib/databases/mysql:configure_database_mysql:74 : is_oraclelinux
2019-12-07 04:15:57.465 | + functions-common:is_oraclelinux:436 : [[ -z CentOS ]]
2019-12-07 04:15:57.468 | + functions-common:is_oraclelinux:440 : '[' CentOS = OracleServer ']'
2019-12-07 04:15:57.470 | + lib/databases/mysql:configure_database_mysql:76 : is_fedora
2019-12-07 04:15:57.472 | + functions-common:is_fedora:448 : [[ -z CentOS ]]
2019-12-07 04:15:57.474 | + functions-common:is_fedora:452 : '[' CentOS = Fedora ']'
2019-12-07 04:15:57.477 | + functions-common:is_fedora:452 : '[' CentOS = 'Red Hat' ']'
2019-12-07 04:15:57.479 | + functions-common:is_fedora:453 : '[' CentOS = RedHatEnterpriseServer ']'
2019-12-07 04:15:57.481 | + functions-common:is_fedora:454 : '[' CentOS = CentOS ']'
2019-12-07 04:15:57.484 | + lib/databases/mysql:configure_database_mysql:77 : my_conf=/etc/my.cnf
2019-12-07 04:15:57.486 | + lib/databases/mysql:configure_database_mysql:78 : local cracklib_conf=/etc/my.cnf.d/cracklib_password_check.cnf
2019-12-07 04:15:57.488 | + lib/databases/mysql:configure_database_mysql:79 : '[' -f /etc/my.cnf.d/cracklib_password_check.cnf ']'
2019-12-07 04:15:57.491 | + lib/databases/mysql:configure_database_mysql:87 : is_fedora
2019-12-07 04:15:57.494 | + functions-common:is_fedora:448 : [[ -z CentOS ]]
2019-12-07 04:15:57.496 | + functions-common:is_fedora:452 : '[' CentOS = Fedora ']'
2019-12-07 04:15:57.499 | + functions-common:is_fedora:452 : '[' CentOS = 'Red Hat' ']'
2019-12-07 04:15:57.502 | + functions-common:is_fedora:453 : '[' CentOS = RedHatEnterpriseServer ']'
2019-12-07 04:15:57.504 | + functions-common:is_fedora:454 : '[' CentOS = CentOS ']'
2019-12-07 04:15:57.507 | + lib/databases/mysql:configure_database_mysql:89 : start_service mariadb
2019-12-07 04:15:57.509 | + functions-common:start_service:2243 : '[' -x /bin/systemctl ']'
2019-12-07 04:15:57.512 | + functions-common:start_service:2244 : sudo /bin/systemctl start mariadb
2019-12-07 04:16:01.299 | + lib/databases/mysql:configure_database_mysql:95 : sudo mysqladmin -u root password secretmysql
2019-12-07 04:16:01.343 | + lib/databases/mysql:configure_database_mysql:99 : is_ubuntu
2019-12-07 04:16:01.345 | + functions-common:is_ubuntu:494 : [[ -z rpm ]]
2019-12-07 04:16:01.348 | + functions-common:is_ubuntu:497 : '[' rpm = deb ']'
2019-12-07 04:16:01.351 | + lib/databases/mysql:configure_database_mysql:102 : local 'cmd_args=-uroot -psecretmysql -h127.0.0.1 '
2019-12-07 04:16:01.353 | + lib/databases/mysql:configure_database_mysql:108 : '[' mariadb == mariadb ']'
2019-12-07 04:16:01.355 | + lib/databases/mysql:configure_database_mysql:109 : sudo mysql -uroot -psecretmysql -h127.0.0.1 -e 'UPDATE mysql.user SET plugin='\'''\'' WHERE user='\''root'\'' AND host='\''localhost'\'';'
2019-12-07 04:16:01.396 | + lib/databases/mysql:configure_database_mysql:110 : sudo mysql -uroot -psecretmysql -h127.0.0.1 -e 'FLUSH PRIVILEGES;'
2019-12-07 04:16:01.432 | + lib/databases/mysql:configure_database_mysql:113 : sudo mysql -uroot -psecretmysql -h127.0.0.1 -e 'GRANT ALL PRIVILEGES ON *.* TO '\''root'\''@'\''%'\'' identified by '\''secretmysql'\'';'
2019-12-07 04:16:01.457 | ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
2019-12-07 04:16:01.462 | + lib/databases/mysql:configure_database_mysql:1 : exit_trap
2019-12-07 04:16:01.465 | + ./stack.sh:exit_trap:533 : local r=1
2019-12-07 04:16:01.468 | ++ ./stack.sh:exit_trap:534 : jobs -p
2019-12-07 04:16:01.473 | + ./stack.sh:exit_trap:534 : jobs=
2019-12-07 04:16:01.475 | + ./stack.sh:exit_trap:537 : [[ -n '' ]]
2019-12-07 04:16:01.477 | + ./stack.sh:exit_trap:543 : '[' -f /tmp/tmp.Ou4ACfo9ni ']'
2019-12-07 04:16:01.479 | + ./stack.sh:exit_trap:544 : rm /tmp/tmp.Ou4ACfo9ni
2019-12-07 04:16:01.483 | + ./stack.sh:exit_trap:548 : kill_spinner
2019-12-07 04:16:01.485 | + ./stack.sh:kill_spinner:443 : '[' '!' -z '' ']'
2019-12-07 04:16:01.487 | + ./stack.sh:exit_trap:550 : [[ 1 -ne 0 ]]
2019-12-07 04:16:01.489 | + ./stack.sh:exit_trap:551 : echo 'Error on exit'
2019-12-07 04:16:01.490 | Error on exit
2019-12-07 04:16:01.492 | + ./stack.sh:exit_trap:553 : type -p generate-subunit
2019-12-07 04:16:01.494 | + ./stack.sh:exit_trap:554 : generate-subunit 1575691361 800 fail
2019-12-07 04:16:02.039 | + ./stack.sh:exit_trap:556 : [[ -z /opt/stack/new/screen-logs ]]
2019-12-07 04:16:02.041 | + ./stack.sh:exit_trap:559 : /opt/stack/new/devstack/tools/worlddump.py -d /opt/stack/new/screen-logs
2019-12-07 04:16:02.085 | World dumping... see /opt/stack/new/screen-logs/worlddump-2019-12-07-041602.txt for details
2019-12-07 04:16:03.487 | + ./stack.sh:exit_trap:568 : exit 1