HOW TO INSTALL ROSARIOSIS ON WINDOWS

HOW TO INSTALL ROSARIOSIS ON WINDOWS

Step 1:
Download latest WAMP Server and INSTALL to C:/WAMP
http://www.wampserver.com/download.php

Step 2:
Download latest PostgreSQL and INSTALL to C:/WAMP/apps/PostgreSQL
http://enterprisedb.com/downloads/postgres-postgresql-downloads

While installing, follow on screen instructions. Input the password as "root" (without the ") then

click next, next, till done.

Launch PGAdminIII from the start menu.

Click on Server(1) and Right Click on PostgreSQL Database Server (localhost:5432) and Select Connect

to obtain a connection to server and give password. It will connect to Database server.

Navigate to C:\wamp\apps\PostgreSQL\data and open pg_hba.conf
Scroll to the bottom of the page. Make sure the  last several lines of this file are EXACTLY as the

following:


# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication	 postgres			 peer
#host	 replication	 postgres	 127.0.0.1/32	 md5
#host	 replication	 postgres	 ::1/128	 md5

Step 3:
Launch WAMP if not yet launched (from the start menu)
Left click on the WAMP icon in the system tray.
Go to PHP>PHP extension and enable:
- php_pgsql
- php_pdo_pgsql
- php_xmlrpc
- php_gettext

Right click the WAMP icon and exit.

Step 4:
Copy libpq.dll from C:/WAMP/bin/php/phpxxx to  C:/WAMP/bin/apache/Apachexxx/bin.  (xxx is the

version number)

Step 5:
Download latest phpPGAdmin and INSTALL to C:/WAMP/apps/phPGAdmin (delete the version number)
http://downloads.sourceforge.net/project/phppgadmin/

Step 6:
Navigate to C:/WAMP/alias and create a text document. Copy and paste the following:
Alias /phppgadmin "C:/wamp/apps/phpPgAdmin/"

<Directory "C:/wamp/apps/phpPgAdmin/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
	Allow from all
</Directory>

Save the file as phppgadmin.conf

Now, navigate to C:\wamp\apps\phpPgAdmin\conf and open config.inc in Notepad. Press Ctrl and F (or

click edit then find) and type in security. Click find and then find next. You should now see

['extra_login_security'] = true; with the word security highlighted. Delete the word true and change

to false. Save the file.

Step 7:
Download wkhtmltopdf and install to it's deafult location (C:/Program Files/wkhtmltopdf)
http://wkhtmltopdf.org/downloads.html

Step 8:
Download the latest RosarioSIS and extract to C:/WAMP/www/Rosario
https://github.com/francoisjacquet/rosariosis/releases

Step 9:
Navigate to the extracted folder in the above step.
Right click on the config.inc.sample and click on Edit. If you have been following this guide

exactly then delete all the contents of the file and copy and paste the following:

<?php
if(!defined('CONFIG_INC'))
{
	define('CONFIG_INC',1);

	// Database Setup


$DatabaseServer = 'localhost';	// postgres = host, oracle=SID
	$DatabaseUsername = 'postgres';


$DatabasePassword = 'root';
	$DatabaseName = 'rosariosis';
	$DatabasePort = '5432';

	// Server

Names and Paths
	$RosarioPath = 'C:\wamp\www\Rosario';
	$pg_dumpPath = 'C:\wamp\apps\PostgreSQL

\bin'; // Specify the path to the database dump utility for this server.
	//modif Francois:

wkhtmltopdf
	$wkhtmltopdfPath = 'C:\Program Files\wkhtmltopdf\bin'; // empty string means

wkhtmltopdf will not be called and reports will be rendered in htlm instead of pdf


$wkhtmltopdfAssetsPath = '/var/www/rosariosis/assets/'; // way wkhtmltopdf accesses the assets/

directory, empty string means no translation
	$StudentPicturesPath = 'assets/StudentPhotos/';


$UserPicturesPath = 'assets/UserPhotos/';
	$PortalNotesFilesPath = 'assets/PortalNotesFiles/';


$FS_IconsPath = 'assets/FS_icons/';

	$DefaultSyear = '2013';
	$RosarioAdmins = '1'; // can be list

such as '1,23,50' - note, these should be id's in the DefaultSyear, otherwise they can't login

anyway
	$RosarioNotifyAddress = 'youremail@.mail.com';
	$RosarioLocales = array('en_US.utf8');	//

Add other languages you want to support here, ex: 'fr_FR.utf8', 'es_ES.utf8', ...


$CurrencySymbol = 'R'; // locale currency
	$LocalePath = 'locale'; // Path were the language

packs are stored. You need to restart Apache at each change in this directory

	$RosarioModules =

array(
		'School_Setup'=>true,
		'Students'=>true,
		'Users'=>true,


'Scheduling'=>true,
		'Grades'=>true,
		'Attendance'=>true,


'Eligibility'=>true,
		'Discipline'=>true,
		'Student_Billing'=>true,


'Food_Service'=>true,
		'State_Reports'=>false,
		'Resources'=>true,


'Custom'=>true
	);

	//modif Francois: Moodle integrator, see /modules/Moodle/config.inc.php for

instructions
	define('MOODLE_INTEGRATOR', false);

	// If session isn't started, start it.
	if

(!isset($SessionStart))
		$SessionStart = 1;
}
?>

Save as config.inc.php
I would advise that you follow the instructions to edit the config.inc.php file that are in the

INSTALL guide in the RosarioSIS source directory.
It should give you a brief idea of what's what in the code above.

Step 10:
Start WAMP again.
Right click on the icon and click localhost.
A new window/tab will open in your browser.
Under Your Aliases, find phPGAdmin and click on it.
Click on PostgreSQL on the left.
Enter the username "postgres"
Enter the password "root".
At the bottom, click Create database
Enter the name as rosariosis, then click create.
Click on PostgreSQL on the left and then on the newly created rosariosis
On the top bar, click on SQL then scroll to the bottom and click on browse.
Navigate to C:/WAMP/www/Rosario and select rosariosis.sql
After opening the file, click on execute.

Step 11:
Copy and paste this link in your browser:
http://localhost/Rosario/index.php

Log in with username, admin and password, admin.
Enjoy!

Don't forget to take a look at:
http://www.rosariosis.org/contribute/

NOTES
1. WAMP must be running for Rosariosis to work.
2. If you encounter any error copy this link into your browser and see what error is displayed.

http://localhost/Rosario/diagnostic.php
3. If you need to activate the french and spanish translations, read

https://github.com/francoisjacquet/rosariosis/blob/mobile/locale/README first
4. In general, for PHP files edition, you can use Notepad++ (http://notepad-plus-plus.org/) which

features Syntax Highlighting.