PostgreSQL with Sessions Issue

Mehr
3 Jahre 7 Monate her - 3 Jahre 7 Monate her #110185 von Gordon55M
Gordon55M erstellte das Thema PostgreSQL with Sessions Issue
I found this issue in the bug tracker here: bugs.limesurvey.org/view.php?id=8076 but it is marked as solved and I am using Version 2.05+ Build 140612, so I thought this would have been included in my version.

The admin side works without issue with regards to the sessions being used on the postgresql database side. However when I try to start a survey, I get to the 2nd page and have a sessions issue. This happens on all browsers.

This only happens to PostgreSQL, when I switch the db to be MySQL it works no problem. Data is being written to the lime_sessions table when I check the db as well so I figure it should work. Thoughts?

// Uncomment the following line if you need table-based sessions
		 'session' => array (
			 'class' => 'system.web.CDbHttpSession',
			 'connectionID' => 'db',
			 'sessionTableName' => '{{sessions}}',
		 ),
 

"Error

We are sorry but your session has expired.

Either you have been inactive for too long, you have cookies disabled for your browser, or there were problems with your connection."
Letzte Änderung: 3 Jahre 7 Monate her von Gordon55M. Begründung: Added survey error code regarding sessions at the bottom.

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
2 Jahre 8 Monate her #120704 von riqcles
riqcles antwortete auf das Thema: PostgreSQL with Sessions Issue
Fixed on the new build, but not for me.
You can try ?

LimeSurvey version 2.64.3+ 170327
OS : CentOS 7.1 / PHP 5.6.27
BDD : PostGresql 9.4.6 /

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
2 Jahre 8 Monate her #120705 von Gordon55M
Gordon55M antwortete auf das Thema: PostgreSQL with Sessions Issue
I actually have kind of gone away from PostgreSQL since I posted this. I found the performance to be very minimal over that of MySQL so I kept it simple and stayed with MySQL. I will however be doing some more research on MariaDB with this and you let you know how it works.

Bitte Anmelden um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha