0ct0pu5
/
tutorials


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110
							    <!DOCTYPE html>
    <html lang="en" xmlns="http://www.w3.org/1999/xhtml">
      <head>
        <title>Install openSIS Student Information System on Debian/Ubuntu Linux</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <meta charset="UTF-8">
        <meta name="keywords" content="OpenSIS,Student Information System,School Software,Linux,Debian,Ubuntu,Install Guide,How To,Tutorial,i12bretro">
        <meta name="author" content="i12bretro">
        <meta name="description" content="Install openSIS Student Information System on Debian/Ubuntu Linux">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="revised" content="06/21/2022 11:48:23 AM" />
				          <link rel="icon" type="image/x-icon" href="includes/favicon.ico">
				  <script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
				        <script type="text/javascript" src="includes/js/steps.js"></script>
        <link href="css/steps.css" rel="stylesheet" type="text/css" />
      </head>
      <body>
        <div id="gridContainer">
          <div class="topMargin"></div>
          <div id="listName" class="topMargin">
            <h1>Install openSIS Student Information System on Debian/Ubuntu Linux</h1>
          </div>
          <div></div>
          <div id="content">
          <h2>What is openSIS (Open Student Information System)</h2>

<blockquote><em>openSIS is a commercial grade, secure, scalable &amp; 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. -<a href="https://www.opensis.com/" target="_blank">https://www.opensis.com/</a></em></blockquote>

<h2>Installation</h2>

<ol>
	<li>Log into the Linux based device</li>
	<li>Run the following commands in the terminal
	<div class="codeBlock"># update software repositories<br />
	sudo apt update<br />
	# install available software updates<br />
	sudo apt upgrade -y<br />
	# install some dependencies<br />
	sudo apt install git apt-transport-https ca-certificates curl -y<br />
	# install Apache HTTPD and MySQL<br />
	sudo apt install apache2 mariadb-server mariadb-client -y<br />
	# install PHP components<br />
	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<br />
	# configure the MySQL database<br />
	sudo su<br />
	mysql_secure_installation</div>
	</li>
	<li>Press Enter to login as root</li>
	<li>Type Y and press Enter to set a root password, type the password twice to confirm</li>
	<li>Type Y and press Enter to remove anonymous users</li>
	<li>Type Y and press Enter to disallow root login remotely</li>
	<li>Type Y and press Enter to remove the test database</li>
	<li>Type Y and press Enter to reload privilege tables</li>
	<li>Run the following command to login into MySQL:
	<div class="codeBlock">mysql -u root -p</div>
	</li>
	<li>Authenticate with the root password set earlier</li>
	<li>Run the following commands to create the openSIS database and database user
	<div class="codeBlock">CREATE DATABASE openSIS DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;<br />
	GRANT ALL ON openSIS.* TO &#39;openSIS_rw&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;Op3nS!S&#39;;<br />
	FLUSH PRIVILEGES;<br />
	EXIT;<br />
	exit</div>
	</li>
	<li>Continue with the following commands to download and extract openSIS in the Apache webroot
	<div class="codeBlock"># clone from git<br />
	sudo git clone https://github.com/OS4ED/openSIS-Classic.git /var/www/html/openSIS<br />
	# cd into the new openSIS directory<br />
	cd /var/www/html/openSIS<br />
	# checkout the latest version<br />
	sudo git checkout &quot;$(git tag --sort=v:refname | tail -n1)&quot;<br />
	# set permissions on the openSIS directory<br />
	sudo chown -R www-data:www-data /var/www/html/openSIS<br />
	# edit mysql strict mode<br />
	sudo nano /etc/mysql/conf.d/strict_mode.cnf</div>
	</li>
	<li>Paste the following into strict_mode.cnf
	<p>[mysqld]<br />
	sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION</p>
	</li>
	<li>Press CTRL+O, Enter, CTRL+X to write the changes</li>
	<li>Continue with the following commands in the terminal
	<div class="codeBlock"># restart mariadb service<br />
	sudo systemctl restart mariadb</div>
	</li>
	<li>Open a web browser and navigate to http://DNSorIP/openSIS</li>
	<li>Click the New Installation option</li>
	<li>Click the Continue button</li>
	<li>Complete the MySQL connection form as follows
	<p>Server: localhost<br />
	Port: 3306<br />
	MySQL Username: openSIS_rw<br />
	MySQL Password: Op3nS!S</p>
	</li>
	<li>Click the Save &amp; Next button</li>
	<li>Enter the database name openSIS &gt; Click the Save &amp; Next button</li>
	<li>Wait while the database schema is built</li>
	<li>Complete the School Information form &gt; Click the Save &amp; Next button</li>
	<li>Complete the Site Admin Account form &gt; Click the Save &amp; Next button</li>
	<li>Click the Proceed to openSIS Login button</li>
	<li>Login using the admin account credentials created earlier</li>
	<li>Welcome to openSIS</li>
</ol>

<p>More Info: <a href="https://github.com/OS4ED/openSIS-Classic/wiki/openSIS-Installation-Instructions" target="_blank">https://github.com/OS4ED/openSIS-Classic/wiki/openSIS-Installation-Instructions</a></p>
          </div>
        </div>
      </body>
    </html>