Install openSIS Student Information System on Debian/Ubuntu Linux 🌱

What is openSIS (Open Student Information System)

openSIS is a commercial grade, secure, scalable & intuitive Student Information System / School Management Software that just works. It is published by OS4ED, a full life cycle software development company headquartered in the USA. -https://www.opensis.com/

Installation

1. Log into the Linux based device
2. Run the following commands in the terminal
   # update software repositories
   sudo apt update
   # install available software updates
   sudo apt upgrade -y
   # install some dependencies
   sudo apt install git apt-transport-https ca-certificates curl -y
   # install Apache HTTPD and MySQL
   sudo apt install apache2 mariadb-server mariadb-client -y
   # install PHP components
   sudo apt install php7.3 libapache2-mod-php7.3 php7.3-common php7.3-mysql php7.3-ldap php7.3-json php7.3-curl php7.3-zip php7.3-xml php7.3-mbstring -y
   # configure the MySQL database
   sudo su
   mysql_secure_installation
3. Press Enter to login as root
4. Type Y and press Enter to set a root password, type the password twice to confirm
5. Type Y and press Enter to remove anonymous users
6. Type Y and press Enter to disallow root login remotely
7. Type Y and press Enter to remove the test database
8. Type Y and press Enter to reload privilege tables
9. Run the following command to login into MySQL:
   mysql -u root -p
10. Authenticate with the root password set earlier
11. Run the following commands to create the openSIS database and database user
    CREATE DATABASE openSIS DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    GRANT ALL ON openSIS.* TO 'openSIS_rw'@'localhost' IDENTIFIED BY 'Op3nS!S';
    FLUSH PRIVILEGES;
    EXIT;
    exit
12. Continue with the following commands to download and extract openSIS in the Apache webroot
    # clone from git
    sudo git clone https://github.com/OS4ED/openSIS-Classic.git /var/www/html/openSIS
    # cd into the new openSIS directory
    cd /var/www/html/openSIS
    # checkout the latest version
    sudo git checkout "$(git tag --sort=v:refname | tail -n1)"
    # set permissions on the openSIS directory
    sudo chown -R www-data:www-data /var/www/html/openSIS
    # edit mysql strict mode
    sudo nano /etc/mysql/conf.d/strict_mode.cnf
13. Paste the following into strict_mode.cnf

    [mysqld]
    sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

14. Press CTRL+O, Enter, CTRL+X to write the changes
15. Continue with the following commands in the terminal
    # restart mariadb service
    sudo systemctl restart mariadb
16. Open a web browser and navigate to http://DNSorIP/openSIS
17. Click the New Installation option
18. Click the Continue button
19. Complete the MySQL connection form as follows

    Server: localhost
    Port: 3306
    MySQL Username: openSIS_rw
    MySQL Password: Op3nS!S

20. Click the Save & Next button
21. Enter the database name openSIS > Click the Save & Next button
22. Wait while the database schema is built
23. Complete the School Information form > Click the Save & Next button
24. Complete the Site Admin Account form > Click the Save & Next button
25. Click the Proceed to openSIS Login button
26. Login using the admin account credentials created earlier
27. Welcome to openSIS

More Info: https://github.com/OS4ED/openSIS-Classic/wiki/openSIS-Installation-Instructions