No Image

Mozilla SSL Configuration Generator

2016-10-14 KENNETH 0

URL : https://mozilla.github.io/server-side-tls/ssl-config-generator/   웹서버,openssl 버전 별로 SSL 설정을 자동화 해서 안내 해줌… 세상에 이걸 첨 알다니.. ㅋㅋㅋㅋㅋㅋ   샘플로 한번 해보자면 1. httpd-2.4 & openssl-1.0.1e <VirtualHost *:443> … SSLEngine on SSLCertificateFile /path/to/signed_certificate SSLCertificateChainFile /path/to/intermediate_certificate SSLCertificateKeyFile /path/to/private/key # Uncomment the following directive when using client certificate authentication #SSLCACertificateFile /path/to/ca_certs_for_client_authentication # HSTS (mod_headers is required) (15768000 seconds = 6 months) Header always set Strict-Transport-Security "max-age=15768000" … </VirtualHost> # modern configuration, tweak to your needs SSLProtocol all -SSLv3 -TLSv1 -TLSv1.1 SSLCipherSuite ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256 SSLHonorCipherOrder on # OCSP Stapling, only in httpd 2.3.3 and later SSLUseStapling on SSLStaplingResponderTimeout 5 SSLStaplingReturnResponderErrors off SSLStaplingCache shmcb:/var/run/ocsp(128000)   2. httpd-2.2 & openssl-1.0.1e <VirtualHost *:443> … SSLEngine on SSLCertificateFile /path/to/signed_certificate SSLCertificateChainFile /path/to/intermediate_certificate SSLCertificateKeyFile /path/to/private/key # Uncomment the following directive when using client certificate authentication #SSLCACertificateFile /path/to/ca_certs_for_client_authentication # HSTS (mod_headers is required) (15768000 seconds = 6 months) Header always set Strict-Transport-Security [ more… ]

No Image

mysql server system variables log_warnings to log_error_verbosity

2016-10-04 KENNETH 0

url : http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html   under 5.7.2 : log_warnings over 5.7.2 : log_error_verbosity   log_warnings Deprecated 5.7.2 Command-Line Format –log-warnings[=#] System Variable Name log_warnings Variable Scope Global Dynamic Variable Yes Permitted Values (32-bit platforms, <= 5.7.1) Type integer Default 1 Min Value 0 Max Value 4294967295 Permitted Values (32-bit platforms, >= 5.7.2) Type integer Default 2 Min Value 0 Max Value 4294967295 Permitted Values (64-bit platforms, <= 5.7.1) Type integer Default 1 Min Value 0 Max Value 18446744073709551615 Permitted Values (64-bit platforms, >= 5.7.2) Type integer Default 2 Min Value 0 Max Value 18446744073709551615 Whether to produce additional warning messages to the error log. This variable is enabled by default (the default is 1 before MySQL 5.7.2, 2 as of 5.7.2). To disable it, set it to 0. The server logs messages about statements that are unsafe for statement-based logging if the [ more… ]

No Image

[mysql] Buffered warning: Could not increase number of max_open_files to more than 1024 on centos

2016-09-07 KENNETH 0

OS : CentOS7 MySQL : install rpm package from mysql official repository 1. mysql error log [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 16384) [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 3000) [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 2048) 2. modify service file file path : /usr/lib/systemd/system/mysqld.service add LimitNOFILE=163840 LimitNPROC=163840 3. reload # systemctl daemon-reload for this error message… Warning: mysqld.service changed on disk. Run ’systemctl daemon-reload’ to reload units. 4. Restart mysql # service mysqld restart

No Image

Unable to validate certificate chain in aws elb – comodossl

2016-09-05 KENNETH 0

AWS ELB 설정시 SSL 인증서를 등록하는 중에… 이와같은 에러를 만났다면.. 발급받은 인증서 파일들에는 문제가 없음을 가정한다. 이 문제는 마지막 항목인 ”Certificate Chain”의 입력값을 지적하는 내용이다.   아마도 당신이 발급받은 체인 인증서 목록은 아래와 같을 것이다. AddTrustExternalCARoot.crt COMODORSAAddTrustCA.crt COMODORSADomainValidationSecureServerCA.crt 이중에서… COMODO.. 로 시작하는 두개의 파일이 있는데… 그중 COMODORSADomainValidationSecureServerCA.crt 파일의 내용을 먼저 입력하고.. 그 다음 COMODORSAAddTrustCA.crt 파일의 내용을 입력해 보자.. 명령어로 굳이 설명하면.. cat COMODORSADomainValidationSecureServerCA.crt COMODORSAAddTrustCA.crt 를 실행해서 출력된 값을 넣어보자..   그렇다면 정상적인 등록이 될것이다…