Connect other directories (LDAP, SQL, REST, RADIUS, token servers)
Besides Active Directory, Entra ID, Okta, Google Workspace and local users, Airgate can check accounts against several other kinds of identity store. This guide covers each of them: what it can do, the fields to fill in, and how to map its data to attributes that access rules can use.
Choose the right type
Section titled “Choose the right type”In Access › Directories › Add directory, each type shows what it can do:
| Capability | Meaning |
|---|---|
| Lookup | Finds a user without a password (authorization, MAC authentication, EAP-TLS). |
| Verify | Checks a clear-text password (PAP, EAP-TTLS/PAP, web login, TACACS+). |
| MSCHAP/CHAP | Returns an NT hash or clear text so PEAP-MSCHAPv2 and CHAP work. |
| Attributes | Returns attributes for rules. |
| MAC auth | Usable for MAC authentication. |
| Type (category) | Lookup | Verify | MSCHAP/CHAP | Typical use |
|---|---|---|---|---|
| Generic LDAP (Directories) | Yes | Yes | With a password attribute | OpenLDAP, 389-DS, eDirectory |
| Generic SQL DB (Databases) | Yes | Yes | Yes | PostgreSQL, MySQL, MariaDB, MSSQL user tables |
| HTTP (REST) (Web services) | Yes | Yes | No | An HR system or custom identity API |
| RADIUS server (RADIUS / token servers) | No | Yes | No | Proxy PAP to another RADIUS server |
| Token server (RADIUS) (RADIUS / token servers) | No | Yes | No | RSA, Duo proxy and other OTP servers over RADIUS |
| Static Host List (Host lists) | Yes | Yes | No | MAC or IP lists as a MAC-authentication source |
Before you begin
Section titled “Before you begin”- Airgate can reach the server from its location (or a site connector can).
- For TLS connections, the server’s CA is trusted for Directories under Certificates › Trusted CAs, or pasted into the type’s Trusted CA (PEM) field.
- A read-only service account on the server.
Common settings (every type)
Section titled “Common settings (every type)”- General tab: Name (used in policies and rules), Description,
Enabled, Use for authorization (fetch this source’s attributes for
users it authenticates, as
Authorization:<name>:<alias>), Additional authorization sources (other sources whose attributes are fetched too), and Cache timeout (seconds) with presets from Disabled to 7 days (default 10 hours). - Filters & attributes tab: each filter is a query plus a table
Attributes → aliases that maps a field of the result to an alias name.
The filter named
Authenticationis the user search. Restore default filters brings back the type’s defaults. Variables such as%{Authentication:Username}are inserted at the cursor from the chips under the query; their values are escaped or bound as parameters. - Enable as role: aliases whose values become roles
(
Authentication:Role). - Advanced: Server timeout (s) (default 5, never longer than the RADIUS deadline).
- Test connection checks the settings without saving them; Create source saves.
Generic LDAP
Section titled “Generic LDAP”-
Add directory › Generic LDAP.
-
Connection tab:
Field Example Hostname ldap.contoso.comConnection security, Port LDAP_SSLand636, orStartTLSand389Verify server certificate On Bind DN, Bind password cn=airgate,ou=services,dc=contoso,dc=com(optional for anonymous search)Base DN dc=contoso,dc=comVerify passwords by user bind On: passwords are checked by binding as the user. Password attribute, Password type Optional: for example sambaNTPasswordwithNTLM, so PEAP-MSCHAPv2 and CHAP work. -
Default filters:
Authentication(&(uid=%{Authentication:Username})(objectClass=*))andGroup(&(member=%{UserDN})(objectClass=groupOfNames))mappingcntoGroups. Change them to match your schema (for exampleposixGroupwithmemberUid). -
Backup servers tab: add replicas.
Generic SQL DB
Section titled “Generic SQL DB”-
Add directory › Generic SQL DB.
-
Connection tab: Database type (
PostgreSQL,MySQL,MariaDB,MSSQL), Server, Port (default 5432, 3306 or 1433), Database, Login username, Login password, TLS (disable,prefer,require,verify-full), Password type (User_Password column). -
Filters & attributes: the
Authenticationfilter is an SQL query. Every%{…}becomes a bind parameter. These column names have a meaning:Column Meaning User_PasswordThe password, in the format set by Password type ( ClearText,NTLM,SHA,SHA256,SHA512,MD5,SSHA,Crypt,PBKDF2).Password_HashA password hash. Password_Ntlm_HashAn NT hash, so PEAP-MSCHAPv2 works. Account_Status225disabled,226expired,227not approved.Example:
SELECT password AS User_Password, dept AS departmentFROM users WHERE username = '%{Authentication:Username}'Up to 100 rows; several rows become multi-valued aliases.
HTTP (REST)
Section titled “HTTP (REST)”- Add directory › HTTP (REST).
- Connection tab:
- Base URL:
https://idp.contoso.com/api. - Authentication:
None,Basic(Username, Password),BearerorSSWS(Token), orHeader(Token sent in Token header name, defaultX-API-Key). Extra headers, Secret headers and Secret parameters (sealed values used as%{name}, sent only to the base URL and the URLs configured here). - User lookup path: a template such as
/users/%{Authentication:Username}. A 2xx answer means the user exists; User-not-found HTTP status (default404) means unknown user. - Password verify path, Verify method (
POST), Verify body (template) (default{"username":"%{Authentication:Username}","password":"%{Authentication:Password}"}), Verify content type, Send user credentials as Basic auth, Success JSON path and Success value.
- Base URL:
- Filters & attributes: each filter is a request path; the attribute
table maps JSON paths (
profile.department,groups[*].name) to aliases.
RADIUS server and Token server (RADIUS)
Section titled “RADIUS server and Token server (RADIUS)”Both proxy a PAP Access-Request (with Message-Authenticator) to another server. Attributes of its Access-Accept become authorization attributes. They cannot look users up without a password, so they do not work for EAP-TLS or PEAP.
- Add directory › RADIUS server or Token server (RADIUS).
- Connection tab: Server, Port (default
1812), Shared secret, NAS-Identifier (defaultnac-console), NAS-IP-Address, Retransmissions (default 2), Require Message-Authenticator in replies, Treat Access-Reject as unknown user (lets Airgate try the next directory in the policy). - On the remote server, add Airgate as a RADIUS client with the same shared secret. The requests come from the Airgate server’s address (or the site connector’s, when it is relayed).
- Filters & attributes: the
Radius_Attributesfilter maps reply attributes (Class,Filter-Id,Cisco-AVPair…) to aliases.
For a token server, users type their one-time code (or password and code, as the token server expects) as the password. Use PAP or EAP-TTLS/PAP.
Static Host List
Section titled “Static Host List”- Create the MAC or IP lists first under Devices › MAC lists.
- Add directory › Static Host List and select the lists under Static host lists.
- Use it in a MAC-authentication policy.
Use the directory
Section titled “Use the directory”- Open Access › Access policies, open a policy and, under Check accounts in, select Add a directory… and pick the new directory.
- Add rules (User is in group works for every directory that returns a
Groupsalias). - Select Save changes.
Verify
Section titled “Verify”- On the directory, open Test user and look up a user (or verify a password).
- Run Access › Test access for a user and check Step-by-step details.
- After a real sign-in, Monitor › Sign-in log shows the source in the entry, and the Computed attributes tab shows the aliases.
Troubleshooting
Section titled “Troubleshooting”| Symptom | Cause | Fix |
|---|---|---|
| Saving asks to Re-enter the stored secrets | You changed the server or weakened verification; stored secrets are never sent to a new or less verified server. | Type the secrets again and select Apply and save. |
| A type card shows Driver not installed | This Airgate deployment has no driver for the type. | Use another type, or contact Airowire support. |
| Sign-in log: Airgate couldn’t reach the directory | Timeout or connection error. | Test connection; raise Server timeout (s); add backup servers. |
| Sign-in log: No account named “…” | The Authentication filter returned nothing, or a RADIUS server rejected the user with Treat Access-Reject as unknown user on. |
Check the filter in Test user. |
| PEAP fails with an SQL or LDAP directory | No NT hash or clear-text password is returned. | Return Password_Ntlm_Hash (SQL) or set Password attribute (LDAP). |