Message-ID:

"Pay no attention to the man behind the curtain." -- The Wizard Of Oz

devel / comp.databases.mysql / deploy MYSQL on Openshift using Template

deploy MYSQL on Openshift using Template

<84039d8b-2089-4132-a5ae-374f47121fabn@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=21&group=comp.databases.mysql#21

copy link Newsgroups: comp.databases.mysql

X-Received: by 2002:a05:6214:4102:: with SMTP id kc2mr29986885qvb.44.1626787615120;
Tue, 20 Jul 2021 06:26:55 -0700 (PDT)
X-Received: by 2002:a05:6214:3004:: with SMTP id ke4mr21415281qvb.52.1626787614783;
Tue, 20 Jul 2021 06:26:54 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.mysql
Date: Tue, 20 Jul 2021 06:26:54 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=2409:4070:2e00:e070:cc28:423d:2920:f39a;
posting-account=p6I3jwoAAAAWxaH4I628YJx0zNmnROw3
NNTP-Posting-Host: 2409:4070:2e00:e070:cc28:423d:2920:f39a
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <84039d8b-2089-4132-a5ae-374f47121fabn@googlegroups.com>
Subject: deploy MYSQL on Openshift using Template
From: anilkuma...@gmail.com (anilkumar panditi)
Injection-Date: Tue, 20 Jul 2021 13:26:55 +0000
Content-Type: text/plain; charset="UTF-8"

by: anilkumar panditi - Tue, 20 Jul 2021 13:26 UTC

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

Re: deploy MYSQL on Openshift using Template

<ilo6h6F5k2oU1@mid.individual.net>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=22&group=comp.databases.mysql#22

copy link Newsgroups: comp.databases.mysql

Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: use...@example.net (J.O. Aho)
Newsgroups: comp.databases.mysql
Subject: Re: deploy MYSQL on Openshift using Template
Date: Tue, 20 Jul 2021 16:56:38 +0200
Lines: 43
Message-ID: <ilo6h6F5k2oU1@mid.individual.net>
References: <84039d8b-2089-4132-a5ae-374f47121fabn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net PWpX3obfBDmXTRpQLXMTKgUKU5b3upBFa//pfFXCHvi38GWmsm
Cancel-Lock: sha1:j6mMqXFRlLlG8zFJVkmNICBanyo=
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
Thunderbird/78.12.0
In-Reply-To: <84039d8b-2089-4132-a5ae-374f47121fabn@googlegroups.com>
Content-Language: en-US-large

by: J.O. Aho - Tue, 20 Jul 2021 14:56 UTC

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

Subject	Author
deploy MYSQL on Openshift using Template	anilkumar panditi
Re: deploy MYSQL on Openshift using Template	J.O. Aho