[2024-feb-29] Sad news: Eric Layton aka Nocturnal Slacker aka vtel57 passed away on Feb 26th, shortly after hospitalization. He was one of our Wiki's most prominent admins. He will be missed.
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
howtos:network_services:postfix_dovecot_mysql:database [2015/02/16 21:09 (UTC)] – astrogeek | howtos:network_services:postfix_dovecot_mysql:database [2015/06/11 14:42 (UTC)] (current) – [Creating Mail Database Tables] tim | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Virtual Mail Server Database ===== | + | ====== Virtual Mail Server Database ====== |
+ | |||
+ | This page is supplemental to main article: [[howtos: | ||
The database is used to provide configuration and authentication for your virtual mail domains and mail boxes. Email content is not stored in the database in this configuration. | The database is used to provide configuration and authentication for your virtual mail domains and mail boxes. Email content is not stored in the database in this configuration. | ||
Line 57: | Line 59: | ||
* virtual_users - Contains an entry for each virtual mail box served | * virtual_users - Contains an entry for each virtual mail box served | ||
* virtual_aliases - Maps aliases (source) to actual mail boxes (destination) | * virtual_aliases - Maps aliases (source) to actual mail boxes (destination) | ||
+ | to create these tables, type | ||
+ | < | ||
+ | |||
+ | mysql --user=" | ||
+ | mysql --user=" | ||
+ | </ | ||
==== Adding Domain Entries ==== | ==== Adding Domain Entries ==== | ||
To add entries to the virtual_domains table using the mysql client: | To add entries to the virtual_domains table using the mysql client: | ||
Line 147: | Line 155: | ||
For troubleshooting, | For troubleshooting, | ||
[[howtos: | [[howtos: | ||
+ | ====== Sources ====== | ||
+ | * Originally written by [[wiki: | ||
{{tag> | {{tag> |