Server-Side/Linux2010. 12. 18. 16:58

[cacti] ERROR: Cannot connect to MySQL server on 'localhost'.

problem

log/cacti.log 에 다음과 같은 로그가 남았다면...


12/17/2010 07:00:10 PM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.



solution

include/config.php 파일을 보면 $database_hostname = "localhost"; 라고 되어있을텐데

$database_hostname = "127.0.0.1"; 로 변경하면 잘 작동한다.


'Server-Side > Linux' 카테고리의 다른 글

[cacti] how to install settings (cacti plugin) on CentOS 5.X 64bit  (0) 2010.12.18
[cacti] how to install cacti PIA on CentOS 5.X 64bit  (0) 2010.12.18
[cacti] how to install cacti on CentOS 5.X 64bit  (0) 2010.12.18
[rrdtool] how to install rrdtool on CentOS 5.X 64bit  (0) 2010.12.18
[CentOS] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)  (0) 2010.12.01
Posted by 준피
Server-Side/Linux2010. 12. 18. 16:52

[cacti] how to install cacti on CentOS 5.X 64bit

Required software(s)

 - MySQL server : Store cacti data.

 - NET-SNMP server : SNMP(Simple Network Management Protocol) is a protocol used for network management.

 - PHP with net-snmp module : Access SNMP data using PHP.

  - RRDTOOL(round robin database tool)

 - Apache / lighttpd / nginx webserver : Web server to display graphs created with PHP and RRDTOOL.


Install the software

# yum install mysql-server mysql php-mysql php-pear php-common php-gd php-devel php php-mbstring php-cli php-snmp php-pear-Net-SMTP php-mysql httpd


Configure MySQL server

# mysql -u root -p

Enter password: **********


mysql> create database cacti;

mysql> use mysql;

mysql> GRANT ALL ON cacti.* TO cacti@localhost IDENTIFIED BY 'password';

mysql> FLUSH privileges;

mysql> quit


Install snmpd

# yum install net-snmp-utils php-snmp net-snmp-libs

# vi /etc/snmp/snmpd.conf


------------> append <----------------

.

.


com2sec local   localhost       public

group   MyRWGroup       v1      local

group   MyRWGroup       v2c     local

group   MyRWGroup       usm     local

view    all     included        .1      80

access  MyRWGroup       ""      any     noauth  exact   all     all     none

syslocation     Unknown (edit /etc/snmp/snmpd.conf)

syscontact      Root    (configure /etc/snmp/snmp.local.conf)

pass .1.3.6.1.4.1.4413.4.1      /usr/bin/ucd5820stat

------------------------------------


# /etc/init.d/snmpd start

# chkconfig snmpd on

# snmpwalk -v 1 -c public localhost IP-MIB::ipAdEntIfIndex


(output)

IP-MIB::ipAdEntIfIndex.your.ip.address = INTEGER: 2

IP_MIB::ipAdEntIfIndex.127.0.0.1 = INTEGER: 1


Install cacti

# cd /usr/local/src

# wget http://www.cacti.net/downloads/cacti-0.8.7g.tar.gz


# tar xzfv cacti-0.8.7g.tar.gz

# cp -Rf cacti-0.8.7g /usr/local/cacti/

# ln -s /usr/local/cacti/ /usr/local/apache/htdocs/cacti


# vi /usr/local/cacti/include/config.php

--------------->modify<------------------

#database_type = "mysql";

#database_default = "cacti";

$database_hostname = "127.0.0.1";

$database_username = "cacti";

$database_password = "password";

$database_port = "3306";

------------------------------------------


# mysql -u root -p cacti < /usr/local/cacti/cacti.sql



Configure crond

# crontab -e

-------------->append<----------------

*/5 * * * * php /usr/local/cacti/poller.php > /dev/null 2>&1

----------------------------------------

# service crond restart


Install cacti web console

go to http://your.ip.address/cacti/

click 'Next'

choose 'New Install' and click 'Next'

if all of Path is [FOUND], click 'Finish'


if you show "[NOT FOUND] PHP Binary Path", install php-cli

# yum install php-cli


Username: admin

Password: admin



reference site

cacti plug-in

install cacti

install cacti

more specific information about cacti


'Server-Side > Linux' 카테고리의 다른 글

[cacti] how to install cacti PIA on CentOS 5.X 64bit  (0) 2010.12.18
[cacti] ERROR: Cannot connect to MySQL server on 'localhost'.  (0) 2010.12.18
[rrdtool] how to install rrdtool on CentOS 5.X 64bit  (0) 2010.12.18
[CentOS] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)  (0) 2010.12.01
linux mount  (0) 2010.12.01
Posted by 준피
Server-Side/Linux2010. 12. 18. 16:47

[rrdtool] how to install rrdtool on CentOS 5.X 64bit

1. add Dag RPM Repository
# vi /etc/yum.repos.d/Dag.repo
-----------------------------------
[dag]
name=Dag RPM Repository for Red Hat Enterprise Linux
baseurl=http://apt.sw.be/redhat/el$releasever/en/$basearch/dag
gpgcheck=0
enabled=1
protect=0
-----------------------------------
2. install rrdtool
# yum install rrdtool

'Server-Side > Linux' 카테고리의 다른 글

[cacti] ERROR: Cannot connect to MySQL server on 'localhost'.  (0) 2010.12.18
[cacti] how to install cacti on CentOS 5.X 64bit  (0) 2010.12.18
[CentOS] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)  (0) 2010.12.01
linux mount  (0) 2010.12.01
how to check memory usage of memcached  (0) 2010.11.22
Posted by 준피
Server-Side/Linux2010. 10. 9. 14:17

[CentOS] mysqli 설치

CentOS 64bit, php-5.2.5에서 mysqli를 설치해봤다.
apm 설치할때 보니까 mysqli가 빠져있길래 추가로 설치를 해봤다.
예전에는 애좀 먹었는데 간만에 하니까 술술 잘되는구나

# cd /usr/local/src/apm/php-5.2.5/ext/mysqli
# phpize
# ./configure --with-php-config=/usr/local/php/bin/php-config --with-mysqli=/usr/local/mysql/bin/mysql_config
# make

# mkdir -p /usr/lib64/extension/no-debug-non-zts-20060613
# cp modules/*.* /usr/lib64/extension/no-debug-non-zts-20060613/
# vi /usr/local/apache/conf/php.ini

extension_dir = "/usr/lib64/extensions/no-debug-non-zts-20060613/"
.
.
.
extension=mysqli.so

# /etc/init.d/http restart


'Server-Side > Linux' 카테고리의 다른 글

[CentOS] php에서 memcache 설치하기  (0) 2010.10.11
[CentOS] php version update 5.1 to 5.2  (0) 2010.10.09
[CentOS] 아파치 2개 이상 설치한 경우 해결책  (0) 2010.09.20
netstat 사용법  (0) 2010.09.20
서버 상태 확인  (0) 2010.08.28
Posted by 준피

티스토리툴바