Welcome, Guest
Username: Password: Remember me

TOPIC: V192+ PostgreSQL 9.1.X - 9.1.2

V192+ PostgreSQL 9.1.X - 9.1.2 1 year 11 months ago #85433

  • riqcles
  • riqcles's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 118
  • Thank you received: 6
  • Karma: 2
je réalise une installation de la version 1.92+ (limesurvey192plus-build120909).
Les environnements sont les suivants :
1. DEV1
Serveur CentOS
Serveur de Base de donnée (BDD) PostgreSql 9.1.4
PHP 5.3.9
limesurvey192+ build120909

2. DEV2
Machine virtuel VirtualBox - windows XP
EasyPHP
BDD PostgreSQL 8.4.11 port 5432 -> répertoire limesurvey_8_4
BDD PostgreSQL 9.1.3 port 5436 -> répertoire limesurvey_9_1
BDD PostgreSQL 9.2.0 port 5437 -> répertoire limesurvey_9_2
PHP 5.3.9
limesurvey192+ build120909

Je travaille sur la machine virtuelle en choisissant le serveur de BDD 9.1.3
1. Je copie les fichiers de LimeSurvey 192+ dans le répertoire dédié pour l'application (limesurvey_9_1).
2. Je lance le navigateur et je tape l'adresse http://127.0.0.1/limesurvey/admin/install/
3. Le script s'exécute et la base est installé -> accès application OK

Mais dans mon environnement de travail, je n'ai pas la possibilité d'exécuter l'initialisation de la BDD (ainsi que des utilisateurs propriétaire de la BDD et du schéma associé) en mode web.
Je dois fournir des fichiers de scripts SQL pour qu'ils soient exécuté en mode console.

J'ai donc réalisé deux fichiers :
A. création des utilisateurs, de la BDD en UTF8 et du schéma
B. création des tables et index associés.

:ohmy: -> l'exécution des scripts en utilisant la console de PGadmin (je suis sous Windows XP) fonctionne en PostgreSql 8.4 et en 9.1.

I - connexion à l'interface d'administration : login ou mot de passe incorrect.
Mais je n'arrive pas à me connecter en sur l'interface d'administration dans l'instance (ici limesurvey_9_1) lié au serveur en 9.1 et à ses BDD associées.
Il m'indique que le login et le mot de passe sont incorrect. Je ne rencontre pas ce problème sur l'instance limesurvey_8_4 lié au serveur en 8.4

Un mantis a déjà été associé à cette erreur de mot de passe pour les bases Postgres 9.1.X
J'ai utilisé l'instruction : ALTER DATABASE limesurvey SET bytea_output = 'escape';

aucun effet, je ne peux toujours pas me connecter.
J'ai mis cette instruction (qui est en native dans le fichier createdb.php) dans mon script A et toujours aucun effet.

L'installation par le navigateur étant fonctionnelle, j'ai réalisé un dump de ma base de données avec pgadmin au format plat.

J'ai supprimé ma base, puis j'ai exécuté le contenu du dump (une liste d'instruction SQL) en tant qu'utilisateur postgres.

La base a bien été recréé, mais je ne peux toujours pas me connecté.

-> question : un script existe pour créer les users + tables + schéma + tables ?

II - Création de la base et "populate"
J'ai essayé une autre méthode : utiliser le script A pour la création des utilisateurs, de la BDD et du schéma.
Après je me connecte via le navigateur pour poursuivre l'installation.
J'ai bien le message pour faire populate + mise à jour DB en 155.
Mais toujours impossible de me connecter.


III - Migration d'une base d'un serveur 8.4 à 9.1
J'ai fait un dump d'une base sur serveur 8.4 sur le port 5432 vers un serveur en 9.1 qui écoute le port 5436.
LimeSurvey n'arrive pas à se connecter sur le port 5436.
-> question : le port est codé en dur dans la base de données ?


J'ai mis en Pj mes deux scripts A et B.

Merci de votre aide.
Attachments:
LimeSurvey version 2.05 build 140520 / 1.92+ build 120909 / 1.85+ (plus pour longtemps ! yes ! )
OS : CentOS 6.5 / PHP 5.3.13/
BDD : PostGresql 9.3 /PostGresql 8.4.11
Last Edit: 1 year 11 months ago by riqcles. Reason: pièces jointes pas à la bonne extension
The administrator has disabled public write access.

Re: V192+ PostgreSQL 9.1.X - 9.1.2 1 year 11 months ago #85772

  • riqcles
  • riqcles's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 118
  • Thank you received: 6
  • Karma: 2
Bonsoir,
J'ai réussi à faire l'installation via les deux scripts A et B.
En analysant le script d'installation de LimeSurvey, j'ai constaté un appel à la fonction de cryptographie.

J'ai donc modifié le fichier createdb.php :
Le fichier createdb.php est modifié pour récuperer le mot de passe de l'administrateur du fichier config.php
Il faut ajouter une référence au début du fichier createdb.php :

require_once(dirname(__FILE__).'/../classes/core/sha256.php');

et on rajoute sous cette ligne :
echo sprintf($clang->gT("Database `%s` has been successfully populated."),$dbname)."</div><p> \n";

la commande suivante :
echo( SHA256::hashing($defaultpass));

ce qui donne à la fin :
echo sprintf($clang->gT("Database `%s` has been successfully populated."),$dbname)."</div><p> \n";
echo( SHA256::hashing($defaultpass));

J'execute l'installation normal de Limesurvey avec la procédure standart.
Le mot de passe apparait en clair à la fin de l'installation (une suite de 64 caractères alphanumérique).

Je reprend ce mot de passe.
J'ouvre mon script B que je modifie comme suit :

--
-- Create admin user
--

INSERT INTO lime_users(
users_name, "password", full_name, parent_id, lang, email,
create_survey, create_user, delete_user, superadmin, configurator,
manage_template, manage_label,htmleditormode)
VALUES ('admin', '34c8ecfbb719491306c4269335690827bd7f8c44dd930bd8b27314471ceb4dc6', 'les administrateurs', 0, 'fr', 'limesurvey@limesurvey.fr',1,1,1,1,1,1,1,'default');


(j'ai modifié des caractères dans le mot de passe :P )

Et j'arrive maintenant à me connecter.
Après je modifie le mot de passe dans l'application et plus de soucis.

Voici mes scripts en mode text :

Script A : create_user_db
--
-- PostgreSQL database cluster dump
--

\connect postgres

--
-- Roles
--

CREATE ROLE limesurvey_adm;
ALTER ROLE limesurvey_adm WITH NOSUPERUSER NOINHERIT CREATEROLE CREATEDB LOGIN ENCRYPTED PASSWORD 'limesurvey' VALID UNTIL 'infinity';
-- Mot de passe à modifier dans la base après !
CREATE ROLE limesurvey;
ALTER ROLE limesurvey WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN ENCRYPTED PASSWORD 'limesurvey' VALID UNTIL 'infinity';

--


SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 1719 (class 1262 OID 4009679)
-- Name: limesurvey; Type: DATABASE; Schema: -; Owner: limesurvey_adm
--

CREATE DATABASE limesurvey WITH TEMPLATE = template1 ENCODING = 'UTF8';
ALTER DATABASE limesurvey SET bytea_output='escape';
ALTER DATABASE limesurvey OWNER TO limesurvey_adm;


--
-- TOC entry 2 (class 2615 OID 4009680)
-- Name: limesurvey; Type: SCHEMA; Schema: -; Owner: limesurvey_adm
--


script B : create_schema_Table
-- 12/09/2012 - RIQCLES
-- Il faut penser à se connecter en tant qu'utilisateur limesurvey_adm
-- 12/09/2012 - RIQCLES - fin d'ajouts

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;

-- 12/09/2012 - début ajouts RIQCLES


SET escape_string_warning = off;
SET standard_conforming_strings = off;
CREATE SCHEMA limesurvey;
ALTER DATABASE limesurvey SET search_path = 'limesurvey';
ALTER SCHEMA limesurvey OWNER TO limesurvey_adm;
SET search_path = limesurvey, pg_catalog;
GRANT ALL ON SCHEMA limesurvey TO limesurvey_adm;
GRANT USAGE ON SCHEMA limesurvey TO limesurvey;


-- 12/09/2012 - RIQCLES - fin d'ajouts

--
-- Table structure for table answers
--
CREATE TABLE lime_answers (
qid integer DEFAULT 0 NOT NULL,
code character varying(5) DEFAULT ''::character varying NOT NULL,
answer text NOT NULL,
sortorder integer NOT NULL,
assessment_value integer DEFAULT 0 NOT NULL,
"language" character varying(20) DEFAULT 'en'::character varying NOT NULL,
scale_id smallint DEFAULT 0 NOT NULL,
CONSTRAINT lime_answers_pkey PRIMARY KEY (qid, code, "language", scale_id)
);


--
-- Table structure for table assessments
--
CREATE TABLE lime_assessments (
id serial,
sid integer DEFAULT 0 NOT NULL,
scope character varying(5) DEFAULT ''::character varying NOT NULL,
gid integer DEFAULT 0 NOT NULL,
name text NOT NULL,
minimum character varying(50) DEFAULT ''::character varying NOT NULL,
maximum character varying(50) DEFAULT ''::character varying NOT NULL,
message text NOT NULL,
language character varying(20) DEFAULT 'en'::bpchar NOT NULL,
CONSTRAINT lime_assessments_pkey PRIMARY KEY (id,language)
);


--
-- Table structure for table conditions
--
CREATE TABLE lime_conditions (
cid serial,
qid integer DEFAULT 0 NOT NULL,
scenario integer DEFAULT 1 NOT NULL,
cqid integer DEFAULT 0 NOT NULL,
cfieldname character varying(50) DEFAULT ''::character varying NOT NULL,
method character(5) DEFAULT ''::bpchar NOT NULL,
value character varying(255) DEFAULT ''::character varying NOT NULL,
CONSTRAINT lime_conditions_pkey PRIMARY KEY (cid)
);


--
-- Table structure for table defaultvalues
--
CREATE TABLE lime_defaultvalues (
qid integer NOT NULL default '0',
scale_id integer NOT NULL default '0',
sqid integer NOT NULL default '0',
language character varying(20) NOT NULL,
specialtype character varying(20) NOT NULL default '',
defaultvalue text,
CONSTRAINT lime_defaultvalues_pkey PRIMARY KEY (qid , scale_id, language, specialtype, sqid)
);

--
-- Table structure for table expression_errors
--

CREATE TABLE lime_expression_errors (
id serial,
errortime character varying(50) DEFAULT NULL,
sid integer DEFAULT NULL,
gid integer DEFAULT NULL,
qid integer DEFAULT NULL,
gseq integer DEFAULT NULL,
qseq integer DEFAULT NULL,
"type" character varying(50) ,
eqn text,
prettyprint text,
CONSTRAINT lime_expression_errors_pkey PRIMARY KEY (id)
);


--
-- Table structure for table groups
--
CREATE TABLE lime_groups (
gid serial,
sid integer DEFAULT 0 NOT NULL,
group_name character varying(100) DEFAULT ''::character varying NOT NULL,
group_order integer DEFAULT 0 NOT NULL,
description text,
"language" character varying(20) DEFAULT 'en'::character varying NOT NULL,
randomization_group character varying(20) DEFAULT ''::character varying NOT NULL,
grelevance text DEFAULT NULL,
CONSTRAINT lime_groups_pkey PRIMARY KEY (gid, "language")
);


--
-- Table structure for table labels
--
CREATE TABLE lime_labels (
lid integer DEFAULT 0 NOT NULL,
code character varying(5) DEFAULT ''::character varying NOT NULL,
title text,
sortorder integer NOT NULL,
assessment_value integer DEFAULT 0 NOT NULL,
"language" character varying(20) DEFAULT 'en'::character varying NOT NULL,
CONSTRAINT lime_labels_pkey PRIMARY KEY (lid, sortorder, "language")
);
CREATE INDEX lime_labels_ixcode_idx ON lime_labels USING btree (code);


--
-- Table structure for table labelsets
--
CREATE TABLE lime_labelsets (
lid serial NOT NULL,
label_name character varying(100) DEFAULT ''::character varying NOT NULL,
languages character varying(200) DEFAULT 'en'::character varying,
CONSTRAINT lime_labelsets_pkey PRIMARY KEY (lid)
);


--
-- Table structure for table question_attributes
--
CREATE TABLE lime_question_attributes (
qaid serial NOT NULL,
qid integer DEFAULT 0 NOT NULL,
attribute character varying(50),
value text NULL,
"language" character varying(20),
CONSTRAINT lime_question_attributes_pkey PRIMARY KEY (qaid)
);


--
-- Table structure for table quota
--
CREATE TABLE lime_quota (
id serial NOT NULL,
sid integer,
name character varying(255),
qlimit integer,
"action" integer,
"active" integer NOT NULL default '1',
autoload_url integer NOT NULL DEFAULT 0,
CONSTRAINT lime_quota_pkey PRIMARY KEY (id)
);


--
-- Table structure for table quota_languagesettings
--
CREATE TABLE lime_quota_languagesettings
(
quotals_id serial NOT NULL,
quotals_quota_id integer NOT NULL DEFAULT 0,
quotals_language character varying(45) NOT NULL DEFAULT 'en'::character varying,
quotals_name character varying(200),
quotals_message text NOT NULL,
quotals_url character varying(255),
quotals_urldescrip character varying(255),
CONSTRAINT lime_quota_languagesettings_pkey PRIMARY KEY (quotals_id)
);


--
-- Table structure for table quota_members
--
CREATE TABLE lime_quota_members (
id serial,
sid integer,
qid integer,
quota_id integer,
code character varying(11),
CONSTRAINT lime_quota_members_pkey PRIMARY KEY (id)
);
CREATE INDEX lime_quota_members_ixcode_idx ON lime_quota_members USING btree (sid,qid,quota_id,code);


--
-- Table structure for table questions
--
CREATE TABLE lime_questions (
qid serial NOT NULL,
parent_qid integer DEFAULT 0 NOT NULL,
sid integer DEFAULT 0 NOT NULL,
gid integer DEFAULT 0 NOT NULL,
"type" character(1) DEFAULT 'T'::bpchar NOT NULL,
title character varying(20) DEFAULT ''::character varying NOT NULL,
question text NOT NULL,
preg text,
help text,
other character(1) DEFAULT 'N'::bpchar NOT NULL,
mandatory character(1),
question_order integer NOT NULL,
"language" character varying(20) DEFAULT 'en'::character varying NOT NULL,
scale_id smallint DEFAULT 0 NOT NULL,
same_default smallint DEFAULT 0 NOT NULL,
relevance text,
CONSTRAINT lime_questions_pkey PRIMARY KEY (qid, "language")
);


--
-- Table structure for table saved_control
--
CREATE TABLE lime_saved_control (
scid serial NOT NULL,
sid integer DEFAULT 0 NOT NULL,
srid integer DEFAULT 0 NOT NULL,
identifier text,
access_code text NOT NULL,
email character varying(320) NOT NULL,
ip text NOT NULL,
saved_thisstep text NOT NULL,
status character(1) DEFAULT ''::bpchar NOT NULL,
saved_date timestamp without time zone NOT NULL,
refurl text,
CONSTRAINT lime_saved_control_pkey PRIMARY KEY (scid)
);


--
-- Table structure for table sessions
--
CREATE TABLE lime_sessions(
sesskey character varying( 64 ) NOT NULL DEFAULT '',
expiry TIMESTAMP NOT NULL ,
expireref character varying( 250 ) DEFAULT '',
created TIMESTAMP NOT NULL ,
modified TIMESTAMP NOT NULL ,
sessdata TEXT DEFAULT '',
CONSTRAINT lime_sessions_pkey PRIMARY KEY ( sesskey )
);
create INDEX sess_expiry on lime_sessions( expiry );
create INDEX sess_expireref on lime_sessions ( expireref );


--
-- Table structure for table settings_global
--
CREATE TABLE lime_settings_global (
stg_name character varying(50) DEFAULT ''::character varying NOT NULL,
stg_value character varying(255) DEFAULT ''::character varying NOT NULL,
CONSTRAINT lime_settings_global_pkey PRIMARY KEY (stg_name)
);


--
-- Table structure for table surveys
--
CREATE TABLE lime_surveys (
sid integer NOT NULL,
owner_id integer NOT NULL,
"admin" character varying(50),
active character(1) DEFAULT 'N'::bpchar NOT NULL,
startdate timestamp,
expires timestamp,
adminemail character varying(320) NOT NULL,
anonymized character(1) DEFAULT 'N' NOT NULL,
faxto character varying(20),
format character(1),
savetimings character(1) DEFAULT 'N'::bpchar,
"template" character varying(100) DEFAULT 'default'::character varying,
"language" character varying(50),
additional_languages character varying(255),
datestamp character(1) DEFAULT 'N'::bpchar,
usecookie character(1) DEFAULT 'N'::bpchar,
allowregister character(1) DEFAULT 'N'::bpchar,
allowsave character(1) DEFAULT 'Y'::bpchar,
printanswers character(1) DEFAULT 'N'::bpchar,
autonumber_start integer DEFAULT 0,
autoredirect character(1) DEFAULT 'N'::bpchar,
showxquestions character(1) DEFAULT 'Y'::bpchar,
showgroupinfo character(1) DEFAULT 'B'::bpchar,
shownoanswer character(1) DEFAULT 'Y'::bpchar,
showqnumcode character(1) DEFAULT 'X'::bpchar,
showwelcome character(1) DEFAULT 'Y'::bpchar,
allowprev character(1) DEFAULT 'Y'::bpchar,
ipaddr character(1) DEFAULT 'N'::bpchar,
refurl character(1) DEFAULT 'N'::bpchar,
datecreated date,
listpublic character(1) DEFAULT 'N'::bpchar,
publicstatistics character(1) DEFAULT 'N'::bpchar,
publicgraphs character(1) DEFAULT 'N'::bpchar,
htmlemail character(1) DEFAULT 'N'::bpchar,
tokenanswerspersistence character(1) DEFAULT 'N'::bpchar,
assessments character(1) DEFAULT 'N'::bpchar,
usecaptcha character(1) DEFAULT 'N'::bpchar,
bouncetime bigint,
bounceprocessing character(1) default 'N'::bpchar,
bounceaccounttype character(4),
bounceaccounthost character(200),
bounceaccountuser character(200),
bounceaccountpass character(100),
bounceaccountencryption character(3),
usetokens character(1) DEFAULT 'N'::bpchar,
"bounce_email" character varying(320) NOT NULL,
attributedescriptions text,
emailresponseto text,
emailnotificationto text,
tokenlength smallint DEFAULT '15',
showprogress character(1) DEFAULT 'N'::bpchar,
allowjumps character(1) DEFAULT 'N'::bpchar,
navigationdelay smallint DEFAULT '0',
nokeyboard character(1) DEFAULT 'N'::bpchar,
alloweditaftercompletion character(1) DEFAULT 'N'::bpchar,
googleanalyticsstyle character(1) DEFAULT NULL,
googleanalyticsapikey character varying(25) DEFAULT NULL,
CONSTRAINT lime_surveys_pkey PRIMARY KEY (sid)
);


--
-- Table structure for table surveys_languagesettings
--
CREATE TABLE lime_surveys_languagesettings (
surveyls_survey_id integer DEFAULT 0 NOT NULL,
surveyls_language character varying(45) DEFAULT 'en'::character varying NOT NULL,
surveyls_title character varying(200) NOT NULL,
surveyls_description text,
surveyls_welcometext text,
surveyls_url character varying(255),
surveyls_urldescription character varying(255),
surveyls_endtext text,
surveyls_email_invite_subj character varying(255),
surveyls_email_invite text,
surveyls_email_remind_subj character varying(255),
surveyls_email_remind text,
surveyls_email_register_subj character varying(255),
surveyls_email_register text,
surveyls_email_confirm_subj character varying(255),
surveyls_email_confirm text,
surveyls_dateformat integer DEFAULT 1 NOT NULL,
email_admin_notification_subj character varying(255),
email_admin_notification text,
email_admin_responses_subj character varying(255),
email_admin_responses text,
surveyls_numberformat integer NOT NULL DEFAULT 1,
CONSTRAINT lime_surveys_languagesettings_pkey PRIMARY KEY (surveyls_survey_id, surveyls_language)
);


--
-- Table structure for table survey_permissions
--
CREATE TABLE lime_survey_permissions (
sid integer DEFAULT 0 NOT NULL,
uid integer DEFAULT 0 NOT NULL,
permission character varying(20) NOT NULL,
create_p integer DEFAULT 0 NOT NULL,
read_p integer DEFAULT 0 NOT NULL,
update_p integer DEFAULT 0 NOT NULL,
delete_p integer DEFAULT 0 NOT NULL,
import_p integer DEFAULT 0 NOT NULL,
export_p integer DEFAULT 0 NOT NULL,
CONSTRAINT lime_survey_permissions_pkey PRIMARY KEY (sid,uid,permission)
);


--
-- Table structure for table user_groups
--
CREATE TABLE lime_user_groups (
ugid serial NOT NULL,
name character varying(20) NOT NULL,
description text NOT NULL,
owner_id integer NOT NULL
);


--
-- Table structure for table user_in_groups
--
CREATE TABLE lime_user_in_groups (
ugid integer NOT NULL,
uid integer NOT NULL,
CONSTRAINT lime_user_in_groups_pkey PRIMARY KEY (ugid,uid)
);


--
-- Table structure for table users
--
CREATE TABLE lime_users (
uid serial PRIMARY KEY NOT NULL,
users_name character varying(64) DEFAULT ''::character varying UNIQUE NOT NULL,
"password" bytea NOT NULL,
full_name character varying(50) NOT NULL,
parent_id integer NOT NULL,
lang character varying(20),
email character varying(320) NOT NULL,
create_survey integer DEFAULT 0 NOT NULL,
create_user integer DEFAULT 0 NOT NULL,
participant_panel integer DEFAULT 0 NOT NULL,
delete_user integer DEFAULT 0 NOT NULL,
superadmin integer DEFAULT 0 NOT NULL,
configurator integer DEFAULT 0 NOT NULL,
manage_template integer DEFAULT 0 NOT NULL,
manage_label integer DEFAULT 0 NOT NULL,
htmleditormode character(7) DEFAULT 'default'::bpchar,
templateeditormode character(7) DEFAULT 'default'::bpchar,
questionselectormode character(7) DEFAULT 'default'::bpchar,
one_time_pw bytea,
"dateformat" integer DEFAULT 1 NOT NULL
);


--
-- Table structure for table templates_rights
--
CREATE TABLE lime_templates_rights (
"uid" integer NOT NULL,
"folder" character varying(255) NOT NULL,
"use" integer NOT NULL,
CONSTRAINT lime_templates_rights_pkey PRIMARY KEY ("uid","folder")
);


--
-- Table structure for table participants
--
CREATE TABLE lime_participants (
"participant_id" character varying( 50 ) PRIMARY KEY NOT NULL,
"firstname" character varying( 40 ) DEFAULT NULL,
"lastname" character varying( 40 ) DEFAULT NULL,
"email" character varying( 80 ) DEFAULT NULL,
"language" character varying( 2 ) DEFAULT NULL,
"blacklisted" character( 1 ) NOT NULL,
"owner_uid" integer NOT NULL
);


--
-- Table structure for table participant_attribute
--
CREATE TABLE lime_participant_attribute (
"participant_id" character varying( 50 ) NOT NULL,
"attribute_id" integer NOT NULL,
"value" character varying(50) NOT NULL,
CONSTRAINT lime_participant_attribut_pkey PRIMARY KEY (participant_id,attribute_id)
);


--
-- Table structure for table participant_attribute_names
--
CREATE TABLE lime_participant_attribute_names (
"attribute_id" serial NOT NULL,
"attribute_type" character varying( 4 ) NOT NULL,
"visible" character varying( 5 ) NOT NULL,
CONSTRAINT lime_participant_attribute_names_pkey PRIMARY KEY (attribute_id, attribute_type)
);
--
-- Table structure for table participant_attribute_lang
--
CREATE TABLE lime_participant_attribute_names_lang (
"id" integer NOT NULL,
"attribute_id" integer NOT NULL,
"attribute_name" character varying( 30 ) NOT NULL,
"lang" character varying( 20 ) NOT NULL,
CONSTRAINT lime_participant_attribute_names_lang_pkey PRIMARY KEY (attribute_id, lang)
);
--
-- Table structure for table participant_attribute_values
--
CREATE TABLE lime_participant_attribute_values (
"value_id" serial PRIMARY KEY NOT NULL,
"attribute_id" integer NOT NULL,
"value" character varying( 20 ) NOT NULL
);
--
-- Table structure for table participant_shares
--
CREATE TABLE lime_participant_shares (
"participant_id" character varying( 50 ) NOT NULL,
"share_uid" integer NOT NULL,
"date_added" timestamp NOT NULL,
"can_edit" character varying( 5 ) NOT NULL,
CONSTRAINT lime_participant_shares_pkey PRIMARY KEY (participant_id,share_uid)
);


--
-- Table structure for table participant_attribute_values
--
CREATE TABLE lime_survey_links (
"participant_id" character varying ( 50 ) NOT NULL,
"token_id" integer NOT NULL,
"survey_id" integer NOT NULL,
"date_created" date NOT NULL,
CONSTRAINT lime_survey_links_pkey PRIMARY KEY (participant_id,token_id,survey_id)
);


--
-- Table structure for table templates
--
CREATE TABLE lime_templates (
"folder" character varying(255) NOT NULL,
"creator" integer NOT NULL,
CONSTRAINT lime_templates_pkey PRIMARY KEY ("folder")
);


--
-- Create failed_login_attempts
--
CREATE TABLE lime_failed_login_attempts (
id serial PRIMARY KEY NOT NULL,
ip character varying(37) NOT NULL,
last_attempt character varying(20) NOT NULL,
number_attempts integer NOT NULL
);


--
-- Secondary indexes
--
create index assessments_idx2 on lime_assessments (sid);
create index assessments_idx3 on lime_assessments (gid);
create index conditions_idx2 on lime_conditions (qid);
create index groups_idx2 on lime_groups (sid);
create index question_attributes_idx2 on lime_question_attributes (qid);
create index question_attributes_idx3 on lime_question_attributes (attribute);
create index questions_idx2 on lime_questions (sid);
create index questions_idx3 on lime_questions (gid);
create index quota_idx2 on lime_quota (sid);
create index saved_control_idx2 on lime_saved_control (sid);
create index parent_qid_idx on lime_questions (parent_qid);


--
-- Version Info
--
INSERT INTO lime_settings_global VALUES ('DBVersion', '155.6');
--INSERT INTO lime_settings_global VALUES ('SessionName', '$sessionname');


--
-- Create admin user
--

INSERT INTO lime_users(
users_name, "password", full_name, parent_id, lang, email,
create_survey, create_user, delete_user, superadmin, configurator,
manage_template, manage_label,htmleditormode)
VALUES ('admin', '34c8ecfbb719491306c4269335690827bd7f8c44dd930bd8b27314471ceb4dc6', 'les administrateurs', 0, 'fr', 'limesurvey@limesurvey.fr',1,1,1,1,1,1,1,'default');


:ohmy: N'oubliez pas que le mot de passe associé à "admin" est actuellement modifié : a vous de le remplacer grâce à la méthode décrite plus haut.

Si ces scripts peuvent aider :unsure: car il ne s'agit pas d'une procédure normale d'installation de LimeSurvey.
LimeSurvey version 2.05 build 140520 / 1.92+ build 120909 / 1.85+ (plus pour longtemps ! yes ! )
OS : CentOS 6.5 / PHP 5.3.13/
BDD : PostGresql 9.3 /PostGresql 8.4.11
The administrator has disabled public write access.
Moderators: Nickko
Time to create page: 0.269 seconds
Donation Image