-
Notifications
You must be signed in to change notification settings - Fork 343
How to install RosarioSIS on cPanel
Note: Below we are going to open PHP files. You may want to install Notepad++ first to get syntax highlighting for these files.
Your (shared) hosting provider should provide you with PostgreSQL databases. Check for PostgreSQL support before going any further.
Download RosarioSIS and extract the project files on your computer.
-
Go to cPanel
-
Enter the PostgreSQL Database Wizard.
-
Create the database, for example: "sisdb". Note the complete name down (for example
rosario_sisdb
). Click "Create Database". -
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". -
Add a User to the Database. Click "Submit".
-
Return to cPanel Home and enter phpPgAdmin.
-
Click on the database "sisdb" (for example
rosario_sisdb
). -
Then click on the "SQL" button and uncheck "Paginate results".
-
Now, go back to where you extracted RosarioSIS files. Double click on the
rosariosis.sql
file to open it. PressCTRL
+A
to select all its content. PressCTRL
+C
to copy it. -
Now, go back to the "SQL" tab in phpPgAdmin. Paste the
rosariosis.sql
file content in the textarea box by pressingCTRL
+V
. Then click the "Execute" button.
-
Now, go back to where you extracted RosarioSIS files. Rename the
config.inc.sample.php
file toconfig.inc.php
. -
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';
-
Save the
config.inc.php
file
Note: For other configuration options, you may refer to the INSTALL file.
-
Go to cPanel
-
Enter the Subdomains.
-
Create a subdomain named "rosariosis". And note down the "Document root" (here, it is
~/public_html/rosariosis
). Click "Create". -
Your RosarioSIS URL will later be accessed like this:
http://rosariosis.yourdomain.com/
-
Go to cPanel
-
Enter the File Manager and select the right document root in the popup.
-
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. -
Select the archive and click the "Extract button". Then click the "Extract File(s)" button.
-
Refresh and enter the
rosariosis-xxx/
folder. Click the "Select All" button. -
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)". -
Go back to our document root by clicking on the "Up one level" button.
-
Click the "Upload" button and then, in the new "Upload Files" window, select the
config.inc.php
file we have edited earlier.
Access RosarioSIS at http://rosariosis.yourdomain.com/
If you experience the following error: permission denied for relation config
-
Go to cPanel.
-
Enter PostgreSQL Databases.
-
Then, in the "Add a User to a Database" section, select our
rosario_sisuser
user and ourrosario_sisdb
database. Click "Submit".
Login with username admin
and password admin
.
Enjoy!
You can continue with the Quick Setup Guide.