Cacti

My version Cacti 0.8.8h, NET-SNMP-5.7.3 , RRDtool-1.2.* OS FreeBSD 11
----------------------------#--------------------------------------------
Problem with drawing graphs from interfaces servers & switches
Graphics load avarage and memory usage draws ))

The problem was due to errors in the tables.
Fixed by directly deleting database files in the directories / var / db / mysql/ cacti
The BD is new !

When deleting a database, cacti writes an error:
#1051 Unknown table 'cacti.poller_resource_cache, cacti.vdef, cacti.poller_outpust_boost, cacti.data_source_profile, cacti.si'

What to do ?

Friends. Does not draw graphics. I ask for additional help ----- I'm doing the command php -q /usr/local/share/cacti/poller.php ------- ERROR POLLER: Poller[1] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '338164.61', Max Runtime '298', Poller Runs: '1' 2018/01/02 17:22:11 - POLLER: Po...

A new problem in the charts.
Data in figures is written, but the graph does not draw!
-------

The data that is displayed is old data. New after the transfer does not draw

A new problem in the charts.
Data in figures is written, but the graph does not draw!
-------

The data that is displayed is old data. New after the transfer does not draw

Thank you ! I entered Cacti

Use my last code block. It looks the same but it is not. oooo :o --- Sorryy cd /usr/local/share/cacti/cli # php upgrade_database.php --forcever=0.8.8 Upgrading to 1.0.0 Upgrading to 1.0.1 no actions Upgrading to 1.0.2 no actions Upgrading to 1.0.3 no actions Upgrading to 1.0.4 Upgrading to 1.0.5 Up...

markv wrote:My bad, I’m writing this on an iPad, there is an = missing.

Code: Select all

cd /usr/share/cacti/cli
php upgrade_database.php --forcever=0.8.8

sorry , i don't understand you

Should have been part of the upgrade past 1.0.0: install/upgrades/1_0_0.php: db_install_execute("ALTER TABLE user_auth MODIFY COLUMN password varchar(2048) NOT NULL default ''"); Yes, I agree with Paul. Try running this cd <cacti-path>/cli php upgrade_database.php --forcever <previous-ver...

paulgevers wrote:Should have been part of the upgrade past 1.0.0:

Code: Select all

install/upgrades/1_0_0.php:     db_install_execute("ALTER TABLE user_auth MODIFY COLUMN password varchar(2048) NOT NULL default ''");

---------
Sorry.
What needs to be done?
The points !

markv wrote:OK, that is not what I expected for the current version of cacti. What version are you running again? Have you upgraded recently?

Freebsd 11
Cacti version 1.1.24
PHP 5.6.31

And this error occurs when you enter the correct login and password

Can you do a show create table `user_auth`\G; in mysql ? Mine shows a line for the password field of: `password` varchar(2048) NOT NULL DEFAULT '' Please run the command I put in the first code block at the MySQL prompt. You have broken it up which isn’t the desired commands. Run command and ..... ...

Can you do a show create table `user_auth`\G; in mysql ? Mine shows a line for the password field of: `password` varchar(2048) NOT NULL DEFAULT '' ---------- Sorry !!! For database mysql or cacti ? create table `user_auth'; or show table `user_auth'; :D ----------------------------- I am doing mysq...

I updated my password with this request mysql> update user_auth set password=’34819d7baaaee0934a5c854bc85b3e44′ where username=’admin’; It's not strange that updating the password helped, but it's impossible to enter the system. Friends, how can you help in this situation? What's next, I'm at an im...