How to install RosarioSIS on Windows

The following is a tutorial to install RosarioSIS on Windows with WAMP. It is based on @ZeroSplice tutorial with the needed corrections.

Step 1:

Download latest WAMP Server and INSTALL to C:\WAMP

http://www.wampserver.com/download.php

Note: With WAMP 2.4 64bits, the translations (gettext) will not work (see http://php.net/manual/en/function.gettext.php#114058). Prefer the 32bits version.

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 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: https://gist.github.com/francoisjacquet/11052047

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\phpPGAdmin (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.php 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 default location (C:\Program Files\wkhtmltopdf)

http://wkhtmltopdf.org/downloads.html

Step 8:

Download the latest RosarioSIS release 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.php and click on Edit. If you have been following this guide exactly then the content of this file should reflect this one: https://gist.github.com/francoisjacquet/11235845

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 phpPGAdmin 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, the encoding as UTF8 then click create.

Click on PostgreSQL on the left and then on the newly created rosariosis

On the top bar, click on SQL.

Navigate with the Windows Explorer to C:\WAMP\www\Rosario and open rosariosis.sql.

After opening the file, select all its content (CTRL and A) and copy it.

Back to the browser, paste the content in the SQL field.

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.

RosarioSIS comes with an empty calendar, so the first thing you should do is create a calendar or recreate the Main calendar with school days (in green).

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. In general, for PHP files edition, you can use Notepad++ which features Syntax Highlighting.