CodeIgniter Forums
Using the new Encryption library throws "MySQL server has gone away" error - Printable Version

+- 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?