Page MenuHomePhabricator

Unable to locate or set MariaDB password
Closed, ResolvedPublic

Description

I setup a test environment with Wikibase client, everything seems tobe working fine, so I tried to move to the next step by importing data.
I wanted to import in this test environment a DB backup from my current production Wikibase so I read the "Can I migrate from another Wikibase installation to WBS Deploy?" paragraph, but I think the instructions are a bit tight there.

First of all, I found myself unable to access the MariaDB server. Every time I try to run the MySQL client with the docker exec command I keep receiving a "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)".
Because of the MYSQL_RANDOM_ROOT_PASSWORD: yes setting, I know I should have found a password in the MariaDB's container log, but I was unable to find it also following instructions here https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html#docker-starting-mysql-server . So I modified the .env and docker-compose.yml to use custom root password (not good security practice, I know, but this is only for testing): it was successfully set (properly shown using ENV command) but still I can't access. Also using the less privileged user set in .env for the Wikibase database results in the "access denied" error as above.

Can anyone help with this two issues? Thanks in advance

Event Timeline

Hi Luca,

First off, we're sorry for the trouble and lack of speedy response this month! December has been really quiet here with most of the team out sick or on vacation.

I just tried it to confirm just now, and I do see the generated root password on the first boot of the mysql (MariaDB) service. The log entry looked like this: 2025-01-02 16:41:03+00:00 [Note] [Entrypoint]: GENERATED ROOT PASSWORD: ----------------

Where I think things have gone wrong for you is that this password will only show on the first boot of the container and never again afterward. To see it, you will need to start over by fully resetting your Deploy services and data according to the instructions found here:
https://github.com/wmde/wikibase-release-pipeline/blob/main/deploy/README.md#removing-wikibase-suite-completely-with-all-its-data

I hope this gets you going, and please do let us know here if not. We will be keeping an eye out and should be able to respond much more promptly. If this does get you going and you think of it, it would be helpful to hear back that you're back on course.

Happy New Year!

Loren Johnson
Wikibase Suite Team