BASIC_DB_AUTH(8)

📦
version 7.7 · 26 versions
, in arch rolling

💅 basic_db_auth — the database auth helper for Squid (yes, that one)

okay so real quick before we get into it: this is the manual page for basic_db_auth, a Perl helper that lives in the Squid family. It's giving "small program, big responsibilities." Let's go 🫶

✨ NAME ✨

basic_db_auth — the database auth helper for Squid. literally her whole job.

🌸 SYNOPSIS 🌸

basic_db_auth [options]

that's it. that's the whole vibe. options go in, auth comes out 💖

🦋 DESCRIPTION 🦋

This program verifies a username & a password against a database. no cap, that's literally the entire description. it checks if the creds are valid. periodt.

🎀 OPTIONS 🎀

okay bestie, here's the full lineup — every single flag, and I'm not skipping a single one because we don't do that here:

  • --debug — writes debug info out to stderr. use it when you're confused. it's your emotional support flag 💅
  • --dsn — the Database DSN. default is "DBI:mysql:database=squid" ⭐
  • --user — the Database User.
  • --password — the Database password 🙈
  • --table — the Database table. default is "passwd".
  • --usercol — the Username column. default is "user".
  • --passwdcol — the Password column. default is "password".
  • --cond — the Condition. defaults to enabled=1. specify 1 or "" for no condition. and heads up: if you use the --joomla flag, this condition gets changed to block=0.
  • --plaintext — tells it the Database contains plain-text passwords.
  • --md5 — tells it the Database contains unsalted MD5 passwords.
  • --sha1 — tells it the Database contains unsalted SHA1 passwords.
  • --salt — selects the correct salt to evaluate passwords 🧂✨
  • --persist — keeps a persistent database connection open between queries. lowkey efficient.
  • --joomla — tells the helper that the user database is a Joomla DB. so their unusual salt hashing is understood. iykyk.

👑 AUTHOR 👑

This program was written by Henrik Nordstrom <henrik@henriknordstrom.net> and Luis Daniel Lucio Quiroz <dlucio@okay.com.mx>.

This manual was written by Henrik Nordstrom <henrik@henriknordstrom.net>.

absolute icons, both of them 💖

 * 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) 2007 Henrik Nordstrom <henrik@henriknordstrom.net> Copyright (C) 2010 Luis Daniel Lucio Quiroz <dlucio@okay.com.mx> (Joomla support)

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. slay, licensing-wise 💜

⭐ 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, don't be scared 🫶

🔥 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. (ngl, reading that first saves everybody time.)

Report bugs or bug fixes using https://bugs.squid-cache.org/

Report serious security bugs to Squid Bugs <squid-bugs@lists.squid-cache.org> — seriously, security stuff goes here, not the general pile 💀

Report ideas for new improvements to the Squid Developers mailing list <squid-dev@lists.squid-cache.org> ✨

🌸 SEE ALSO 🌸

and that's the page bestie 🎀 this one's running on perl v5.42.2, dated 2026-08-25 — main character energy from start to finish. go authenticate something, ily 💅💖

📦 where this page comes from