Page 1 of 1

No Mysql option for database type

Posted: Sat Aug 19, 2017 11:37 pm
by eabjoker
What do I have to do to enable the Mysql database in the configuration?
Only options are PDO::SQLite and SQLIte3.
I am using PHP 7.0, Serendipity 2.1.1, new install.
serendipity_db_error.png
serendipity_db_error.png (16.72 KiB) Viewed 4197 times

Re: No Mysql option for database type

Posted: Mon Aug 21, 2017 6:44 pm
by thh
eabjoker wrote:What do I have to do to enable the Mysql database in the configuration?
Only options are PDO::SQLite and SQLIte3.
Do you have compiled or installed a PHP with mySQL extension?

You can check for that by using a file called, for example, phpinfo.php, containing only this:

Code: Select all

<?php phpinfo(); ?>
When viewing that file in your browser, look for sections called "mysql" or "mysqli".

Re: No Mysql option for database type

Posted: Mon Aug 21, 2017 8:28 pm
by eabjoker
Thanks for the reply.
Below is a screenshot of the relevant phpinfo section.
I have other php applications using mysql on this install without any issue.
mysql.png
mysql.png (16.5 KiB) Viewed 4189 times

Re: No Mysql option for database type

Posted: Mon Aug 21, 2017 8:39 pm
by yellowled
eabjoker wrote:Below is a screenshot of the relevant phpinfo section.
At the very top of that page, there's a section “Configure Command”. Does that contain '--with-mysqli' in your phpinfo()?

YL

Re: No Mysql option for database type

Posted: Mon Aug 21, 2017 9:37 pm
by eabjoker
That appears to be the issue.
I am recompiling with mysqli option.