Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    156
    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:
    255
    Likes Received:
    2
    Trophy Points:
    68
    Location:
    Romania
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. bpmod

    bpmod Well-Known Member

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

    Thanks

    Brian
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice