How to Install RosarioSIS on Debian Latest

Introduction

RosarioSIS is a free, open-source Student Information System that enables educational institutions to easily manage student information, academic records, attendance, and more. It uses PHP and MySQL and can be installed on various platforms. In this tutorial, we will learn how to install RosarioSIS on Debian Latest.

Prerequisites

Before you start the installation process, make sure the following prerequisites are met:

  • A server running Debian latest
  • A web server installed (Apache or Nginx)
  • PHP 7.0 or higher installed
  • MySQL installed and running
  • Git installed

Step 1: Install Apache and PHP

First, you need to install Apache and PHP on your Debian system. Open the terminal and use the following commands to install the Apache web server and PHP:

sudo apt update 
sudo apt install apache2 php php-mysql php-gd php-ldap

Step 2: Install MySQL

Next, you need to install MySQL. Use the following command to install MySQL:

sudo apt install mysql-server

During the installation, you will be prompted to create a root password for MySQL. After you have finished installing MySQL, start the MySQL service:

sudo systemctl start mysql
sudo systemctl enable mysql

Step 3: Create a MySQL Database

Before you can install RosarioSIS, you need to create a MySQL database. Log in to the MySQL console with the following command:

sudo mysql -u root -p

Enter the root password when prompted, then create a new database and user for RosarioSIS:

CREATE DATABASE rosariosisdb;
CREATE USER 'rosariouser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON rosariosisdb.* TO 'rosariouser'@'localhost';
FLUSH PRIVILEGES;

Replace password with a strong password that you choose.

Step 4: Download and Configure RosarioSIS

Now, you can download RosarioSIS from the official website using Git:

sudo git clone https://github.com/francoisjacquet/rosariosis /var/www/html/rosariosis

After the download is complete, change the owner of the RosarioSIS directory to the Apache user:

sudo chown -R www-data:www-data /var/www/html/rosariosis

Create a new Apache configuration file for RosarioSIS with nano:

sudo nano /etc/apache2/sites-available/rosariosis.conf

Enter the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/rosariosis

<Directory /var/www/html/rosariosis>
Options -Indexes +FollowSymLinks
DirectoryIndex index.php
AllowOverride All
Order allow,deny
Allow from all
</Directory>

ErrorLog ${APACHE_LOG_DIR}/rosariosis-error.log
CustomLog ${APACHE_LOG_DIR}/rosariosis-access.log combined
</VirtualHost>

Save the changes and exit nano.

Enable the site configuration:

sudo a2ensite rosariosis.conf

Restart Apache:

sudo systemctl restart apache2

Step 5: Finish the RosarioSIS Installation

Open your web browser and enter the following URL: http://YOUR_SERVER_IP/rosariosis/install.

Follow the on-screen instructions to complete the installation. When prompted for the database information, use the following information:

  • Database Name: rosariosisdb
  • Database Username: rosariouser
  • Database Password: password (the password you created in Step 3)

After the installation is complete, log in to RosarioSIS using the default username and password:

  • Username: admin
  • Password: admin

You should change the default password as soon as possible.

Conclusion

In this tutorial, we learned how to install RosarioSIS on Debian Latest. RosarioSIS is an easy-to-use and powerful student information system that can help educational institutions manage their student information more efficiently.