sqlgrey-logstats(1)

📦
version 1.8.0 · 4 versions
, in debian bookworm, ubuntu jammy

✨ sqlgrey-logstats ✨

okay bestie, gather round, because this is the manual page for sqlgrey-logstats, aka the SQLgrey log parser 💖 it lives in the User Contributed Perl Documentation corner of your system, and it's here to read your logs and spill all the tea about what your greylisting has been up to. no cap.

🌸 SYNOPSIS 🌸

sqlgrey-logstats [options...] < syslogfile

 -h, --help             display this help and exit
     --man              display man page
     --version          output version information and exit
     --debug            output detailed log parsing steps

 -y, --yesterday        compute stats for yesterday
 -t, --today            compute stats for today
     --lasthour         compute stats for last hour
 -d, --lastday          compute stats for last 24 hours
 -w, --lastweek         compute stats for last 7 days

     --programname      program name looked into log file

     --top-from         how many from AWL entries to print (default: all)
     --top-domain       how many domain AWL entries to print (default: all)
     --top-spam         how many SPAM sources to print (default: all)
     --top-throttled    how many throttled sources to print (default: all)
     --print-delayed    print delayed sources (default: don't)

so you literally just pipe your syslog file into it and it does its lil analysis thing 🦋

the "help me, i'm lost" options

  • -h, --help — shows you this help and then dips. bye 👋
  • --man — pulls up the man page, for when you want the full ✨documentation experience✨
  • --version — prints the version info and peaces out
  • --debug — gives you the detailed log parsing steps, every single little thing it's doing. perfect for when you're nosy (affectionate) 🔍

the "when tho" options

  • -y, --yesterday — stats for yesterday
  • -t, --today — stats for today
  • --lasthour — stats for the last hour
  • -d, --lastday — stats for the last 24 hours
  • -w, --lastweek — stats for the last 7 days

pick your era bestie, the numbers don't lie 💅

the "what even are we looking at" options

  • --programname — the program name that gets looked into in the log file

the "how much do you wanna see" options

  • --top-from — how many from AWL entries to print (default: all)
  • --top-domain — how many domain AWL entries to print (default: all)
  • --top-spam — how many SPAM sources to print (default: all)
  • --top-throttled — how many throttled sources to print (default: all)
  • --print-delayed — print delayed sources (default: don't)
so yeah, by default it's giving everything, all the entries, the whole buffet 🍓 but if you only want the top few you can say so and it'll respect that. and delayed sources? not shown unless you explicitly ask, bestie. that's the default, no take-backs.

🎀 DESCRIPTION 🎀

sqlgrey-logstats ...

yep. that's it. that's the description. it's literally just sqlgrey-logstats ... and honestly? iconic. main character energy, zero explanation 💀

🦋 SEE ALSO 🦋

wanna know what greylisting even is? go look at:

and wanna know how Postfix policy servers work? that's over here:

iykyk 🌈

Copyright (c) 2004 by Lionel Bouton.

💜 LICENSE 💜

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

fr fr, that's the whole legal vibe. free software, no promises, read the license. 🫶

🌟 AUTHOR 🌟

Lionel Bouton <lionel-dev@bouton.name> — the legend themselves 👑

and that's the whole page, bestie!! this one's running on perl v5.30.0 and the page itself is dated 2020-02-16, so it's a lil vintage but it absolutely still ate. go parse some logs, you got this 💅✨🎀

📦 where this page comes from