- Posts: 29
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
PostgreSQL with Sessions Issue
- Gordon55M
- Topic Author
- Offline
- Junior Member
Less
More
9 years 11 months ago - 9 years 11 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?
"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."
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 11 months ago by Gordon55M. Reason: Added survey error code regarding sessions at the bottom.
The topic has been locked.
- riqcles
- Offline
- Elite Member
Less
More
- Posts: 233
- Thank you received: 21
9 years 1 week ago #120704
by riqcles
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
Replied by riqcles on topic PostgreSQL with Sessions Issue
Fixed on the new build, but not for me.
You can try ?
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 29
- Thank you received: 1
9 years 1 week 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.