Computer Laboratory Monitoring System

An RFID-based system for monitoring the computer laboratory.

This system has 3 parts

• Computer Laboratory Monitoring App
• PC User Monitoring App
• Door Accessing Logging

Installation

Prerequisite

RFID Reader is needed to use the programs

Server Side

1. Install Computer Laboratory Monitoring App

2. Install XAMMP

3. Configure XAMMP

   1. Configure Apache to allow external access
      1. Open this file: C:\xampp\apache\conf\extra\httpd-xampp.conf
      2. Find this section: <Directory "C:/xampp/phpMyAdmin"> AllowOverride AuthConfig Require local
      3. Replace Require local with this: Require all granted
   2. Allow remote connections to MySQL
      1. Open my.ini C:\xampp\mysql\bin\my.ini
      2. Find this line: bind-address=127.0.0.1
      3. Comment it out or change it to: #bind-address=127.0.0.1
   3. Grant access
      1. To external IPs

            CREATE USER 'root'@'%' IDENTIFIED BY '';
            GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
            FLUSH PRIVILEGES;

      2. To your other computer’s with same network
         • change "192.168.1" to your local subnet, you can get it using ipconfig

           CREATE USER 'root'@'192.168.1.%' IDENTIFIED BY '';
           GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.%' WITH GRANT OPTION;
           FLUSH PRIVILEGES;

4. Creating Database and Tables

   1. Start the Apache and MySQL in the Xampp Control Panel
   2. Open a browser the search “http://localhost/phpmyadmin/”
   3. Click “New->SQL” then paste this code:

         CREATE DATABASE IF NOT EXISTS pums
         CHARACTER SET utf8mb4
         COLLATE utf8mb4_general_ci;
         
         USE pums;
         
         -- Credentials
         CREATE TABLE cred (
           user VARCHAR(100) NOT NULL,
           password VARCHAR(100) NOT NULL
         );
         
         INSERT INTO cred (user, password)
         VALUES ('admin', '123456');
         
         -- PC Log History
         CREATE TABLE log_history_pc (
           id INT AUTO_INCREMENT PRIMARY KEY,
           school_id VARCHAR(100) NOT NULL,
           name VARCHAR(100) NOT NULL,
           date VARCHAR(100) NOT NULL,
           time_in VARCHAR(100) NOT NULL,
           time_out VARCHAR(100) NOT NULL,
           room VARCHAR(100) NOT NULL,
           pc_name VARCHAR(100) NOT NULL,
           file_name VARCHAR(100) NOT NULL,
           file_content TEXT NOT NULL
         );
         
         -- Room Log History
         CREATE TABLE log_history_room (
           id INT AUTO_INCREMENT PRIMARY KEY,
           name VARCHAR(100) NOT NULL,
           date VARCHAR(100) NOT NULL,
           time_in VARCHAR(100) NOT NULL,
           time_out VARCHAR(100) NOT NULL,
           room_name VARCHAR(100) NOT NULL,
           school_id VARCHAR(100) NOT NULL
         );
         
         -- Registered Students
         CREATE TABLE registered_students (
           uid VARCHAR(100) PRIMARY KEY,
           name VARCHAR(100) NOT NULL,
           school_id VARCHAR(100) NOT NULL,
           gender VARCHAR(100) NOT NULL
         );
         
         -- Registered Teachers
         CREATE TABLE registered_teachers (
           uid VARCHAR(100) PRIMARY KEY,
           name VARCHAR(100) NOT NULL,
           school_id VARCHAR(100) NOT NULL,
           gender VARCHAR(100) NOT NULL
         );
      

5. Open Computer Laboratory Monitoring App

   • using "123456" as defualt password

Client Side

1. Install PC User Monitoring App
2. Install Door Accessing Logging