TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 01-26-2008, 09:12 PM   #1 (permalink)
The Addict
 
sarmenhb's Avatar
 
Join Date: Jan 2008
Location: los angeles
Posts: 309
Thanks: 44
sarmenhb is on a distinguished road
Default is there such a software as this

is there such a software to monitor what scripts or what object/item is sending queries to a specific table or database and displays a report or a log of queries sent.

thxn
__________________
no signature set
sarmenhb is offline  
Reply With Quote
Old 01-26-2008, 09:24 PM   #2 (permalink)
The Frequenter
 
ReSpawN's Avatar
 
Join Date: Nov 2007
Location: Netherlands
Posts: 460
Thanks: 49
ReSpawN is on a distinguished road
Default

Not that I know of, sorry mate. I usually make it on my own. Simply make a class (if you know how, you're already on your way). In the class (it's a mySQL class btw), you are going to create a function called query. When the $mysql->query(); is called upon, you can insert the query into an array like so; $history = array("sql" => $query);

In any case, something like that. The same you can perform with any given object or item. Fetched, Result or what ever you prefer.

Good luck.
__________________
"Life is a bitch, take that bitch on a ride"
Send a message via MSN to ReSpawN
ReSpawN is offline  
Reply With Quote
Old 01-26-2008, 09:29 PM   #3 (permalink)
The Addict
 
sarmenhb's Avatar
 
Join Date: Jan 2008
Location: los angeles
Posts: 309
Thanks: 44
sarmenhb is on a distinguished road
Default

what if someone had access to my server and was sending queries, is there no way to catch what querys he's sending?

being that he created a php script so that loaded it can show him username/passwords or select from a table and show to the page.
__________________
no signature set
sarmenhb is offline  
Reply With Quote
Old 01-26-2008, 09:35 PM   #4 (permalink)
Moderateur
RegEx Guru PHP Guru Top Contributor Advanced Programmer 
 
Salathe's Avatar
 
Join Date: Apr 2007
Posts: 1,393
Thanks: 5
Salathe is on a distinguished road
Default

MySQL can keep log files for a history of activity, errors, etc. just like Apache keeps logs for httpd activity, errors, etc. A starting point: http://dev.mysql.com/doc/refman/5.0/en/log-files.html
Salathe is offline  
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 03:47 AM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design