View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06750Bug reportsSurvey takingpublic2012-10-23 17:21
Reporterriqcles Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary06750: PostgreSQL 9.1 - Problems with installing the limesuvey 2.00
Description

Hi,
I encountered several problems during installation.

  1. Language
    During installation, select the language is French cause display bugs (after choosing the language from the beginning, select the [Back] button to see symptoms). This is visible in the video capture. (Mysql idem)

  2. pg_dump and pg_restore
    To dump no problem, cons after restore, care must be taken to restore the bytea parameter (for passwords) otherwise impossible to connect (see video).
    If I change the schema name I have an error message (see attachments)

  3. Changing the dump to compensate for a missing selection in the installation script.
    I modified the dump to be able to choose:

    • The postgres user (superuser) to create the database limesurvey_2_0
    • Limesurvey_adm user (power user: CreateDB and CreateRole) to create the schema and populate the limesurvey base.

The scripts are properly conducted, but after not connect to the database:
The table "{{}} settings_global" for active record class "Settings_global" can not be found in the database.
This is the same mistake that changing the schema name.

  1. Questions
    Is it possible to choose the installation schema for postgres? (Provided in a new role?)
    Is limesurvey combines schema name with a parameter in the database (I have not found anything in the config file)?

Should I make a Mantis?

  1. nothing to do, but you never know.
    To translate limesurvey the elements are present to translate the old version? -> If yes, I would take the missing elements to reach 100% (although there are words that I can not easily translate).

PS: The installation script is only a small part of the iceberg that I set up for my instances LimeSurvey.

Attachments:

Steps To Reproduce

See video

TagsNo tags attached.
Attached Files
apres_modif_nom_shema.png (51,373 bytes)   
apres_modif_nom_shema.png (51,373 bytes)   
sql.zip (35,251 bytes)
Bug heat4
Complete LimeSurvey version number (& build)121017
I will donate to the project if issue is resolvedNo
BrowserInternet explorer 8 8.0.6001.18702IC / Firefox 10.0.0
Database type & versionPostgreSql 9.1
Server OS (if known)Windows XP SP3 / CentOS 5.x
Webserver software & version (if known)Wamp 2.2 / Apache 2.2.4
PHP Version5.1.13

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2012-10-23 17:08

developer   ~21565

Hello,

I just install a LS with pg db.
1: sorry, i don't look at instruction, don't get back. But this one is not the same bug than after.

2: My user have for the db:
CREATE to yes and CONNECT to yes. User need to create table for survey.

And i don't have problem . my limesurvey user don't have acces to schema.

  1. Did you want a parameter more (for mysql it can be done too) give the postgre for database creation and user creation. And give a user/pass for cretaion. It's more a feature request than a bug report.

  2. Don't think

5 : FR is already at 100% \o/

c_schmitz

c_schmitz

2012-10-23 17:21

administrator   ~21567

about 1.) I can't see the video, link shows 'Fichier perimé ou déjà supprimé'. Where is the installation messed up translation-wise?

about 2.) You are responsible for creating a backup and restoring with all parameters properly set.

I cannot reproduce the remaining issues and your screenshots are pretty non-saying to me. This is not a discussion board - if you have general question please use the forums. Please also only post one issue per bug report bug report.
Thank you.

Issue History

Date Modified Username Field Change
2012-10-22 16:12 riqcles New Issue
2012-10-22 16:12 riqcles File Added: apres_modif_nom_shema.png
2012-10-22 16:12 riqcles File Added: modif_proprietaire_et_fichier_config.png
2012-10-22 16:12 riqcles File Added: sql.zip
2012-10-23 17:08 DenisChenu Note Added: 21565
2012-10-23 17:21 c_schmitz Note Added: 21567
2012-10-23 17:21 c_schmitz Status new => closed
2012-10-23 17:21 c_schmitz Assigned To => c_schmitz
2012-10-23 17:21 c_schmitz Resolution open => unable to reproduce