Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
I upgrade from 0.8veryold to packet-based 1.0.4 (CentOS7).
I am logged in as admin (Sure? How to verify? How to logout an re-login?) but I can not edit my tree. I always get told: "is locked for Editing on 2017-04-08 10:59:04 by .To edit..."
You unlock a tree by clicking the "Finish editing tree" button you see above the Tree items column of the edit view of the tree. I don't know if the account that locked the tree is the only one who is allowed to unlock, or if everyone is allowed, though.
If you are familiar with some kind of mysql admin tool, for example MySQL Workbench or phpmyadmin, open the table graph_tree and look into the column "locked". It contains a 1 for locked trees. Change this to 0 to unlock the corresponding tree.
I know this is a few months old, but just in case anybody else is having issues with this, I found a solution that worked for me.
Under trees (before you open the tree you want to edit) put a check for "Choose an action" for the tree you need access to and in the "Choose an action" dorpdown, select Un Publish and click Go. After that you should be able to select and edit your tree.
# You might be able to use a different user with permissions for cacti database
$>mysql -u root -p
Enter password:
# open the Cacti databse (identified by show databases;)
>use cacti;
Database changed
# Show the entries in database. You will notice the "1" for locked.
> SELECT * from graph_Tree;
+----+---------+--------+---------------------+-----------+-------+----------+---------+---------------------+-------------+
| id | enabled | locked | locked_date | sort_type | name | sequence | user_id | last_modified | modified_by |
+----+---------+--------+---------------------+-----------+-------+----------+---------+---------------------+-------------+
| 1 | on | 1 | 2018-04-01 23:37:33 | 1 | admin | 1 | 1 | 2018-04-01 23:37:52 | 0 |
+----+---------+--------+---------------------+-----------+-------+----------+---------+---------------------+-------------+
1 row in set (0.00 sec)
# Now set the locked field to "0" to unlock it
> update graph_tree set locked = 0 where locked=1;
Query OK, 1 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
# Done and exit.
>exit;
This means that you have not finished editing the tree manually. This is done by clicking on "Finished Editing" which is just above the tree branches when you are editing it. I'm not sure what circumstances would make the button greyed out unless it thinks a different person was editing the tree.
knebb wrote: ↑Mon Apr 02, 2018 12:35 am
As I am having this issue reglarly and even the last post did not help I will show how to fix it to have it documented for the next times.
# You might be able to use a different user with permissions for cacti database
$>mysql -u root -p
Enter password:
# open the Cacti databse (identified by show databases;)
>use cacti;
Database changed
# Show the entries in database. You will notice the "1" for locked.
> SELECT * from graph_Tree;
+----+---------+--------+---------------------+-----------+-------+----------+---------+---------------------+-------------+
| id | enabled | locked | locked_date | sort_type | name | sequence | user_id | last_modified | modified_by |
+----+---------+--------+---------------------+-----------+-------+----------+---------+---------------------+-------------+
| 1 | on | 1 | 2018-04-01 23:37:33 | 1 | admin | 1 | 1 | 2018-04-01 23:37:52 | 0 |
+----+---------+--------+---------------------+-----------+-------+----------+---------+---------------------+-------------+
1 row in set (0.00 sec)
# Now set the locked field to "0" to unlock it
> update graph_tree set locked = 0 where locked=1;
Query OK, 1 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
# Done and exit.
>exit;
to packet-based 1.0.4 (CentOS7).
