Check out the LimeSurvey source code on GitHub!

Postgresql not conect

More
5 years 3 months ago #66852 by alfredoleganes
Sorry for my english.

I hava this error during then installs: Can't connect to LimeSurvey database. Reason: Database connection failed.

My config.php is:


$databasetype = 'postgres';
$databaselocation = 'localhost';
$databasename = 'limesurvey';
$databaseuser = 'postgres';
$databasepass = 'Navamediana1';
$dbprefix = 'lime_';

pass Navamediana1 is a superuser of postgresql.

I don´t undrestand, postgreqsl 8.3 and limesurvey191plus-build11110-20111005.zip.

Thanks

Please Log in to join the conversation.

More
5 years 3 months ago #66853 by Mazi
I think this is a settings problem but I'm no postgres expert.

Do you use these settings for any other applications?

Check our forum and the manual for any further postgres tips.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
The following user(s) said Thank You: alfredoleganes

Please Log in to join the conversation.

More
5 years 3 months ago #66922 by alfredoleganes
Someone has limesurvey on Postgradesql, i need postgradesql because the bbdd has 7378 question. I read at your forum that if i change the block size in postgradesql i have 1600*4 os space.

Please Log in to join the conversation.

More
5 years 3 months ago - 5 years 3 months ago #66924 by DenisChenu
Hello,

Did you try to create the postgre database before <a href=' www.docs.limesurvey.org/tiki-index.php?p...tions+for+LimeSurvey '>installation</a> of LS ?

my config:
[code type=php-brief]$databasetype = 'postgres';
$databaselocation = 'localhost';
$databasename = 'limesurvey';
$databaseuser = 'limesurvey';
$databasepass = 'XXXXX';
$dbprefix = 'lime_'; [/code]

PostgreSQL 8.4.8 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
Last Edit: 5 years 3 months ago by DenisChenu.
The following user(s) said Thank You: alfredoleganes

Please Log in to join the conversation.

More
5 years 3 months ago #66927 by alfredoleganes
Thanks Shnoulle. I make this suvery on mysql and limesurey and when i publish the survey, limesuvery said too many columns. At your forum said that tire to install postgradre.

Please Log in to join the conversation.

More
5 years 3 months ago #66931 by Mazi
Instead of using postgres I'd better split up your questions into 1-n surveys.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
The following user(s) said Thank You: alfredoleganes

Please Log in to join the conversation.

More
5 years 3 months ago #66932 by alfredoleganes
Is it possible?. Sorry i don´t know, can i split suvery in three sub-surveys and only send one email???.

Please Log in to join the conversation.

More
5 years 3 months ago #66934 by Eddie_V
it is if you use the same tokens for all three surveys.

set the END URL of survey 1 to go to survey 2, you can use {token} here to build the right URL for each participant. and set the END URL for survey 2 to go to survey 3.

also do not forget to set "Automatically load URL when survey complete" to Yes.

the only thing that a user might notice is that at the end of survey 1 and 2 the "Next" button will be a "submit" button.
The following user(s) said Thank You: alfredoleganes

Please Log in to join the conversation.

More
5 years 3 months ago #66937 by alfredoleganes
Thans Eddie_v, but how use {token} to build the right URL for each participant. if i have one person at suvery 1 with token 100, i need this person pass to survey 2 with token 100 . How i make???, where i find same help.

Please Log in to join the conversation.

More
5 years 3 months ago - 5 years 3 months ago #66938 by Eddie_V
well first make sure that that all three token tables are the same, that person 1 who has token 100 in survey 1 also has token 100 in survey 2

then for the END URL set it: <limesurvey_url>/index.php?sid=<the_ID_of_survey_#2>&token={TOKEN}

and replace <limesurvey_url> with your url eg. www.limesurvey.org
and replace <the_ID_of_survey_#2> with the ID of the second survey eg. 87453
Last Edit: 5 years 3 months ago by Eddie_V.
The following user(s) said Thank You: alfredoleganes

Please Log in to join the conversation.

More
5 years 3 months ago - 5 years 3 months ago #66940 by alfredoleganes
Muchas graciassssssss, thnakssssssss. It´s ok, it´s functionally at 100%. The file .lsg of suvery is 29 Mb, now i have to split.

Thanks A LOT YOU HAVE BEEN REALLY HELPFULL Eddie_V
Last Edit: 5 years 3 months ago by alfredoleganes.

Please Log in to join the conversation.

More
5 years 3 months ago #66942 by Eddie_V
you are welcome :)

Please Log in to join the conversation.

More
5 years 3 months ago #66944 by Mazi

alfredoleganes wrote: Muchas graciassssssss, thnakssssssss.

You're welcome!

If our hints have been helpful and you enjoy limesurvey please consider a donation to the team .
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form