Permission denied

[moarf56]

Hi,

I want to install ampache via docker but I have this error message :

Error: Unable to make database connection: SQLSTATE[HY000] [2002] Permission denied

The issue star on page 3 when the install ask me "MYSQL username........." I foolow the installation guide and when I clic on "insert database" the message come on the same page.

I use docker on the last Open Media Vault version.

Thx :d

[lachlan-00]

updated build today, try that again

[no95typem]

I experienced the same problem today. Solved by manually creating a mysql user via the command line. I thought the problem was in the% symbol in the related script:
mysql -uroot -e "CREATE USER 'admin'@'%' IDENTIFIED BY '$PASS'"
But I was wrong when I replaced % with localhost and tried to create the container again I had to manually create the mysql user again too. So I don't understand what the problem is.

[lachlan-00]

i'll do some new installs and test out

[marker5a]

any luck on this? Trying to get mine up and running and it fails miserably during setup due to the same issue

[didi-home]

Actually, @no95typem is right - the user creation is incorrect, it should be "localhost".

I logged into the container via "docker exec -it /bin/bash":
started mysql shell via "mysql"

use mysql;
UPDATE user SET Host = "localhost" WHERE user.User = "admin";
flush privileges;

After that, the installer runs correctly 👍

[didi-home]

I experienced the same problem today. Solved by manually creating a mysql user via the command line. I thought the problem was in the% symbol in the related script:
mysql -uroot -e "CREATE USER 'admin'@'%' IDENTIFIED BY '$PASS'"
But I was wrong when I replaced % with localhost and tried to create the container again I had to manually create the mysql user again too. So I don't understand what the problem is.

Did you re-create the docker image? Since the create script is baked into the image, you'd have to "docker build" your own image after the change, not only "docker run" a new container...

[no95typem]

Did you re-create the docker image? Since the create script is baked into the image, you'd have to "docker build" your own image after the change, not only "docker run" a new container...

Yes, I did not recreate the image - this is my mistake.

[marker5a]

Actually, @no95typem is right - the user creation is incorrect, it should be "localhost".

I logged into the container via "docker exec -it /bin/bash":
started mysql shell via "mysql"

use mysql;
UPDATE user SET Host = "localhost" WHERE user.User = "admin";
flush privileges;

After that, the installer runs correctly

Worked for me! Thanks!!!