# Automate Deploying a LAMP Stack Application using Ansible # What is Ansible? Ansible is a software tool that provides simple but powerful automation for cross-platform computer support. It is primarily intended for IT professionals, who use it for application deployment, updates on workstations and servers, cloud provisioning, configuration management, intra-service orchestration, and nearly anything a systems administrator does on a weekly or daily basis. Ansible doesn't depend on agent software and has no additional security infrastructure, so it's easy to deploy. In this project, we will use Ansible to deploy a LAMP stack web application on multi-node setup. # Pre-requisites - User with `root` privileges - 3 CentOS hosts on the same network. One will act the Ansible controller, and the other two will acts as target hosts. The hostnames should be configured as below to follow along: - ansible-controller - lamp-db - lamp-web - Ansible installed on ansible-controller host - /etc/hosts/ on `ansible-controller` host is configured with the IP addresses of the targets as below example ![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1666967198317/wyue6mFQd.png align="left") - SSH Password-less login enabled between the ansible-controller host and the two target hosts # **Steps** ## Step1: Create the project folder and access it by running below commands: ``` mkdir lamp-stack-playbooks cd lamp-stack-playbooks ``` ## Step 2: Configure the inventory file - Create an inventory file ``` vi inventory ``` - Copy below lines and paste them in the inventory file. Also, make sure to replace and with your proper DB and Web hosts' IP addresses. In addition you need to specify the user and SSH private key path for both DB and WEB. ``` [db_servers] lamp-db ansible_host= ansible_user= ansible_ssh_private_key_file= mysqlservice=mysqld mysql_port=3306 dbname=ecomdb dbuser=ecomuser dbpassword=ecompassword [web_servers] lamp-web ansible_host= ansible_user= ansible_ssh_private_key_file= httpd_port=80 repository=https://github.com/noweder/lamp-app-ecommerce.git ``` ## Step 3: Prepare the configuration files - Create `files` sub-folder and move into it: ``` mkdir files ``` - Create MySQL Configuration file `my.cnf` under `files` folder: ``` vi files/my.cnf ``` - Paste the below lines inside `my.cnf` and save it: ``` [mysqld] innodb-buffer-pool-size=5242880 # datadir=/var/lib/mysql # socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 port=3306 ``` - Create another file named `db-load-script.sql` on the controller host under `files` folder: ``` vi files/db-load-script.sql ``` - Paste below lines inside `db-load-script.sql` file and save it: ``` USE ecomdb; CREATE TABLE products (id mediumint(8) unsigned NOT NULL auto_increment,Name varchar(255) default NULL,Price varchar(255) default NULL, ImageUrl varchar(255) default NULL,PRIMARY KEY (id)) AUTO_INCREMENT=1; INSERT INTO products (Name,Price,ImageUrl) VALUES ("Laptop","100","c-1.png"),("Drone","200","c-2.png"),("VR","300","c-3.png"),("Tablet","50","c-5.png"),("Watch","90","c-6.png"),("Phone Covers","20","c-7.png"),("Phone","80","c-8.png"),("Laptop","150","c-4.png"); ``` - Create `index.php` file on controller host under `files` folder ``` vi files/index.php ``` - Paste below code inside `index.php` file and make sure to replace `` with your specific DB Host IP address before saving it: ``` E-Commerce Website

Make Your Shopping Easy

Find everything accordingly

Show Now!

Product List

', 'ecomuser', 'ecompassword', 'ecomdb'); if ($link) { $res = mysqli_query($link, "select * from products;"); while ($row = mysqli_fetch_assoc($res)) { ?>

' ?>

Purchase at the lowest price $

Database connection error

``` ## Step 3: Create a `deploy-lamp-stack.yml` playbook file under `lamp-stack-playbooks` and paste below code: ``` --- - name: Deploy lamp stack application hosts: all become: yes tasks: - name: Install common dependencies yum: name: - libselinux-python - libsemanage-python - firewalld state: installed # Install and Configure Database - name: Deploy DB of the application hosts: lamp-db become: yes tasks: - name: Install MariaDB package yum: name: - mariadb-server - MySQL-python state: installed - name: Create Mysql configuration file copy: src=files/my.cnf dest=/etc/my.cnf - name: Start MariaDB Service service: name=mariadb state=started enabled=yes - name: Start firewalld service: name=firewalld state=started enabled=yes - name: insert firewalld rule firewalld: port={{ mysql_port }}/tcp permanent=true state=enabled immediate=yes - name: Create Application Database mysql_db: name={{ dbname }} state=present - name: Create Application DB User mysql_user: name={{ dbuser }} password={{ dbpassword }} priv=*.*:ALL host='' state=present - name: Move db-load-script to db host copy: src: files/db-load-script.sql dest: /tmp/db-load-script.sql - name: Load Inventory Data shell: mysql -f < /tmp/db-load-script.sql - name: Deploy web application hosts: lamp-web become: yes tasks: - name: Install httpd and php yum: name: - httpd - php - php-mysql state: present - name: Install web role specific dependencies yum: name=git state=installed - name: Start firewalld service: name=firewalld state=started enabled=yes - name: insert firewalld rule for httpd firewalld: port={{ httpd_port }}/tcp permanent=true state=enabled immediate=yes - name: Set index.php as the default page tags: "Set index.php as the default page" replace: path: /etc/httpd/conf/httpd.conf regexp: 'DirectoryIndex index.html' replace: 'DirectoryIndex index.php' - name: http service state service: name=httpd state=started enabled=yes - name: Copy the code from repository git: repo={{ repository }} dest=/var/www/html/ force=yes - name: Create the index.php file copy: src=files/index.php dest=/var/www/html/index.php ``` - Make sure to replace `` with your specific Web Host IP address before saving the file. ## Step 4: Run the playbook with below command ``` ansible-playbook -i inventory deploy-lamp-stack.yml ``` - Make sure to replace the `host` value `` in ` Create Application DB User` task with your specific web host IP address. ## Step 5: Access the web application - Run the below command to access the web application from CLI: ``` curl ``` - Or, copy `` and paste it into a web browser. Thank you for reading!