Is there a way to reset root@localdomain.localhost's password

[jbuntain-alltech]

Outside of logging into the admin portal that is. I have taken over a linshare install from someone who has left the company, and the password in our records is not working. I note that if I try to many times, the lockout timeout can get pretty large, so I'm hoping for a way to reset the password short of reinstalling the whole system (and presumably losing the many secure files our users are sharing).

Thanks!

[lacrimal]

postgres - replace password hash with known hash

[jbuntain-alltech]

Thanks, I'll give that a go!

[jbuntain-alltech]

Hrm. I can't find root@localhost.localdomain in either the postgres or linshare databases under the database docker container. All I see is a linshare user in the pg_users table. Presumably, there is... an account table somewhere? If so, I am having trouble finding it. Am I looking in the wrong place?

linshare=# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges
-----------+----------+----------+------------+------------+-----------------------
 linshare  | linshare | UTF8     | en_US.utf8 | en_US.utf8 |
 postgres  | linshare | UTF8     | en_US.utf8 | en_US.utf8 |
 template0 | linshare | UTF8     | en_US.utf8 | en_US.utf8 | =c/linshare          +
           |          |          |            |            | linshare=CTc/linshare
 template1 | linshare | UTF8     | en_US.utf8 | en_US.utf8 | =c/linshare          +
           |          |          |            |            | linshare=CTc/linshare
(4 rows)

linshare=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of
-----------+------------------------------------------------------------+-----------
 linshare  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

looking at the databases under the linshare-database:4.1 docker container.

[fabienmoyon]

Hello @jbuntain-alltech,

did you found the solution ?

Regards, Fabien

[jbuntain-alltech]

No, haven't figured out where that password is stored. At some point, we will have to tear down our linshare installation and reinstall, just have to find when we can afford to lose all the files in it.

On Fri, Mar 3, 2023 at 9:21 AM Fabien Moyon @.***> wrote:

Hello @jbuntain-alltech https://github.com/jbuntain-alltech,

did you found the solution ?

Regards, Fabien

— Reply to this email directly, view it on GitHub https://github.com/linagora/linshare/issues/260#issuecomment-1453690586, or unsubscribe https://github.com/notifications/unsubscribe-auth/A2WTDPCCUENVMB7BZ4EQIXTW2ID7LANCNFSM6AAAAAATXIOPME . You are receiving this because you were mentioned.Message ID: @.***>

-- *-------------------------------------------------------------------------------------------------------- CONFIDENTIALITY NOTICE:

The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited. *

[matdemb]

Hi, in database linshare, table account, the user with id 1with mail root@localhost.localdomain in a normal installation (not a docker one but probably the same).

[jbuntain-alltech]

Hi, in database linshare, table account, the user with id 1with mail root@localhost.localdomain in a normal installation (not a docker one but probably the same).

There it is! Thank you for that, I was looking in completely the wrong place. Now to figure out how to get a password encrypted properly and put in there. But this was a big help!