Docker Lab \u2013 Containerising your website, Part 2<\/a>)<\/p>\nConfiguring your Containers.<\/h2>\n
Yet again, it will come as no surprise that, in order to install PHP, we need to edit the docker-compose.yml file. It will be necessary to stop Docker (just in case you left it running from the last session). You may remember that you can edit the docker-compose.yml file while Docker is still running – but the changes won’t take effect until Docker is restarted. I shan’t tell you how to stop the containers. You can look that up for yourself in Part 2.<\/p>\n
Edit docker-compose.yml to add the maria-db container. I added it just below services and before nginx. Replace <Your Root Password Goes Here> with a password of your choice. Make it complicated – and remember that you probably aren’t going to have to type it all that often, so it doesn’t need to be convenient for your fingers. I generally use a UUID – something like this ‘1e1fdb9c-6ba5-48ea-9640-7801eed2022e’.<\/p>\n
maria-db:\r\n image: 'bitnami\/mariadb:latest'\r\n networks:\r\n - app-tier\r\n environment:\r\n - MARIADB_ROOT_PASSWORD=<Your Root Password Goes Here>\r\n volumes:\r\n - .\/db-data:\/bitnami<\/pre>\nGenerating a UUID.<\/h3>\n
If you do want to use a UUID for your password then you can generate one using the following command:<\/p>\n
cat \/proc\/sys\/kernel\/random\/uuid<\/pre>\nStarting Docker<\/h3>\n
Now start Docker, giving it a little while to start up and configure MariaDB before moving on to the next step:<\/p>\n
cd ~\/lemp-compose \r\ndocker-compose up --remove-orphans -d<\/pre>\nTesting your MariaDB install<\/h2>\n
A useful online tool for administering your database and also for testing that MariaDB has been installed correctly is phpminiadmin.php – in fact this will exercise every part of your set up.<\/p>\n
Place the phpminiadmin.php into your site directory as follows:<\/p>\n
cd ~\/lemp-compose\/public\/<your website name>\/htdocs\r\nwget https:\/\/raw.github.com\/osalabs\/phpminiadmin\/master\/phpminiadmin.php<\/pre>\nBrowse to your website URL – in this example, http:\/\/<your domain name>\/phpminiadmin.php, and you’ll see the phpminiadmin page. Click “advanced settings” and log in as follows:<\/p>\n
Username:<\/strong> root<\/em><\/p>\nHostname:<\/strong> maria-db<\/em><\/p>\nPassword:<\/strong> whatever you specified in the Docker Compose file.<\/p>\nYou will now have access to the phpMiniAdmin database management interface. You can use this interface to create databases and tables and execute SQL queries on your MariaDB database server.<\/p>\n
If that all worked then next time we’ll add certificates. If it didn’t work, go back and check your working.<\/p>\n
Note!<\/h2>\n
If you want to connect to this MariaDB instance from your desktop computer using a tool like Navicat Essentials, you need the following setup.<\/p>\n
Click the SSH tab, check the ‘Use SSH tunnel’ checkbox and fill in the details that you use to SSH into the server.<\/p>\n
Next click on the General tab and fill in the User Name as ‘root’ and the password as\u00a0whatever you specified in the Docker Compose file. \u00a0The Host Name \/ IP Address needs to be retrieved from Docker with the following command:<\/p>\n
docker inspect <containerID> | grep \\\"IPAddress\\\"<\/pre>\nGet the Container ID using docker ps, as previously. \u00a0Note that the IP Address may change periodically – so if you can’t connect for whatever reason, check this first.<\/p>\n","protected":false},"excerpt":{"rendered":"
So you’ve set up containers for Nginx and for PHP – now you’d like to have a database. After all the work of the last two labs you’ll be glad to hear than adding MariaDB to the mix is very simple – we can get it up and running in minutes.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[15,18,28,5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/595"}],"collection":[{"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=595"}],"version-history":[{"count":0,"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/595\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.45rpmsoftware.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}