- Posts: 4
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
LimeSurvey CE 3.x & PHP 7.2 upgrade – database connection?
- saggeana
- Topic Author
- Offline
- New Member
Less
More
5 years 5 months ago #176258
by saggeana
LimeSurvey CE 3.x & PHP 7.2 upgrade – database connection? was created by saggeana
Hi community!
So, I'm running LimeSurvey CE on 3.14.x currently, updating to 3.15.x soon. Today I tried upgrading PHP on my IIS server from a depreciated 5.6.x to a more current 7.2.11. I got everything working fine enough that I got the admin login screen to load well enough, but couldn't actually log in to the system. Couldn't really find anything helpful in the browser's developer console, error messages or such.
Does anyone know if any specific modules have to be enabled so as to get LS 3.x to function with PHP 7.2?
Currently my extensions look like this:
;extension=bz2
;extension=curl
;extension=fileinfo
;extension=gd2
;extension=gettext
;extension=gmp
;extension=intl
extension=imap
;extension=interbase
;extension=ldap
extension=mbstring
;extension=exif ; Must be after mbstring as it depends on it
extension=mysqli
;extension=oci8_12c ; Use with Oracle Database 12c Instant Client
extension=odbc
extension=openssl
;extension=pdo_firebird
extension=pdo_mysql
;extension=pdo_oci
extension=pdo_odbc
;extension=pdo_pgsql
;extension=pdo_sqlite
;extension=pgsql
;extension=shmop
;extension=snmp
;extension=soap
;extension=sockets
;extension=sqlite3
;extension=tidy
;extension=xmlrpc
;extension=xsl
The earlier extension php_mysql.dll has been removed from PHP7.
Or do I perhaps have to make changes to the LimeSurvey config itself when upgrading PHP?
Thanks for any helpful tips, and I hope you all have a nice weekend coming up!
So, I'm running LimeSurvey CE on 3.14.x currently, updating to 3.15.x soon. Today I tried upgrading PHP on my IIS server from a depreciated 5.6.x to a more current 7.2.11. I got everything working fine enough that I got the admin login screen to load well enough, but couldn't actually log in to the system. Couldn't really find anything helpful in the browser's developer console, error messages or such.
Does anyone know if any specific modules have to be enabled so as to get LS 3.x to function with PHP 7.2?
Currently my extensions look like this:
;extension=bz2
;extension=curl
;extension=fileinfo
;extension=gd2
;extension=gettext
;extension=gmp
;extension=intl
extension=imap
;extension=interbase
;extension=ldap
extension=mbstring
;extension=exif ; Must be after mbstring as it depends on it
extension=mysqli
;extension=oci8_12c ; Use with Oracle Database 12c Instant Client
extension=odbc
extension=openssl
;extension=pdo_firebird
extension=pdo_mysql
;extension=pdo_oci
extension=pdo_odbc
;extension=pdo_pgsql
;extension=pdo_sqlite
;extension=pgsql
;extension=shmop
;extension=snmp
;extension=soap
;extension=sockets
;extension=sqlite3
;extension=tidy
;extension=xmlrpc
;extension=xsl
The earlier extension php_mysql.dll has been removed from PHP7.
Or do I perhaps have to make changes to the LimeSurvey config itself when upgrading PHP?
Thanks for any helpful tips, and I hope you all have a nice weekend coming up!
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
5 years 5 months ago - 5 years 5 months ago #176262
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic LimeSurvey CE 3.x & PHP 7.2 upgrade – database connection?
extension=fileinfo , extension=gd2 and extension=exif
Else : maybe something with session, activate debug mode and check what session is created using a developper tool
Else : maybe something with session, activate debug mode and check what session is created using a developper tool
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 5 years 5 months ago by DenisChenu.
The topic has been locked.
- saggeana
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
5 years 5 months ago #176305
by saggeana
Replied by saggeana on topic LimeSurvey CE 3.x & PHP 7.2 upgrade – database connection?
Hi again, and thank you DenisChenu for your reply!
I finally got it to work by copying the configuration rows from the earlier PHP 5.6.x installation which was done through Microsoft WebPI:
[WebPIChanges]
error_log=C:\PHP_72\phperror.log
cgi.force_redirect=0
cgi.fix_pathinfo=1
fastcgi.impersonate=1
fastcgi.logging=0
max_execution_time=300
extension_dir="C:\PHP_72\ext\"
I finally got it to work by copying the configuration rows from the earlier PHP 5.6.x installation which was done through Microsoft WebPI:
[WebPIChanges]
error_log=C:\PHP_72\phperror.log
cgi.force_redirect=0
cgi.fix_pathinfo=1
fastcgi.impersonate=1
fastcgi.logging=0
max_execution_time=300
extension_dir="C:\PHP_72\ext\"
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 5 months ago #176309
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic LimeSurvey CE 3.x & PHP 7.2 upgrade – database connection?
You should check if tokens are working. If you don't have OpenSSL extension activated, you will run into issues when using PHP 7.2 under windows.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.