Author Topic: Database changes script watch / warning?  (Read 571 times)

Offline rumen

  • Posts: 399
Database changes script watch / warning?
« on: August 02, 2017, 12:13:23 PM »
Hi there,

I saw script in the site under Admin in the menu "dbWatchSite" that watch for changes in the db. The file is not accessible unfortunately. Is there any other similar script?

I suspect some changes that has not been done by any of the users of the site. I just need script that will send message by e-mail or any other way in case the DataBase is changed in any way. I seek in the web without any success until now.



Offline hgs

  • Betatester
  • **
  • Posts: 1110
    • EFG MG
Re: Database changes script watch / warning?
« Reply #1 on: August 02, 2017, 02:01:21 PM »
Here is not the DB monitored, but the webspace
LG Harald

"Fange nie an, aufzuhören - höre nie auf, anzufangen." Marcus Tullius Cicero (106-43 v.Chr.)

Offline Ruud

  • Posts: 3649
  • Gender: Male
  • Do not use PM for help! Please use the forum!
    • Dev4Me - Professional WebsiteBaker Development
Re: Database changes script watch / warning?
« Reply #2 on: August 02, 2017, 02:21:01 PM »
It also depends a little bit on what you want to check..

For checking if valid users updated pages it should not be too hard to do becase most (not all) module saving routines will update the last_modified field in the pages table.

If you want to detect hackers that use other ways to modify data somewhere in the database you will need to have a copy of the previous database state and compare every table and field for changes/additions/removals. That would be pretty difficult to do.

Either way, I don't think there is some existing module/snippet to do that.

If you want to play around, this script might be what you are looking for.