Bug 1505037 - mysql pod is not debug friendly when passwd-change.sh failed
Summary: mysql pod is not debug friendly when passwd-change.sh failed
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: Red Hat Software Collections
Classification: Red Hat
Component: rh-mysql57-container
Version: rh-mysql57
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
: 3.1
Assignee: Augusto Caringi
QA Contact: qe-baseos-daemons
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-10-21 10:41 UTC by Kenjiro Nakayama
Modified: 2020-12-14 10:36 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-02-26 16:09:26 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Kenjiro Nakayama 2017-10-21 10:41:40 UTC
Description of problem:
- When passwd-change.sh in mysql pod failed, mysql pod will never starts and we cannnt debug.
- One customer hit following error and we cannot debug it.

  $ oc logs mysql-1-x95v8 -c mysql
  ~~~
  OUTPUT:
  ---> 14:16:58     Processing MySQL configuration files ...
   
   ... snip ...
   
  2017-10-18T14:16:59.149617Z 0 [Note] /opt/rh/rh-mysql57/root/usr/libexec/mysqld: ready for connections.
  Version: '5.7.16'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server (GPL)
  2017-10-18T14:16:59.535076Z 2 [Note] Access denied for user 'UNKNOWN_USER'@'localhost' (using password: NO)
  ---> 14:16:59     MySQL started successfully
  ---> 14:16:59     Setting passwords ...
  2017-10-18T14:16:59.558903Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
  ~~~

Version-Release number of selected component (if applicable):
- registry.access.redhat.com/rhscl/mysql-57-rhel7 (4ae3a3f4f409)

How reproducible:
- We still don't know why "Access denied for user 'root'@'localhost'" happened.

Actual results:
- We had to rebuild MySQL image and put it on public registry.

Expected results:
- Script continue to run and start mysql process. Then, we can debug it.

Additional info:
- Proposal patch https://github.com/sclorg/mysql-container/pull/199

Comment 4 Honza Horak 2018-01-16 08:44:46 UTC
PR merged: https://github.com/sclorg/mysql-container/pull/199


Note You need to log in before you can comment on or make changes to this bug.