How to configure nginx+php+mysql in docker

First, understand a method:

Entering a Docker container using docker exec

Docker also provides a new command exec after version 1.3.X for entering the container. This method is relatively simpler. Let's take a look at the use of this command:

sudo docker exec --help 

Next we use this command to enter an already running container

$ sudo docker ps 
$ sudo docker exec -it 775c7c9ee1e1 /bin/bash

1. Configure nginx

Find the nginx image on Docker Hub

runoob@runoob:~/nginx$ docker search nginx
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
nginx Official build of Nginx. 3260 [OK]    
jwilder/nginx-proxy Automated Nginx reverse proxy for docker c... 674 [OK]
richarvey/nginx-php-fpm Container running Nginx + PHP-FPM capable ... 207 [OK]
million12/nginx-php Nginx + PHP-FPM 5.5, 5.6, 7.0 (NG), CentOS... 67 [OK]
maxexcloo/nginx-php Docker framework container with Nginx and ... 57 [OK]
webdevops/php-nginx Nginx with PHP-FPM 39 [OK]
h3nrik/nginx-ldap NGINX web server with LDAP/AD, SSL and pro... 27 [OK]
bitnami/nginx Bitnami nginx Docker Image 19 [OK]
maxexcloo/nginx Docker framework container with Nginx instance... 7 [OK]
...

Here we pull the official image

runoob@runoob:~/nginx$ docker pull nginx

After waiting for the download to complete, we can find the mirror with REPOSITORY as nginx in the local mirror list.

runoob@runoob:~/nginx$ docker images nginx
REPOSITORY TAG IMAGE ID CREATED SIZE
nginx latest 555bbd91e13c 3 days ago 182.8 MB

Create and run the container:

docker run --name mynginx -p 80:80 -v /var/www:/var/www -v /usr/local/nginx/conf/conf.d:/etc/nginx/conf.d -d nginx

Notice:

-v adds file mappings so that files changed on the host can be directly mapped into the container. The directory here is mapped according to your actual situation.

After creating and running the container, nginx in docker is started successfully. There is no need to enter docker to start nginx again. Otherwise, it will prompt that ports 80 and other ports are occupied because nginx has already started.

At this time, you can access the domain name verification configured by nginx.

The conf.d I mapped here mainly contains the nginx configuration file, and the php configuration information is:

# php
server {
  charset utf-8;
  client_max_body_size 128M;

  listen 80; ## listen for ipv4
  #listen [::]:80 default_server ipv6only=on; ## listen for ipv6

  server_name www.baidu.com;
  root /var/www;
  index index.php;

  location / {
    #-e means as long as filename exists, it is true if (!-e $request_filename){
      rewrite ^(.*)$ /index.php?s=$1 last;
      break;
    }
    # Redirect everything that isn't a real file to index.php
    try_files $uri $uri/ /index.php$is_args$args;
  }

  # uncomment to avoid processing of calls to non-existing static files by Yii
  #location ~ \.(js|css|png|jpg|gif|swf|ico|pdf|mov|fla|zip|rar)$ {
  # try_files $uri =404;
  #}
  #error_page 404 /404.html;

  # deny accessing php files for the /assets directory
  location ~ ^/assets/.*\.php$ {
    deny all;
  }

  location ~ \.php$ {
    include fastcgi_params;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    fastcgi_pass 172.17.0.3:9000;
    #fastcgi_pass unix:/var/run/php5-fpm.sock;
    try_files $uri =404;
  }

  location ~* /\. {
    deny all;
  }
}

Note the IP address of fastcgi_pass at the end, which is described in detail in the FAQ of PHP configuration.

2. PHP configuration

Find the PHP image on Docker Hub

runoob@runoob:~/php-fpm$ docker search php
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
php While designed for web development, the PH... 1232 [OK]    
richarvey/nginx-php-fpm Container running Nginx + PHP-FPM capable ... 207 [OK]
phpmyadmin/phpmyadmin A web interface for MySQL and MariaDB. 123 [OK]
eboraas/apache-php PHP5 on Apache (with SSL support), built of... 69 [OK]
php-zendserver Zend Server - the integrated PHP applicati... 69 [OK]    
million12/nginx-php Nginx + PHP-FPM 5.5, 5.6, 7.0 (NG), CentOS... 67 [OK]
webdevops/php-nginx Nginx with PHP-FPM 39 [OK]
webdevops/php-apache Apache with PHP-FPM (based on webdevops/php) 14 [OK]
phpunit/phpunit PHPUnit is a programmer-oriented testing framework... 14 [OK]
tetraweb/php PHP 5.3, 5.4, 5.5, 5.6, 7.0 for CI and run... 12 [OK]
webdevops/php PHP (FPM and CLI) service container 10 [OK]
...

Here we pull the official image, tagged 5.6-fpm

runoob@runoob:~/php-fpm$ docker pull php:5.6-fpm

After waiting for the download to complete, we can find the image with REPOSITORY as php and tag as 5.6-fpm in the local mirror list.

runoob@runoob:~/php-fpm$ docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
php 5.6-fpm 025041cd3aa5 6 days ago 456.3 MB

Create and run the php container:

docker run -p 9000:9000 --name phpfpm -v /var/www:/var/www -d php:5.6-fpm

Note that you must create a file mapping here, or there must be corresponding PHP code in the PHP container. The file mapping of nginx in the previous step cannot be found here. So if there is no file mapping, 127.0.0.1:9000 cannot find the file in this container.

Frequently Asked Questions:

After starting the PHP container, if you access nginx, it will show: 502 Bad Gateway

Try the following:

View the IP address of the PHP mirror

docker inspect --format='{{.NetworkSettings.IPAddress}}' phpfpm

For example: 192.168.4.202

Then modify the conf configuration file of nginx to set the value of fastcgi_pass to 192.168.4.202:9000

vim /docker/nginx/conf.d/default.conf

fastcgi_pass 192.168.4.202:9000;

After restarting the nginx container, you can access it normally.

3. MySQL configuration

Find the mysql image on Docker Hub

runoob@runoob:/mysql$ docker search mysql
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
mysql MySQL is a widely used, open-source relati... 2529 [OK]    
mysql/mysql-server Optimized MySQL Server Docker images. Create... 161 [OK]
centurylink/mysql Image containing mysql. Optimized to be li... 45 [OK]
sameersbn/mysql 36 [OK]
google/mysql MySQL server for Google Compute Engine 16 [OK]
appcontainers/mysql Centos/Debian Based Customizable MySQL Con... 8 [OK]
marvambass/mysql MySQL Server based on Ubuntu 14.04 6 [OK]
drupaldocker/mysql MySQL for Drupal 2 [OK]
azukiapp/mysql Docker image to run MySQL by Azuki - http:... 2 [OK]
...

Here we pull the official image, tagged 5.6

runoob@runoob:~/mysql$ docker pull mysql:5.6

After waiting for the download to complete, we can find the image with REPOSITORY as mysql and tag 5.6 in the local mirror list.

runoob@runoob:~/mysql$ docker images |grep mysql
mysql 5.6 2c0964ec182a 3 weeks ago 329 MB

Create and run the MySQL container:

docker run -p 3306:3306 --name mysql -v /usr/local/mysql:/etc/mysql/sqlinit -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6

The main purpose of the file mapping here is to map the host's sql database data file to the docker mysql container for easy import. Note that the directory of the mysql container cannot be an existing directory, otherwise it will be overwritten.

Notice:

Here, it is easy to create my.cnf, so there is no need to add it yourself.

expand

Use external tool navicat to connect to mysql in docker

For mysql host, fill in the IP in docker, and obtain it as follows:

docker inspect --format='{{.NetworkSettings.IPAddress}}' mysql 

Fill in the ssh connection information:

The connection is successful!

Notice:

The startup order of Docker containers will cause inconsistent container IP addresses. If the container IP is used to connect to the database and fastcgi, pay attention to the startup order of the containers.

Restart the container: docker restart container name/container ID

Shut down the container: docker stop xxx

Start the container: docker start xxx

View the running containers: docker ps

View all containers (including non-running containers): docker ps -a

Create and run the container: docker run

---------------------------------------

Common errors:

1. thinkphp reports an error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND'

The pdo_mysql extension is missing and database connection fails.

Find php.ini, copy a copy of php.ini in /usr/local/etc/php in docker, add extension=pdo_mysql.so, and restart phpfpm.

If it still doesn't work, visit the phpinfo page to see if there is pdo_mysql

If not, the extension does not exist and needs to be compiled.

The compilation method is as follows:

This can be achieved in two ways

Method 1 (unverified):

pecl pdo_msql

Method 2 (proven feasible):

Go to the PHP container of Docker, in the PHP folder:

docker-php-ext-install pdo pdo_mysql

If it reports /usr/local/bin/docker-php-ext-enable: cannot create /usr/local/etc/php/conf.d/docker-php-ext-pdo_mysql.ini: Directory nonexistent

Solution:

Create a new conf.d directory and the corresponding docker-php-ext-pdo_msql.ini file directly under the /usr/local/etc/php directory

The content of docker-php-ext-pdo_msql.ini is:

extension=pdo_mysql.so

2. thinkphp reports error _STORAGE_WRITE_ERROR_:./Application/Runtime/Cache/Home/4e64ea6a2012f26b832b14cbc2152b28.php

This is because the server cache folder does not have sufficient operation permissions, that is, Runtime does not have permissions. Delete all cache files and then give Runtime777 permissions.

sudo chmod 777 Runtime or directly set 777 permissions on the outermost layer of the code base

3. ThinkPHP verification code image cannot be displayed

Missing gd extension, install:

docker-php-ext-install pdo pdo_mysql

The following errors may be reported:

If configure fails try --with-webp-dir=<DIR>
If configure fails try --with-jpeg-dir=<DIR>
configure: error: png.h not found.

Install:

apt-get install libpng-dev libjpeg-dev

Execute again:

// Add freetype configuration docker-php-ext-configure gd --enable-gd-native-ttf --with-freetype-dir=/usr/include/freetype2 --with-png-dir=/usr/include --with-jpeg-dir=/usr/include

// Install docker-php-ext-install gd

php.ini adds php_gd2.so

The gd library is displayed in phpinfo

Note that if there is no freetype support in the gd library of phpinfo, the verification code will still not be displayed and an error will be reported:

Call to undefined function Think_imagettftext()

If freeType is not available in the gd library, follow these steps:

docker-php-ext-configure gd --enable-gd-native-ttf --with-freetype-dir=/usr/include/freetype2 --with-png-dir=/usr/include

Recompile:
docker-php-ext-install gd

If an error occurs:

configure: error: freetype-config not found.

Run: apt-get -y install libfreetype6-dev and then continue to run the above command.

With freetype in the gd library, the verification code is displayed normally:

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.