RosarioSIS is a free and open-source Student Information System (SIS) that helps educational institutions manage and keep track of all features related to students, such as grades, attendance, schedules, and more.
In this tutorial, we will guide you through the process of installing RosarioSIS on the latest version of FreeBSD.
Before we get started, make sure that you have the following:
To start, we need to install a few packages that are required for RosarioSIS.
Run the following command to install the required packages:
pkg install php74 php74-mysqli php74-pdo_mysql
This command will install PHP along with the mysqli and pdo_mysql extensions required for database connectivity.
Next, we need to download the latest version of RosarioSIS from its official website. You can either download the file using the wget command or download it manually and upload it to your FreeBSD server.
To download the file using wget, run the following command:
wget https://www.rosariosis.org/rosarioSIS-7.8.2.tar.gz
This command will download the RosarioSIS installation package to your FreeBSD server.
After downloading the file, navigate to the directory where you've downloaded the compressed file and extract it using the following command:
tar -xzvf rosarioSIS-7.8.2.tar.gz
This command will extract the RosarioSIS files to a directory named rosarioSIS-7.8.2
.
In this step, move the extracted RosarioSIS directory to your web server's document root.
For example, if you're using the Apache web server, move the extracted directory to Apache's document root directory:
mv rosarioSIS-7.8.2 /usr/local/www/apache24/data/
After moving RosarioSIS to the document root, set the correct ownership and permissions for the files and directories. Run the following commands to do so:
cd /usr/local/www/apache24/data/rosarioSIS-7.8.2
chown -R www:www *
chmod -R 775 *
These commands set the ownership and permission to the www
user and group for all files and directories inside the RosarioSIS directory.
Before installing RosarioSIS, create a MySQL or MariaDB database and user that will be used to store and retrieve data.
Log in to your MySQL or MariaDB server as root:
mysql -u root -p
Create a new database by entering the following command:
CREATE DATABASE rosariosisdb;
Next, create a new MySQL or MariaDB user for RosarioSIS with the following command:
CREATE USER 'rosariosisuser'@'localhost' IDENTIFIED BY 'Your_Password';
Assign permissions to the newly created user by running:
GRANT ALL PRIVILEGES ON rosariosisdb.* TO 'rosariosisuser'@'localhost';
Exit from the MySQL or MariaDB prompt by typing exit
.
Open up your web browser and navigate to the URL where you have installed RosarioSIS, using the IP address or domain name of your web server.
The installation wizard will start automatically, and you'll be asked to enter the database details that you created earlier:
rosariosisdb
rosariosisuser
Your_Password
localhost
Fill out the necessary details and click on the Install
button to start the installation process.
Once the installation is complete, you can log in to your RosarioSIS instance using the admin credentials that you entered during the installation process.
Congratulations! You have successfully installed RosarioSIS on the latest version of FreeBSD. You can now start using it to manage your educational institution's student records.
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!