LMS and Certification System Integration

Project Overview

This project integrates a Learning Management System (LMS) and a Certification System (CS) using two separate Laravel projects.

Required Libraries/Packages

• Prerequisites

Code Guide

• Codes

Setup Instructions

1. composer install
2. npm run
3. cp .env.example .env
4. php artisan key:generate
5. php artisan migrate
6. php artisan serve
7. npm run dev [for vite]

Setup the database environment

ex (for sql server): DB_CONNECTION=sqlsrv DB_HOST=127.0.0.1 DB_PORT=1433 DB_DATABASE=CS DB_USERNAME= DB_PASSWORD=

For problems with dependencies

1. For specific packages: composer require simplesoftwareio/simple-qrcode or

composer install

3. Then clear cached configuration and regenerate autoloader: php artisan config:cache composer dump-autoload

Artisan Serve/Hosting Problems

Check firewall settings on your computer, ensure the port is open and accessible

1. Open *Windows Defender -> Firewall -> Advanced Settings -> Inbound Rules

2. Modify existing rule for port or... Add new rule for port 2.1 For adding rules:

   2.2 Set rule type to Port

   2.3 Set as TCP and specify port number

   2.4 Allow connection & set to apply to all profiles

3. Check if your device's connection is set to Private/Public by going to *Settings->'name of connection'->Network Profile (Private/Public) (Network profiles can have certain restrictions)

Database Connection Problems

SQL Server Configuration Manager

1. Run SQL Server Configuration Manager
2. Right click on SQL Server (MSSQLSERVER) and set to start

SQL Server TCP/IP Connections

1. Open SQL Server Configuration Manager

2. Navigate to SQL Server Network Configuration -> Protocols for MSSQLSERVER

3. Ensure TCP/IP is enabled

4. To allow SQL server to listen on a specific TCP port

   4.1 Open SQL Server Configuration Manager

   4.2 Under Protocols for MSSQLSERVER, double-click TCP/IP

   4.3 Enable and activate IP1 and IP2, ensure the same port number (IP1 is the first IP address SQL Server binds to)

   4.4 Leave TCP Dynamic Ports as Blank (for IPAII) (IPAII represents all settings that apply to all IP addresses)

   Leave TCP Dynamic Ports blank to make SQL Server listen to a specific port (1433 for defalt instances)