On Tuesday 22 July 2003 18:14, Tristan.Pretty@risk.sungard.com wrote: > Now I am not an Apache guru, and my PHP/MySQL experience is all based > around the coding side, not the instilation, security etc... > > So when I arrived at work yesterday, and discovered that several databases > had been deleted, and a random database called 'sanij' has been created, > My gut was to suspect hackers. > None of my web site pages are unaffected, and the web site runs just fine, > apart from those pages that need a MySQL database for content. Hmm, you have several databases missing, you suspect hackers, yet you continue to run the server so that ... > This morning I come to work and ALL the databases have been deleted. > As I said, I really don't know where to begin looking for evidence of > hackers. ... they can delete ALL your databases? The golden rule is, at the first sign of any suspicious activity (yes having several databases deleted does count as suspicious activity!), take the server off-line, backup all your important data, and investigate. > While I'm curious to know who did this, I think a better question to be asking is *how* they did this. Knowing that would stand you in good stead to prevent it from happenning in the future. Depending on the ability of the 'hacker' the logs may be a source of info. > I guess my priority os to recover > the lost data... is this possible...? See what you can salvage from the directory where MySQL keeps the databases. If there's nothing there then your only salvation are in the backups. > I'm working off a RAQ4, hosted by NetBenefit... > > Any advise, ideas are gonna be apperciated at this point. > I've got backups of alot of the databases, but several were created in the > past few weeks, and I didn't back them up yet... > I know I know... stupid man I am, but I'll slap myself later, for now... a > solution is required.... 1) The RAQs and its siblings seems to be notoriously insecure. You really need to keep up with any new security updates. 2) A default installation of MySQL is also insecure in that you do not need a password to use the root account. As with all break-ins or suspected break-ins, to be on the safe side you should recover any data that you can (making sure that they haven't been tainted) then format the hard-disk (or better still, put in a new hard-disk, keeping the old one for analysis) and re-install. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* Cats are intended to teach us that not everything in nature has a function. -- Garrison Keillor */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
