i cant connect the backend mysql and the front end nodejs on my ec2

Question

i am using an unbuntu server on AWS EC2 and on the same instance i am hosting my web app(nodejs) and MySQL as the backend. i cant register a user i keep getting the error : (The requested URL was not found on this server.) the setup on the server is like ``` /home/ubuntu/application │ ├── index.html ├── register.html ├── style.css │ └── server ├── server.js ├── package.json ├── package-lock.json └── node_modules ``` ---index.html--- ``` Home page

webapp

Move the mouse over the button to open the dropdown menu.

``` ---register.html--- ``` Registration Form ``` ---server.js--- ``` const http = require('http'); const mysql = require('mysql2'); const express = require('express'); const bcrypt = require('bcrypt'); const bodyParser = require('body-parser'); const path = require('path'); const app = express(); const port = 3006; const connection = mysql.createConnection({ host: 'EC2 private IP', user: 'ubuntu', password: 'password', database: 'WebApp', port: '3306', }); connection.connect((err) => { if (err) { console.error('Error connecting to MySQL:', err); return; } console.log('Connected to MySQL'); }); app.use(bodyParser.urlencoded({ extended: false })); app.use(bodyParser.json()); // Serve static files from the 'application' directory app.use(express.static(path.join(__dirname, 'application'))); // Your route handlers come after this app.post('/register', (req, res) => { const { fullName, title, agency, email, telephone, password, passwordConfirm } = req.body; if (password !== passwordConfirm) { return res.send('Passwords do not match'); } bcrypt.hash(password, 10, (err, hashedPassword) => { if (err) { console.error('Error hashing password:', err); return res.send('Error hashing password'); } const userData = { full_name: fullName, title, agency, email, telephone, password: hashedPassword, }; connection.query('INSERT INTO users SET ?', userData, (err, results) => { if (err) { console.error('Error inserting user data:', err); return res.send('Error inserting user data'); } res.redirect('/index.html'); }); }); }); // Handle root URL ('/') app.get('/', (req, res) => { res.sendFile(path.join(__dirname, 'application', 'index.html')); }); // Handle GET request for /register.html app.get('/register.html', (req, res) => { res.sendFile(path.join(__dirname, '../', 'register.html')); }); /* // Handle GET request for /index.html app.get('/index.html', (req, res) => { res.sendFile(path.join(__dirname, '../', 'index.html')); }); */ const server = http.createServer(app); server.listen(port, () => { console.log(`Server running on port ${port}`); }); ``` i tried the code on my local machine and i was able to populate the users table in Mysql. i slightly modified the code to work on the ec2 after testing it on local machine. i checked if i can connect to the ec2 instance from MySQL Workbench db on my workstation and it was successful. i also checked if i can ssh into the server from the terminal that was also successful. security group: inbound ``` - IPv4 SSH TCP 22 0.0.0.0/0 – – IPv4 MYSQL/Aurora TCP 3306 0.0.0.0/0 – – IPv4 HTTPS TCP 443 0.0.0.0/0 – – IPv4 HTTP TCP 80 0.0.0.0/0 – – IPv4 Custom TCP TCP 3006 0.0.0.0/0 ``` outbound ``` IPv4 All traffic All All ``` network ACL inbound ``` 1 SSH (22) TCP (6) 22 73.15.7.194/32 Allow 22 SSH (22) TCP (6) 22 0.0.0.0/0 Allow 88 MySQL/Aurora (3306) TCP (6) 3306 0.0.0.0/0 Allow 89 Custom TCP TCP (6) 1 - 888 0.0.0.0/0 Allow 100 All traffic All All 0.0.0.0/0 Allow ``` outbound ``` 22 SSH (22) TCP (6) 22 0.0.0.0/0 Allow 88 MySQL/Aurora (3306) TCP (6) 3306 0.0.0.0/0 Allow 100 All traffic All All 0.0.0.0/0 Allow * All traffic All All 0.0.0.0/0 Deny ``` i cant figure out what im missing? the document root is set : /var/www/html/application

Answer

I am curious to see what happens if you change your form action from

i cant connect the backend mysql and the front end nodejs on my ec2

Relevant content