Tag Archives: opensuse

rsyslog + MySQL + LogAnalyzer on OpenSUSE

rsyslog Features Map

1. Install requirements

2. Create RuleBase for PHP log

3. Prepare MySQL

4. rsyslog Configuration for Log-Servers

5. rsyslog Configuration for Log-Client

6. Install LogAnalyzer

7. LogAnalyzer Configuration http://localhost/loganalyzer   ♦ References http://www.the-art-of-web.com/system/rsyslog-config/ http://www.liblognorm.com/files/manual/configuration.html  

Install OpenVPN on openSUSE

OpenVPN

0. Plan Public IF : eth1 (210.1.1.1) Private IF : eth0 (10.1.0.0/16) Virtual Tunneling IF : tun0 (172.16.1.0/24) 1. Download and install packages

2. Install EasyRSA and create server ertificates

3. Configuration for PAM-plugin

4. Configuration for rsyslog

5. Configure SuSEfirewall

6. Configure IP setting shell script

7. Status file script and add to cron job

8. Configure OpenVPN and Start service Run yast Add network device “tun0” type TUN Assign tun0 to External Network at Firewall 9. Configure OpenVPN and Start service

  ∗ Create new client certificate ‥‥‥

Enable SFTP Logging on OpenSUSE

1. Update rsyslog(syslog) configuration

2. SSHD Configuration file

 

Chroot for SFTP on OpenSUSE

1. Add chroot to SSHD Configuration file

2. Mount directory to home directory

 

Install DKIMproxy on OpenSUSE

1. Install requirements

2. Create keys

3. Configuration file

4. Setting up postfix

5. Restart services

6. Add DNS record (sender’s domain)

  ♦ References http://dkimproxy.sourceforge.net/usage.html

Install Subversion Server on OpenSUSE 12.3

1. Install requirements

2. Create account

3. Add Apache2 module

4. Configure Apache

5. Prepare directories

6. Add SVN user

7. Create SVN access list

8. Create repogitory

9. Apply skin of directory index(3rd-party XSLT) http://www.reposstyle.com 10. Script for new repogitory (tip)

  ♦ References http://download.xskernel.org/howto/svn/Setting_up_a_Subversion_server_using_Apache2.html  

Install Cacti on OpenSUSE 12.3

1. Install requirements

2. Create user cacti

3. Create mysql user

4. Create DB schema

5. Configure cacti

6. Configure Apache

7. Configure from Web UI

8. Case of using spine

  ♦  Configuration of  monitoring taget servers

  ♦  Import percona plugins & templates #1 – mysql & ssh http://www.percona.com/downloads/percona-monitoring-plugins/LATEST/

Import XML templetes from Web-UI   ♦  Import percona plugins & templates #2 – mssql http://www.percona.com/downloads/percona-monitoring-plugins/LATEST/

Modify&run”sql_server_2005-2008.sql”on mssql server. Import XML templetes from Web-UI. (cacti_host_template_windows_-_sql_server.xml)   ♦  Import my additional templates Aiden’s ‥‥‥

Install Nagios on OpenSUSE 12.3

1. Install requirements

2. Prepare mysql

3. Configure ndo2db

3. Add httpd user

4. Create nagios objects

5. Start service with monitoring log

6. apache 설정 수정

♦ Nagios Skins http://exchange.nagios.org/directory/Graphics-and-Logos/Images-and-Logos/F*Nagios-Icon-Pack/details ♦ References http://doc.opensuse.org/documentation/html/openSUSE/opensuse-tuning/cha.nagios.html http://nagios.sourceforge.net/docs/3_0/quickstart-opensuse.html http://hyper-choi.blogspot.jp/2012/07/monitoring-setting-up-nagois-ndoutils.html http://support.nagios.com/wiki/index.php/Nagios_XI:FAQs#Upgrade_to_2011R3.x_Issues