Login issue

[saltNZ]

Hello I was trying to configure LDAP for authentication and have broken the login for admin

Now i can not log on as admin
In the cacti.log it tells me: AUTH LOGIN: User 'admin' Authenticated

But all it does is return the login prompt

I found
http://forums.cacti.net/viewtopic.php?f=2&t=47628

And dleeted those fields. In fact the last thing I did before I broke it was mess around the fields
"guest_user" and "user_template";

I have also gone and deleted all the LDAP config I put in too now it look slike this, but still broken

mysql> select * from settings;
+------------------------+--------------------------------------------------------------------------------------------------------------+
| name | value |
+------------------------+--------------------------------------------------------------------------------------------------------------+
| poller_lastrun | 1391051402 |
| path_webroot | /usr/share/cacti |
| date | 2014-01-30 16:10:02 |
| path_rrdtool | /usr/bin/rrdtool |
| path_php_binary | /usr/bin/php |
| path_snmpwalk | /usr/bin/snmpwalk |
| path_snmpget | /usr/bin/snmpget |
| path_snmpbulkwalk | /usr/bin/snmpbulkwalk |
| path_snmpgetnext | /usr/bin/snmpgetnext |
| path_cactilog | /usr/share/cacti/log/cacti.log |
| snmp_version | net-snmp |
| rrdtool_version | rrd-1.2.x |
| stats_poller | Time:0.4661 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:54 RRDsProcessed:30 |
| stats_recache | RecacheTime:0.0 HostsRecached:0 |
| auth_method | 1 |
| ldap_port | 390 |
| ldap_port_ssl | 636 |
| ldap_version | 3 |
| ldap_encryption | 0 |
| ldap_referrals | 0 |
| ldap_mode | 1 |
| ldap_group_require | |
| ldap_group_attrib | |
| ldap_group_member_type | 1 |
| ldap_search_filter | |
+------------------------+--------------------------------------------------------------------------------------------------------------+
25 rows in set (0.00 sec)


Please help

[phalek]

you could try setting "auth_method" to 0 for disabling the authentication completely. Then check if you can get it and fix any issues you see.

Other than that, it may be that you lost the realm permissions for you admin user. Grab the cacti.sql file that comes with cacti and check the user/permission part there for the admin user.

[saltNZ]

Hi Thanks for that.

I have tried to update that value, but I am getting my sysntax wrong any chance you could help me with the sysntax to update the value?

[saltNZ]

OK That worked thanks

for everyones reference, incase you create the probelm for your self

>use table
>update settings set value = 0 where name = "auth_method" ;

[francois_j]

I confirm fixed as well. Updating status to 0 bypasses the authentication and let's you in.

But what if we want to keep the authenticating?! ...

[phalek]

Now this is only a fix to get you in. Once you're in, check the admin user in case that one has an error or create a new admin user. Then change the authentication to e.g. Cacti internal to get it up and running again.