Log in Problem

[jrego]

I have just installed cacti on fedora 9. i got the configuration page. then i got the login page. tried admin/admin and it says "Error: Access Denied, user account disabled."

Can anyone help me? Like i said this is a new install. I already did update user_auth set password=md5('admin') where username='admin'; to make sure the password was correct but i need to know how to enable it. I have no idea why it would be disabled.

thanks

[streaker69]

I have just installed cacti on fedora 9. i got the configuration page. then i got the login page. tried admin/admin and it says "Error: Access Denied, user account disabled."

Can anyone help me? Like i said this is a new install. I already did update user_auth set password=md5('admin') where username='admin'; to make sure the password was correct but i need to know how to enable it. I have no idea why it would be disabled.

thanks

Do this:

mysql -u username -p password cacti

where username = user of the cacti database
password = password of that user

then execute this:

update user_auth set `enabled` = 'on' where `username` ='admin'

see if that fixes it for you.

[jrego]

Thanks for the quick response but no dice.

mysql> update user_auth set `enabled` = 'on' where `username` ='admin';
ERROR 1054 (42S22): Unknown column 'enabled' in 'field list'

[streaker69]

Thanks for the quick response but no dice.

mysql> update user_auth set `enabled` = 'on' where `username` ='admin';
ERROR 1054 (42S22): Unknown column 'enabled' in 'field list'

then it sound as though you haven't created your cacti database correctly.

[jrego]

here is what i have done so far relating to the database.

I can log in to mysql. I can see that the db is there. i can issue a show tables and i get the following output:

mysql> show tables;
+---------------------------+
| Tables_in_cactidb |
+---------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
| host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_query |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_reindex |
| poller_time |
| rra |
| rra_cf |
| settings |
| settings_graphs |
| settings_tree |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
+---------------------------+
48 rows in set (0.00 sec)

mysql> set password for root@localhost=password('password');
mysql> create database cactidb;
mysql> grant all on cactidb.* to root;
mysql> grant all on cactidb.* to root@localhost;
mysql> grant all on cactidb.* to cacti;
mysql> grant all on cactidb.* to cacti@localhost;
mysql> set password for cacti@localhost=password('password');
mysql> exit

mysql --user=root --password=password cactidb < cacti.sql

anything sound wrong there? how can i see the columns in that table that you are looking for?

[jrego]

Attached is the log file.

[jrego]

Here is the log file.

[jrego]

Here is what i see....



mysql> show columns from user_auth;
+------------------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------+------+-----+---------+----------------+
| id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |
| username | varchar(50) | NO | | 0 | |
| password | varchar(50) | NO | | 0 | |
| realm | mediumint(8) | NO | | 0 | |
| full_name | varchar(100) | YES | | 0 | |
| must_change_password | char(2) | YES | | NULL | |
| show_tree | char(2) | YES | | on | |
| show_list | char(2) | YES | | on | |
| show_preview | char(2) | NO | | on | |
| graph_settings | char(2) | YES | | NULL | |
| login_opts | tinyint(1) | NO | | 1 | |
| policy_graphs | tinyint(1) unsigned | NO | | 1 | |
| policy_trees | tinyint(1) unsigned | NO | | 1 | |
| policy_hosts | tinyint(1) unsigned | NO | | 1 | |
| policy_graph_templates | tinyint(1) unsigned | NO | | 1 | |
+------------------------+-----------------------+------+-----+---------+----------------+
15 rows in set (0.00 sec)

[streaker69]

go to a mysql prompt and do this.

select * from 'user_auth';

see if you get anything.

[jrego]

mysql> select * from 'user_auth';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user_auth'' at line 1
mysql>

no dice?

[jrego]

had to change the syntax.

mysql> SELECT * FROM user_auth LIMIT 10;
+----+----------+----------------------------------+-------+---------------+----------------------+-----------+-----------+--------------+----------------+------------+---------------+--------------+--------------+------------------------+
| id | username | password | realm | full_name | must_change_password | show_tree | show_list | show_preview | graph_settings | login_opts | policy_graphs | policy_trees | policy_hosts | policy_graph_templates |
+----+----------+----------------------------------+-------+---------------+----------------------+-----------+-----------+--------------+----------------+------------+---------------+--------------+--------------+------------------------+
| 1 | admin | 21232f297a57a5a743894a0e4a801fc3 | 0 | Administrator | on | on | on | on | on | 1 | 1 | 1 | 1 | 1 |
| 3 | guest | 43e9a4ab75570f5b | 0 | Guest Account | on | on | on | on | on | 3 | 1 | 1 | 1 | 1 |
+----+----------+----------------------------------+-------+---------------+----------------------+-----------+-----------+--------------+----------------+------------+---------------+--------------+--------------+------------------------+
2 rows in set (0.00 sec)