Solved Lost admin password

[z-enzo]

We have a site we are taking over that looks to be running 15.6 that currently does not have a valid backup.

They do not have a working admin password and we are trying to avoid rebuilding the PBX from scratch.

The password reset via failed login is also not working and we are not sure why. We can't access the management portal to find out.

I know it used to be possible to go into PostgreSQL and find or reset the password but I cannot find any info on how to actually do this. I got connected to the DB on the PBX but have no idea what I am looking for in there. I have physical access to the machine.

Is anyone here familiar with how to find or reset the admin password on 15.6 from PostgreSQL?

Again we do not have a valid backup to get the password from and can't do a failed login reset.

 

[Shawn]

I don't know the answer to your question but you could also login as an extension that has been given admin access. Do you know if any of the extensions there have been given access to the admin console along with admin rights? If so then that could be an avenue to reset the admin password, or at least get into the admin console and get somewhere there.

 

[cobaltit]

For obvious reasons 3CX doesn't post this information as well as deletes any posts that would contain this information. You likely won't be able to retrieve the password as it should be hashed for security. But it should be in a common sense place unless they intentionally buried it for security by obscurity reasons.

 

[z-enzo]

Shawn: I don't know if there were any admin extensions created since we never had access to the console.

Cobaltit: I know up to v14 tech support could do this in extreme circumstances but I am not sure if something changed in 15. Support wouldn't answer one way or the other if they could and actually told me to ask here before opening a support case and using one of our incidents in which they would confirm or deny their ability to do this.

 

[leejor]

Seems a bit odd that there was never a back-up done. If you had one, even an old one, you should be able to find the password in there.

 

[z-enzo]

Leejor: We don't have any valid backups meaning there are some but the password changed since they were done. At some point auto backups turned off and the configuration since the last backup has changed substantially as well.

Our guess is the client changed the password when the old provider was leaving but before they retained us thinking they could do the management themselves and then lost the password. Now they need a bunch of work done but have been locked out for some time and were hoping we had a magic back door.

 

[Saqqara]

Can you not do a backup via command line -
https://www.3cx.com/docs/backup-restore-command-line/

 

[z-enzo]

Saqqara: That worked. I didn't even know that was option. Learned something today. Thank you so much for the help.

It looks like what we thought. Pass was close to what they told us but had a extra cap in it.

 

[TBWD]

Is this a debian or windows install? If this is a debian install PM, me and I can walk you through the process.