/
INSTALL
152 lines (114 loc) · 6.18 KB
/
INSTALL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
Rosario Student Information System - INSTALLATION DIRECTIONS
-------------------------------------------------------------------------------
Version 2.8.9
-------------------------------------------------------------------------------
NOTE: Before Installing RosarioSIS, you must read and agree to the included
license.
RosarioSIS is a web based application which relies on other facilities such as
a web server, PHP server-side scripting, and postgres database server. For
RosarioSIS to work you must first have your web server working, PHP working,
postgres working. username/password authentication working. Setting these
up varies a lot with platform, operating system, and distribution so it is
well beyond to scope of this brief install document. RosarioSIS was
tested on a Windows 7 x64 with Apache 2.2.21, Postgres 9.1, and PHP 5.3.9
(EasyPHP 5.3.9) and on a Ubuntu Server 12.04 with Apache 2.2.22, Postgres 9.1,
and PHP 5.3.10 and through Mozilla Firefox.
Minimum requirements: PHP 5.3.2 & Postgres 8
Installation Directions for Windows:
https://github.com/francoisjacquet/rosariosis/wiki/How-to-install-RosarioSIS-on-Windows
Installing the Package
----------------------
Unzip the RosarioSIS distribution to a directory that is accessible to your web
browser. Edit the config.inc.sample.php file to set the configuration variables
as appropriate for your installation. Rename the file to config.inc.php.
$DatabaseServer is the host name or ip for the database server
$DatabaseUsername is the username used for authenticating the database
$DatabasePassword is the password used for authenticating the database
$DatabaseName is the database name
$DatabasePort is the socket port number for accessing the database server
$RosarioPath is full path to RosarioSIS installation, you can define it
statically for your installation or the runtime value derived from the
__FILE__ magic constant should work
$pg_dumpPath is full path to the postgres database dump utility pg_dump
$wkhtmltopdfPath full path to wkhtmltopdf for pdf 'printing'
$DefaultSyear default school year, should be present in the database to
be able to login
$RosarioNotifyAddress is email address to send error and new administrator notifications
$RosarioLocales is a comma separated list of the locale names of the
translations (see locale/ folder for available locales)
[Optional variables]
$wkhtmltopdfAssetsPath is path where wkhtmltopdf will access the assets/
directory, possibly different than how the user's web browser finds it,
empty string means no translation
$StudentPicturesPath relative path to student pictures
$UserPicturesPath relative path to user pictures
$PortalNotesFilesPath relative path to portal notes attached files
$FS_IconsPath relative path to food service icons
$LocalePath relative path were the language packs are stored.
You need to restart Apache at each change in this directory
$Timezone sets the default time zone used by all date/time functions.
See List of Supported Timezones: http://php.net/manual/en/timezones.php
Now, you're ready to setup the RosarioSIS database. If you have access to the
command prompt for your server, follow these instructions. If you're using
phpPGAdmin or a similar tool, import the rosariosis.sql file included in
this package.
1) Open a command prompt window.
2) Login as the postgres user
ex) server$ su - postgres
3) Login to the postgres database server using the template1 database
ex) server$ psql template1
4) Create the rosariosis database
ex) template1=# CREATE DATABASE rosariosis;
5) Skip to step 6 if used in an American / English-speaking environment.
If your data will include non-standard English characters (like
characters with accent marks), you'll have to create your database
with a different character encoding (the default is unicode).
ex) createdb rosariosis -E UTF8
UTF8 is Unicode, 8-bit -- useful for all languages.
See http://www.postgresql.org/docs/9.1/interactive/multibyte.html for
more information.
6) Logout of the database server
ex) template1=# \q
7) Run the RosarioSIS sql file
ex) server$ psql rosariosis < YOUR_ROSARIO_INSTALL_DIRECTORY/rosariosis.sql > rosariosis.log
Notice, you will see several lines beginning "NOTICE: ALTER TABLE / ADD PRIMARY
KEY will create implicit index " after completing direction 6. Disregard these
messages.
If you run into permissions problems involving rosariosis.log, simply remove the
" > rosariosis.log" from the command
You will have to start postgres with the -i option, telling postmaster to accept
TCP/IP connections. Also, the pg_hba.conf file may have to be altered to specify the
server's TCP/IP address.
That's it!... now, point your browser to:
http://yourdomain.com/INSTALL_LOCATION/index.php
and login as 'admin' password 'admin'. With this login, you can create new
users, and change and delete the three template users. Since students can not
be deleted the template student should be changed to a proper student.
Installation problems
---------------------
To help you spot problems, point your browser to:
http://yourdomain.com/INSTALL_LOCATION/diagnostic.php
Installing wkhtmltopdf
----------------------
http://wkhtmltopdf.org/
Install instructions for Ubuntu 12.04.5 64bits server:
1) Download the latest executable (0.12.2.1 as of 2015.02.03) :
server$ wget http://downloads.sourceforge.net/project/wkhtmltopdf/0.12.2.1/wkhtmltox-0.12.2.1_linux-precise-amd64.deb
2) Install package :
server$ sudo dpkg --install wkhtmltox-0.12.2.1_linux-precise-amd64.deb
3) Install the missing dependencies :
server$ sudo apt-get -f install
4) Test :
server$ wkhtmltopdf http://google.com google.pdf
5) Set $wkhtmltopdfPath in RosarioSIS config.inc.php file:
$wkhtmltopdfPath = '/usr/local/bin/wkhtmltopdf';
Activate PHP mail() function
----------------------------
Install instructions for Ubuntu 12.04.4 64bits server:
server$ sudo apt-get install sendmail
Additional Configuration
------------------------
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).
See the School Configuration program in the School Setup module for optional
modules configuration.