Project:Drupal core
Version:8.x-dev
Component:dblog.module
Category:feature request
Priority:normal
Assigned:Unassigned
Status:postponed

Issue Summary

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 KBIgnored: Check issue status.NoneNone

Comments

#1

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

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

#3

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

Version:4.6.0» x.y.z
Status:needs review» needs work

lots of it. *shudder*

#5

Version:x.y.z» 6.x-dev

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

#6

Version:6.x-dev» 7.x-dev
Status:needs work» active

Patch has no relationship to current module.

#7

Component:watchdog.module» syslog.module
Status:active» needs work

#8

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

Component:syslog.module» dblog.module
Assigned to:deekayen» Anonymous

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

#10

Assigned to:Anonymous» deekayen

#11

Status:needs work» postponed

#445482: Convert dblog_build_filter_query() to DBTNG needs to be resolved before this can happen

#12

This is where I was headed with this feature when I discovered #445482: Convert dblog_build_filter_query() to DBTNG. :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 KBIgnored: Check issue status.NoneNone

#13

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!

#14

Is the dblog / watchdog data available to views and / or rules / trigger /actions?
That would be great, as i need to do a lot of hand holding for user login and password reset. Could have better monitoring, automatic emails and reports,...

#15

Assigned to:deekayen» Anonymous

#16

Version:7.x-dev» 8.x-dev

#17

#18

shouldn't this be marked closed (won't fix) because who doesn't want to manually search through logs when they get about 2000 log entries per day.. finding that error message from last night should be an hour long endeavor, no?