> For the complete documentation index, see [llms.txt](https://playground.e107sk.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://playground.e107sk.com/alt-auth-plugin/admin-area/e107db.md).

# e107 database

**Configure e107 db auth** (`E107DB_LAN_10`) — `e107db_conf.php`

Authenticate against **a second e107 installation**. Typical use: several sites that should share one set of accounts, with one of them acting as the master.

Because the layout of an e107 user table is already known, you do not name the table or the columns — only the database and its table prefix.

Help text: *"This authentication method is to be used with a second E107 database, which may use a different password format to this system."* (`LAN_AUTHENTICATE_HELP`)

## Connection

| Field                  | LAN key        | Notes                                                                                                                                                                        |
| ---------------------- | -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Database type          | `LAN_ALT_26`   | *e107 format database* (`E107DB_LAN_1`).                                                                                                                                     |
| Server                 | `LAN_ALT_32`   | Host of the master site's MySQL server.                                                                                                                                      |
| Port                   | `LAN_ALT_80`   | Blank means 3306.                                                                                                                                                            |
| Username               | `LAN_ALT_33`   | Read-only database account is enough.                                                                                                                                        |
| Password               | `LAN_ALT_34`   |                                                                                                                                                                              |
| Database               | `LAN_ALT_35`   | The master site's database.                                                                                                                                                  |
| Table Prefix           | `LAN_ALT_39`   | e.g. `e107_`. This replaces "table + username field + password field".                                                                                                       |
| User class restriction | `LAN_ALT_76`   | Help: *Only users in this class (on the database set above) are permitted access*. A numeric user-class ID; zero or blank means everyone.                                    |
| Password Method        | `E107DB_LAN_9` | Only the two e107 formats are offered here: *MD5 (e107 original)* and *e107 salted (option 2.0 on)*. See [Password formats](/alt-auth-plugin/reference/password-formats.md). |

## Field transfer

For `e107db` the field table is a **checkbox per field** (`E107DB_LAN_11`: *Check the box against any field you wish to be transferred to the local database*) — column names are identical on both sides, so there is nothing to type.

Every user column is offered here, including the ones the other methods do not expose: **user id** (*"Use with caution"*), class membership, ban status, join date and custom title.

{% hint style="danger" %}
**User id** copies the remote `user_id` onto the local record. On an existing local user base this can collide with ids that are already in use. Only consider it on a fresh, empty site.
{% endhint %}

See [Field mapping](/alt-auth-plugin/reference/field-mapping.md).