cvm-mysql(8)

📦 version 0.97, in debian bookworm, ubuntu jammy, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

✨ cvm-mysql — the MySQL module, bestie edition ✨

okay so this is cvm-mysql(8), and it lives in the System Manager's Manual section of your man pages 💖 if you've ever wanted your credential validation to come straight out of a MySQL database, this is literally the girl for the job.

🌸 SYNOPSIS 🌸

cvm-mysql

that's it. that's the whole invocation. no flags, no arguments, she just goes 💅

🔑 CREDENTIALS 🔑

  • Pass phrase — you're handing her a pass phrase, and she's gonna check it 🫶

🦋 DESCRIPTION 🦋

So here's the vibe: this module goes and queries a MySQL database for the account name, then compares the pass phrase that's stored in there against the one you gave her, using crypt(3). that's the whole plot, no cap ✨

🎀 CONFIGURATION VARIABLES 🎀

these are the env vars she reads, and ngl you gotta get them right or nothing happens:

  • CVM_MYSQL_DEFAULT_FILE — the full path of the defaults file to read if the next variable down is set. If it's not set, the file $HOME/.my.cnf gets read instead (that's the MySQL default, iykyk).
  • CVM_MYSQL_DEFAULT_GROUP — if you set this, the module reads connection default options from the named group in the defaults file from up above 👆
  • CVM_MYSQL_HOST — the hostname or IP of the MySQL server. If you don't set it, she just assumes you're connecting to the local host 🏠
  • CVM_MYSQL_USER — the MySQL login ID to connect as. If you don't set it, she assumes the invoking user 🙋
  • CVM_MYSQL_PASS — the password for that user up there ⬆️
  • CVM_MYSQL_DB — the database name. this one must be set, periodt 🚨
  • CVM_MYSQL_PORT — the port number for the TCP/IP connection (only used if the server is not local)
  • CVM_MYSQL_POSTQ (optional) — the SQL query to execute after the credentials have been validated, see cvm-sql(7) 👀
  • CVM_MYSQL_PWCMP (optional) — the password comparison module to use
  • CVM_MYSQL_SOCKET — the path to the socket that should be used for connections to a local server 🔌
  • CVM_MYSQL_QUERY (optional) — the SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7) 📜

👑 SEE ALSO 👑

and if you wanna go down the rabbit hole 🕳️🐇:

http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
fr fr bestie, go read cvm-sql(7) if the query vars are confusing you, she explains the whole SQL situation way better than I can in one breath 😭

that's the whole page!! mwah 💋 this was cvm-mysql(8) from the System Manager's Manual, and yeah the footer just says cvm-mysql(8) again because the page is that iconic 💅✨ no date, no version, just vibes. stay hydrated, go validate some credentials 🫶🌈

📦 where this page comes from