Unable to Scan

Hey @kwebdesign,

I just wanted to let you know that a colleague is looking into this. We’ll update you when we know more.

Thanks for your patience.

Gerroald

No problem… I understand and thanks for the update!

Hey @kwebdesign,

Thanks for your understanding. In the meantime, can you send me a Diagnostics report so I can get a better overview of your environment? Please navigate to Wordfence > Tools > Diagnostics. Here you can select SEND REPORT BY EMAIL. Please include your www.ads-software.com username and update this thread after you’ve sent it.

Thanks,

Gerroald

• This reply was modified 4 years, 11 months ago by WFGerroald.

Hi Gerroald,

I’ve now sent the diagnostics report.

Regards,

Kirk

Hi @kwebdesign,

I’m unable to locate your diagnostics report from the [email protected] email inbox. Can you try again making sure that the email is [email protected] and that you have put kwebdesign for the Ticket ID?

For the moment, I believe this is an issue with your table prefix. Can you open up wp-config.php, and tell me what is the value for:

$table_prefix = *****?

By default it should be wp_ but I think on your installation it might have been changed to 3dJr37Rvt. You don’t have any tables that start with 3dJr37Rvt, so I’m wondering if this file was changed after you installed Wordfence.

If you have access to the database, can you list me all the table names related to Wordfence? For example: show tables;

| wp_wfhits             |
| wp_wfhoover           |
| wp_wfissues           |
...

I’m almost confident that the tables created have the prefix wp_wf on your database.

Dave

Hi there,

Apologies for wasting your time on looking for the report…
I’d forgotten that this client had refused to work with me in setting up Send Grid or MailGun, as they’ve given up on the site and plan to drop it when their hosting is up in 6 months. This adds to the frustration of trying to resolve this issue!
I’ve just chucked my Send Grid API key in and have resent the report.

My value is…
$table_prefix = ‘3dJr37Rvt_’;
All of my tables start with this prefix, so I’m confused that you’ve said “You don’t have any tables that start with 3dJr37Rvt”.

You can see all my WF Tables here…
https://snipboard.io/Tbfsih.jpg

I’m sure the hackers out there are loving all of this information… No security and here’s my secret table prefix. Thank god for backups, because I don’t think this site will last another 6 months at this rate.

That’s not me having a go… I totally understand these questions are necessary. It’s just an unfortunate situation.

Hi again,

I suspect that your database is case-sensitive – and comparing the database tables in your screenshot:

3dJr37Rvt_wfconfig
3dJr37Rvt_wfblocks7

They seem to have been created in lowercase.

Can you run the following query in your database?

show variables where variable_name='lower_case_table_names';

If this variable is 0 – that means table names are case sensitive, and you will need to edit my.cnf so that you can set this value to 1.

Dave

Thanks for your response.
For some reason I didn’t get an email notification and only noticed you’d replied yesterday.

My lower_case_table_names variable is set to 0.
I tried changing it to 1 in the early hours of this morning, but I must have made the change in the wrong place, because mysql failed to restart, so I had to revert.

I’m currently trying to set it on a per user basis, but am struggling to find the location.

I think I’ll have to pick this up once I’ve watched some more Linux tutorials.

Many thanks for your input so far…

Hi @kwebdesign,

We haven’t heard back from you in a while, so I’ve gone ahead and marked this thread as resolved.

Please feel free to open another thread if you’re still having issues with Wordfence.

Thanks,

Gerroald