====== Deploying the Student Information System on Debian) ======

<note important>Only experience IT staff should try any of this. Basic Linux experience is highly desirable.</note>

The Pacific Student Information System (FedSIS, MISIS) is based on openSIS. So here we document how to install that on a Debian server (e.g. a Debian Virtual Machine). This could be useful to bring the SIS with your for training where Internet is unreliable or not existant.


First, you need to ssh into the server from your own machine as shown below

<code>
user@yourmachine:~$ ssh user@ip.address.of.server
</code>

<note>The above ''ip.address.of.server'' will depend on your network.</note>

Alternatively you can work directly in the console of the virtual machine (e.g. VirtualBox's console of the VM).

Once logged in make sure are as root user and browse to the /var/www/ directory.

<code>
user@server:~$ su
root@server:~# cd /var/www/
</code>

Before installing anything upgrade the system and make sure some of the basic software is already installed.

<code>
root@server:~$ sudo apt-get update
root@server:~$ sudo apt-get upgrade
root@server:~$ sudo apt-get install wget rsync openssh-server sudo vim tar gzip aptitude
</code>

Download the latest OpenSIS into a zip file. This step will depend if you are installing a new setup or a clone of your country's production system with all it's current data. 

For a new installation use this.

<code>
root@server:~$ wget -c https://codeload.github.com/OS4ED/openSIS-Responsive-Design/zip/master -O opensis.zip
</code>

For a clone of your own production system it will look more like this.

<code>
root@server:~$ wget -c https://www.pacific-emis.org/files/misis.pss.edu.mh.tar.gz
</code>

Decompress the files. Use one of the following commmand only depending on which files you downloaded in previous step.

<code>
root@server:~$ unzip opensis.zip
root@server:~$ tar zxvf misis.pss.edu.mh.tar.gz
</code>

Change the ownership.

<code>
root@server:~$ sudo chown www-data:www-data -R /var/www/misis.pss.edu.mh/
</code>

<note>Above we copied to ''misis.pss.edu.mh'' as example for RMI deployment. In FSM you could call it ''fedsis.doe.fm''</note>

Now we install the web server and other dependencies.

<code>
root@server:~$ sudo apt-get install php php-cli php-common php-mysql php-imagick php-intl php-gd php-pear imagemagick apache2 libapache2-mod-php mcrypt
</code>

Now configure a virtual host to run the SIS web application. Open the file below (called differently based on country or school).

<code>
root@server:~$ nano /etc/apache2/sites-available/misis.pss.edu.mh.conf
</code>

And copy the following text in it. you save it the same way as above: press ''Control-X'' (i.e. the ''Control'' key followed by the ''x'' key at the same time) following by ''Y'' and ''Enter'' to say yes and close the text editor.

<code>
<VirtualHost *:80>
    ServerAdmin webmaster@nuzusys.com
    ServerName misis-offline.pss.edu.mh
    ServerAlias misis-local.pss.edu.mh
    DocumentRoot /var/www/misis.pss.edu.mh
    LogLevel info
    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>
</code>

Now activate your newly setup virtual host website and restart the web server (or reload it).

<code>
root@server:~$ a2ensite misis.pss.edu.mh.conf
root@server:~$ systemctl restart apache2
</code>

Now install the database server MariaDB (MySQL.) You will need to enter the password. Use the same as your VM root password so you don't forget.

<note important>This is not best security practice as far as passwords go but for the purposed of training and testing on virtual machines it is fine.</note>

<note important>If you already have the MariaDB server installed then the following steps (i.e. next three commands) are not necessary. If you have MariaDB already installed you may have to [[reset-mysql-root-password|Reset MySQL root password]] if you do not know it.</note>

<code>
root@server:~$ apt-get install mariadb-server
</code>

Make sure the mariadb server is enabled and started.

<code>
root@server:~$ systemctl enable mariadb.service
root@server:~$ systemctl start mariadb.service
</code>

(Optional) Change an important setting of the MariaDB server. You will have to enter the MariaDB root password for the following command.

<code>
root@server:~$ mysql -u root -p -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';"
</code>

Optionally check the above setting was changed.

<code>
root@server:~$ mysql -u root -p -e "SELECT @@GLOBAL.sql_mode;"
</code>

Now if you are cloning your existing production system with the data you will need to create a database for it and load the backup into it. To do this you will have to login the MariaDB database server.

<code>
root@server:~$ mysql -u root -p
mysql# 
</code>

Then create the database.

<code>
mysql# CREATE DATABASE misisoffline;
mysql# quit;
</code>

Load the database backup which should have been included for you in the download file.

<code>
root@server:~$ mysql -u root -p misisoffline < /var/www/misis.pss.edu.mh/mysql-misis-22022021-125047-backup.sql
</code>

At this point you should be able to login. As a final step for the workstations on the network you want to find the offsite installation you will need to configure them a DNS entry in the hosts file. As an administrator open notepad and open the file ''C:\Windows\System32\drivers\etc\hosts''. Add the following line so other can connect to your server with the hostname and save.

<code>
ip.address.of.server    misis-offline.pss.edu.mh
</code>

Open a browser and point it to ''http://misis-offline.pss.edu.mh/''

You can stop here if this was a clone of your production system. If you were setting up a brand new installation you need to complete as follows. Click ''New Installation''.

{{ :misc-it:opensis-install-1.png?nolink |}}

Make sure you have all dependencies met. Click ''Continue''.

{{ :misc-it:opensis-install-2.png?nolink |}}

Enter the MySQL Server details (i.e. the password put previously). Click ''Save & Next''.

{{ :misc-it:opensis-install-3.png?nolink |}}

Enter the database name. Click ''Save & Next''.

{{ :misc-it:opensis-install-4.png?nolink |}}

Enter the school details. Click ''Save & Next''.

{{ :misc-it:opensis-install-5.png?nolink |}}

Enter the first admin user as follows.  Click ''Save & Next''.

{{ :misc-it:opensis-install-6.png?nolink |}}

You should see the following. Click on ''Proceed to openSIS Login''.

{{ :misc-it:opensis-install-7.png?nolink |}}

Login with your admin user.

{{ :misc-it:opensis-install-8.png?nolink |}}