Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

PostgreSQL with Sessions Issue

  • Gordon55M
  • Gordon55M's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 8 months ago - 9 years 8 months ago #110185 by Gordon55M
PostgreSQL with Sessions Issue was created by Gordon55M
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?

Code:
// 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."
Last edit: 9 years 8 months ago by Gordon55M. Reason: Added survey error code regarding sessions at the bottom.
The topic has been locked.
More
8 years 9 months ago #120704 by riqcles
Replied by riqcles on topic PostgreSQL with Sessions Issue
Fixed on the new build, but not for me.
You can try ?

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • Gordon55M
  • Gordon55M's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 9 months ago #120705 by Gordon55M
Replied by Gordon55M on topic 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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose