HOW TO INSTALL ROSARIO SIS ON WINDOWS

[ZeroSplice]

HOW TO INSTALL ROSARIO SIS ON WINDOWS

[francoisjacquet]

Thank you @ZeroSplice for your tutorial on how to install RosarioSIS with WAMP.
I am sure it will be useful for many people.

[francoisjacquet]

After reviewing your tutorial, here are my observations:

1. You left your personal email
2. Instead of emptying and copying the config.inc.php code you posted, I recommend you edit the original file.
3. $wkhtmltopdfPath = 'C:\wamp\www\Rosario\classes'; is wrong. You should install wkhtmltopdf 0.11.0 rc1 for Windows (http://code.google.com/p/wkhtmltopdf/downloads/list?can=1) and then enter the path of the executable.
4. If you need to activate the french and spanish translations, read https://github.com/francoisjacquet/rosariosis/blob/mobile/locale/README first
5. Do not save the config.inc.sample.php as config.inc but as config.inc.php
6. In general, for PHP files edition, you can use Notepad++ (http://notepad-plus-plus.org/) which features Syntax Highlighting.

Could you please take time to correct your tutorial?

[ZeroSplice]

Thanks for the input.

Changes should reflect in the new link in the opening post.

Apologies for the somewhat untidy guide. When I copy from Notepad to pastebin (or here) the setting of the text goes haywire.

[francoisjacquet]

Maybe a Gist would better suits your needs than pastebin: http://gist.github.com/
For example, you could post the config.inc.php with Syntax Highlighting for better readability.

[francoisjacquet]

Another correction: when creating the database with phpPgAdmin, select UFT8 for the encoding as the default maybe LATIN1.

[francoisjacquet]

Other corrections: the pg_dump & wkhtmltopdf paths:
These should contain the path + the ".exe", which are missing.

[francoisjacquet]

Another correction: copy / paste the rosariosis.sql content into phpPgAdmin instead of uploading the SQL script. This will prevent having an extra blank line in between the select options.

[francoisjacquet]

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.

[francoisjacquet]

Another correction:
$wkhtmltopdfAssetsPath = '/var/www/rosariosis/assets/';
Should be something like
$wkhtmltopdfAssetsPath = 'C:/wamp/www/Rosario/assets/';
Or else, the CSS and images wont be in the PDF.

[francoisjacquet]

See Wiki for updated tutorial:
https://github.com/francoisjacquet/rosariosis/wiki/How-to-install-RosarioSIS-on-Windows

[benitoski]

Hi all
I just installed Rosario SIS on win 10 environment. Apache and php are provided by Xampp. I installed PostgreSQL also.
The thing is I can't get the locale in Spanish. I changed the config.inc.php to:
$RosarioLocales = array('es_ES.utf8') but the pages are still displayed in English.
Is there another setting elsewhere to change? Am I doing wrong something?
Thanks in advance
Oscar

[francoisjacquet]

Hi @benitoski

You may experience issues with PHP > 5.4 and gettext (used for translations) on Windows. Please prefer this new tutorial: https://github.com/francoisjacquet/rosariosis/wiki/How-to-install-RosarioSIS-on-Windows

[benitoski]

Hi @francoisjacquet
I followed the install instructions you mention but I'm having a problem in the 'Import database' section.
When I run the sql I got a bunch of errors that make me think that something is wrong with the SQL database...

First attempt:
"#1193 - Unknown system variable 'client_encoding' "
When I comment "SET client_encoding = 'UTF8';" I get the following error
"#1193 - Unknown system variable 'check_function_bodies' "
When I comment "SET check_function_bodies = false;" I get the following error
"#1193 - Unknown system variable 'client_min_messages' "
When I comment "SET client_min_messages = warning; " I get the following error:
"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS $$
CREATE LANGUAGE plpgsql' at line 17 "

Despite having followed your instructions, all the above (and specially the last error) make me suspect that I don't have PostgreSQL but MySQL Is that possible?
On the Bitnami WAPP page there were just a single option to download:

And after install Bitnami WAPP the application looks:

What am I doing wrong?
Thanks in advance
Oscar

[francoisjacquet]

Hi @benitoski

We can offer you support for RosarioSIS installation at http://www.rosariosis.org/services/

[jeetdebnath]

Hello Francoisjacquet
How to install rosariosis on linux hosting server using cpanel? after Installation it showing

Fatal error: Call to undefined function pg_escape_string() in /home/kidzagar/public_html/log/database.inc.php on line 258

[frendy13]

Hello Francois Jacques,

Congratulations for this project. Could you please confirm for me if I can use a MySQL database instead of the PostgreSQL one if I would use a migration tools. If Yes, in what files I must carry out some update?