create an instance, make two html pages. On page 1 we have to make a registration page which includes - user, password, email, phone number. it also includes a submit button and already a user log-in button. after clicking on submit button we will proceed to login page which is page 2. On page 2 we have to make login page which includes - user, password and login button. All the data we are typing on these pages will go in the EC2 database. if the data matches with the database it will take us to the welcome page. if the data doesn't match it will show us a popup invalid user or password.
ssh -i "your key" ubuntu@(your publicip).compute-1.amazonaws.com
sudo apt update
For web browsing we have to install apache2. to install apache2 services we have to type the command for installation which is -
sudo apt install apache2 -y
sudo systemctl start apache2
sudo systemctl enable apache2
sudo apt install mysql-server -y
To know more about bind address click on this link https://www.ibm.com/docs/en/cics-tg-zos/9.3.0?topic=hps-bind-address
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
sudo systemctl start mysql
sudo apt install php libapache2-mod-php php-mysql -y
sudo service apache2 start
sudo chown -R www-data:www-data /var/www/html
sudo chmod -R 755 /var/www/html
sudo mysql -u root
CREATE USER 'your_username'@'localhost' IDENTIFIED BY 'your_password';
FLUSH PRIVILEGES;
create database your_database_name;
show databases;
GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'localhost';
FLUSH PRIVILEGES;
cd /var/www/html/
Now we have to create files in /var/www/html/. so firstly , we have to create signup.hmtl page. type-
sudo vim signup.html
<!DOCTYPE html>
<html>
<head>
<title>signup Page</title>
<img src="https://cdn.dribbble.com/users/751212/screenshots/2510592/media/885bb6c1cd2e2cc207a69e8b96cf9504.gif">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/water.css@2/out/water.css">
<script>
function validateForm() {
var username = document.forms["registrationForm"]["username"].value;
var password = document.forms["registrationForm"]["password"].value;
var email = document.forms["registrationForm"]["email"].value;
var phone = document.forms["registrationForm"]["phone"].value;
if (username == "" || password == "" || email == "" || phone == "") {
alert("Please fill in all the fields.");
return false;
}
}
</script>
</head>
<body>
<h1>Registration Page</h1>
<form name="registrationForm" action="database.php" method="post" onsubmit="return validateForm()">
<input type="text" name="username" placeholder="Username">
<input type="password" name="password" placeholder="Password">
<input type="email" name="email" placeholder="Email">
<input type="tel" name="phone" placeholder="Phone Number">
<input type="submit" value="Submit">
<input type="button" value="Login" onclick="window.location.href='login.html'">
</form>
</body>
</html>
sudo vim login.html
<!DOCTYPE html>
<html>
<head>
<title>Login Page</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/water.css@2/out/water.css">
</head>
<body>
<h1>Login Page</h1>
<img src="https://cdn.pixabay.com/animation/2022/12/05/10/47/10-47-58-930_512.gif">
<form action="login.php" method="post">
<input type="text" name="username" placeholder="Username" required>
<input type="password" name="password" placeholder="Password" required pattern=".{6,}" title="Password must be at least 6 characters long.">
<input type="submit" value="Login">
</form>
</body>
</html>
Signup and login pages are done. now we have to create a database page database.php for the user data which will help us in login of user..
sudo vim database.php
<?php
$servername = "localhost";
$username = "ec1"; // Replace with your MySQL username
$password = "ec1@123"; // Replace with your MySQL password
$dbname = "myec1";
// Create a connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Get form data from the previous page (page1.html)
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$username = $_POST["username"];
$password = $_POST["password"];
$email = $_POST["email"];
$phone = $_POST["phone"];
// Insert data into the 'users' table change myec1 here with your table name
$sql = "INSERT INTO myec1 (username, password, email, phone) VALUES ('$username', '$password', '$email', '$phone')";
if ($conn->query($sql) === TRUE) {
echo "Registration Completed";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
$conn->close();
sudo vim index.php
<?php
session_start();
if (isset($_SESSION["user_id"])) {
$mysqli = require __DIR__ . "/database.php";
$sql = "SELECT * FROM user
WHERE id = {$_SESSION["user_id"]}";
$result = $mysqli->query($sql);
$user = $result->fetch_assoc();
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Home</title>
<meta charset="UTF-8">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/water.css@2/out/water.css">
</head>
<body>
<h1>Home</h1>
<?php if (isset($user)): ?>
<p>Hello <?= htmlspecialchars($user["name"]) ?></p>
<p><a href="logout.php">Log out</a></p>
<?php else: ?>
<p><a href="login.html">Log in</a> or <a href="signup.html">sign up</a></p>
<?php endif; ?>
</body>
</html>
sudo vim login.php
<?php
// Replace 'your_db_host', 'your_db_username', 'your_db_password', and 'your_db_name' with your database credentials
$servername = 'localhost';
$username = 'ec1';
$password = 'ec1@123';
$dbname = 'myec1';
// Handling login form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
// Retrieve user input from the login form
$inputUsername = $_POST['username'];
$inputPassword = $_POST['password'];
// Connect to the database
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die('Connection failed:'. $conn->connect_error);
}
// Fetch user data from the database based on the input username change the table name myec1 to ur table name
$query = "SELECT * FROM myec1 WHERE username = '$inputUsername'";
$result = $conn->query($query);
if ($result->num_rows === 1) {
// User found, verify the password
$row = $result->fetch_assoc();
$storedPassword = $row['password'];
if ($inputPassword === $storedPassword) {
// Passwords match, login successful
$conn->close();
header('Location:entert.html');
exit();
}
}
// Login failed
$conn->close();
echo 'Invalid username or password. Please try again.';
}
?>
Now we have to create the table in the my sql for our incoming users which will provide us their data in this form-(name,password,email and phone number).
sudo mysql -u your_useer_name -p
show databases;
use your_database_name;
create table yourtablename (userame varchar(50), password varchar(50), email varchar(50), phone int(50));
select * from your_table_name;
create two instances.we have to create a database in instance one and whenever we type some information in database..it shows us in our second instance too... (master and slave data replication with the help of mysql)
To set up MySQL database replication between two AWS Ubuntu instances, where Instance 1 acts as the master and Instance 2 acts as the slave, follow these steps:
sudo apt update
sudo apt install mysql-server
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
server-id=1
log_bin = /var/log/mysql/mysql-bin.log
#
# The MySQL database server configuration file.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
[mysqld]
#
# * Basic Settings
#
user = mysql
# pid-file = /var/run/mysqld/mysqld.pid
# socket = /var/run/mysqld/mysqld.sock
# port = 3306
# datadir = /var/lib/mysql
# If MySQL is running as a replication slave, this should be
# changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
# tmpdir = /tmp
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0
mysqlx-bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer_size = 16M
# max_allowed_packet = 64M
# thread_stack = 256K
# thread_cache_size = -1
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options = BACKUP
# max_connections = 151
# table_open_cache = 4000
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
#
# Log all queries
# Be aware that this log type is a performance killer.
# general_log_file = /var/log/mysql/query.log
# general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
# slow_query_log = 1
# slow_query_log_file = /var/log/mysql/mysql-slow.log
# long_query_time = 2
# log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
# binlog_expire_logs_seconds = 2592000
max_binlog_size = 100M
# binlog_do_db = include_database_name
# binlog_ignore_db = include_database_name
sudo systemctl restart mysql
sudo mysql -u root
Once logged in, run the following SQL commands to create a replication user and grant appropriate privileges:
CREATE USER 'replication_user_you_created'@'%' IDENTIFIED BY 'your_password_here';
GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%';
FLUSH PRIVILEGES;
SHOW MASTER STATUS;
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
server-id=2
# The MySQL database server configuration file.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
[mysqld]
#
# * Basic Settings
#
user = mysql
# pid-file = /var/run/mysqld/mysqld.pid
# socket = /var/run/mysqld/mysqld.sock
# port = 3306
# datadir = /var/lib/mysql
# If MySQL is running as a replication slave, this should be
# changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
# tmpdir = /tmp
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0
# mysqlx-bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer_size = 16M
# max_allowed_packet = 64M
# thread_stack = 256K
# thread_cache_size = -1
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options = BACKUP
# max_connections = 151
# table_open_cache = 4000
#
# * Logging and Replication
#
# Both location gets rotated by cronjob
#
# Log all queries
# Be aware that this log type is a performance killer.
# general_log_file = /var/log/mysql/query.log
# general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
# slow_query_log = 1
# slow_query_log_file = /var/log/mysql/mysql-slow.log
# long_query_time = 2
# log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
# server-id = 1
server-id = 2
# log_bin = /var/log/mysql/mysql-bin.log
# binlog_expire_logs_seconds = 2592000
max_binlog_size = 100M
# binlog_do_db = include_database_name
# binlog_ignore_db = include_database_name
sudo systemctl restart mysql
NOTE - we have to make sure that our inbound and outbound rules have access to allow traffic from port 3306 for my sql and add new rule in inbound rules and allow,
sudo mysql -u root
CHANGE MASTER TO MASTER_HOST='master_ip_address', MASTER_USER='replication_user', MASTER_PASSWORD='password', MASTER_LOG_FILE='binlog_file_from_master', MASTER_LOG_POS=binlog_position_from_master;
binlog_file_from_master and binlog_position_from_master: The values you obtained from the SHOW MASTER STATUS; command on the master.
START SLAVE;
SHOW SLAVE STATUS\G
Now we have to go to the master instance (instance1) and login to mysql to create a database and insert a table.
sudo mysql -u your_user -p
create database your_database_name;
show databases;
use your_database_name;
CREATE TABLE employees (
employee_id INT PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
hire_date DATE,
department VARCHAR(100)
);
show tables;
insert into table_name ('name','city','standard') values('kitty','england','A');
select * from table_name;
Everything is done and With these steps, you should have set up MySQL database replication between the two AWS Ubuntu instances. Any changes made to the master database on Instance 1 will now be replicated to the slave database on Instance 2.
Now we have to use master instance as registration database and slave instance as login database by which, whenever user type information on registration page it will be saved in master instance and replicate the data in slave instance and whenever user try to login then it will use slave instance to cross verify the user data and give access.
To do this task firstly, we have to change the servername from localhost to public-ip of master instance in database.php which we created in /html/.
cd /var/www/html
sudo vim database.php
Change the servername to public-ip of your master instance. press esc and type:wq exit from the file.
Move on to the slave instance, Now we have to create a new mysql user for the cross verification of data in slave instance for login.php. which will verfiy the user and let user access the welcome page.
sudo mysql
CREATE USER 'replication_user_you_created'@'%' IDENTIFIED BY 'your_password_here';
GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%';
FLUSH PRIVILEGES;
Now GO BACK IN WEBSITE INSTANCE and open the login.php file and change the servername to public_ip of slave instance.change the username to the user you just created im slave instance.
Change the password with your user-password and change the dbname with the database you created in MASTER INSTANCE IN MYSQL. FOR EX- if i created moon database with the help of mysql user which i created in master instance then i have to copy paste the name of moon database in the place of dbname.
cd /var/www/html
sudo vim login.php