# ---------------------------
# rrdtoolのインストール
# ---------------------------
mkdir /home/test/;
cd /home/test/;
wget http://www.fastmirrors.org/rrdtool/rrdtool-1.0.49.tar.gz;
tar -xzf rrdtool-1.0.49.tar.gz;
cd rrdtool-1.0.49;
./configure;
make;
make install;
# 元に戻る
cd /home/test/
# ---------------------------
# mysqlのインストール
# ---------------------------
wget http://dev6.beat4u.co.jp/test/ysql-4.1.14.tar.gz
tar -xzf ysql-4.1.14.tar.gz;
cd ysql-4.1.14;
./configure --prefix=/usr/local/mysql --localstatedir=/var/lib/mysql --with-extra-charsets=latin1,sjis,ujis;
make;
make install;
# 元に戻る
cd /home/test/
# ユーザーの追加
# ---------------
groupadd mysql;
adduser -g mysql -d /usr/local/var mysql;
PATH=$PATH:/usr/local/mysql/bin;
export MANPATH=$MANPATH:/usr/local/mysql/man;
/usr/local/mysql/bin/mysqladmin -u mysql password hoge;
# mysql初期化
/usr/local/mysql/bin/mysql_install_db --user=mysql;
chown -R mysql /usr/local/mysql;
chgrp -R mysql /usr/local/mysql;
# 起動
/usr/local/mysql/bin/mysqld_safe --user=mysql &
/usr/local/mysql/bin/mysqladmin -u mysql password hoge;
# コマンドのリンク?
PATH=$PATH:/usr/local/mysql/bin;
export MANPATH=$MANPATH:/usr/local/mysql/man;
# DBの作成
/usr/local/mysql/bin/mysqladmin -p create cacti
adduser -r cacti;
chown -R cacti:cacti ./cacti;
/usr/local/mysql/bin/mysqladmin -u cat password hoge;
# mysql ユーザー追加
grant all on *.* to cacti@localhost identified by 'hoge';
mysql -u root -p cat GRANT ALL ON cacti.* TO cat@localhost IDENTIFIED BY 'hoge';
./configure --prefix=/usr/local/mysql --localstatedir=/var/lib/mysql --with-extra-charsets=latin1,sjis,ujis --without-isam
UPDATE user SET Password = OLD_PASSWORD('hoge') WHERE Host = 'localhost' AND User = 'cacti';
# 動作の確認
php /home/cactiuser/cacti-バージョン番号/poller.php
php /home/cactiuser/cacti-0.8.6g/poller.php
*/5 * * * * /usr/local/bin/php /home/httpd/html/cacti/poller.php > /dev/null 2>&1