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
)
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');
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
car il ne s'agit pas d'une procédure normale d'installation de LimeSurvey.
