yahoo-eng-team team mailing list archive

[Miguel Lavalle <1956116@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Job neutron-ovn-tempest-ovs-master-fedora is failing because devstack
fails to build. Specifically, set the root user password in mariadb
fails:

2021-12-31 03:01:18.052 | + lib/databases/mysql:configure_database_mysql:97 :   sudo mysqladmin -u root password secretdatabase
2021-12-31 03:01:18.118 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
2021-12-31 03:01:18.118 | Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
2021-12-31 03:01:18.118 | mysqladmin: unable to change password; error: 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '() IDENTIFIED BY 'secretdatabase'' at line 1'

which in turn leads to the following failure:

2021-12-31 03:01:18.140 | + lib/databases/mysql:configure_database_mysql:115 :   sudo mysql -uroot -psecretdatabase -h127.0.0.1 -e 'CREATE USER IF NOT EXISTS '\''root'\''@'\''%'\'' identified by '\''secretdatabase'\'';'
2021-12-31 03:01:18.200 | mysql: [Warning] Using a password on the command line interface can be insecure.
2021-12-31 03:01:18.204 | ERROR 1698 (28000): Access denied for user 'root'@'localhost'
2021-12-31 03:01:18.209 | + lib/databases/mysql:configure_database_mysql:1 :   exit_trap

This terminates the execution of devstack/stack.sh

This job currently runs on Fedora 34

** Affects: neutron
     Importance: Medium
     Assignee: Miguel Lavalle (minsel)
         Status: Confirmed

** Changed in: neutron
       Status: New => Confirmed

** Changed in: neutron
   Importance: Undecided => Medium

** Changed in: neutron
     Assignee: (unassigned) => Miguel Lavalle (minsel)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1956116

Title:
  neutron-ovn-tempest-ovs-master-fedora failing 100% of the time since
  12/13/2021

Status in neutron:
  Confirmed

Bug description:
  Job neutron-ovn-tempest-ovs-master-fedora is failing because devstack
  fails to build. Specifically, set the root user password in mariadb
  fails:

  2021-12-31 03:01:18.052 | + lib/databases/mysql:configure_database_mysql:97 :   sudo mysqladmin -u root password secretdatabase
  2021-12-31 03:01:18.118 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
  2021-12-31 03:01:18.118 | Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
  2021-12-31 03:01:18.118 | mysqladmin: unable to change password; error: 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '() IDENTIFIED BY 'secretdatabase'' at line 1'

  which in turn leads to the following failure:

  2021-12-31 03:01:18.140 | + lib/databases/mysql:configure_database_mysql:115 :   sudo mysql -uroot -psecretdatabase -h127.0.0.1 -e 'CREATE USER IF NOT EXISTS '\''root'\''@'\''%'\'' identified by '\''secretdatabase'\'';'
  2021-12-31 03:01:18.200 | mysql: [Warning] Using a password on the command line interface can be insecure.
  2021-12-31 03:01:18.204 | ERROR 1698 (28000): Access denied for user 'root'@'localhost'
  2021-12-31 03:01:18.209 | + lib/databases/mysql:configure_database_mysql:1 :   exit_trap

  This terminates the execution of devstack/stack.sh

  This job currently runs on Fedora 34

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1956116/+subscriptions