---
name: "automx_sql"
section: "5"
platform: "linux"
package: "automx"
version: "0.10.0-2.1"
release: "Debian 10 (Buster)"
platforms: ["linux"]
url: "https://new.carta.tech/automx_sql"
---

# automx\_sql(5)

automx SQL backend configuration parameters

## NAME

automx\_sql - automx SQL backend configuration parameters

## DESCRIPTION

The [automx\_sql(5)](/automx_sql/5.md) man page specifies all parameters that control access from within automx to a SQL backend.

## PARAMETERS

- **host (default: none)**

  Specifies one or more SQL servers separated by commas. Each server specification must provide database driver, username and password to access a database on a host as shown in the following example:

  ```
  host = driver://username:password@hostname/database
  ```

  **IMPORTANT:**

  Subsequent servers to the first serve only for fallback purposes, i.e. a server to the right will only be queried if the server left to it cannot be reached. If a server can be reached no further attempts will be made regardless if the query returned a result or not.

- **query (default: none)**

  Specifies the query that should be sent to the database specified with the host parameter:

  query = SELECT displayname, mailaddr FROM mail WHERE mailaddr='%s';

  **NOTE:**

  See the section called “Macros and Variables” in [automx.conf(5)](/automx.conf/5.md) for a list of available query macros.

- **result\_attrs (default: none)**

  Specifies the attributes whose values should be used in an automx account setup:

  result\_attrs = displayname, mailaddr

## AUTHORS

- **Christian Roessner \<*cr@sys4.de*\>**

  Wrote the program.

- **Patrick Ben Koetter \<*p@sys4.de*\>**

  Wrote the documentation.

## SEE ALSO

*automx(8)*, *[automx.conf(5)](/automx.conf/5.md)*, *[automx\_ldap(5)](/automx_ldap/5.md)*, *[automx\_script(5)](/automx_script/5.md)*, *[automx\_sql(5)](/automx_sql/5.md)*, *[automx-test(1)](/automx-test/1.md)*

## COPYRIGHT

This document has been placed in the public domain.