Alex helped me with the lost password of the CMS running on Docker for Windows on my local PC.
Eventually, I managed to reset the password, and I could log in into the CMS.
Once logged in, I discovered that al my layouts, campaigns and other settings were gone. I don’t know why.
Looking in the folder C:\xibo\shared\cms\library shows me all the data is still there:
Then, I restarted the computer, and to my surprise, I could not log in, again!
It seems that somehow the old user is back again, and I don’t know the password for this user.
There is a bug with Docker for Windows that requires you to restart the containers after you have rebooted Windows. It is mentioned in the below manual in the Special Considerations section:
You will need to restart Docker, then the containers and then apply the password reset fix that Alex described. This will then save the changes made as well as reveal your Layouts and Media in your CMS. If you do not do this first, the changes will be temporary and so will revert when you access the container again.
If this does not fix the issue, you will need to stop the container, unshare and reshare the C: Drive in your Docker settings an then start the container again.
Windows PowerShell
Copyright (C) Microsoft Corporation. All rights reserved.
PS C:\Users\Peter> cd \xibo
PS C:\xibo> docker-compose stop
Stopping xibo_cms-web_1 … done
Stopping xibo_cms-xmr_1 … done
Stopping xibo_cms-db_1 … done
PS C:\xibo> docker-compose start
Starting cms-db … done
Starting cms-xmr … done
Starting cms-web … done
PS C:\xibo> docker exec -it xibo_cms-web_1 bash
bash-4.3# mysql -u cms -h mysql -p cms
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.6.40 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MySQL [cms]> UPDATE user set UserPassword = MD5(“password”), CSPRNG = 0 WHERE UserID = 1 LIMIT 1; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0
But now something else strange happens, the password reset is not accepted.
So, login in with user: xibo_admin and password: password doesn’t work.
In the sql statement you have used, the quotes around password appear to be gendered. You will need to use the " quotes instead. I have successfully changed my password (in this example to test) using the below statement:
UPDATE user set UserPassword = MD5(“test”), CSPRNG = 0 WHERE UserID = 1 LIMIT 1;
If this still does not work, can you send me the output from SELECT userid,username FROM user;
