Regarding phpList 3.7.0 installation issue

[prbt2016]

Hello,

I was in the process of manual installation of phplist 3.7.0 downloaded from sourceforge on AlmaLinux 9, PHP 8.1 , MYSQL 5.7, Apache 2.4.

Also for installation I use the config_extended.php , i.e rename the default config.php to config.old.php and rename the config_extended.php to config.php as mentioned here, Since i need the custom configuration in that file like 'table prefix' :

https://www.phplist.org/manual/books/phplist-manual/page/installing-phplist-manually

So after hitting the installation URL i.e :

http://example.com/phplist370/admin I get the following error i.e :

Array ( [type] => 1 [message] => Uncaught RuntimeException: Invalid SSL CA file: /path/to/ca.pem in /home/{{USER_DIR}}/public_html/phplist370/admin/mysqli.inc:37

After inspecting config_extended.php (which I am using as config.php), It seems that following is causing this error i.e line number 49 :

// If the database user requires SSL, set this to the path
// of the CA certificate used to verify the MySQL server certificate.
$database_connection_ssl_ca = '/path/to/ca.pem';

After setting this to blank or commenting it and visiting the installation URL i.e http://example.com/phplist370/admin, installation works fine .

Is the above variable '$database_connection_ssl_ca' mandatory for phplist install or is it safe to keep it blank or comment the same ?.

Kindly let me know .

Regards.

[prbt2016]

Hello,

Any updates regarding the same ?.

Regards.

[TatevikGr]

Hello,

No, $database_connection_ssl_ca is not mandatory for a phpList installation.

That setting is only needed when you are connecting to MySQL over SSL/TLS and want phpList to verify the MySQL server certificate using a specific CA certificate file. If your MySQL server does not require SSL, or if you are not using certificate verification, then the setting can be left empty