冯虚的BLOG

冯虚

I ran a mysql in docker

docker run --name mysql --network wp-net --network-alias mysql-host -e MYSQL_ROOT_PASSWORD=root mysql

Then ran a phpmyadmin in docker to connect to it

docker run --name myadmin --rm --link mysql:db \

--network wp-net \

--network-alias myadmin-host \

-p 8083:80 phpmyadmin/phpmyadmin

I go this error:

mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

The working version:

A quick solution is using older version of mysql

docker run --name mysql --network wp-net --network-alias mysql-host -e MYSQL_ROOT_PASSWORD=root mysql:5.7.22

Problem solved.

You can also config mysql 8.0.11 to use old password

https://stackoverflow.com/questions/49948350/phpmyadmin-on-mysql-8-0

--

Feng

冯虚

FROM php:apache

RUN apt-get update && apt-get -y install zip libxml2-dev libpng-dev apt-utils && docker-php-ext-install mysqli simplexml mbstring gd && rm -r /var/lib/apt/lists/*

RUN rm /etc/apache2/sites-enabled/* && \

echo \<VirtualHost *:80\> > /etc/apache2/sites-enabled/mybb.conf && \

echo DocumentRoot /var/www/mybb >> /etc/apache2/sites-enabled/mybb.conf && \

echo \</VirtualHost\> >> /etc/apache2/sites-enabled/mybb.conf && \

cd /var/www && mkdir mybb && cd mybb && \

curl https://resources.mybb.com/downloads/mybb_1815.zip -o mybb.zip && \

unzip mybb.zip "Upload/*" && \

mv Upload/* . && \

rm -Rf Upload mybb.zip && \

mv inc/config.default.php inc/config.php && \

chmod 666 inc/config.php inc/settings.php && \

chmod -R 777 inc/languages && \

chmod 777 cache/ cache/themes/ uploads/ uploads/avatars/ admin/backups/

WORKDIR /var/www

EXPOSE 80

CMD ["apache2-foreground"]

FROM php:alpine

RUN apk update && apk add zip libxml2-dev libpng-dev && docker-php-ext-install mysqli simplexml mbstring gd

RUN \

mkdir /var/www && \

cd /var/www && mkdir mybb && cd mybb && \

curl https://resources.mybb.com/downloads/mybb_1815.zip -o mybb.zip && \

unzip mybb.zip "Upload/*" && \

mv Upload/* . && \

rm -Rf Upload mybb.zip && \

mv inc/config.default.php inc/config.php && \

chmod 666 inc/config.php inc/settings.php && \

chmod -R 777 inc/languages && \

chmod 777 cache/ cache/themes/ uploads/ uploads/avatars/ admin/backups/

WORKDIR /var/www/mybb

EXPOSE 80

CMD ["php","-S","0.0.0.0:80"]

--

Feng

冯虚

When I tried to mount a windows folder as docker volume, the mounted folder in docker container is empty.

docker run --rm -v c:/Users:/data alpine ls /data

I recently changed my windows password. So I suspected this was the reason.

I then reset credentials and reshared C drive.

The problem was solved.

--

Feng

冯虚

I suspected the problem may come with Azure file through SMB. So I created a new wordpress container with a local /var/www/html folder (not a volume from Azure file). The the problem disappeared.

So the problem is the SMB Azure file?

I then use the following command to host a python http server and mount the azure volume to it.

sudo docker run -it --rm --name my-running-script -p 8000:8000 -v vol3:/usr/src/myapp -w /usr/src/myapp python:2 python -m SimpleHTTPServer 8000

There is no problem at all with this python server.

The only thing I can think is that the apache config in the wordpress container does not work well with SMB volume, especially when a big file is served in fast speed.

I then mounted the azure file volume to a php container without wordpress

sudo docker run --rm -p 8000:80 --name my-apache-php-app -v vol3:/var/www/html php:7.0-apache

The problem can be reproduced. So there is nothing to do with wordpress.

I then tried the same thing on apache httpd

docker run --rm --name my-apache-app -p 8000:80 -v vol3:/usr/local/apache2/htdocs/ httpd:2.4

I can reproduce the problem. So that the problem is apache, not php.

I run apache with local dir

sudo docker run --rm --name my-apache-app -p 8000:80 -v "$PWD":/usr/local/apache2/htdocs/ httpd:2.4

It worked well, the problem disappeared; which comes to the summary, docker apache is not working well with Docker Volume Driver.

The file I used to test is only 3.7M. Good news is that wordpress can still work well with this problem. I think that wordpress files are small enough to hide this problem.

I then used php CLI as a php web host

sudo docker run -it --rm --name my-running-script -p 8000:8000 -v vol3:/usr/src/myapp -w /usr/src/myapp php:7.0-cli php -S 0.0.0.0:8000

This time, the problem is gone for directly file access (better than apache). But once I download the file with a download.php file, the problem comes back.

I used readfile function in the download.php file to read a local file

I then changed the local file URL to a HTTP URL, then it worked. This is really dirty, because the php file go through internet to reach it's own server to read a local file as a remote file.

Now comes to the solution.

run a python http server

sudo docker run -it -d --name python_http -p 8001:80 -v vol4:/usr/src/myapp -w /usr/src/myapp python:2 python -m SimpleHTTPServer 80

Add this http server to the same network as wordpress server

docker network connect --alias python_http_host wp-net python_http

Then in the download.php file, use http://python_http/... in the readfile function to read a remote file from another docker container, which is actually a local file.

Problem solved!!! But this requires a new docker container running.

--

Feng

冯虚

Navigate to the www dir which you would like to use as web root

Create a new file call http.py (you can use any file name) with following content

import SimpleHTTPServer  import SocketServer    PORT = 8000    Handler = SimpleHTTPServer.SimpleHTTPRequestHandler    httpd = SocketServer.TCPServer(("", PORT), Handler)    print "serving at port", PORT  httpd.serve_forever()

Run the following test command

sudo docker run -it --rm --name my-running-script -p 8000:8000 -v "$PWD":/usr/src/myapp -w /usr/src/myapp python:2 python http.py

Test:

root@fengUbuntu:~/certs# curl http://localhost:8000/http.py

import SimpleHTTPServer

import SocketServer

PORT = 8000

Handler = SimpleHTTPServer.SimpleHTTPRequestHandler

httpd = SocketServer.TCPServer(("", PORT), Handler)

print "serving at port", PORT

httpd.serve_forever()

--

Feng

冯虚

The download link was working OK.

When I added a nginx layer, it's not working properly. Most of the times, it only returned partial files. The connection was closed before the file is downloaded.

nginx.1 | 2018/04/26 21:45:39 [alert] 41#41: *550 recv() failed (14: Bad address) while reading upstream, client: 125.168.222.225, server: www.dengnz.com, request: "GET /wp-content/download.php?name=link2sd HTTP/2.0", upstream: "http:/

/172.17.0.5:80/wp-content/download.php?name=link2sd", host: "www.dengnz.com", referrer: "https://www.dengnz.com/youtube/"

I then tried to use curl and wget in another docker to access the wordpress container. I can reproduce the issue, so that there is nothing to do with nginx.

Both Curl and Wget gave "bad address" error as well.

root@fa624a62a561:/# curl -O http://172.18.0.2/wp-content/shareMyFileSecretly/link2sd.apk

% Total % Received % Xferd Average Speed Time Time Time Current

Dload Upload Total Spent Left Speed

26 3792k 26 1015k 0 0 9846k 0 --:--:-- --:--:-- --:--:-- 9956k

curl: (56) Recv failure: Bad address

k2sd.apk24a62a561:/# wget http://172.17.0.5:80/wp-content/download3.php?name=lin

--2018-04-27 00:52:42-- http://172.17.0.5/wp-content/download3.php?name=link2sd.apk

Connecting to 172.17.0.5:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 3883503 (3.7M) [application/vnd.android.package-archive]

Saving to: 'download3.php?name=link2sd.apk.2'

download3.php?name= 27%[====> ] 1.00M --.-KB/s in 0.1s

2018-04-27 00:52:42 (6.69 MB/s) - Read error at byte 1051536/3883503 (Bad address). Retrying.

Then I tried to use wget and curl from the host VM to access the wordpress container, same issue.

Both curl and wget didn't give "bad address" any more.

Wget gave connection closed:

root@fengUbuntu:~/certs# wget http://localhost:8082/wp-content/shareMyFileSecretly/link2sd.apk

--2018-04-27 14:58:02-- http://localhost:8082/wp-content/shareMyFileSecretly/link2sd.apk

Resolving localhost (localhost)... 127.0.0.1

Connecting to localhost (localhost)|127.0.0.1|:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 3883503 (3.7M) [application/vnd.android.package-archive]

Saving to: 'link2sd.apk.3'

link2sd.apk.3 27%[====================================> ] 1.02M --.-KB/s in 0.03s

2018-04-27 14:56:56 (33.1 MB/s) - Connection closed at byte 1066270. Retrying.

Curl gave transfer closed:

root@fengUbuntu:~/certs# wget http://localhost:8082/wp-content/shareMyFileSecretly/link2sd.apk

--2018-04-27 14:58:02-- http://localhost:8082/wp-content/shareMyFileSecretly/link2sd.apk

Resolving localhost (localhost)... 127.0.0.1

Connecting to localhost (localhost)|127.0.0.1|:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 3883503 (3.7M) [application/vnd.android.package-archive]

Saving to: 'link2sd.apk.3'

link2sd.apk.3 27%[====================================> ] 1.02M --.-KB/s in 0.03s

2018-04-27 14:56:56 (33.1 MB/s) - Connection closed at byte 1066270. Retrying.

Which may mean that, the Apache server of wordpress container close the connection for some reason. When the communication was between two docker containers, it gave "bad address" error, because (maybe) sockets are used between to containers.

But why there is no problem when access from public?

Because accessing from public has a slower speed? No, I limited the speed to 100K, it's still happening.

I then tried to host the file using python's simple http server, it work well. So there nothing to do with the loop back interface.

It could be something with the docker0 interface? I don't know.

Further investigation is needed.

--

Feng

冯虚

Turn on the console log

Then open a new console, SSH to your server and run your command.

All the output will be saved in the log file.

--

Feng

冯虚

Check your date using date command

link /etc/localtime to whatever time zone file you want

sudo ln -sf /usr/share/zoneinfo/Pacific/Auckland /etc/localtime

Appendix:

/usr/share/zoneinfo/Africa/Abidjan

/usr/share/zoneinfo/Africa/Accra

/usr/share/zoneinfo/Africa/Addis_Ababa

/usr/share/zoneinfo/Africa/Algiers

/usr/share/zoneinfo/Africa/Asmara

/usr/share/zoneinfo/Africa/Asmera

/usr/share/zoneinfo/Africa/Bamako

/usr/share/zoneinfo/Africa/Bangui

/usr/share/zoneinfo/Africa/Banjul

/usr/share/zoneinfo/Africa/Bissau

/usr/share/zoneinfo/Africa/Blantyre

/usr/share/zoneinfo/Africa/Brazzaville

/usr/share/zoneinfo/Africa/Bujumbura

/usr/share/zoneinfo/Africa/Cairo

/usr/share/zoneinfo/Africa/Casablanca

/usr/share/zoneinfo/Africa/Ceuta

/usr/share/zoneinfo/Africa/Conakry

/usr/share/zoneinfo/Africa/Dakar

/usr/share/zoneinfo/Africa/Dar_es_Salaam

/usr/share/zoneinfo/Africa/Djibouti

/usr/share/zoneinfo/Africa/Douala

/usr/share/zoneinfo/Africa/El_Aaiun

/usr/share/zoneinfo/Africa/Freetown

/usr/share/zoneinfo/Africa/Gaborone

/usr/share/zoneinfo/Africa/Harare

/usr/share/zoneinfo/Africa/Johannesburg

/usr/share/zoneinfo/Africa/Juba

/usr/share/zoneinfo/Africa/Kampala

/usr/share/zoneinfo/Africa/Khartoum

/usr/share/zoneinfo/Africa/Kigali

/usr/share/zoneinfo/Africa/Kinshasa

/usr/share/zoneinfo/Africa/Lagos

/usr/share/zoneinfo/Africa/Libreville

/usr/share/zoneinfo/Africa/Lome

/usr/share/zoneinfo/Africa/Luanda

/usr/share/zoneinfo/Africa/Lubumbashi

/usr/share/zoneinfo/Africa/Lusaka

/usr/share/zoneinfo/Africa/Malabo

/usr/share/zoneinfo/Africa/Maputo

/usr/share/zoneinfo/Africa/Maseru

/usr/share/zoneinfo/Africa/Mbabane

/usr/share/zoneinfo/Africa/Mogadishu

/usr/share/zoneinfo/Africa/Monrovia

/usr/share/zoneinfo/Africa/Nairobi

/usr/share/zoneinfo/Africa/Ndjamena

/usr/share/zoneinfo/Africa/Niamey

/usr/share/zoneinfo/Africa/Nouakchott

/usr/share/zoneinfo/Africa/Ouagadougou

/usr/share/zoneinfo/Africa/Porto-Novo

/usr/share/zoneinfo/Africa/Sao_Tome

/usr/share/zoneinfo/Africa/Timbuktu

/usr/share/zoneinfo/Africa/Tripoli

/usr/share/zoneinfo/Africa/Tunis

/usr/share/zoneinfo/Africa/Windhoek

/usr/share/zoneinfo/America/Adak

/usr/share/zoneinfo/America/Anchorage

/usr/share/zoneinfo/America/Anguilla

/usr/share/zoneinfo/America/Antigua

/usr/share/zoneinfo/America/Araguaina

/usr/share/zoneinfo/America/Argentina

/usr/share/zoneinfo/America/Argentina/Buenos_Aires

/usr/share/zoneinfo/America/Argentina/Catamarca

/usr/share/zoneinfo/America/Argentina/ComodRivadavia

/usr/share/zoneinfo/America/Argentina/Cordoba

/usr/share/zoneinfo/America/Argentina/Jujuy

/usr/share/zoneinfo/America/Argentina/La_Rioja

/usr/share/zoneinfo/America/Argentina/Mendoza

/usr/share/zoneinfo/America/Argentina/Rio_Gallegos

/usr/share/zoneinfo/America/Argentina/Salta

/usr/share/zoneinfo/America/Argentina/San_Juan

/usr/share/zoneinfo/America/Argentina/San_Luis

/usr/share/zoneinfo/America/Argentina/Tucuman

/usr/share/zoneinfo/America/Argentina/Ushuaia

/usr/share/zoneinfo/America/Aruba

/usr/share/zoneinfo/America/Asuncion

/usr/share/zoneinfo/America/Atikokan

/usr/share/zoneinfo/America/Atka

/usr/share/zoneinfo/America/Bahia

/usr/share/zoneinfo/America/Bahia_Banderas

/usr/share/zoneinfo/America/Barbados

/usr/share/zoneinfo/America/Belem

/usr/share/zoneinfo/America/Belize

/usr/share/zoneinfo/America/Blanc-Sablon

/usr/share/zoneinfo/America/Boa_Vista

/usr/share/zoneinfo/America/Bogota

/usr/share/zoneinfo/America/Boise

/usr/share/zoneinfo/America/Buenos_Aires

/usr/share/zoneinfo/America/Cambridge_Bay

/usr/share/zoneinfo/America/Campo_Grande

/usr/share/zoneinfo/America/Cancun

/usr/share/zoneinfo/America/Caracas

/usr/share/zoneinfo/America/Catamarca

/usr/share/zoneinfo/America/Cayenne

/usr/share/zoneinfo/America/Cayman

/usr/share/zoneinfo/America/Chicago

/usr/share/zoneinfo/America/Chihuahua

/usr/share/zoneinfo/America/Coral_Harbour

/usr/share/zoneinfo/America/Cordoba

/usr/share/zoneinfo/America/Costa_Rica

/usr/share/zoneinfo/America/Creston

/usr/share/zoneinfo/America/Cuiaba

/usr/share/zoneinfo/America/Curacao

/usr/share/zoneinfo/America/Danmarkshavn

/usr/share/zoneinfo/America/Dawson

/usr/share/zoneinfo/America/Dawson_Creek

/usr/share/zoneinfo/America/Denver

/usr/share/zoneinfo/America/Detroit

/usr/share/zoneinfo/America/Dominica

/usr/share/zoneinfo/America/Edmonton

/usr/share/zoneinfo/America/Eirunepe

/usr/share/zoneinfo/America/El_Salvador

/usr/share/zoneinfo/America/Ensenada

/usr/share/zoneinfo/America/Fort_Nelson

/usr/share/zoneinfo/America/Fort_Wayne

/usr/share/zoneinfo/America/Fortaleza

/usr/share/zoneinfo/America/Glace_Bay

/usr/share/zoneinfo/America/Godthab

/usr/share/zoneinfo/America/Goose_Bay

/usr/share/zoneinfo/America/Grand_Turk

/usr/share/zoneinfo/America/Grenada

/usr/share/zoneinfo/America/Guadeloupe

/usr/share/zoneinfo/America/Guatemala

/usr/share/zoneinfo/America/Guayaquil

/usr/share/zoneinfo/America/Guyana

/usr/share/zoneinfo/America/Halifax

/usr/share/zoneinfo/America/Havana

/usr/share/zoneinfo/America/Hermosillo

/usr/share/zoneinfo/America/Indiana

/usr/share/zoneinfo/America/Indiana/Indianapolis

/usr/share/zoneinfo/America/Indiana/Knox

/usr/share/zoneinfo/America/Indiana/Marengo

/usr/share/zoneinfo/America/Indiana/Petersburg

/usr/share/zoneinfo/America/Indiana/Tell_City

/usr/share/zoneinfo/America/Indiana/Vevay

/usr/share/zoneinfo/America/Indiana/Vincennes

/usr/share/zoneinfo/America/Indiana/Winamac

/usr/share/zoneinfo/America/Indianapolis

/usr/share/zoneinfo/America/Inuvik

/usr/share/zoneinfo/America/Iqaluit

/usr/share/zoneinfo/America/Jamaica

/usr/share/zoneinfo/America/Jujuy

/usr/share/zoneinfo/America/Juneau

/usr/share/zoneinfo/America/Kentucky

/usr/share/zoneinfo/America/Kentucky/Louisville

/usr/share/zoneinfo/America/Kentucky/Monticello

/usr/share/zoneinfo/America/Knox_IN

/usr/share/zoneinfo/America/Kralendijk

/usr/share/zoneinfo/America/La_Paz

/usr/share/zoneinfo/America/Lima

/usr/share/zoneinfo/America/Los_Angeles

/usr/share/zoneinfo/America/Louisville

/usr/share/zoneinfo/America/Lower_Princes

/usr/share/zoneinfo/America/Maceio

/usr/share/zoneinfo/America/Managua

/usr/share/zoneinfo/America/Manaus

/usr/share/zoneinfo/America/Marigot

/usr/share/zoneinfo/America/Martinique

/usr/share/zoneinfo/America/Matamoros

/usr/share/zoneinfo/America/Mazatlan

/usr/share/zoneinfo/America/Mendoza

/usr/share/zoneinfo/America/Menominee

/usr/share/zoneinfo/America/Merida

/usr/share/zoneinfo/America/Metlakatla

/usr/share/zoneinfo/America/Mexico_City

/usr/share/zoneinfo/America/Miquelon

/usr/share/zoneinfo/America/Moncton

/usr/share/zoneinfo/America/Monterrey

/usr/share/zoneinfo/America/Montevideo

/usr/share/zoneinfo/America/Montreal

/usr/share/zoneinfo/America/Montserrat

/usr/share/zoneinfo/America/Nassau

/usr/share/zoneinfo/America/New_York

/usr/share/zoneinfo/America/Nipigon

/usr/share/zoneinfo/America/Nome

/usr/share/zoneinfo/America/Noronha

/usr/share/zoneinfo/America/North_Dakota

/usr/share/zoneinfo/America/North_Dakota/Beulah

/usr/share/zoneinfo/America/North_Dakota/Center

/usr/share/zoneinfo/America/North_Dakota/New_Salem

/usr/share/zoneinfo/America/Ojinaga

/usr/share/zoneinfo/America/Panama

/usr/share/zoneinfo/America/Pangnirtung

/usr/share/zoneinfo/America/Paramaribo

/usr/share/zoneinfo/America/Phoenix

/usr/share/zoneinfo/America/Port-au-Prince

/usr/share/zoneinfo/America/Port_of_Spain

/usr/share/zoneinfo/America/Porto_Acre

/usr/share/zoneinfo/America/Porto_Velho

/usr/share/zoneinfo/America/Puerto_Rico

/usr/share/zoneinfo/America/Punta_Arenas

/usr/share/zoneinfo/America/Rainy_River

/usr/share/zoneinfo/America/Rankin_Inlet

/usr/share/zoneinfo/America/Recife

/usr/share/zoneinfo/America/Regina

/usr/share/zoneinfo/America/Resolute

/usr/share/zoneinfo/America/Rio_Branco

/usr/share/zoneinfo/America/Rosario

/usr/share/zoneinfo/America/Santa_Isabel

/usr/share/zoneinfo/America/Santarem

/usr/share/zoneinfo/America/Santiago

/usr/share/zoneinfo/America/Santo_Domingo

/usr/share/zoneinfo/America/Sao_Paulo

/usr/share/zoneinfo/America/Scoresbysund

/usr/share/zoneinfo/America/Shiprock

/usr/share/zoneinfo/America/Sitka

/usr/share/zoneinfo/America/St_Barthelemy

/usr/share/zoneinfo/America/St_Johns

/usr/share/zoneinfo/America/St_Kitts

/usr/share/zoneinfo/America/St_Lucia

/usr/share/zoneinfo/America/St_Thomas

/usr/share/zoneinfo/America/St_Vincent

/usr/share/zoneinfo/America/Swift_Current

/usr/share/zoneinfo/America/Tegucigalpa

/usr/share/zoneinfo/America/Thule

/usr/share/zoneinfo/America/Thunder_Bay

/usr/share/zoneinfo/America/Tijuana

/usr/share/zoneinfo/America/Toronto

/usr/share/zoneinfo/America/Tortola

/usr/share/zoneinfo/America/Vancouver

/usr/share/zoneinfo/America/Virgin

/usr/share/zoneinfo/America/Whitehorse

/usr/share/zoneinfo/America/Winnipeg

/usr/share/zoneinfo/America/Yakutat

/usr/share/zoneinfo/America/Yellowknife

/usr/share/zoneinfo/Antarctica/Casey

/usr/share/zoneinfo/Antarctica/Davis

/usr/share/zoneinfo/Antarctica/DumontDUrville

/usr/share/zoneinfo/Antarctica/Macquarie

/usr/share/zoneinfo/Antarctica/Mawson

/usr/share/zoneinfo/Antarctica/McMurdo

/usr/share/zoneinfo/Antarctica/Palmer

/usr/share/zoneinfo/Antarctica/Rothera

/usr/share/zoneinfo/Antarctica/South_Pole

/usr/share/zoneinfo/Antarctica/Syowa

/usr/share/zoneinfo/Antarctica/Troll

/usr/share/zoneinfo/Antarctica/Vostok

/usr/share/zoneinfo/Arctic/Longyearbyen

/usr/share/zoneinfo/Asia/Aden

/usr/share/zoneinfo/Asia/Almaty

/usr/share/zoneinfo/Asia/Amman

/usr/share/zoneinfo/Asia/Anadyr

/usr/share/zoneinfo/Asia/Aqtau

/usr/share/zoneinfo/Asia/Aqtobe

/usr/share/zoneinfo/Asia/Ashgabat

/usr/share/zoneinfo/Asia/Ashkhabad

/usr/share/zoneinfo/Asia/Atyrau

/usr/share/zoneinfo/Asia/Baghdad

/usr/share/zoneinfo/Asia/Bahrain

/usr/share/zoneinfo/Asia/Baku

/usr/share/zoneinfo/Asia/Bangkok

/usr/share/zoneinfo/Asia/Barnaul

/usr/share/zoneinfo/Asia/Beirut

/usr/share/zoneinfo/Asia/Bishkek

/usr/share/zoneinfo/Asia/Brunei

/usr/share/zoneinfo/Asia/Calcutta

/usr/share/zoneinfo/Asia/Chita

/usr/share/zoneinfo/Asia/Choibalsan

/usr/share/zoneinfo/Asia/Chongqing

/usr/share/zoneinfo/Asia/Chungking

/usr/share/zoneinfo/Asia/Colombo

/usr/share/zoneinfo/Asia/Dacca

/usr/share/zoneinfo/Asia/Damascus

/usr/share/zoneinfo/Asia/Dhaka

/usr/share/zoneinfo/Asia/Dili

/usr/share/zoneinfo/Asia/Dubai

/usr/share/zoneinfo/Asia/Dushanbe

/usr/share/zoneinfo/Asia/Famagusta

/usr/share/zoneinfo/Asia/Gaza

/usr/share/zoneinfo/Asia/Harbin

/usr/share/zoneinfo/Asia/Hebron

/usr/share/zoneinfo/Asia/Ho_Chi_Minh

/usr/share/zoneinfo/Asia/Hong_Kong

/usr/share/zoneinfo/Asia/Hovd

/usr/share/zoneinfo/Asia/Irkutsk

/usr/share/zoneinfo/Asia/Istanbul

/usr/share/zoneinfo/Asia/Jakarta

/usr/share/zoneinfo/Asia/Jayapura

/usr/share/zoneinfo/Asia/Jerusalem

/usr/share/zoneinfo/Asia/Kabul

/usr/share/zoneinfo/Asia/Kamchatka

/usr/share/zoneinfo/Asia/Karachi

/usr/share/zoneinfo/Asia/Kashgar

/usr/share/zoneinfo/Asia/Kathmandu

/usr/share/zoneinfo/Asia/Katmandu

/usr/share/zoneinfo/Asia/Khandyga

/usr/share/zoneinfo/Asia/Kolkata

/usr/share/zoneinfo/Asia/Krasnoyarsk

/usr/share/zoneinfo/Asia/Kuala_Lumpur

/usr/share/zoneinfo/Asia/Kuching

/usr/share/zoneinfo/Asia/Kuwait

/usr/share/zoneinfo/Asia/Macao

/usr/share/zoneinfo/Asia/Macau

/usr/share/zoneinfo/Asia/Magadan

/usr/share/zoneinfo/Asia/Makassar

/usr/share/zoneinfo/Asia/Manila

/usr/share/zoneinfo/Asia/Muscat

/usr/share/zoneinfo/Asia/Nicosia

/usr/share/zoneinfo/Asia/Novokuznetsk

/usr/share/zoneinfo/Asia/Novosibirsk

/usr/share/zoneinfo/Asia/Omsk

/usr/share/zoneinfo/Asia/Oral

/usr/share/zoneinfo/Asia/Phnom_Penh

/usr/share/zoneinfo/Asia/Pontianak

/usr/share/zoneinfo/Asia/Pyongyang

/usr/share/zoneinfo/Asia/Qatar

/usr/share/zoneinfo/Asia/Qyzylorda

/usr/share/zoneinfo/Asia/Rangoon

/usr/share/zoneinfo/Asia/Riyadh

/usr/share/zoneinfo/Asia/Saigon

/usr/share/zoneinfo/Asia/Sakhalin

/usr/share/zoneinfo/Asia/Samarkand

/usr/share/zoneinfo/Asia/Seoul

/usr/share/zoneinfo/Asia/Shanghai

/usr/share/zoneinfo/Asia/Singapore

/usr/share/zoneinfo/Asia/Srednekolymsk

/usr/share/zoneinfo/Asia/Taipei

/usr/share/zoneinfo/Asia/Tashkent

/usr/share/zoneinfo/Asia/Tbilisi

/usr/share/zoneinfo/Asia/Tehran

/usr/share/zoneinfo/Asia/Tel_Aviv

/usr/share/zoneinfo/Asia/Thimbu

/usr/share/zoneinfo/Asia/Thimphu

/usr/share/zoneinfo/Asia/Tokyo

/usr/share/zoneinfo/Asia/Tomsk

/usr/share/zoneinfo/Asia/Ujung_Pandang

/usr/share/zoneinfo/Asia/Ulaanbaatar

/usr/share/zoneinfo/Asia/Ulan_Bator

/usr/share/zoneinfo/Asia/Urumqi

/usr/share/zoneinfo/Asia/Ust-Nera

/usr/share/zoneinfo/Asia/Vientiane

/usr/share/zoneinfo/Asia/Vladivostok

/usr/share/zoneinfo/Asia/Yakutsk

/usr/share/zoneinfo/Asia/Yangon

/usr/share/zoneinfo/Asia/Yekaterinburg

/usr/share/zoneinfo/Asia/Yerevan

/usr/share/zoneinfo/Atlantic/Azores

/usr/share/zoneinfo/Atlantic/Bermuda

/usr/share/zoneinfo/Atlantic/Canary

/usr/share/zoneinfo/Atlantic/Cape_Verde

/usr/share/zoneinfo/Atlantic/Faeroe

/usr/share/zoneinfo/Atlantic/Faroe

/usr/share/zoneinfo/Atlantic/Jan_Mayen

/usr/share/zoneinfo/Atlantic/Madeira

/usr/share/zoneinfo/Atlantic/Reykjavik

/usr/share/zoneinfo/Atlantic/South_Georgia

/usr/share/zoneinfo/Atlantic/St_Helena

/usr/share/zoneinfo/Atlantic/Stanley

/usr/share/zoneinfo/Australia/ACT

/usr/share/zoneinfo/Australia/Adelaide

/usr/share/zoneinfo/Australia/Brisbane

/usr/share/zoneinfo/Australia/Broken_Hill

/usr/share/zoneinfo/Australia/Canberra

/usr/share/zoneinfo/Australia/Currie

/usr/share/zoneinfo/Australia/Darwin

/usr/share/zoneinfo/Australia/Eucla

/usr/share/zoneinfo/Australia/Hobart

/usr/share/zoneinfo/Australia/LHI

/usr/share/zoneinfo/Australia/Lindeman

/usr/share/zoneinfo/Australia/Lord_Howe

/usr/share/zoneinfo/Australia/Melbourne

/usr/share/zoneinfo/Australia/NSW

/usr/share/zoneinfo/Australia/North

/usr/share/zoneinfo/Australia/Perth

/usr/share/zoneinfo/Australia/Queensland

/usr/share/zoneinfo/Australia/South

/usr/share/zoneinfo/Australia/Sydney

/usr/share/zoneinfo/Australia/Tasmania

/usr/share/zoneinfo/Australia/Victoria

/usr/share/zoneinfo/Australia/West

/usr/share/zoneinfo/Australia/Yancowinna

/usr/share/zoneinfo/Brazil/Acre

/usr/share/zoneinfo/Brazil/DeNoronha

/usr/share/zoneinfo/Brazil/East

/usr/share/zoneinfo/Brazil/West

/usr/share/zoneinfo/Canada/Atlantic

/usr/share/zoneinfo/Canada/Central

/usr/share/zoneinfo/Canada/Eastern

/usr/share/zoneinfo/Canada/Mountain

/usr/share/zoneinfo/Canada/Newfoundland

/usr/share/zoneinfo/Canada/Pacific

/usr/share/zoneinfo/Canada/Saskatchewan

/usr/share/zoneinfo/Canada/Yukon

/usr/share/zoneinfo/Chile/Continental

/usr/share/zoneinfo/Chile/EasterIsland

/usr/share/zoneinfo/Europe/Amsterdam

/usr/share/zoneinfo/Europe/Andorra

/usr/share/zoneinfo/Europe/Astrakhan

/usr/share/zoneinfo/Europe/Athens

/usr/share/zoneinfo/Europe/Belfast

/usr/share/zoneinfo/Europe/Belgrade

/usr/share/zoneinfo/Europe/Berlin

/usr/share/zoneinfo/Europe/Bratislava

/usr/share/zoneinfo/Europe/Brussels

/usr/share/zoneinfo/Europe/Bucharest

/usr/share/zoneinfo/Europe/Budapest

/usr/share/zoneinfo/Europe/Busingen

/usr/share/zoneinfo/Europe/Chisinau

/usr/share/zoneinfo/Europe/Copenhagen

/usr/share/zoneinfo/Europe/Dublin

/usr/share/zoneinfo/Europe/Gibraltar

/usr/share/zoneinfo/Europe/Guernsey

/usr/share/zoneinfo/Europe/Helsinki

/usr/share/zoneinfo/Europe/Isle_of_Man

/usr/share/zoneinfo/Europe/Istanbul

/usr/share/zoneinfo/Europe/Jersey

/usr/share/zoneinfo/Europe/Kaliningrad

/usr/share/zoneinfo/Europe/Kiev

/usr/share/zoneinfo/Europe/Kirov

/usr/share/zoneinfo/Europe/Lisbon

/usr/share/zoneinfo/Europe/Ljubljana

/usr/share/zoneinfo/Europe/London

/usr/share/zoneinfo/Europe/Luxembourg

/usr/share/zoneinfo/Europe/Madrid

/usr/share/zoneinfo/Europe/Malta

/usr/share/zoneinfo/Europe/Mariehamn

/usr/share/zoneinfo/Europe/Minsk

/usr/share/zoneinfo/Europe/Monaco

/usr/share/zoneinfo/Europe/Moscow

/usr/share/zoneinfo/Europe/Nicosia

/usr/share/zoneinfo/Europe/Oslo

/usr/share/zoneinfo/Europe/Paris

/usr/share/zoneinfo/Europe/Podgorica

/usr/share/zoneinfo/Europe/Prague

/usr/share/zoneinfo/Europe/Riga

/usr/share/zoneinfo/Europe/Rome

/usr/share/zoneinfo/Europe/Samara

/usr/share/zoneinfo/Europe/San_Marino

/usr/share/zoneinfo/Europe/Sarajevo

/usr/share/zoneinfo/Europe/Saratov

/usr/share/zoneinfo/Europe/Simferopol

/usr/share/zoneinfo/Europe/Skopje

/usr/share/zoneinfo/Europe/Sofia

/usr/share/zoneinfo/Europe/Stockholm

/usr/share/zoneinfo/Europe/Tallinn

/usr/share/zoneinfo/Europe/Tirane

/usr/share/zoneinfo/Europe/Tiraspol

/usr/share/zoneinfo/Europe/Ulyanovsk

/usr/share/zoneinfo/Europe/Uzhgorod

/usr/share/zoneinfo/Europe/Vaduz

/usr/share/zoneinfo/Europe/Vatican

/usr/share/zoneinfo/Europe/Vienna

/usr/share/zoneinfo/Europe/Vilnius

/usr/share/zoneinfo/Europe/Volgograd

/usr/share/zoneinfo/Europe/Warsaw

/usr/share/zoneinfo/Europe/Zagreb

/usr/share/zoneinfo/Europe/Zaporozhye

/usr/share/zoneinfo/Europe/Zurich

/usr/share/zoneinfo/Indian/Antananarivo

/usr/share/zoneinfo/Indian/Chagos

/usr/share/zoneinfo/Indian/Christmas

/usr/share/zoneinfo/Indian/Cocos

/usr/share/zoneinfo/Indian/Comoro

/usr/share/zoneinfo/Indian/Kerguelen

/usr/share/zoneinfo/Indian/Mahe

/usr/share/zoneinfo/Indian/Maldives

/usr/share/zoneinfo/Indian/Mauritius

/usr/share/zoneinfo/Indian/Mayotte

/usr/share/zoneinfo/Indian/Reunion

/usr/share/zoneinfo/Mexico/BajaNorte

/usr/share/zoneinfo/Mexico/BajaSur

/usr/share/zoneinfo/Mexico/General

/usr/share/zoneinfo/Pacific/Apia

/usr/share/zoneinfo/Pacific/Auckland

/usr/share/zoneinfo/Pacific/Bougainville

/usr/share/zoneinfo/Pacific/Chatham

/usr/share/zoneinfo/Pacific/Chuuk

/usr/share/zoneinfo/Pacific/Easter

/usr/share/zoneinfo/Pacific/Efate

/usr/share/zoneinfo/Pacific/Enderbury

/usr/share/zoneinfo/Pacific/Fakaofo

/usr/share/zoneinfo/Pacific/Fiji

/usr/share/zoneinfo/Pacific/Funafuti

/usr/share/zoneinfo/Pacific/Galapagos

/usr/share/zoneinfo/Pacific/Gambier

/usr/share/zoneinfo/Pacific/Guadalcanal

/usr/share/zoneinfo/Pacific/Guam

/usr/share/zoneinfo/Pacific/Honolulu

/usr/share/zoneinfo/Pacific/Johnston

/usr/share/zoneinfo/Pacific/Kiritimati

/usr/share/zoneinfo/Pacific/Kosrae

/usr/share/zoneinfo/Pacific/Kwajalein

/usr/share/zoneinfo/Pacific/Majuro

/usr/share/zoneinfo/Pacific/Marquesas

/usr/share/zoneinfo/Pacific/Midway

/usr/share/zoneinfo/Pacific/Nauru

/usr/share/zoneinfo/Pacific/Niue

/usr/share/zoneinfo/Pacific/Norfolk

/usr/share/zoneinfo/Pacific/Noumea

/usr/share/zoneinfo/Pacific/Pago_Pago

/usr/share/zoneinfo/Pacific/Palau

/usr/share/zoneinfo/Pacific/Pitcairn

/usr/share/zoneinfo/Pacific/Pohnpei

/usr/share/zoneinfo/Pacific/Ponape

/usr/share/zoneinfo/Pacific/Port_Moresby

/usr/share/zoneinfo/Pacific/Rarotonga

/usr/share/zoneinfo/Pacific/Saipan

/usr/share/zoneinfo/Pacific/Samoa

/usr/share/zoneinfo/Pacific/Tahiti

/usr/share/zoneinfo/Pacific/Tarawa

/usr/share/zoneinfo/Pacific/Tongatapu

/usr/share/zoneinfo/Pacific/Truk

/usr/share/zoneinfo/Pacific/Wake

/usr/share/zoneinfo/Pacific/Wallis

/usr/share/zoneinfo/Pacific/Yap

/usr/share/zoneinfo/US/Alaska

/usr/share/zoneinfo/US/Aleutian

/usr/share/zoneinfo/US/Arizona

/usr/share/zoneinfo/US/Central

/usr/share/zoneinfo/US/East-Indiana

/usr/share/zoneinfo/US/Eastern

/usr/share/zoneinfo/US/Hawaii

/usr/share/zoneinfo/US/Indiana-Starke

/usr/share/zoneinfo/US/Michigan

/usr/share/zoneinfo/US/Mountain

/usr/share/zoneinfo/US/Pacific

/usr/share/zoneinfo/US/Pacific-New

/usr/share/zoneinfo/US/Samoa

--

Feng

冯虚

I have a wordpress website running in a docker instance in azure. It's running over HTTP and I would like to add HTTPS for it.

This can be done easier by a few commands.

// Run companion which used to generate SSL certificate from letsencrypt.org, replace /home/fennng/certs to your own chosen path on your linux host.

sudo docker run \

--name companion \

-v /home/fennng/certs:/etc/nginx/certs:rw \

-v /var/run/docker.sock:/var/run/docker.sock:ro \

--volumes-from nginx-proxy \

jrcs/letsencrypt-nginx-proxy-companion

//Run a new wordpress container instance. Because my wordpress files are hosted on azure file and can be mounted as a volume, I can run wordpress instance as many as I want. They will use same wordpress file and connect to the same db.

sudo docker volume create -d azurefile --name vol3 -o share=wpacishare

docker stop wp2 && docker rm wp2 && \

sudo docker run -d --name wp2 \

-e VIRTUAL_HOST=www.dengnz.com \

-e "LETSENCRYPT_HOST=www.dengnz.com" \

-e "LETSENCRYPT_EMAIL=youremail_address" \

-v vol3:/var/www/html -p 8082:80 wordpress

Stop the original wordpress instance and run nginx-proxy. Do not delete the old wordpress container, in case there is an incident, we can start it again. Your nginx server has to listen to port 80 for letsencrypt to verify the domain. The port 80 must be public.

docker stop wp && \

sudo docker run -p 80:80 -p 443:443 \

--name nginx-proxy \

-v /home/fennng/certs:/etc/nginx/certs:ro \

-v /etc/nginx/vhost.d \

-v /usr/share/nginx/html \

-v /var/run/docker.sock:/tmp/docker.sock:ro \

--label com.github.jrcs.letsencrypt_nginx_proxy_companion.nginx_proxy \

jwilder/nginx-proxy

Now just wait a moment,

Your certificate will be generated in a few seconds

You will see something like this in your nginx log, which is a request from letsencrypt to verify your domain.

www.dengnz.com 66.133.109.36 - - [26/Apr/2018:10:53:10 +0000] "GET /.well-known/acme-challenge/uFc

ds

QYMADRKPwxgg_CeLKMRfdAaNpT23hsY4OH3NikFo HTTP/1.1" 200 87 "-" "Mozilla/5.0 (compatible; Let's Encrypt validation server; +https://www.letsencrypt.org)"

Your HTTPS should be working now. Don't forget to have both of your 80 and 443 exposed to public.

Although the certificate generated by let's Encrypt only valid for 3 months, you don't have to worry about it because the certificate will be renewed automatically.

--

Feng

冯虚的BLOG

星期一, 四月 30, 2018

PHPMyAdmin doesn't work with MYSQL 8.0.11

Dockerfile for building mybb 1.8.15 based on apache and alpine

A problem with docker volume mount on windows

星期六, 四月 28, 2018

A very strange behaviors of docker contained wordpress cont

A quick HTTP server using python docker container

星期五, 四月 27, 2018

A very strange behavior of docker contained wordpress

Copy long console output from SSH to local using conemu

Change time zone in Ubuntu

星期四, 四月 26, 2018

Add HTTPS to wordpress running in docker container

其它博客地址