Hello,
trying to move an omeka classic install on a new server, I have an issue with the connection to my database. Digging into the code I have found that it is because my hosting requires some SSL settings to be set to allow the PHP server to access the database. The issue is that I have not been able to fix it by changing settings in omeka classic, but only by updating the code. I have found that in application/libraries/Omeka/Application/Resource/Db.php
if I change the line :
$dbh = Zend_Db::factory('Mysqli', $connectionParams);
to :
$connectionParams["driver_options"][PDO::MYSQL_ATTR_SSL_CA] = "";
$connectionParams["driver_options"][PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] = false;
$dbh = Zend_Db::factory('PDO_Mysql', $connectionParams);
At first sight it seems to work fine but I wonder if there is a reason to have Mysqli fixed in the code rather than an option to chose between different adapters? Should this create some issues at some screens I have not tried yet?
Thanks,
S.