RosarioSIS is a free and open-source Student Information System (SIS) that helps educational institutes to manage student records, teachers, courses, schedules, attendance, and more. Alpine Linux is a lightweight and secure Linux distribution that is ideal for running server applications. In this tutorial, we will guide you through the installation process of RosarioSIS on Alpine Linux Latest.
Before starting with the installation, you need to fulfill the following prerequisites:
Firstly, update the Alpine Linux system package repository and packages to their latest version by running the below command:
sudo apk update && sudo apk upgrade
To install the required packages, run the following command:
sudo apk add php php-mysqli php-pdo php-pdo_mysql php-json php-ldap php-gd php-mbstring php-curl php-xml php-xmlrpc php-session php-gettext mariadb mariadb-client
After installing the MariaDB server package, start and enable the service to start at boot time using the following command:
sudo rc-update add mariadb && sudo rc-service mariadb start
Then, secure your MariaDB installation by running the below command:
sudo mysql_secure_installation
Log in to the MariaDB server using the following command:
sudo mysql -u root -p
Create a new database for RosarioSIS using the following command:
CREATE DATABASE rosariosis;
Then, create a new user and grant privileges to the created database using the below command:
CREATE USER 'rosariosis'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON rosariosis.* TO 'rosariosis'@'localhost';
FLUSH PRIVILEGES;
Replace "password" with a strong password for your user.
Download the latest version of RosarioSIS from the website https://www.rosariosis.org/download/
Extract the downloaded archive:
tar -zxvf rosariosis-x.x.x.tar.gz -C /var/www/
Change the ownership of the extracted directory to the webserver user:
sudo chown -R www-data:www-data /var/www/rosariosis/
Copy the config-sample.php file to config.php using the below command:
sudo cp /var/www/rosariosis/config-sample.php /var/www/rosariosis/config.php
Edit the config.php file to match the database details you created earlier:
sudo nano /var/www/rosariosis/config.php
Change the following lines:
define('DB_USER', 'rosariosis'); // Your database username
define('DB_PASS', 'password'); // Your database password
define('DB_NAME', 'rosariosis'); // Your database name
The configuration of the Web Server depends on the webserver you are using. Please refer to the respective documentation for details on how to configure the webserver for RosarioSIS.
For Nginx, you can create a new server block as shown below:
sudo nano /etc/nginx/conf.d/default.conf
server {
listen 80 default_server;
server_name _;
root /var/www/rosariosis;
index index.php;
access_log /var/log/nginx/access.log;
error_log /var/log/nginx/error.log;
location / {
try_files $uri $uri/ /index.php?$args;
}
location ~ .php$ {
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}
}
Save the file and restart the Nginx server to apply the changes:
sudo rc-service nginx restart
Now RosarioSIS is installed and configured on your Alpine Linux system. To access it, open your web browser and go to http://
Congratulations! You have successfully installed and configured RosarioSIS on Alpine Linux Latest. Now you can manage your educational institute's student and staff records with ease.
If you want to self-host in an easy, hands free way, need an external IP address, or simply want your data in your own hands, give IPv6.rs a try!
Alternatively, for the best virtual desktop, try Shells!
