The table user is a reserved one in postgres. As you can see, when querying it, it’ll show the current logged user, in this case loraserver_as. In order to get the loraserver_as’s DB user table, you must query it with quotes, i.e.:
select * from "user";
When updating the admin user, you must do the same.
UPDATE "user" SET password_hash= 'PBKDF2$sha512$100000$4u3hL8krvlMIS0KnCYXeMw==$G7c7tuUYq2zSJaUeruvNL/KF30d3TVDORVD56wzvJYmc3muWjoaozH8bHJ7r8zY8dW6Pts2bWyhFfkb/ubQZsA==' WHERE username='admin';
this is postgresql command. you need to connect to exact database and make insert. how to connect described in installation guide on the main site docs.
With the change to the Chirpstack user tables, the command to reset the admin user password becomes:
UPDATE “user” SET password_hash= ‘PBKDF2$sha512$100000$4u3hL8krvlMIS0KnCYXeMw==$G7c7tuUYq2zSJaUeruvNL/KF30d3TVDORVD56wzvJYmc3muWjoaozH8bHJ7r8zY8dW6Pts2bWyhFfkb/ubQZsA==’ WHERE email=‘admin’;
Hi, tried this. Bot no way to reset my admin password.
chirpstack=# UPDATE “user” SET password_hash=‘PBKDF2$sha512$100000$4u3hL8krvlMIS0KnCYXeMw==$G7c7tuUYq2zSJaUeruvNL/KF30d3TVDORVD56wzvJYmc3muWjoaozH8bHJ7r8zY8dW6Pts2bWyhFfkb/ubQZsA==’ WHERE email=‘admin’;
UPDATE 1
But it does not work. I’ve installed the Debian version with latest updates.