+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: Using the new Encryption library throws "MySQL server has gone away" error (/showthread.php?tid=78690)
Using the new Encryption library throws "MySQL server has gone away" error - asantoli - 02-26-2021
I have code that currently runs without error. When I introduce the "Encryption" library and call the encrypt or decrypt functions, the MySQL call to update the ci_sessions table fail with the error "MySQL has gone away". Note: MySQL ssl is being used. Its seems like the openssl used in Encryption library is overwriting the mysqli key or chiper?
Does anyone have an history with this or ideas? Thanks
The Code is currently running on:
PHP 5.6
CI 3.1.6
MySQL 5.6
Here is the database.php setup
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' =>FALSE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => array(
'ssl_key' => $db_ssl_key,
'ssl_cert' => $db_ssl_cert,
'ssl_ca' => $db_ssl_ca,
),
'compress' => FALSE,
'stricton' =>FALSE,
RE: Using the new Encryption library throws "MySQL server has gone away" error - InsiteFX - 02-27-2021
What version of CodeIgniter, PHP and MySQLi are you trying to run it on now?