How to disable 2FA aka 2 Factor Authentification

whattheserver

Original thanks to @land12 for method in: https://forums.cyberpanel.net/discussion/comment/11902/#Comment_11902

Below is reusable way to do this for the main administrator with an id of 1

How to disable it
PASSWORD=$(cat /etc/cyberpanel/mysqlPassword);
DB_NAME="cyberpanel";
mysql -uroot -p${PASSWORD} "${DB_NAME}" -e "UPDATE loginSystem_administrator SET twoFA = '0' WHERE id = 1;"

How to check if its enabled:
PASSWORD=$(cat /etc/cyberpanel/mysqlPassword);
DB_NAME="cyberpanel";
mysql -uroot -p${PASSWORD} "${DB_NAME}" -e "SELECT twoFA FROM loginSystem_administrator WHERE id = 1;"

Example:
[email protected]:~# PASSWORD=$(cat /etc/cyberpanel/mysqlPassword);
[email protected]:~# DB_NAME="cyberpanel";
[email protected]:~# mysql -uroot -p${PASSWORD} "${DB_NAME}" -e "SELECT twoFA FROM loginSystem_administrator WHERE id = 1;"
+-------+
| twoFA |
+-------+
| 0 |
+-------+
[email protected]:~#

Also requested that the official documentation is updated to reflect how to do this as it seems to be coming up alot lately.
https://cyberpanel.net/docs/two-factor-authentication-in-cyberpanel/

Hobiano

Thanks alot, but i have same issue, i check if enabled but I didn’t know what that mean
+-------+
| twoFA |
+-------+
| 0 |
+-------+
I still can’t access our panel

liberato

como eu encontro o meu id?

samysalahgad

Why I get Google 2FA activated after I install cyberpanel?
what SSH command to remove this feature from my server?

engcnyyl_TR

HELP CENTOS 7 2FA DISABLE CODE SSH

samysalahgad

its a big problem
we cannot login to the control panel, we didn't enable 2FA, why its automatically enabled when login?

alinabeen

Type your coI did this:
Go to the Security Basics page and log in to your Microsoft account.
Select Advanced Security Settings.
For the second-step verification, select Set to two-step verification to enable it, or select Disable two-step verification to enable it to disable it .

daotiendung

Type your comment> @samysalahgad said:
> its a big problem
> we cannot login to the control panel, we didn't enable 2FA, why its automatically enabled when login?

Yes, I also got the same error, I didn't enable Google 2FA but they automatically enabled, and now I can't login dc Panel. Do you have any solution?

piet

One of our clients reports the same issue since today. Above fix in the DB does not work, because twoFA field is already 0:

MariaDB [cyberpanel]> SELECT twoFA FROM loginSystem_administrator WHERE id = 1
-> ;
+-------+
| twoFA |
+-------+
| 0 |
+-------+
1 row in set (0.001 sec)

To be sure and stupid, I ran the script:
UPDATE `loginSystem_administrator` SET `twoFA` = '0' WHERE `loginSystem_administrator`.`id` = 1;
Query OK, 0 rows affected (0.001 sec)
Rows matched: 1 Changed: 0 Warnings: 0

and after:
systemctl restart lscpd


Also did a yum update to make sure I use the most recent versions and changed the admin pass.

Still the 2FA field....

bgxerjoe

i hope this can help;
open with new browser (different with your daily browser) and open 8090 in browser
if it's pop google auth field then delete your browser history (ctrl+shif+del if you use chrome and firefox) and choose everything. close your 8090 page and the re open. the google auth magically disappear .. it's work for me.. not use the DB injection

piet

> @bgxerjoe said:
> i hope this can help;
> open with new browser (different with your daily browser) and open 8090 in browser
> if it's pop google auth field then delete your browser history (ctrl+shif+del if you use chrome and firefox) and choose everything. close your 8090 page and the re open. the google auth magically disappear .. it's work for me.. not use the DB injection


Yes, did it for me! Thank you.

usmannasir

Yesterday this error came due to Fastly CDN being down.

sarangpaul9

Damm even I am having a similar kind of issue, I have searched all over the internet and even have posted on number of threads on different forum, no solution seems to work. I am really frustrated, can anyone of you here help me resolve this issue, I am very much tired now.