V3_v4 migration: Select gateways errorpq: password authentication failed for user "root"


While running the v3-v4 migration script, I get the following error

2023/12/18 16:22:47 Reading ChirpStack configuration file: /etc/chirpstack/chirpstack.toml
2023/12/18 16:22:47 Reading AS configuration file: /etc/chirpstack-application-server/chirpstack-application-server.toml
2023/12/18 16:22:47 Start migration
2023/12/18 16:22:47 Deleting users and tenants from target database
2023/12/18 16:22:47 Migrating users
2023/12/18 16:22:47 Migrating organizations
2023/12/18 16:22:47 Migrating organization users
2023/12/18 16:22:47 Migrating applications
2023/12/18 16:22:47 Migrating application integrations
2023/12/18 16:22:47 Reading NS configuration file: /etc/chirpstack-network-server/chirpstack-network-server-eu868.toml
2023/12/18 16:22:47 Migrating region: EU868
2023/12/18 16:22:47 Migrating gateways
2023/12/18 16:22:47 Select gateways errorpq: password authentication failed for user “root”

I can’t get a clue about that requested root password.
I run latest versions of the different components

Any idea ?
Thank you

It is almost entirely certain that root isn’t the user you want for your PostgreSQL database. It is likely postgres or chirpstack, depending on your configuration.

I would look into how you have your credentials set up for the migration.

Thank you for your feedback.

It made me looking closer and indeed … My call to the v3-v4 migratio script was not provinding the right configuration file in the argumenrts … My bad :frowning:

So now I get another issue (“Exec device-profile statement errorpq: value “2555555555” is out of range for type integer”) but I have to dig a bit into it before possibly coming back to the forum.