Support

Admin Tools

#33189 Exporting records from security exceptions log

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by diagonal on Wednesday, 10 June 2020 05:35 CDT

Wednesday, 10 June 2020 03:44 CDT

diagonal
Hi,

What would be the best way to extract specific records from the Security Exceptions Log? Sometimes you strike lucky and it involves an ISP who actually enforced their Terms, and it is of great help to them if it was possible to extract the relevant records for them from the interface.

I'm going to check what my ISP has available in their records as well, but having some way to search (possibly mark) and extract records would be good, even if it's just text or CSV. Or even just the whole log in CSV, then it's just a bit of work in LibreOffice to select the relevant data. Might even be quicker.

(update: yes, I have extracted the relevant records from access.log, but the Akeeba log is better as it flags the reason why)

Cheers, Peter
Edited by diagonal on 2020-06-10 04:45 CDT

Wednesday, 10 June 2020 05:32 CDT

tampe125
Hello,

the log table is pretty massive, so any interaction should be made directly inside the database, using phpMyAdmin or any database administrator software.
You can run queries directly on the table, otherwise you can take a look at this reply from Nicholas, about exporting security exceptions: https://www.akeebabackup.com/support/admin-tools-wordpress/Ticket/32923:report-for-security-exceptions-log.html#p183032


Once you have exported everything, you can start filtering data that you're interested into.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 10 June 2020 05:35 CDT

diagonal
Ah, excellent - that post pretty much explains it (although I would use LibreOffice for a connect, but that's tomato - tomahto at this point :) ).

Thank you very much for the quick response.

Cheers, Peter

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!