So it seems the mysql isn't able to resolve the service name mysql to its IP: because this works inside the container: mysql -u user -h 172.30.183.216 -p password: xx ---> mysql (works)
This doesn't work: mysql -u user h mysql -p password: xx --> error unkown mysql server host 'mysql' mysql is the service name and service IP is 172.30.183.216 here are all the logs of the container: Warning: Can't detect memory limit from cgroups Warning: Can't detect number of CPU cores from cgroups ---> 16:19:51 Processing MySQL configuration files ... ---> 16:19:51 Initializing database ... ---> 16:19:51 Running mysql_install_db ... 2016-06-21 16:19:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-06-21 16:19:51 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 17 ... 2016-06-21 16:19:51 663521f0b840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2016-06-21 16:19:51 17 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-06-21 16:19:51 17 [Note] InnoDB: The InnoDB memory heap is disabled 2016-06-21 16:19:51 17 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-06-21 16:19:51 17 [Note] InnoDB: Memory barrier is not used 2016-06-21 16:19:51 17 [Note] InnoDB: Compressed tables use zlib 1.2.7 2016-06-21 16:19:51 17 [Note] InnoDB: Using Linux native AIO 2016-06-21 16:19:51 17 [Note] InnoDB: Using CPU crc32 instructions 2016-06-21 16:19:51 17 [Note] InnoDB: Initializing buffer pool, size = 32.0M 2016-06-21 16:19:51 17 [Note] InnoDB: Completed initialization of buffer pool 2016-06-21 16:19:51 17 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2016-06-21 16:19:51 17 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2016-06-21 16:19:51 17 [Note] InnoDB: Database physically writes the file full: wait... 2016-06-21 16:19:51 17 [Note] InnoDB: Setting log file ./ib_logfile101 size to 8 MB 2016-06-21 16:19:52 17 [Note] InnoDB: Setting log file ./ib_logfile1 size to 8 MB 2016-06-21 16:19:52 17 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2016-06-21 16:19:52 17 [Warning] InnoDB: New log files created, LSN=45781 2016-06-21 16:19:52 17 [Note] InnoDB: Doublewrite buffer not found: creating new 2016-06-21 16:19:52 17 [Note] InnoDB: Doublewrite buffer created 2016-06-21 16:19:52 17 [Note] InnoDB: 128 rollback segment(s) are active. 2016-06-21 16:19:52 17 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-06-21 16:19:52 17 [Note] InnoDB: Foreign key constraint system tables created 2016-06-21 16:19:52 17 [Note] InnoDB: Creating tablespace and datafile system tables. 2016-06-21 16:19:52 17 [Note] InnoDB: Tablespace and datafile system tables created. 2016-06-21 16:19:52 17 [Note] InnoDB: Waiting for purge to start 2016-06-21 16:19:52 17 [Note] InnoDB: 5.6.26 started; log sequence number 0 2016-06-21 16:19:52 17 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work. 2016-06-21 16:19:52 17 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work. 2016-06-21 16:19:55 17 [Note] Binlog end 2016-06-21 16:19:55 17 [Note] InnoDB: FTS optimize thread exiting. 2016-06-21 16:19:55 17 [Note] InnoDB: Starting shutdown... 2016-06-21 16:19:56 17 [Note] InnoDB: Shutdown completed; log sequence number 1625977 2016-06-21 16:19:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-06-21 16:19:56 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 39 ... 2016-06-21 16:19:56 6ef05c1a6840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2016-06-21 16:19:56 39 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-06-21 16:19:56 39 [Note] InnoDB: The InnoDB memory heap is disabled 2016-06-21 16:19:56 39 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-06-21 16:19:56 39 [Note] InnoDB: Memory barrier is not used 2016-06-21 16:19:56 39 [Note] InnoDB: Compressed tables use zlib 1.2.7 2016-06-21 16:19:56 39 [Note] InnoDB: Using Linux native AIO 2016-06-21 16:19:56 39 [Note] InnoDB: Using CPU crc32 instructions 2016-06-21 16:19:56 39 [Note] InnoDB: Initializing buffer pool, size = 32.0M 2016-06-21 16:19:56 39 [Note] InnoDB: Completed initialization of buffer pool 2016-06-21 16:19:56 39 [Note] InnoDB: Highest supported file format is Barracuda. 2016-06-21 16:19:56 39 [Note] InnoDB: 128 rollback segment(s) are active. 2016-06-21 16:19:56 39 [Note] InnoDB: Waiting for purge to start 2016-06-21 16:19:57 39 [Note] InnoDB: 5.6.26 started; log sequence number 1625977 2016-06-21 16:19:57 39 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work. 2016-06-21 16:19:57 39 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work. 2016-06-21 16:19:57 39 [Note] Binlog end 2016-06-21 16:19:57 39 [Note] InnoDB: FTS optimize thread exiting. 2016-06-21 16:19:57 39 [Note] InnoDB: Starting shutdown... 2016-06-21 16:19:58 39 [Note] InnoDB: Shutdown completed; log sequence number 1625987 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /opt/rh/rh-mysql56/root/usr/bin/mysqladmin -u root password 'new-password' /opt/rh/rh-mysql56/root/usr/bin/mysqladmin -u root -h mysql-1-irei5 password 'new-password' Alternatively you can run: /opt/rh/rh-mysql56/root/usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. Please report any problems at http://bugs.mysql.com/ The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com Note: new default config file not created. Please make sure your config file is current WARNING: Default config file /etc/opt/rh/rh-mysql56/my.cnf exists on the system This file will be read by default by the MySQL server If you do not want to use this, either remove it, or use the --defaults-file argument to mysqld_safe when starting the server ---> 16:19:59 Starting MySQL server with disabled networking ... ---> 16:19:59 Waiting for MySQL to start ... 2016-06-21 16:19:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-06-21 16:19:59 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 70 ... 2016-06-21 16:19:59 70 [Note] Plugin 'FEDERATED' is disabled. 2016-06-21 16:19:59 772efa0dd840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2016-06-21 16:19:59 70 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-06-21 16:19:59 70 [Note] InnoDB: The InnoDB memory heap is disabled 2016-06-21 16:19:59 70 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-06-21 16:19:59 70 [Note] InnoDB: Memory barrier is not used 2016-06-21 16:19:59 70 [Note] InnoDB: Compressed tables use zlib 1.2.7 2016-06-21 16:19:59 70 [Note] InnoDB: Using Linux native AIO 2016-06-21 16:19:59 70 [Note] InnoDB: Using CPU crc32 instructions 2016-06-21 16:19:59 70 [Note] InnoDB: Initializing buffer pool, size = 32.0M 2016-06-21 16:19:59 70 [Note] InnoDB: Completed initialization of buffer pool 2016-06-21 16:19:59 70 [Note] InnoDB: Highest supported file format is Barracuda. 2016-06-21 16:19:59 70 [Note] InnoDB: 128 rollback segment(s) are active. 2016-06-21 16:19:59 70 [Note] InnoDB: Waiting for purge to start 2016-06-21 16:19:59 70 [Note] InnoDB: 5.6.26 started; log sequence number 1625987 2016-06-21 16:19:59 70 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 00162ab4-37cc-11e6-beb2-02420a010003. 2016-06-21 16:19:59 70 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work. 2016-06-21 16:19:59 70 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work. 2016-06-21 16:19:59 70 [Warning] 'user' entry 'root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:19:59 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:19:59 70 [Warning] 'proxies_priv' entry '@ root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:19:59 70 [Note] Event Scheduler: Loaded 0 events 2016-06-21 16:19:59 70 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: ready for connections. Version: '5.6.26' socket: '/tmp/mysql.sock' port: 0 MySQL Community Server (GPL) ---> 16:20:00 MySQL started successfully ---> 16:20:00 Creating user specified by MYSQL_USER (user) ... ---> 16:20:00 Creating database db ... ---> 16:20:00 Granting privileges to user user for db ... 2016-06-21 16:20:00 70 [Warning] 'user' entry 'root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:00 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:00 70 [Warning] 'proxies_priv' entry '@ root@mysql-1-irei5' ignored in --skip-name-resolve mode. ---> 16:20:00 Initialization finished ---> 16:20:00 Setting passwords ... 2016-06-21 16:20:00 70 [Warning] 'user' entry 'root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:00 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:00 70 [Warning] 'proxies_priv' entry '@ root@mysql-1-irei5' ignored in --skip-name-resolve mode. ---> 16:20:00 Sourcing post-init.sh ... ---> 16:20:00 Shutting down MySQL ... 2016-06-21 16:20:00 70 [Warning] 'user' entry 'root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:00 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:00 70 [Warning] 'proxies_priv' entry '@ root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:00 70 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: Normal shutdown 2016-06-21 16:20:00 70 [Note] Giving 0 client threads a chance to die gracefully 2016-06-21 16:20:00 70 [Note] Event Scheduler: Purging the queue. 0 events 2016-06-21 16:20:00 70 [Note] Shutting down slave threads 2016-06-21 16:20:00 70 [Note] Forcefully disconnecting 0 remaining clients 2016-06-21 16:20:00 70 [Note] Binlog end 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'partition' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_METRICS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_TRX' 2016-06-21 16:20:00 70 [Note] Shutting down plugin 'InnoDB' 2016-06-21 16:20:00 70 [Note] InnoDB: FTS optimize thread exiting. 2016-06-21 16:20:00 70 [Note] InnoDB: Starting shutdown... 2016-06-21 16:20:01 70 [Note] InnoDB: Shutdown completed; log sequence number 1625997 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'ARCHIVE' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'BLACKHOLE' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'MRG_MYISAM' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'MyISAM' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'MEMORY' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'CSV' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'sha256_password' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'mysql_old_password' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'mysql_native_password' 2016-06-21 16:20:01 70 [Note] Shutting down plugin 'binlog' 2016-06-21 16:20:01 70 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: Shutdown complete ---> 16:20:02 Cleaning up environment variables MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE and MYSQL_ROOT_PASSWORD ... ---> 16:20:02 Running final exec -- Only MySQL server logs after this point 2016-06-21 16:20:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-06-21 16:20:02 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 1 ... 2016-06-21 16:20:02 1 [Note] Plugin 'FEDERATED' is disabled. 2016-06-21 16:20:02 6c4828a2d840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2016-06-21 16:20:02 1 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-06-21 16:20:02 1 [Note] InnoDB: The InnoDB memory heap is disabled 2016-06-21 16:20:02 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-06-21 16:20:02 1 [Note] InnoDB: Memory barrier is not used 2016-06-21 16:20:02 1 [Note] InnoDB: Compressed tables use zlib 1.2.7 2016-06-21 16:20:02 1 [Note] InnoDB: Using Linux native AIO 2016-06-21 16:20:02 1 [Note] InnoDB: Using CPU crc32 instructions 2016-06-21 16:20:02 1 [Note] InnoDB: Initializing buffer pool, size = 32.0M 2016-06-21 16:20:02 1 [Note] InnoDB: Completed initialization of buffer pool 2016-06-21 16:20:02 1 [Note] InnoDB: Highest supported file format is Barracuda. 2016-06-21 16:20:02 1 [Note] InnoDB: 128 rollback segment(s) are active. 2016-06-21 16:20:02 1 [Note] InnoDB: Waiting for purge to start 2016-06-21 16:20:02 1 [Note] InnoDB: 5.6.26 started; log sequence number 1625997 2016-06-21 16:20:02 1 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work. 2016-06-21 16:20:02 1 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work. 2016-06-21 16:20:02 1 [Note] Server hostname (bind-address): '*'; port: 3306 2016-06-21 16:20:02 1 [Note] IPv6 is available. 2016-06-21 16:20:02 1 [Note] - '::' resolves to '::'; 2016-06-21 16:20:02 1 [Note] Server socket created on IP: '::'. 2016-06-21 16:20:02 1 [Warning] 'user' entry 'root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:02 1 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:02 1 [Warning] 'proxies_priv' entry '@ root@mysql-1-irei5' ignored in --skip-name-resolve mode. 2016-06-21 16:20:02 1 [Note] Event Scheduler: Loaded 0 events 2016-06-21 16:20:02 1 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: ready for connections. Version: '5.6.26' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) From: bpar...@redhat.com Date: Tue, 21 Jun 2016 11:20:22 -0400 Subject: Re: MySQL: Readiness probe failed To: dencow...@hotmail.com CC: users@lists.openshift.redhat.com can you provide the logs from the postgres pod? On Tue, Jun 21, 2016 at 10:44 AM, Den Cowboy <dencow...@hotmail.com> wrote: I'm using the MySQL template and started it with the right environment variables The MySQL is running fine but I got this error and I'm not able to access my mysql on its service name: mysql -u myuser -h mysql -p password:xxx Readiness probe failed: sh: cannot set terminal process group (-1): Inappropriate ioctl for device sh: no job control in this shell ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) _______________________________________________ users mailing list users@lists.openshift.redhat.com http://lists.openshift.redhat.com/openshiftmm/listinfo/users -- Ben Parees | OpenShift
_______________________________________________ users mailing list users@lists.openshift.redhat.com http://lists.openshift.redhat.com/openshiftmm/listinfo/users
