MySQL57-RH

Hi @michelandre!
Wordfence uses mySQLi when available. I wonder if it could be related to that? Do you still have this problem if you do a fresh install of Wordfence *after* you’ve changed DB_HOST?

Hi wfasa,

It is a “bug” of Wordfence when it reports MySQL version.

** Wordfence > Tools > Diagnostics > MySQL = Version de la base de données 5.7.16

** Wordfence > Tools > Diagnostics > Other Tests > Clic here to display… > mysql > mysql.default_socket = /var/lib/mysql/mysql.sock
– This is wrong as there is no Table for wf… in standard MySQL only in MySQL57 there are a few.

# mysql WPBD -e "show tables;"
ERROR 1049 (42000): Unknown database 'WPBD'

]# mysql57 WPBD -e "show tables;"
+---------------------------------------+
| Tables_in_WPBD                        |
+---------------------------------------+
...
| Toto0327_wfblockediplog               |
| Toto0327_wfblocks7                    |
| Toto0327_wfconfig                     |
| Toto0327_wfcrawlers                   |
| Toto0327_wffilechanges                |
| Toto0327_wffilemods                   |
| Toto0327_wfhits                       |
| Toto0327_wfhoover                     |
| Toto0327_wfissues                     |
| Toto0327_wfknownfilelist              |
| Toto0327_wflivetraffichuman           |
| Toto0327_wflocs                       |
| Toto0327_wflogins                     |
| Toto0327_wfnotifications              |
| Toto0327_wfpendingissues              |
| Toto0327_wfreversecache               |
| Toto0327_wfsnipcache                  |
| Toto0327_wfstatus                     |
| Toto0327_wftrafficrates               |
+---------------------------------------+

** mysqli > mysqli.default_socket = /var/lib/mysql/mysql.sock
– This is impossible.

** In Duplicator extension: Duplicator > Tools > MySQL = Version 5.7.16

So I say “This is a bug…”

Michel-André

Solution:

Wordfence is looking in php.ini instead of in wp-config.php

In wp-config.php, I have already defined:

define('DB_HOST', 'localhost:/var/lib/mysql/mysql57.sock');

In php.ini, by default, socket’s path is not defined:

mysql.default_socket =

In php.ini, you have to add:

mysql.default_socket =  /var/lib/mysql/mysql57.sock
mysqli.default_socket =  /var/lib/mysql/mysql57.sock

Michel-André

Hi @michelandre,
Sorry for the late reply. Thanks for sharing your solution! I’m a bit confused by it because we use the WordPress $wbdb for database connections, so this shouldn’t be happening. I’ll forward this to the team though, so we can double check.

Hi @michelandre,
Just wanted to verify something. Is it correct that the only place you saw the “wrong” value was in the window that opens when you clicked “Click here to display your system information”? That window just shows a phpinfo() printout, which is the settings as defined in your php.ini and that is not something Wordfence controls.

If so, that’s not a bug. Just wondering if you had any actual problems with the configuration?

Hi wfasa,

Yes, this is the only place.

Then why is Duplicator and WooCommerce are both displaying the correct version and not Wordfence?

Michel-André

Hi @michelandre,
I suppose they are not showing you a phpinfo() printout anywhere? If they did, they’d be showing the exact same thing as you see when you click “Click here to display your system information”. All that function does is print out phpinfo(). That’s the exact same information you would get if you created a .php file yourself containing only

<?php
phpinfo();
?>

The Wordfence Diagnostics page also has a section called MySQL which I believe you said did show 5.7.16?

Hi wfasa

I do not know what they use but they display the correct information.

Your little script display the wrong info; same as yours.

Wordfence > Tools > Diagnostics > MySQL > version is 5.7.16 which is correct.

The page displayed by: “Click here to display your system information”
is called: “Wordfence System Info for PHP Version 7.1.22″,
it should be: “Wordfence System Info of PHP Version 7.1.22″

Michel-André

Hi @michelandre,

The Wordfence specific diagnostics (Wordfence > Tools > Diagnostics > MySQL > version) displays the version WordPress is using.

The output in “Click here to display your system information” and the script I provided is not “wrong” information. It’s exactly what is in your system php configuration. Please see the PHP docs for reference: https://php.net/manual/en/function.phpinfo.php. Wordfence includes a function for viewing what your actual underlying PHP configuration is. The other plugins don’t. That’s the only difference.

Hi wfasa,

Wordfence includes a function for viewing what your actual underlying PHP configuration is. The other plugins don’t. That’s the only difference.

Duplicator > Tools > Diagnostics > Information > PHP Information, Displays <u>exactly the same informations as yours</u>.

for viewing what your actual underlying PHP configuration <u>is</u>

As you wrote <u>is</u> not <u>for</u>.

Other extensions might be small but they display in other languages… Please see other extensions for reference…

Michel-André

Hi again @michelandre,

If Duplicator displays the same information, what is the problem exactly?

Hi @michelandre,

We haven’t heard back from you in a while. I’ve gone ahead and marked this thread as resolved. If you’re still having issues with Wordfence, feel free to open another thread.

Thanks!