After upgrading to 1.4.5, this error shows: | Appwrite | Page 1

crimson halo Oct 10, 2023, 9:13 PM

#

Unable to parse DSN: mariadb://user:...```

#

The password contains characters like } ] ) ; *

#

After downgrading to 1.3.7, this shows

Starting Data Migration to version 1.3.7

Warning: Redis::pconnect(): php_network_getaddresses: getaddrinfo failed: Try again in /usr/src/code/app/init.php on line 650
php_network_getaddresses: getaddrinfo failed: Try again

novel jolt Oct 10, 2023, 9:22 PM

#

Check and follow this

crimson halo Oct 10, 2023, 9:46 PM

#

So I can call docker compose up -d without having migrated yet?

novel jolt Oct 10, 2023, 9:46 PM

#

That for sure

#

Also it's recommend to upgrade and migrate to 1.3.8 first

crimson halo Oct 10, 2023, 10:35 PM

#

Updating to 1.3.8 and docker compose down && docker compose up -d didn't help. Same error afterwards.

#

Also the fix to you've sent me the link to was regarding the appwrite migrate for 1.3.7, which is not the main issue. Was just funny that it couldn't migrate to the same version. The main (first) error is with 1.4.5.

novel jolt Oct 10, 2023, 10:42 PM

#

The restarting of the compose should remove the first error

crimson halo Oct 10, 2023, 10:42 PM

#

Didn't help 😦

#

Everything that I need works well with 1.3.8, so I'll just try upgrading some other time.
Thanks for your effort and help ❤️

crimson halo Mar 7, 2024, 10:38 PM

#

I still have the same error when upgrading to 1.4.13

strong topaz Mar 7, 2024, 11:32 PM

#

crimson halo I still have the same error when upgrading to 1.4.13

What was your upgrading procedure?

#

Do you have backups?

crimson halo Mar 7, 2024, 11:33 PM

#

Yes. I just finished recovering from the backup.

strong topaz Mar 7, 2024, 11:34 PM

#

And now it works?

#

What's the version you have?

crimson halo Mar 7, 2024, 11:36 PM

#

1.3.8

This is my upgrade procedure (I tried with 1.4.5 before, and today with 1.4.13)

docker pull appwrite/appwrite:1.3.8

docker run -it --rm
--volume /var/run/docker.sock:/var/run/docker.sock
--volume "$(pwd)"/appwrite:/usr/src/code/appwrite:rw
--entrypoint="install"
appwrite/appwrite:1.3.8

cd appwrite

(When upgrading major or minor version:)
docker compose exec appwrite migrate

docker compose up -d

#

I used this script: https://gist.github.com/Meldiron/47b5851663668102a676aff43c6341f7

It worked, but I guess, the sql users were not recovered. I will just restore from the DigitalOcean backup...

strong topaz Mar 7, 2024, 11:43 PM

#

crimson halo I used this script: https://gist.github.com/Meldiron/47b5851663668102a676aff43c6...

I recommend Steven's backup procedure in the future: https://youtu.be/lM5yZEPtlvg?si=G-4HowqXCQvzLCcX

YouTube

Appwrite

Backing Up and Restoring an Appwrite Server

Appwrite is a self-hosted backend-as-a-service platform that provides developers with all the core APIs required to build any application.

It's a good practice to backup your Appwrite server data regularly if you need to restore it later.

Backup/Restore scripts: https://gist.github.com/stnguyen90/fee636ff652b8ecbf761935b2aa254fb

Backup Notes...

▶ Play video

crimson halo Mar 7, 2024, 11:46 PM

#

But is the bug known that I got after every upgrading to 1.4.x?

Unable to parse DSN: mariadb://user:...

strong topaz Mar 7, 2024, 11:46 PM

#

crimson halo 1.3.8 This is my upgrade procedure (I tried with 1.4.5 before, and today with 1...

So from 1.3.8, you should run:

    --volume /var/run/docker.sock:/var/run/docker.sock \
    --volume "$(pwd)"/appwrite:/usr/src/code/appwrite:rw \
    --entrypoint="upgrade" \
    appwrite/appwrite:1.4.13

That command in the main folder, not in the Appwrite install folder.

Then run the migration command:

docker compose exec appwrite migrate
``` (In the appwrite folder)

#

And yes, it's directly to latest patch

crimson halo Mar 7, 2024, 11:47 PM

#

That's exactly what I pasted above, no?

strong topaz Mar 7, 2024, 11:48 PM

#

crimson halo That's exactly what I pasted above, no?

You ran "install" entrypoint instead and also it's 1.3.8 and not 1.4.
From what I understand you're with 1.3.8, right?

crimson halo Mar 7, 2024, 11:48 PM

#

Yes, obviously I replaced the version with the one I installed

So the entrypoint could have been the issue?

#

It worked many times before lol

strong topaz Mar 7, 2024, 11:49 PM

#

Maybe. No idea

open nexus Mar 7, 2024, 11:50 PM

#

crimson halo The password contains characters like `} ] ) ; *`

hmmmm can you try url encoding the password?

#

if that doesn't work, you might need to change the password 😬

crimson halo Mar 7, 2024, 11:50 PM

#

How to encode it

#

Am I the only one with special characters in the pw

strong topaz Mar 7, 2024, 11:51 PM

#

Wait, but you're not able to make it run even in older versions?

crimson halo Mar 7, 2024, 11:51 PM

#

1.3.8 works. I use Appwrite for a long time.

But any upgrade to 1.4.x failed.

I'm trying with the correct entrypoint now...

#

Is this a yes?

Previous installation found, do you want to overwrite it (a backup will be created before overwriting)? (Y/n)

strong topaz Mar 7, 2024, 11:53 PM

#

Do you have made a backup prior to this?

open nexus Mar 7, 2024, 11:54 PM

#

crimson halo How to encode it

in PHP: https://www.php.net/manual/en/function.urlencode.php

I think this is the JS one: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/encodeURIComponent

crimson halo Mar 7, 2024, 11:54 PM

#

No, as I just recovered it from the DigitalOcean backup, and will do it again if it fails

#

I recovered via the script mentioned above, which worked after a few attempts, but my sql users weren't able to connect

strong topaz Mar 7, 2024, 11:55 PM

#

crimson halo Is this a yes? Previous installation found, do you want to overwrite it (a back...

This is yes (Y)

crimson halo Mar 7, 2024, 11:55 PM

#

Thanks, it's running

strong topaz Mar 7, 2024, 11:56 PM

#

After it, it won't work. Run after

docker compose exec appwrite migrate

crimson halo Mar 7, 2024, 11:56 PM

#

Same error, the entrypoint change didn't help

strong topaz Mar 7, 2024, 11:57 PM

#

crimson halo Same error, the entrypoint change didn't help

Where do you got the error?

crimson halo Mar 7, 2024, 11:57 PM

#

migrate

strong topaz Mar 7, 2024, 11:57 PM

#

When running the docker exec appwrite migrate?

crimson halo Mar 7, 2024, 11:57 PM

#

If it's because of the special characters in the pw, maybe there could be a fix in the future

#

Yes

strong topaz Mar 7, 2024, 11:57 PM

#

crimson halo If it's because of the special characters in the pw, maybe there could be a fix ...

Then yes, that's probably the issue

crimson halo Mar 7, 2024, 11:57 PM

#

Appwrite installed successfully
root@api:~# cd appwrite
root@api:~/appwrite# docker compose exec appwrite migrate
Unable to parse DSN: mariadb://user...

strong topaz Mar 7, 2024, 11:57 PM

#

As Steven mentioned

#

Seems, yes, definitely the DB password 😅

crimson halo Mar 7, 2024, 11:58 PM

#

Ok so I'll wait for a fix

strong topaz Mar 7, 2024, 11:59 PM

#

You can change the DB password to something that doesn't contain special characters and then update the env var. It should work that way

crimson halo Mar 8, 2024, 12:00 AM

#

Okay

Do you think, in a future release there will be a fix for this issue?

strong topaz Mar 8, 2024, 12:01 AM

#

crimson halo Okay Do you think, in a future release there will be a fix for this issue?

No idea, but you will need to go through 1.4.13 prior to 1.5 for example

#

You can change the password, run migration, and then change the password to what it was initially

open nexus Mar 8, 2024, 12:18 AM

#

crimson halo Ok so I'll wait for a fix

i told you to encode the password

crimson halo Mar 8, 2024, 12:44 AM

#

And DS told me to change the passwords.

I changed (all 4) database passwords and was able to upgrade and to the migration.
If changed back, the migrate fails again.

Now it's running, the database connects, but the domain and its ip say bad gateway.

strong topaz Mar 8, 2024, 12:52 AM

#

crimson halo And DS told me to change the passwords. I changed (all 4) database passwords an...

Checck that the . env variable
_APP_DOMAIN actually have your domain

crimson halo Mar 8, 2024, 12:52 AM

#

Yes it has, and it also happens through the droplet's ip

strong topaz Mar 8, 2024, 12:53 AM

#

Could you send a screenshot of it?

crimson halo Mar 8, 2024, 12:53 AM

#

Of a blank page saying Bad Gateway at the top left?

strong topaz Mar 8, 2024, 12:54 AM

#

Okay, then I know what's it, thanks for the description 😅

#

What do you get when running
docker compose logs appwrite
?
And
docker compose logs traefik
?

#

In your appwrite installation folder

crimson halo Mar 8, 2024, 1:12 AM

#

Just restored the droplet again.

I really appreciate your super fast support, and the product, but I don't have time for fixing bugs when I don't actually need an upgrade.

open nexus Mar 8, 2024, 2:12 AM

#

crimson halo And DS told me to change the passwords. I changed (all 4) database passwords an...

You changed the password back and then things stopped working?

crimson halo Mar 8, 2024, 2:13 AM

#

The database was accessible. The user interface was not.

open nexus Mar 8, 2024, 2:14 AM

#

crimson halo The database was accessible. The user interface was not.

Maybe it was a cache problem

crimson halo Mar 8, 2024, 2:14 AM

#

I used incognito mode

jagged bough Mar 8, 2024, 2:16 AM

#

crimson halo I used incognito mode

Appwrite has internal caches

#After upgrading to 1.4.5, this error shows: