Skip to content
Back

[SOLVED] Can not migrate

  • 0
  • Self Hosted
  • General
danilo73
12 Apr, 2023, 20:25

I got this error when trying to migrate (I have appwrite in WSL):

SQLSTATE[HY000] [1045] Access denied for user 'admin'@'ip'

TL;DR
User encountered an issue with migration in Appwrite. The problem was solved by running "docker compose down" and then up again, followed by the command "docker compose exec appwrite migrate". The user had encountered the error because they started the migration process without turning down Docker compose. The user also mentioned an error related to Traefik and MariaDB logs. The cause of the issue was identified and resolved. The user also compared the .env file and the backup file for MariaDB variables. The user provided information about their folder structure and the steps they followed to upgrade. They encountered an error related to access denied for the user 'admin
Drake
12 Apr, 2023, 20:26

Where did you run the upgrade command? What's in your appwrite folder?

danilo73
12 Apr, 2023, 20:29

i have this folder struct:
dev/ appwrite/ .env docker-compose.yml

I followed instructions here: (https://appwrite.io/docs/upgrade) appwrite 1.21 was running (docker compose) then I run "docker run -it ..." in dev folder then "docker compose exec appwrite migrate" inside appwrite folder

Drake
12 Apr, 2023, 20:36

is this exactly what's in the appwrite folder now? or are there more files?

danilo73
12 Apr, 2023, 20:37

there are more .backup files (one for .env, one for docker-compose)

Drake
12 Apr, 2023, 20:38

ok that's good. and appwrite is online and running fine?

can you check the .env file and the backup one to compare the mariadb variables?

danilo73
12 Apr, 2023, 20:40

yeah both env files contain same variables. appwrite dont work, returns "Bad Gateway" when trying to connect localhost

Drake
12 Apr, 2023, 20:41

what are the logs for that container?

danilo73
12 Apr, 2023, 20:47

the log for traefik is: level=error msg=the router appwrite_realtime_wss@docker uses a non-existent resolver: dns\n","stream":"stdout",

the log for mariadb is: [Warning] Access denied for user 'admin'@'172.27.0.17' (using password: YES)

Drake
12 Apr, 2023, 21:01

i meant the appwrite container

danilo73
12 Apr, 2023, 21:08

oh, sorry

127.0.0.1 is not a publicly accessible domain. Skipping SSL certificate generation.

Drake
12 Apr, 2023, 21:08

that line can be ignored

danilo73
12 Apr, 2023, 21:11

it works now. I run "docker compose down" then up again and it let me run the command "docker compose exec appwrite migrate" Maybe the error appear cause i start the migration process without turning down docker compose

Thank you @Steven

danilo73
12 Apr, 2023, 21:12

[SOLVED] Can not migrate

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more