EXT\_SQL\_SESSION\_ACL(8) User Contributed Perl Documentation EXT\_SQL\_SESSION\_ACL(8)

# [NAME](#NAME)

```
 ext_sql_session_acl - SQL Database session lookup helper for Squid
```

# [SYNOPSIS](#SYNOPSIS)

```
 ext_sql_session_acl [options]
```

# [DESCRIPTION](#DESCRIPTION)

Validates an HTTP requests access authorization with a session database.

Taking an identity token to be validated (as determined by the external\_acl\_type format) it returns a username or tag associated with the identity token passed in.

Common forms of identifiers are IP address, EUI (MAC) address, passwords, or UUID tokens.

This program uses Squid concurrency support.

# [OPTIONS](#OPTIONS)

[**--dsn**](#dsn)

Database DSN. Default "DBI:mysql:database=squid"

[**--user**](#user)

Database User

[**--password**](#password)

Database password

[**--table**](#table)

Database table. Default "passwd".

[**--uidcol**](#uidcol)

Unique Session Identifier column. Default "id".

[**--usercol**](#usercol)

External ACL user= result column.

[**--tagcol**](#tagcol)

External ACL tag= result column.

[**--cond**](#cond)

Condition, defaults to enabled=1. Specify 1 or "" for no condition

[**--persist**](#persist)

Keep a persistent database connection open between queries.

[**--debug**](#debug)

Write debug info to stderr.

# [AUTHOR](#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 assistance of Nishant Sharma <codemarauder@gmail.com>

# [COPYRIGHT](#COPYRIGHT)

```
 * 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)

Questions on the usage of this program can be sent to the *Squid Users mailing list &lt;squid-users@lists.squid-cache.org*&gt;

# [REPORTING BUGS](#REPORTING_BUGS)

Bug reports need to be made in English. 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 &lt;squid-bugs@lists.squid-cache.org*&gt;

Report ideas for new improvements to the *Squid Developers mailing list &lt;squid-dev@lists.squid-cache.org*&gt;

# [SEE ALSO](#SEE_ALSO)

[squid (8)](/man/enterprise-packages/squid/squid.8), [GPL (7)](/man/enterprise-packages/squid/GPL.7),

The Squid FAQ wiki https://wiki.squid-cache.org/SquidFaq

The Squid Configuration Manual http://www.squid-cache.org/Doc/config/

2026-10-25 perl v5.44.0

---

Document: ext_sql_session_acl(8) from squid 7.7-r4 (Chainguard OS)
Source: https://github.com/squid-cache/squid.git