.\" -*- mode: troff; coding: utf-8 -*-
.\" Automatically generated by Pod::Man 5.01 (Pod::Simple 3.43)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" \*(C` and \*(C' are quotes in nroff, nothing in troff, for use with C<>.
.ie n \{\
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is >0, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.nr rF 0
.if \n(.g .if rF .nr rF 1
.if (\n(rF:(\n(.g==0)) \{\
.    if \nF \{\
.        de IX
.        tm Index:\\$1\t\\n%\t"\\$2"
..
.        if !\nF==2 \{\
.            nr % 0
.            nr F 2
.        \}
.    \}
.\}
.rr rF
.\" ========================================================================
.\"
.IX Title "EXT_SQL_SESSION_ACL 8"
.TH EXT_SQL_SESSION_ACL 8 2024-04-09 "perl v5.38.2" "User Contributed Perl Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH NAME
.Vb 1
\& ext_sql_session_acl \- SQL Database session lookup helper for Squid
.Ve
.SH SYNOPSIS
.IX Header "SYNOPSIS"
.Vb 1
\& ext_sql_session_acl [options]
.Ve
.SH DESCRIPTION
.IX Header "DESCRIPTION"
Validates an HTTP requests access authorization with a session database.
.PP
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.
.PP
Common forms of identifiers are IP address, EUI (MAC) address, passwords, or UUID tokens.
.PP
This program uses Squid concurrency support.
.SH OPTIONS
.IX Header "OPTIONS"
.IP \fB\-\-dsn\fR 12
.IX Item "--dsn"
Database DSN. Default "DBI:mysql:database=squid"
.IP \fB\-\-user\fR 12
.IX Item "--user"
Database User
.IP \fB\-\-password\fR 12
.IX Item "--password"
Database password
.IP \fB\-\-table\fR 12
.IX Item "--table"
Database table. Default "passwd".
.IP \fB\-\-uidcol\fR 12
.IX Item "--uidcol"
Unique Session Identifier column. Default "id".
.IP \fB\-\-usercol\fR 12
.IX Item "--usercol"
External ACL user= result column.
.IP \fB\-\-tagcol\fR 12
.IX Item "--tagcol"
External ACL tag= result column.
.IP \fB\-\-cond\fR 12
.IX Item "--cond"
Condition, defaults to enabled=1. Specify 1 or "" for no condition
.IP \fB\-\-persist\fR 12
.IX Item "--persist"
Keep a persistent database connection open between queries.
.IP \fB\-\-debug\fR 12
.IX Item "--debug"
Write debug info to stderr.
.SH AUTHOR
.IX Header "AUTHOR"
This program and documentation was written by \fIAmos Jeffries <amosjeffries@squid\-cache.org\fR>
.PP
Based on original work in DB_auth by Henrik Nordstrom <henrik@henriknordstrom.net>
With assistance of Nishant Sharma <codemarauder@gmail.com>
.SH COPYRIGHT
.IX Header "COPYRIGHT"
.Vb 5
\& * Copyright (C) 1996\-2023 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.
.Ve
.SH QUESTIONS
.IX Header "QUESTIONS"
Questions on the usage of this program can be sent to the \fISquid Users mailing list <squid\-users@lists.squid\-cache.org\fR>
.SH "REPORTING BUGS"
.IX Header "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.
.PP
Report bugs or bug fixes using https://bugs.squid\-cache.org/
.PP
Report serious security bugs to \fISquid Bugs <squid\-bugs@lists.squid\-cache.org\fR>
.PP
Report ideas for new improvements to the \fISquid Developers mailing list <squid\-dev@lists.squid\-cache.org\fR>
.SH "SEE ALSO"
.IX Header "SEE ALSO"
squid (8), GPL (7),
.PP
The Squid FAQ wiki https://wiki.squid\-cache.org/SquidFaq
.PP
The Squid Configuration Manual http://www.squid\-cache.org/Doc/config/