abinjohnedamanaabinjohnedamana MemberComments: 36 Received thanks: 8 Member since: February 2019 edited October 2019

Hi

I am trying to install shopware6 on ubuntu. I got the following error when I am trying to install using the command ./psh.phar install

"ERROR 2059 (HY000)Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/x86_64-linux-gnu/mariadb18/plugin/caching_sha2_password.so:
cannot open shared object file: No such file or directory

Execution aborted, a subcommand failed!"

I am using 

ubuntu 19.04

Php 7.2 

Mysql 5.7.27

I have tried this 

ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY 'password';

But not working.

Anyone can help me?

Answers

  • abinjohnedamanaabinjohnedamana MemberComments: 36 Received thanks: 8 Member since: February 2019

    Please follow the following instructions in order to complete the developer version installation

    1) You can skip the 'caching_sha2_password' issue by using MySQL 5.7.28 image in docker file (Mysql 8 is the cause of this error)

       dev-ops/docker/containers/mysql/Dockerfile FROM mysql:8 -> FROM mysql:5.7.28

    2) docker commands should run without sudo command

       check 
       "docker info" - If you got an error related to permission please run the following command

       "sudo chmod 666 /var/run/docker.sock" - Then check again "docker info"

       if it is ok please follow the installation.

    3) You need to set the permissions of the folders. (Installation will stop many times with permission issue message)

    4) Set permissions and continue the installation

    5) At last, it will be installed :-)

  • abinjohnedamanaabinjohnedamana MemberComments: 36 Received thanks: 8 Member since: February 2019

    Mysql 8 error can be solved by adding "command: --default-authentication-plugin=mysql_native_password" in docker-compose.yml in root folder.

    app_mysql:
    build: dev-ops/docker/containers/mysql
    environment:
    MYSQL_ROOT_PASSWORD: root
    MYSQL_USER: app
    MYSQL_PASSWORD: app
    command: --default-authentication-plugin=mysql_native_password

Sign In or Register to comment.