View difference between Paste ID: BF7ccXSt and 48Ha4sqm
SHOW: | | - or go back to the newest paste.
1
HOW TO INSTALL ROSARIOSIS ON WINDOWS
2
3
Step 1:
4
Download latest WAMP Server and INSTALL to C:/WAMP
5
http://www.wampserver.com/download.php
6
7
Step 2:
8
Download latest PostgreSQL and INSTALL to C:/WAMP/apps/PostgreSQL
9
http://enterprisedb.com/downloads/postgres-postgresql-downloads
10
11
While installing, follow on screen instructions. Input the password as "root" (without the ") then 
12
13
click next, next, till done.
14
15
Launch PGAdminIII from the start menu.
16
17
Click on Server(1) and Right Click on PostgreSQL Database Server (localhost:5432) and Select Connect 
18
19
to obtain a connection to server and give password. It will connect to Database server.
20
21
Navigate to C:\wamp\apps\PostgreSQL\data and open pg_hba.conf
22
Scroll to the bottom of the page. Make sure the  last several lines of this file are EXACTLY as the 
23
24
following:
25
26
27
# TYPE  DATABASE        USER            ADDRESS                 METHOD
28
29
# IPv4 local connections:
30
host    all             all             127.0.0.1/32            md5
31
# IPv6 local connections:
32
host    all             all             ::1/128                 md5
33
# Allow replication connections from localhost, by a user with the
34
# replication privilege.
35
#local   replication	 postgres			 peer
36
#host	 replication	 postgres	 127.0.0.1/32	 md5
37
#host	 replication	 postgres	 ::1/128	 md5
38
39
Step 3:
40
Launch WAMP if not yet launched (from the start menu)
41
Left click on the WAMP icon in the system tray. 
42
Go to PHP>PHP extension and enable:
43
- php_pgsql
44
- php_pdo_pgsql 
45
- php_xmlrpc
46
- php_gettext
47
48
Right click the WAMP icon and exit.
49
50
Step 4:
51
Copy libpq.dll from C:/WAMP/bin/php/phpxxx to  C:/WAMP/bin/apache/Apachexxx/bin.  (xxx is the 
52
53
version number)
54
55
Step 5:
56
Download latest phpPGAdmin and INSTALL to C:/WAMP/apps/phPGAdmin (delete the version number)
57
http://downloads.sourceforge.net/project/phppgadmin/
58
59
Step 6:
60
Navigate to C:/WAMP/alias and create a text document. Copy and paste the following:
61
Alias /phppgadmin "C:/wamp/apps/phpPgAdmin/" 
62
63
<Directory "C:/wamp/apps/phpPgAdmin/">
64
    Options Indexes FollowSymLinks MultiViews
65
    AllowOverride all
66
        Order Deny,Allow
67
	Allow from all
68
</Directory>
69
70
Save the file as phppgadmin.conf
71
72
Now, navigate to C:\wamp\apps\phpPgAdmin\conf and open config.inc in Notepad. Press Ctrl and F (or 
73
74
click edit then find) and type in security. Click find and then find next. You should now see 
75
76
['extra_login_security'] = true; with the word security highlighted. Delete the word true and change 
77
78
to false. Save the file.
79
80
Step 7:
81
Download wkhtmltopdf and install to it's deafult location (C:/Program Files/wkhtmltopdf)
82
http://wkhtmltopdf.org/downloads.html
83
84
Step 8:
85
Download the latest RosarioSIS and extract to C:/WAMP/www/Rosario
86
https://github.com/francoisjacquet/rosariosis/releases
87
88
Step 9:
89
Navigate to the extracted folder in the above step.
90
Right click on the config.inc.sample and click on Edit. If you have been following this guide 
91
92
exactly then delete all the contents of the file and copy and paste the following:
93
94
<?php
95
if(!defined('CONFIG_INC'))
96
{
97
	define('CONFIG_INC',1);
98
	
99
	// Database Setup
100
	
101
102
$DatabaseServer = 'localhost';	// postgres = host, oracle=SID
103
	$DatabaseUsername = 'postgres';
104
	
105
106
$DatabasePassword = 'root';
107
	$DatabaseName = 'rosariosis';
108
	$DatabasePort = '5432';
109
110
	// Server 
111
112
Names and Paths
113
	$RosarioPath = 'C:\wamp\www\Rosario';
114
	$pg_dumpPath = 'C:\wamp\apps\PostgreSQL
115
116
\bin'; // Specify the path to the database dump utility for this server.
117
	//modif Francois: 
118
119
wkhtmltopdf
120
	$wkhtmltopdfPath = 'C:\Program Files\wkhtmltopdf\bin'; // empty string means 
121
122
wkhtmltopdf will not be called and reports will be rendered in htlm instead of pdf
123
	
124
125
$wkhtmltopdfAssetsPath = '/var/www/rosariosis/assets/'; // way wkhtmltopdf accesses the assets/ 
126
127
directory, empty string means no translation
128
	$StudentPicturesPath = 'assets/StudentPhotos/';
129
	
130
131
$UserPicturesPath = 'assets/UserPhotos/';
132
	$PortalNotesFilesPath = 'assets/PortalNotesFiles/';
133
	
134
135
$FS_IconsPath = 'assets/FS_icons/';
136
137
	$DefaultSyear = '2013';
138
	$RosarioAdmins = '1'; // can be list 
139
140
such as '1,23,50' - note, these should be id's in the DefaultSyear, otherwise they can't login 
141
142
anyway
143
	$RosarioNotifyAddress = 'youremail@.mail.com';
144
	$RosarioLocales = array('en_US.utf8');	// 
145
146
Add other languages you want to support here, ex: 'fr_FR.utf8', 'es_ES.utf8', ...
147
	
148
149
$CurrencySymbol = 'R'; // locale currency
150
	$LocalePath = 'locale'; // Path were the language 
151
152
packs are stored. You need to restart Apache at each change in this directory
153
154
	$RosarioModules = 
155
156
array(
157
		'School_Setup'=>true,
158
		'Students'=>true,
159
		'Users'=>true,
160
		
161
162
'Scheduling'=>true,
163
		'Grades'=>true,
164
		'Attendance'=>true,
165
		
166
167
'Eligibility'=>true,
168
		'Discipline'=>true,
169
		'Student_Billing'=>true,
170
		
171
172
'Food_Service'=>true,
173
		'State_Reports'=>false,
174
		'Resources'=>true,
175
		
176
177
'Custom'=>true
178
	);
179
180
	//modif Francois: Moodle integrator, see /modules/Moodle/config.inc.php for 
181
182
instructions
183
	define('MOODLE_INTEGRATOR', false);
184
185
	// If session isn't started, start it.
186
	if
187
188
(!isset($SessionStart))
189
		$SessionStart = 1;
190
}
191
?>
192
193
Save as config.inc.php
194
I would advise that you follow the instructions to edit the config.inc.php file that are in the 
195
196
INSTALL guide in the RosarioSIS source directory.
197
It should give you a brief idea of what's what in the code above.
198
199
Step 10:
200
Start WAMP again.
201
Right click on the icon and click localhost.
202
A new window/tab will open in your browser.
203
Under Your Aliases, find phPGAdmin and click on it.
204
Click on PostgreSQL on the left. 
205
Enter the username "postgres"
206
Enter the password "root".
207
At the bottom, click Create database
208
Enter the name as rosariosis, then click create.
209
Click on PostgreSQL on the left and then on the newly created rosariosis
210
On the top bar, click on SQL then scroll to the bottom and click on browse.
211
Navigate to C:/WAMP/www/Rosario and select rosariosis.sql
212
After opening the file, click on execute.
213
214
Step 11:
215
Copy and paste this link in your browser:
216
http://localhost/Rosario/index.php
217
218
Log in with username, admin and password, admin.
219
Enjoy!
220
221
Don't forget to take a look at:
222
http://www.rosariosis.org/contribute/
223
224
NOTES
225
1. WAMP must be running for Rosariosis to work.
226
2. If you encounter any error copy this link into your browser and see what error is displayed. 
227
228
http://localhost/Rosario/diagnostic.php
229
3. If you need to activate the french and spanish translations, read 
230
231
https://github.com/francoisjacquet/rosariosis/blob/mobile/locale/README first
232
4. In general, for PHP files edition, you can use Notepad++ (http://notepad-plus-plus.org/) which 
233
234
features Syntax Highlighting.