DB Disable console restrictions Help

[rr4401]

Hello,

We're locked out of our Management Console after Security Setting configuration was changed to restrict IP's, and we're receiving the "Login access denied. Too many incorrect login attempts." loop internally/externally from all IP's.

We have access to our Debian VM and are able to make changes to the database but need assistance with the command to re-enable the Security Setting back to the default, and attempt to re-login externally, or perhaps another command to unlock the locked user as well.

Your help is much appreciated.

 

[diamond9]

Have you managed to lock ALL ip addresses, have you tried from a mobile 4G or another office?

 

[rr4401]

We have tried several external IP's, both external LAN and Mobile 4G connections.

I've already queried the DB to confirmed our User/Pass is correct, and right now I'm digging through the DB to find the table where to change the setting, if possible, or unlock the account.

 

[diamond9]

The blacklisted IP's are in a table called blacklist, modify at your own risk

3CX does not lock a user it locks the IP so should be in there

 

[JohnS_3CX]

Allow me to start by saying: do not modify anything at all in the database.

Now that we got this out of the way let's look for a solution

Other than shell access, is this VM local to your or do you have a way to reach it using a local IP (VPN or whatever other way)?

 

[rr4401]

VM is in the cloud on a Debian Linux server.

I am in the DB at the moment, staring that the Blacklisted IP's, and can clearly see our internal IP listed as #1 in the blacklist. Is there a reasonable reason why not to remove that entry from the blacklist.ipaddr table?

Is there a alternate table field we can update to change the Console Restricted access back to the default "all IP's"?

 

[rr4401]

So without modifying the Database, and all IP's being blocked internally and subsequent all external IP's being blocked (due to Console Access Restriction option), including Mobile, and external LAN connections, how do we reset this option back to the default and remove the blacklisted IP's from the system so we may connect via the Management Console.

Again, we have absolutely no access, from anywhere, to access the Management Console, nor do we have any Backups of the system to revert back to.

 

[BrenttG]

i have had to fix a number of these on debian, if you have SSH root access, i can take care of it for you remotely, just PM me the SSH details. As stated by @JohnS_3CX Do not attempt modification of the DB yourself as bad things can happen, i have experience with having to do this about 10 times now.

 

[diamond9]

I thought that warning applied to EVERYONE not just users

 

[BrenttG]

Im a linux developer and DBA of many many years, as well as a 3CX API Developer, im quite familiar enough with the system to take care of this issue.

We are also an Advanced Certified, Titanium Partner, and as such we provide the support for 100s of our own 3CX clientele.