Hi,
I am installing Honolulu 8.0.0 version of OOM/Portal.
I am still facing this issue.
2021-08-24 21:08:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started. 2021-08-24 21:08:27 0 [Note] mysqld (mysqld 10.5.5-MariaDB-1:10.5.5+maria~focal) starting as process 1 ... 2021-08-24 21:08:27 0 [Note] InnoDB: Using Linux native AIO 2021-08-24 21:08:27 0 [Note] InnoDB: Uses event mutexes 2021-08-24 21:08:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-24 21:08:27 0 [Note] InnoDB: Number of pools: 1 2021-08-24 21:08:27 0 [Note] InnoDB: Using SSE4.2 crc32 instructions 2021-08-24 21:08:27 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2021-08-24 21:08:27 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2021-08-24 21:08:27 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-24 21:08:27 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-08-24 21:08:28 0 [Note] InnoDB: 128 rollback segments are active. 2021-08-24 21:08:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-24 21:08:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-24 21:08:55 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-08-24 21:08:55 0 [Note] InnoDB: 10.5.5 started; log sequence number 42315; transaction id 15 2021-08-24 21:08:55 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-24 21:08:55 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-08-24 21:08:55 0 [Note] Server socket created on IP: '::'. 2021-08-24 21:08:55 0 [Note] InnoDB: Buffer pool(s) load completed at 210824 21:08:55 2021-08-24 21:08:55 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 2021-08-24 21:08:55 0 [Note] Reading of all Master_info entries succeeded 2021-08-24 21:08:55 0 [Note] Added new Master_info '' to hash table 2021-08-24 21:08:55 0 [Note] mysqld: ready for connections. Version: '10.5.5-MariaDB-1:10.5.5+maria~focal' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2021-08-24 21:16:03 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.31.58.193' (This connection closed normally without authentication) 2021-08-24 21:16:04 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.31.58.193' (This connection closed normally without authentication) 2021-08-24 21:16:10 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '10.42.2.29' (This connection closed normally without authentication)
Error running kubectl exec command.
oom/kubernetes$ kubectl -n onap exec -it onap-portal-db-85764f97fd-rqdzw -- mysql -D mysql -h localhost -e 'select * from user' Defaulted container "portal-db" out of: portal-db, volume-permissions (init) ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NO) command terminated with exit code 1
Logged into the container itself.
mysql@onap-portal-db-85764f97fd-rqdzw:/$ mysql -vv --user=root --password=Aaxxxxxx ERROR 1130 (HY000): Host '172.31.58.193' is not allowed to connect to this MariaDB server
- relates to
-
PORTAL-399 ERROR 1130 (HY000): Host '10.42.218.198' is not allowed to connect to this MariaDB server - PORTAL-498/399
- Reopened