Search Watchdog Log

pyromanfo - June 14, 2005 - 01:34
Project:Drupal
Version:7.x-dev
Component:dblog.module
Category:feature request
Priority:normal
Assigned:deekayen
Status:postponed
Description

This patch allows you to search the watchdog log for some text in the hostname, user or the message itself. Also if you enter a severity, 'error','warning','notice' it'll filter by that. Works in tandem with the dropdown filter box.

AttachmentSizeStatusTest resultOperations
watchdog_search.patch2.75 KBIgnoredNoneNone

#1

Dries - June 19, 2005 - 20:30

These queries are not secure. If someone manages to extend an administrator's session information (through a bug elsewhere), they would be able to execute SQL queries.

#2

pyromanfo - June 20, 2005 - 14:13

Would moving it to the standard POST query paramater fix it?

#3

Dries - June 21, 2005 - 18:32

I wouldn't fix the problem. The solution is to properly use the dababase API. That is, to use the '%s' and %d directives.

#4

killes@www.drop.org - August 1, 2005 - 00:19
Version:4.6.0» x.y.z
Status:needs review» needs work

lots of it. *shudder*

#5

Jaza - December 26, 2006 - 00:53
Version:x.y.z» 6.x-dev

this would still be a useful feature. Moving to 6.x-dev queue.

#6

catch - October 24, 2007 - 13:34
Version:6.x-dev» 7.x-dev
Status:needs work» active

Patch has no relationship to current module.

#7

lilou - August 26, 2008 - 20:35
Component:watchdog.module» syslog.module
Status:active» needs work

#8

deekayen - May 13, 2009 - 03:05
Assigned to:Anonymous» deekayen

Rather than maintain http://drupal.org/project/logsearch, perhaps I'll try rolling some small part of it into core.

#9

deekayen - May 18, 2009 - 22:29
Component:syslog.module» dblog.module
Assigned to:deekayen» Anonymous

I guess I can't get this involved right now.

#10

deekayen - June 22, 2009 - 20:31
Assigned to:Anonymous» deekayen

#11

deekayen - June 22, 2009 - 22:39
Status:needs work» postponed

#445482: PDOException: Invalid parameter number: dblog needs to be resolved before this can happen

#12

deekayen - June 22, 2009 - 22:56

This is where I was headed with this feature when I discovered #445482: PDOException: Invalid parameter number: dblog. :s replacement doesn't work for u.name in this method because of the open bug. As this patch is, it would only add user searching, not text message text. Since the text portion of the watchdog log string has replacement values in it between the message and variables fields, that becomes a larger issue of discussion.

AttachmentSizeStatusTest resultOperations
24957_broken_draft.patch3.11 KBIgnoredNoneNone

#13

arhak - September 21, 2009 - 07:08

I don't know the way this patch goes, neither why it is postponed
but I'm providing patches and modules to achieve this

patch providing log_filters hook for D7 #582622: provide hook for dblog_filters
same patch for D6 #582672: dblog support filters through a hook (6.x)

alternatively a set of working modules for D6 #578488: recent/aged/username/hostname filters for log entries
(with screenshots available)

everything waiting for user to test and give feedback

do you really would like to see this into D7 core?
come on! code freeze is here already!

 
 

Drupal is a registered trademark of Dries Buytaert.