Cacti In State Column Showing Incorrect Time

First, go to /usr/share/cacti/lib and edit the functions.php file.
Find this two lines,

$hosts[$host_id]["status_fail_date"] = '0000-00-00 00:00:00';
$hosts[$host_id]["status_rec_date"] = '0000-00-00 00:00:00';

and change it to:

if ($hosts[$host_id]["status_fail_date"] == ""){
$hosts[$host_id]["status_fail_date"] = '0000-00-00 00:00:00';}

if ($hosts[$host_id]["status_rec_date"] == ""){
$hosts[$host_id]["status_rec_date"] = '0000-00-00 00:00:00';}

Next, go to cacti database

#mysql -u [username] -p [database name]

It will prompt you to enter your database password.
Then after entering your password try to execute this command to your mysql command line:

mysql>UPDATE host SET status_fail_date = '2014-04-02 00:00:00';
mysql>UPDATE host SET status_rec_date = '2014-04-02 00:00:00';

Hope it help you.
Got this from here

Squid ncsa auth error TCP_DENIED/407

Squid ncsa auth error TCP_DENIED/407

Problem tersebut muncul ketika saya install dan setup anonymous squid web proxy menggunakan ncsa auth. OS yang saya gunakan Centos 6 dengan Squid 3.
File htpasswd saya letakkan di /etc/squid/passwd dengan perintah

# htpasswd -c /etc/squid/passwd admin

Akan tetapi ketika saya jalankan squid di web browser dengan memasukkan username dan password yang benar selalu di anggap salah oleh server, cek /var/log/squid/access.log

1392962958.800      0 27.131.x.xx TCP_DENIED/407 4261 GET http://www.whatismyip.com/ - NONE/- text/html
1392962963.938      1 27.131.x.xx TCP_DENIED/407 4359 GET http://www.whatismyip.com/ admin NONE/- text/html
1392962969.843      1 27.131.x.xx TCP_DENIED/407 4359 GET http://www.whatismyip.com/ admin NONE/- text/html
1392963083.759      1 27.131.x.xx TCP_DENIED/407 4297 GET http://www.whatismyip.com/ - NONE/- text/html
1392963088.778      1 27.131.x.xx TCP_DENIED/407 4395 GET http://www.whatismyip.com/ admin NONE/- text/html
1392963134.129      0 27.131.x.xx TCP_DENIED/407 3999 GET http://ipgue.com/ - NONE/- text/html
1392963138.087      1 27.131.x.xx TCP_DENIED/407 4097 GET http://ipgue.com/ admin NONE/- text/html
1392963141.863      1 27.131.x.xx TCP_DENIED/407 4097 GET http://ipgue.com/ admin NONE/- text/html

Saya yakin squid.conf saya tidak masalah, karena squid jalan normal sebelum saya aktifkan ncsa auth. Jadi dimana masalahnya?

Ternyata problemnya ada di enkripsi htpasswd dan ncsa_auth, secara default htpasswd menggunakan option -m (enkripsi MD5) sedangkan ncsa_auth menggunakan fungsi crypt().
Jadi untuk mengatasinya kita generate ulang password menggunakan option -d (crypt)

# htpsswd -d /etc/squid/passwd admin

Kemudian restart squid

# /etc/init.d/squid restart