EXT_SQL...SION_ACL(8)

πŸ’… ext_sql_session_acl ✨

okay so bestie, this is the manual page for ext_sql_session_acl β€” it lives in section 8 of the manual, and it's from the User Contributed Perl Documentation (yes, Perl, we love her). Basically it's the SQL Database session lookup helper for Squid and she is lowkey doing the most important job: checking whether people are allowed to be here. 🫢


🌸 NAME 🌸

ext_sql_session_acl β€” SQL Database session lookup helper for Squid

⭐ SYNOPSIS ⭐

ext_sql_session_acl [options]

πŸ¦‹ DESCRIPTION πŸ¦‹

So what does she do? She validates an HTTP request's access authorization against a session database. That's the whole gig. πŸ‘‘

The way it works: you hand her an identity token that needs to be validated (and which token that is, is determined by the external_acl_type format β€” that's the config's job, not hers). She then returns a username or a tag associated with the identity token you passed in.

Common forms of identifiers are:

  • IP address
  • EUI (MAC) address
  • passwords
  • UUID tokens

Also, super important: this program uses Squid concurrency support. She multitasks. Main character energy fr fr. πŸ’…


πŸŽ€ OPTIONS πŸŽ€

okay here's the whole flag lineup, no skips, no cap:

  • --dsn β€” Database DSN. Default is "DBI:mysql:database=squid".
  • --user β€” Database User.
  • --password β€” Database password.
  • --table β€” Database table. Default is "passwd".
  • --uidcol β€” Unique Session Identifier column. Default is "id".
  • --usercol β€” External ACL user= result column.
  • --tagcol β€” External ACL tag= result column.
  • --cond β€” Condition, defaults to enabled=1. Specify 1 or "" for no condition.
  • --persist β€” Keep a persistent database connection open between queries.
  • --debug β€” Write debug info to stderr.

πŸ‘‘ AUTHOR πŸ‘‘

This program and documentation was written by Amos Jeffries <amosjeffries@squid-cache.org>

Based on original work in DB_auth by Henrik Nordstrom <henrik@henriknordstrom.net> with the assistance of Nishant Sharma <codemarauder@gmail.com> β€” collab era, we stan. πŸ’œ

 * Copyright (C) 1996-2026 The Squid Software Foundation and contributors
 *
 * Squid software is distributed under GPLv2+ license and includes
 * contributions from numerous individuals and organizations.
 * Please see the COPYING and CONTRIBUTORS files for details.

 Copyright (C) 2012 Amos Jeffries <amosjeffries@squid-cache.org>

 This program is free software. You may redistribute copies of it under the
 terms of the GNU General Public License version 2, or (at your opinion) any
 later version.

πŸ’Œ QUESTIONS πŸ’Œ

Questions on the usage of this program can be sent to the Squid Users mailing list <squid-users@lists.squid-cache.org> β€” they're nice, go ask. πŸ“

πŸ™ˆ REPORTING BUGS πŸ™ˆ

bestie, listen: bug reports need to be made in English. That's the rule. 😭

See https://wiki.squid-cache.org/SquidFaq/BugReporting for details of what you need to include with your bug report.

  • Report bugs or bug fixes using https://bugs.squid-cache.org/
  • Report serious security bugs to Squid Bugs <squid-bugs@lists.squid-cache.org> (pls do this for the scary ones πŸ”₯)
  • Report ideas for new improvements to the Squid Developers mailing list <squid-dev@lists.squid-cache.org>

🌈 SEE ALSO 🌈


and that's the whole page, bestie β€” you ate that. πŸ’– This beauty ships with perl v5.42.2, dated 2026-08-25, and it's page EXT_SQL...SION_ACL(8) in the User Contributed Perl Documentation collection (the man page title up top, the version-and-date bit down here β€” now you know the whole outfit πŸŽ€βœ¨).

πŸ“¦ where this page comes from