LEMP Dock

A docker image for LEMP Stack Development

Installation / Usage

Run following commands to clone the repo, build and run LEMP Dock docker image.

git clone [email protected]:arifulhb/lempdock.git lemptdock
cd lempdock
lemp/build
lemp/run

Usage

• Build the docker image :
  • Use command lemp/build to build the lempdock image.
• Run the docker image:
  • Use command lemp/run to run the containers
• Stop the container:
  • lemp/stop to stop the containers
• SSH to php-fpm container
  • lemp/ssh and you'll be in /var/www directory of php-fpm container.

Included Softwares:

1. Debian 9.8 / stretch OS
2. PHP 7.2
3. Nginx
4. MySQL 5.7
5. Compose 1.8 for PHP Package Management
6. Nodejs 10.15
7. NPM 6.4
8. git 2.11

Documentation

PHP-FPM

Symlink your source code in the www directory and this source code will be available in your php-fpm and nginx containers /var/www diectory.

Do the following to symlink your PHP based app:

1. cd to your www directory
2. Run the following: ln -s /path/to/project html

Nginx

To add a new site in your LEMP Dock, you need to add a new nginx config file in images/nginx/sites/ directory. Create a copy of the images/nginx/sites/default.conf file and edit server_name and root according to your application.

MySQL

Default settings to connect from SequelPro or MySQL Workbench

host: 127.0.0.1
user: root
pass: root
port: 33066

Default settings to connect from PHP App inside php-fpm container

host: mysql
port: 3306
user: root
pass: root

Restore database from backup

Using Workbench

Set up workbench to connect to local host by entering the folowing:

1. Click on plus icon to add new server
2. Enter mysql information above
3. Once connected, click on Data Import/Restore
4. In the Import Options section, click Import from Self-Contained File
5. Select your file by click on the button to the far right of option choice
6. Set your Default Target Schema by clicking on the New button at the far left and entering the name xchangge
7. Select Start Import

Using Terminal

Find the container id for mysql and then run the following to access:

docker exec -it <container id> bash

After accessing, Create the database and the database user and assign the permissions

After that, Copy the database to the mysql container using the following command:

docker exec -i <container id> sh -c 'exec mysql -uroot -proot xchangge' < ./nameofdbbackup.sql