Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

CactiEz can not log in, restart non-drawing processing

2025-02-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

1. After CactiEz is restarted, the access page displays a blank page.

Solution: after service httpd restart apache is rebooted, add it to boot. Chkconfig httpd on or vim / etc/rc.local join / etc/init.d/httpd start | restart

2. Check the mysql status and normal status.

3. Later refreshed and unable to enter the interface. Online search says that log files fill up space. (when the space is full, there is no space to support the service operation.) at that time, the df-h disk has been filled up. You can see the cacti.log single file 14G. In addition, the. / var/log/mysqld.log single file is 3G.

[root@cactiez /] # cd / var/www/html/log

[root@cactiez log] # ls

Cacti.log

Cacti.log-20170511 cacti.log-20170513 cacti.log-20170515 cacti.log.bak-20170516

Cacti.log-20170510 cacti.log-20170512 cacti.log-20170514 cacti.log-20170516

# logs are used for troubleshooting, so back up some log files.

Tail-n 1000 cacti.log > cacti.log.bak-20170516

Cat / dev/null > mysqld.log

Cat / dev/null > cacti.log

Check the space after you are done, and you can re-enter cacti

4. You can log in and visit normally, but cacti does not draw pictures and has no traffic. After checking the log of cacti.log, there is a problem with the mysqlcacti table. Press the method to enter mysql for repair, and then wait one minute for cacti drawing to recover.

[root@cactiez log] # tail / var/www/html/log/cacti.log.bak-20170516

05x16 PM at 04:46:48 2017-SYSTEM STATS: Time:46.2120 Method:spine Processes:1 Threads:1 Hosts:50 HostsPerProcess:50 DataSources:7294 RRDsProcessed:3702

04:46:48 PM-CMDPHP: Poller [0] ERROR: SQL Assoc failure, Error:'145', SQL: "SELECT data_id, rra_id, lastread, cdef FROM thold_data WHERE thold_enabled='on' AND tcheck=1"

Mysql > use "cacti"

Database changed

Mysql > select count (*) from poller_output

ERROR 145 (HY000): Table'. / cacti/poller_output' is marked as crashed and should be repaired

Mysql > truncate table poller_output

Query OK, 0 rows affected (0.02 sec)

Mysql > select count (*) from poller_output

+-+

| | count (*) |

+-+

| | 0 |

+-+

1 row in set (0.00 sec)

Learn from cacti's troubleshooting articles:

Http://blog.csdn.net/wangxiaofei2006/article/details/17755121

Http://blog.csdn.net/wangxiaofei2006/article/details/17755121

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report