Centos6에서 syslog analyzer 세팅을 위한 세팅 - 1

아파치 설치, mysql 설치, 기본 필요 세팅

 

 

# yum install httpd

# /etc/init.d/httpd start

# chkconfig httpd on

# yum install mysql mysql-server

# /etc/init.d/mysqld start

# chkconfig mysqld on

# mysql –u root –p

> SET PASSWORD = PASSWORD(‘rootpassword’)

# yum install php php-mysql php-gd

# vim /var/www/html/test.php
<?php
phpinfo();
?>

# /etc/init.d/httpd restart

# wget http://rpms.adiscon.com/v8-stable/rsyslog.repo

# mv rsyslog.repo /etc/yum.repos.d/rsyslog.repo

# yum install rsyslog* --skip-broken

# chkconfig rsyslog on

# vim /usr/share/doc/rsyslog-mysql-8.2.1/createDB.sql
CREATE DATABASE rsyslogdb;
USE rsyslogdb;
CREATE TABLE SystemEvents
[...]

# mysql -u root -p < /usr/share/doc/rsyslog-mysql-8.2.1/createDB.sql

# mysql –u root –p rsyslogdb

> GRANT ALL ON rsyslogdb.* TO rsyslogdbadmin@localhost IDENTIFIED BY 'NewPasswordHere';
> FLUSH PRIVILEGES;
> exit

# mysql -u rsyslogdbadmin -p rsyslogdb