deploy MYSQL on Openshift using Template

[anilkumar panditi]

Hi,
I am trying to install MYSQL on Openshift using following Template.

https://github.com/sclorg/mysql-container/blob/master/imagestreams/mysql-rhel.json

i am getting following error.

ysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
2021-07-20T13:24:03.415735Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-20T13:24:03.415892Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2021-07-20T13:24:03.416006Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 39
2021-07-20T13:24:03.419345Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2021-07-20T13:24:03.419376Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2021-07-20T13:24:03.419931Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-20T13:24:03.420161Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.

Any Idea? Please help

[J.O. Aho]

Post by anilkumar panditi
Hi,
I am trying to install MYSQL on Openshift using following Template.
https://github.com/sclorg/mysql-container/blob/master/imagestreams/mysql-rhel.json

I'm no Openshift user, so will not be able to advice on the changes you
would need in the template itself.

Post by anilkumar panditi
i am getting following error.
ysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
2021-07-20T13:24:03.415735Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-20T13:24:03.415892Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2021-07-20T13:24:03.416006Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 39
2021-07-20T13:24:03.419345Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2021-07-20T13:24:03.419376Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/data/mysqld_tmp_file_case_insensitive_test.lower-test
2021-07-20T13:24:03.419931Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-20T13:24:03.420161Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.
Any Idea? Please help

The main issue seems to be that the user as the mysql is run do not have
the read/write privileges to the files it needs to write to.

You also use a symlink, which can cause issues, for example say you
symlink /root/mysql to be /var/lib/mysql, then the mysql user will not
be able to follow the symlink into the /root directory (no matter if the
mysql user owns the /root/mysql directory).


If you must keep the data out of /var/lib/mysql, then consider using
"bind mount" or update your /etc/my.cnf to have the new path.

Also if your data is outside the virtual instance file system, then you
need to see to that the directory is readable (and accessible) by the
openshift service.