How to install RosarioSIS on cPanel

Note: Below we are going to edit PHP files. You may want to install Notepad++ first to get syntax highlighting for these files.

Check for PostgreSQL

Your (shared) hosting provider should provide you with PostgreSQL databases. Check for PostgreSQL support before going any further.

Download RosarioSIS

Download RosarioSIS and extract the project files on your computer.

Create database

1. Go to cPanel

2. Enter the PostgreSQL Database Wizard.

   

3. Create the database, for example: "sisdb". Note the complete name down (for example rosario_sisdb). Click "Create Database".

4. Create a database user, for example: "sisuser", and set a password. Note the complete username (for example rosario_sisuser) and password down. Click "Create User".

5. Add a User to the Database. Click "Submit".

6. Return to cPanel Home and enter phpPgAdmin.

   

7. Click on the database "sisdb" (for example rosario_sisdb).

8. Then click on the "SQL" button and uncheck "Paginate results".

   

9. Now, go back to where you extracted RosarioSIS files. Double click on the rosariosis.sql file to open it. Press CTRL + A to select all its content. Press CTRL + C to copy it.

10. Now, go back to the "SQL" tab in phpPgAdmin. Paste the rosariosis.sql file content in the textarea box by pressing CTRL + V. Then click the "Execute" button.

Generate the configuration file

5. Now, go back to where you extracted RosarioSIS files. Rename the config.inc.sample.php file to config.inc.php.

6. Open the config.inc.php file and edit as follows (replace the database name, user and password with your own):

   $DatabaseUsername = 'rosario_sisuser';
   
   $DatabasePassword = 'YOUR_CHOSEN_PASSWORD';
   
   $DatabaseName = 'rosario_sisdb';

7. Save the config.inc.php file

Note: For other configuration options, you may refer to the INSTALL file.

Create subdomain

1. Go to cPanel

2. Enter the Subdomains.

   

3. Create a subdomain named "rosariosis". And note down the "Document root" (here, it is ~/public_html/rosariosis). Click "Create".

   

4. Your RosarioSIS URL will later be accessed like this: http://rosariosis.yourdomain.com/

Upload RosarioSIS

1. Go to cPanel

2. Enter the File Manager and select the right document root in the popup.

   

3. Click the "Upload" button. Then, in the new "Upload Files" window, select the rosariosis-xxx.zip archive. Go back to the file manager when the upload is complete.

   

   

4. Select the archive and click the "Extract button". Then click the "Extract File(s)" button.

   

   

5. Refresh and enter the rosariosis-xxx/ folder. Click the "Select All" button.

   

6. Now, click the "Move File" button and enter the document root path where we want to move the files (here, it is ~/public_html/rosariosis). Click "Move File(s)".

   

7. Go back to our document root by clicking on the "Up one level" button.

8. Click the "Upload" button and then, in the new "Upload Files" window, select the config.inc.php file we have edited earlier.

   

   

Enter RosarioSIS

Access RosarioSIS at http://rosariosis.yourdomain.com/

If you experience the following error: permission denied for relation config

1. Go to cPanel.

2. Enter PostgreSQL Databases.

   

3. Then, in the "Add a User to a Database" section, select our rosario_sisuser user and our rosario_sisdb database. Click "Submit".

   

Errors, blank screen? Troubleshoot issues by going to http://rosariosis.yourdomain.com/diagnostic.php

Login with username admin and password admin.

Enjoy!

You can continue with the Quick Setup Guide.