linkwarden / linkwarden

⚡️⚡️⚡️Self-hosted collaborative bookmark manager to collect, organize, and preserve webpages, articles, and more...
https://linkwarden.app
GNU Affero General Public License v3.0
8.06k stars 310 forks source link

Error: P1013: The provided database string is invalid. invalid port number in database URL #519

Open PaulMcF1987 opened 7 months ago

PaulMcF1987 commented 7 months ago

I have tried various different tweaks but unable to get Linkwarden running on Docker

Error: P1013: The provided database string is invalid. invalid port number in database URL

postgres-1    | 
postgres-1    | PostgreSQL Database directory appears to contain a database; Skipping initialization
postgres-1    | 
postgres-1    | 2024-03-13 15:45:31.983 UTC [1] LOG:  starting PostgreSQL 16.2 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20231014) 13.2.1 20231014, 64-bit
postgres-1    | 2024-03-13 15:45:31.983 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
postgres-1    | 2024-03-13 15:45:31.983 UTC [1] LOG:  listening on IPv6 address "::", port 5432
postgres-1    | 2024-03-13 15:45:32.148 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres-1    | 2024-03-13 15:45:32.328 UTC [24] LOG:  database system was shut down at 2024-03-13 15:45:10 UTC
postgres-1    | 2024-03-13 15:45:32.385 UTC [1] LOG:  database system is ready to accept connections
linkwarden-1  | yarn run v1.22.19
linkwarden-1  | $ /data/node_modules/.bin/prisma migrate deploy
linkwarden-1  | Prisma schema loaded from prisma/schema.prisma
linkwarden-1  | Datasource "db": PostgreSQL database
linkwarden-1  | 
linkwarden-1  | Error: P1013: The provided database string is invalid. invalid port number in database URL. Please refer to the documentation in https://www.prisma.io/docs/reference/database-reference/connection-urls for constructing a correct connection string. In some cases, certain characters must be escaped. Please check the string for any illegal characters.
linkwarden-1  | info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
linkwarden-1  | error Command failed with exit code 1.
linkwarden-1 exited with code 0
linkwarden-1  | yarn run v1.22.19
linkwarden-1  | $ /data/node_modules/.bin/prisma migrate deploy
linkwarden-1  | Prisma schema loaded from prisma/schema.prisma
linkwarden-1  | Datasource "db": PostgreSQL database
linkwarden-1  | 
linkwarden-1  | Error: P1013: The provided database string is invalid. invalid port number in database URL. Please refer to the documentation in https://www.prisma.io/docs/reference/database-reference/connection-urls for constructing a correct connection string. In some cases, certain characters must be escaped. Please check the string for any illegal characters.
linkwarden-1  | error Command failed with exit code 1.
linkwarden-1  | info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
linkwarden-1 exited with code 0
linkwarden-1  | yarn run v1.22.19
linkwarden-1  | $ /data/node_modules/.bin/prisma migrate deploy
linkwarden-1  | Prisma schema loaded from prisma/schema.prisma
linkwarden-1  | Datasource "db": PostgreSQL database
linkwarden-1  | 
linkwarden-1  | Error: P1013: The provided database string is invalid. invalid port number in database URL. Please refer to the documentation in https://www.prisma.io/docs/reference/database-reference/connection-urls for constructing a correct connection string. In some cases, certain characters must be escaped. Please check the string for any illegal characters.
linkwarden-1  | error Command failed with exit code 1.
linkwarden-1  | info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
linkwarden-1 exited with code 0
linkwarden-1  | yarn run v1.22.19
linkwarden-1  | $ /data/node_modules/.bin/prisma migrate deploy
linkwarden-1  | Prisma schema loaded from prisma/schema.prisma
linkwarden-1  | Datasource "db": PostgreSQL database
linkwarden-1  | 
linkwarden-1  | Error: P1013: The provided database string is invalid. invalid port number in database URL. Please refer to the documentation in https://www.prisma.io/docs/reference/database-reference/connection-urls for constructing a correct connection string. In some cases, certain characters must be escaped. Please check the string for any illegal characters.
linkwarden-1  | error Command failed with exit code 1.

And the above list just keeps repeating

I followed the instructions Here

I did not change the YML file in any way. I added created a password for NEXTAUTH_SECRET and POSTGRES_PASSWORD I have played about with the NEXTAUTH_URL in case that made a difference but it didnt.

Has anyone else faced this issue? what is the recommended fix?

diogovbs commented 7 months ago

I'm having the same issue, didn't change anything

cool012 commented 7 months ago

Database passwords can't include special characters, which solved my problem