The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Searching under Mod Security section

Discussion in 'Security' started by bpmod, Nov 19, 2012.

  1. bpmod

    bpmod Well-Known Member

    Joined:
    Sep 23, 2004
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    I am using WHM 11.34.0 (build 9) on CentOS 6.3 x86_64 standard.

    I click on Mod Security in the plugins section and am taken to a page which shows a table of mod security triggers. The columns are (from left to right): Date, Time, IP, GET, Host, Message, & Action.

    I would like to search for a particular Action (for instance, 500) and sort from newest to oldest (as I am not interested in things that triggered a 500 server error a couple of years ago).

    But no matter what I choose as 'sort by' or 'sort order', it lists the first x number of records from the date the server was installed.

    How can I find the latest records?

    Thanks

    Brian
     
  2. PlotHost

    PlotHost Well-Known Member

    Joined:
    Apr 29, 2011
    Messages:
    253
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    US
    cPanel Access Level:
    Root Administrator
    Twitter:
    Go to WHM->.phpMyAdmin-> modsec database .
    There try a query like this

    SELECT *
    FROM `modsec`
    WHERE mod_security_action LIKE '%500%'
    ORDER BY DATE DESC
    LIMIT 0 , 30
     
  3. bpmod

    bpmod Well-Known Member

    Joined:
    Sep 23, 2004
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    That did the trick and a whole lot more.

    Thanks

    Brian
     
Loading...

Share This Page