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]

On 20/07/2021 15.26, anilkumar panditi wrote:
> 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.

> 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.


--

//Aho