AWS CodeDeploy 설정 (S3)
The flow of a typical AWS CodeDeploy deployment 설정 목록 EC2 On-Premises(EC2가 […]
rsyslog + MySQL + LogAnalyzer on OpenSUSE
1. Install requirements zypper install rsyslog rsyslog-module-relp rsyslog-module-mysql rsyslog-module-snmp rsyslog-module-mmnormalize 2. Create […]
Upload PKCS#12 Server Certificates to AWS
1. Extract RSA Private key openssl pkcs12 -in CERTIFICATE.PFX -nocerts -nodes -out private.key […]
Using request of JSON Payload in Slim framework
How to enable JSON-Payload input in Slim Framework… SlimMiddlewareContentTypes.php <?php /** * […]
MySQL Procedure Pattern for Nested Transaction
The MySQL dose not supports ‘Nested Transaction’. Transactions cannot be nested. This […]
Install OpenVPN on openSUSE
0. Plan Public IF : eth1 (210.1.1.1) Private IF : eth0 (10.1.0.0/16) […]
Enable SFTP Logging on OpenSUSE
1. Update rsyslog(syslog) configuration vi /etc/rsyslog.conf #sftp logging local5.* -/var/log/sftpd.log service rsyslog restart […]
Chroot for SFTP on OpenSUSE
1. Add chroot to SSHD Configuration file vi /etc/ssh/sshd_config Match Group uploaders,!admin […]
MySQL, Checking the IP address in a range
fn_ipv4_match( needle, haystack ) Returns 1 if haystack contains needle. needle : IPv4 […]
Install DKIMproxy on OpenSUSE
1. Install requirements zypper install dkimproxy 2. Create keys cd /usr/share/dkimproxy/etc openssl genrsa […]