Admin/admin loop after changing to AD auth

[giwdul]

I'm tried switching my auth over to AD, instead of the local auth. My AD config didn't work and now I can't get back in with my local admin account. The page just loops.
I set the guest password and can login with guest, but my admin account no longer works.

Anyone know how to reset the auth type from the cli?
I think I'd like to just go back to using local authentication.

FYI: I'm using CentOS 7, but I'm not a linux expert, so please provide commands in your reply.
Also, I have hours of configuration time spent on getting all my devices and trees setup, so I'd rather not blow it away.

Thanks!

[netniV]

Code: Select all

update settings set value = '1' where name = 'auth_method'

[giwdul]

MariaDB [cacti]> update settings set value = '1' where name = 'auth_method';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Looks like it didn't change anything in the table.

[giwdul]

Is there a way to make the guest account an admin? Then, I can create a new admin account and see if that works.

[giwdul]

Here is my user_auth table:

MariaDB [cacti]> select * from user_auth;
+----+----------+----------------------------------+-------+---------------+---------------------+----------------------+-----------------+-----------+-----------+--------------+----------------+------------+---------------+--------------+--------------+------------------------+---------+------------+-----------+------------------+--------+-----------------+----------+-------------+
| id | username | password | realm | full_name | email_address | must_change_password | password_change | show_tree | show_list | show_preview | graph_settings | login_opts | policy_graphs | policy_trees | policy_hosts | policy_graph_templates | enabled | lastchange | lastlogin | password_history | locked | failed_attempts | lastfail | reset_perms |
+----+----------+----------------------------------+-------+---------------+---------------------+----------------------+-----------------+-----------+-----------+--------------+----------------+------------+---------------+--------------+--------------+------------------------+---------+------------+-----------+------------------+--------+-----------------+----------+-------------+
| 1 | admin | 21232f297a57a5a743894a0e4a801fc3 | 0 | Administrator | | | on | on | on | on | on | 1 | 1 | 1 | 1 | 1 | on | -1 | -1 | -1 | | 0 | 0 | 0 |
| 3 | guest | 084e0343a0486ff05530df6c705c8bb4 | 0 | Guest Account | | | on | on | on | on | on | 1 | 1 | 1 | 1 | 1 | on | -1 | -1 | -1 | | 0 | 0 | 0 |

[giwdul]

I was able to take someone else's advice and install phpMyAdmin. From there, I changed the realm ID from 1 to 3, which gave my guest account rights to login as a full admin.
From there, I created a new account and reset the realm back to it.