kodekloudhub/learning-app-ecommerce

A sample e-commerce learning app

Introduction

This is a sample e-commerce application built for learning purposes.

Here's how to deploy it on CentOS systems:

Deploy Pre-Requisites

1. Install FirewallD

sudo yum install -y firewalld
sudo systemctl start firewalld
sudo systemctl enable firewalld
sudo systemctl status firewalld

Deploy and Configure Database

1. Install MariaDB

sudo yum install -y mariadb-server
sudo vi /etc/my.cnf
sudo systemctl start mariadb
sudo systemctl enable mariadb

2. Configure firewall for Database

sudo firewall-cmd --permanent --zone=public --add-port=3306/tcp
sudo firewall-cmd --reload

3. Configure Database

$ mysql
MariaDB > CREATE DATABASE ecomdb;
MariaDB > CREATE USER 'ecomuser'@'localhost' IDENTIFIED BY 'ecompassword';
MariaDB > GRANT ALL PRIVILEGES ON *.* TO 'ecomuser'@'localhost';
MariaDB > FLUSH PRIVILEGES;

ON a multi-node setup remember to provide the IP address of the web server here: 'ecomuser'@'web-server-ip'

4. Load Product Inventory Information to database

Create the db-load-script.sql

cat > db-load-script.sql <<-EOF
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");

EOF

Run sql script

sudo mysql < db-load-script.sql

Deploy and Configure Web

1. Install required packages

sudo yum install -y httpd php php-mysqlnd
sudo firewall-cmd --permanent --zone=public --add-port=80/tcp
sudo firewall-cmd --reload

2. Configure httpd

Change DirectoryIndex index.html to DirectoryIndex index.php to make the php page the default page

sudo sed -i 's/index.html/index.php/g' /etc/httpd/conf/httpd.conf

3. Start httpd

sudo systemctl start httpd
sudo systemctl enable httpd

4. Download code

sudo yum install -y git
sudo git clone https://github.com/kodekloudhub/learning-app-ecommerce.git /var/www/html/

5. Update index.php

Update index.php file to connect to the right database server. In this case localhost since the database is on the same server.

sudo sed -i 's/172.20.1.101/localhost/g' /var/www/html/index.php

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

ON a multi-node setup remember to provide the IP address of the database server here.

sudo sed -i 's/172.20.1.101/localhost/g' /var/www/html/index.php

6. Test

curl http://localhost

learning-app-ecommerce's Issues

git clone

Hi @mmumshad

Below command won't work as /var/www/html/ directory is owned by root, so it won't be able to download code in that location.

git clone https://github.com/kodekloudhub/learning-app-ecommerce.git /var/www/html/

So you should use below command

sudo git clone https://github.com/kodekloudhub/learning-app-ecommerce.git /var/www/html/

Can't connect to remote Mysql server from php

When I'm trying to open in browser "http://myserverip", I get:
Error: Can't connect to MySQL server on '1.1.1.1' (13)
but when I'm starting this script from command line on the server 1.1.1.1, I have another result:
mysql -h 111.111.111.111 -u user -p -P 3306
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 25236357
Server version: 5.5.14-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

---

Any help?

footer.jpg image missing from img subdir

Not a big deal but I run into the issue of passing my own validation test to confirm that the app is running.

Can you please add or delete this file from your the /scss/_footer.scss file?

start service issue for Install FirewallD, Install MariDB, Install Httpd

All the service should be started using sudo systemctl start <servicename> instead of sudo service <servicename> start

Correct
eg: sudo systemctl start mariadb

Wrong
eg: sudo service mariadb start

Where to edit environment variable in updated code of index.php

index.php is updated to use environment variable to call the mysql creds. In which file It needs to edit, is it system ENV file ?

Start service

Instead of
sudo service mariadb start

it should be
sudo systemctl start mariadb

You just need to update the README.md

Need to disable SELinux on web

I spent a boatload of time trying to figure out why my web page couldn't connect to the DB.

First I realized that I needed to use an IP address in both the Mysql user permissions and the mysqli_connect call.

But it was still giving me this error on the web page.

2003:Can't connect to MySQL server on '192.168.86.54' (13)  

I tried installing MySQL on the web server and was able to connect using the mysql client.

Finally I found this Stackoverflow article which said to set

setsebool -P httpd_can_network_connect_db=1

That worked. I ended up using this in my playbook.

- selinux:
  state: disabled

php-mysql package not found for centos8

Instead of
yum install php-mysql

it should be
yum install php-mysqlnd
https://stackoverflow.com/questions/63363030/how-do-i-install-the-mysql-extension-for-php-7-on-centos-8

You just need to update the README.md