• Hello,

    I’m using iThemes 4.6.8 and have set the log files to be saved in the MySQL database.

    I am trying to view these, by inspecting the table itsec_log. However the field (Log_data) contains a large quantity of information, which I would like to be able to see in a readable manner-can someone more technical than I tell me what is the info converted to? it does not seem to be standard Json, nor CSV.

    Also, when I try the other method of going to wordpress->Security->Logs (iThemes) and selecting “File Change History” (which I am interested in reviewing) the data is displayed in a “poorly” formatted frame; I’ve tried this in IE, Firefox and Chrome, and all give the same result. example:

    https://i61.tinypic.com/a1ssh1.jpg

    https://www.ads-software.com/plugins/better-wp-security/

Viewing 10 replies - 16 through 25 (of 25 total)
  • Thread Starter albert.temp

    (@alberttemp)

    ok, I don’t mind doing a teamviewer session with you.

    email me on [redacted]

    Guys, please keep help on these forum – as per:

    https://codex.www.ads-software.com/Forum_Welcome#Helping_Out

    @dwinden – please do not ask people for access to their sites per the above.

    Andrew Nevins

    (@anevins)

    WCLDN 2018 Contributor | Volunteer support

    @dwinden, Your previous attempts to solicit private support from these forums have now been moderated.

    Do not provide your contact information, do not ask for other people’s contact information and please do not ask for access to people’s installations, nor access to FTP or Database servers!

    Hi Albert,

    You can export the logs from the database in different formats using a tool like phpMyAdmin.

    https://kb.site5.com/control/phpmyadmin-control/phpmyadmin-exporting-databases-and-tables/

    As for the formatting of the logs page, I agree that this is likely a plugin/theme conflict. My first assumption is a theme.

    Try switching to a WordPress default theme like Twenty Fifteen and see if that helps.

    If that doesn’t help, then deactivate all other plugins and see if that resolves the issue. If it does, then reactivate the plugins one at a time until you find the culprit(s), if any.

    Thanks,

    Gerroald

    A TeamViewer session revealed the wpDataTables plugin is loading the jquery-ui.css file from Google. And it does so at login to WP Dashboard.

    So I looked at the wpDataTables plugin code and it doesn’t look good …
    ALL the wpDataTables plugin .js and .css files are loaded at WP Dashboard login … including the jquery-ui.css file from Google.

    On to the solution.
    I made some small changes in the code of the WpDataTables/controllers/wdt_admin.php file.
    Basically I hooked enqueueing of the jquery-ui.css file from Google to the 3 pages displayed when navigating using the 3 WpDataTables plugin menu options in WP Dashboard. And voila problem solved.

    wpDataTables plugin developers should seriously rewrite their enqueueing piece of code.

    If the information above helped you resolve the issue please mark the topic as ‘resolved’.

    dwinden

    Is there an easy fix for this? Very annoying.

    Is it the wpDataTables plugin that is also causing this issue in your situation ?
    If so I could add a download link for the fixed WpDataTables/controllers/wdt_admin.php (1.5.5) file to this topic.

    dwinden

    No, it was another plugin causing the issue in my case.

    White Label CMS

    Is it in your case also a style from the jquery-ui.css file that messes up the layout ?

    And if so, is the White Label CMS plugin also loading the jquery-ui.css file from Google ?

    Or is it using a local (=included with the plugin install) copy ?

    dwinden

Viewing 10 replies - 16 through 25 (of 25 total)
  • The topic ‘viewing the itsec_logs file’ is closed to new replies.