AuctionPro

apache internal dummy connection 로그 생성 방지하기

apache 가 정상적으로 응답하지 않는 현상도 발생

::1 - - [26/Mar/2020:16:10:30 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"
::1 - - [26/Mar/2020:16:10:31 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"
::1 - - [26/Mar/2020:16:10:32 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"
::1 - - [26/Mar/2020:16:10:33 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"
::1 - - [26/Mar/2020:16:10:35 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"

::1 - - [26/Mar/2020:16:10:30 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"

::1 - - [26/Mar/2020:16:10:31 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"

::1 - - [26/Mar/2020:16:10:32 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"

::1 - - [26/Mar/2020:16:10:33 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"

::1 - - [26/Mar/2020:16:10:35 +0900] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.29 (Ubuntu) OpenSSL/1.1.0g (internal dummy connection)"

해결책 :
/etc/apache2/apache2.conf

SetEnvIf Remote_Addr "::1" loopback
SetEnvIf Remote_Addr "127\.0\.0\.1" loopback
 
#CustomLog logs/access_log combined env=!loopback

SetEnvIf Remote_Addr "::1" loopback

SetEnvIf Remote_Addr "127\.0\.0\.1" loopback

#CustomLog logs/access_log combined env=!loopback

참조 : https://cwiki.apache.org/confluence/display/HTTPD/InternalDummyConnection
https://allthatlinux.com/dokuwiki/doku.php?id=access_log%EC%97%90_options_http_1.0_%EA%B0%80_%EA%B8%B0%EB%A1%9D%EB%90%98%EB%8A%94_%EC%9D%B4%EC%9C%A0

Adobe Acrobat/Reader에 문제가 있습니다.

Adobe Acrobat/Reader에 문제가 있습니다. 실행 중이라면 종료하고 다시 시도하십시오.(103:103)

This error can be fixed by disabling the Adobe Reader’s “Enable Protected Mode at startup” setting.

1.Close QuickBooks.
2.Launch Adobe Reader.
3.Click on the Edit menu, select Preferences.
4.In the Categories list, select Security (Enhanced).
5.Uncheck Enable Protected Mode at Startup.
6.Click OK.
7. Close Adobe Reader.

참조 : https://quickbooks.intuit.com/learn-support/en-ca/troubleshooting/how-to-fix-the-adobe-reader-error-103-103-when-opening-previous/00/261700

PHP7.2XXX 에서 PHP7.3XXX 으로 안전하게 업그레이드 하기

sudo add-apt-repository ppa:ondrej/php
sudo apt update
sudo apt install php7.3

sudo add-apt-repository ppa:ondrej/php

sudo apt update

sudo apt install php7.3

php7.3 will be updated automatically when updates become available. Alternatively you can build php7.3 from source in Ubuntu 18.04, but it will not be updated automatically, and it also takes more than an hour to build if you want to test it too.

apt-cache search php7.3 | grep php7.3

1	apt-cache search php7.3 \| grep php7.3

sudo apt install php7.3-common php7.3-mysql php7.3-xml php7.3-xmlrpc php7.3-curl php7.3-gd php7.3-imagick php7.3-cli php7.3-dev php7.3-imap php7.3-mbstring php7.3-opcache php7.3-soap php7.3-zip php7.3-intl -y

1	sudo apt install php7.3-common php7.3-mysql php7.3-xml php7.3-xmlrpc php7.3-curl php7.3-gd php7.3-imagick php7.3-cli php7.3-dev php7.3-imap php7.3-mbstring php7.3-opcache php7.3-soap php7.3-zip php7.3-intl -y

update-alternatives --set php /usr/bin/php7.3

1	update-alternatives --set php /usr/bin/php7.3

a2dismod php7.2

1	a2dismod php7.2

a2enmod php7.3

1	a2enmod php7.3

systemctl restart apache2

1	systemctl restart apache2

참조 : https://forum.yiiframework.com/t/yii-1-1-21-and-php-7-2-19-issues/126343

ubuntu Hash sum mismatch error

E: Failed to fetch http://us.archive.ubuntu.com/ubuntu/dists/xenial-updates/main/binary-amd64/by-hash/SHA256/86d06dec5cec67943ee6e7c12ecb473588920e74747b6126d12fbf679ccfb18a  Hash Sum mismatch

1	E: Failed to fetch http://us.archive.ubuntu.com/ubuntu/dists/xenial-updates/main/binary-amd64/by-hash/SHA256/86d06dec5cec67943ee6e7c12ecb473588920e74747b6126d12fbf679ccfb18a Hash Sum mismatch

sudo rm -rf /var/lib/apt/lists/*
sudo apt-get update

1 2	sudo rm -rf /var/lib/apt/lists/* sudo apt-get update

참조 : https://askubuntu.com/questions/41605/trouble-downloading-packages-list-due-to-a-hash-sum-mismatch-error

MySQL Workbench warning when connecting to MariaDB

CenOS에 MariaDB 설치 후

remote 열기

cd /etc/my.cnf.d
# ls
client.cnf  enable_encryption.preset  mysql-clients.cnf  server.cnf  tokudb.cnf

cd /etc/my.cnf.d

# ls

client.cnf enable_encryption.preset mysql-clients.cnf server.cnf tokudb.cnf

# vi server.cnf

#주석처리 
#bind-address=0.0.0.0

# vi server.cnf

#주석처리

#bind-address=0.0.0.0

3306 포트 열기

[root@localhost my.cnf.d]# cat /etc/sysconfig/iptables
# sample configuration for iptables service
# you can edit this manually or use system-config-firewall
# please do not ask us to add additional ports/services to this default configuration
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT

[root@localhost my.cnf.d]# cat /etc/sysconfig/iptables

# sample configuration for iptables service

# you can edit this manually or use system-config-firewall

# please do not ask us to add additional ports/services to this default configuration

*filter

:INPUT ACCEPT [0:0]

:FORWARD ACCEPT [0:0]

:OUTPUT ACCEPT [0:0]

-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT

-A INPUT -p icmp -j ACCEPT

-A INPUT -i lo -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

-A INPUT -j REJECT --reject-with icmp-host-prohibited

-A FORWARD -j REJECT --reject-with icmp-host-prohibited

COMMIT

root 계정 리모트(%) 가능 으로 변경

iptable 및 mysql 재시작후 MySQL Workbench 로 열기
아래 메시지 무시
참조 : https://unix.stackexchange.com/questions/252275/mysql-workbench-warning-when-connecting-to-mariadb

연결된 상태

AuctionPro

카테고리

글목록