1. Forum
  2. USENET
  3. comp.databases.mysql

  • deploy MYSQL on Openshift using Template

    From anilkumar panditi@anilkumar.panditi@gmail.com to comp.databases.mysql on Tue Jul 20 06:26:54 2021
    From Newsgroup: comp.databases.mysql

    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
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From J.O. Aho@user@example.net to comp.databases.mysql on Tue Jul 20 16:56:38 2021
    From Newsgroup: comp.databases.mysql

    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
    --- Synchronet 3.21d-Linux NewsLink 1.2