Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2019-04-03 10:02:05

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 640
Website

Site Hacked -> export log files as text?

One of my client’s Textpattern sites (on 4.7.1) has recently been hacked and turned into a phishing site for some hours, before the server provider luckily shut down the site then quite fast.

EDIT: Textpattern does NOT seem to be the reason, why the site got hacked. Just to mention that.

A quick overview after the site got restored from the last backup now shows, that log files in database probably contain IPs of attackers as well as possible victims of the phishing scam.
Is there a way to export the log files as text, so that for instance handing them over to investigators can be made more easy?
I guess this could already be possible directly from PHP MyAdmin, however the required SQL commands are unknown to me.
Thanx for any insights.

Last edited by jayrope (2019-04-03 10:09:18)


a hole turned upside down is a dome, though only when there’s gravity.

Offline

#2 2019-04-03 10:13:04

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 3,461
Website

Re: Site Hacked -> export log files as text?

I’m not sure if Textpattern’s logs will also show access to phishing scripts that are not routed through Textpattern, but if you want to export the txp_logs table, you can export that individually using phpMyAdmin in CSV format for use with Excel and co. You should just need to choose your individual table in phpMyAdmin and then choose the export format from the dropdown. Note: you might have to search and replace , and ; to get them to show properly in German Excel versions.

Most server providers also have server access log files, and if they still exist for those day, they should contain all attempts to access anything on the server regardless of whether through Textpattern or not. Usually they’re in a specific folder and you can download them via FTP.


TXP Builders – finely-crafted code, design and txp

Offline

#3 2019-04-03 10:40:38

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 640
Website

Re: Site Hacked -> export log files as text?

Thanx Jakob, excellent hint. Exported as CSV for MS Excel, and it works in Open Office already.
Thanx much!


a hole turned upside down is a dome, though only when there’s gravity.

Offline

Board footer

Powered by FluxBB