[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/15 22:07 (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 |
- | <note important> | + | |
+ | 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 6: | Line 7: | ||
If you have a full Slackware installation with MySQL already working then you may skip to the next section. | If you have a full Slackware installation with MySQL already working then you may skip to the next section. | ||
- | If you need to install MySQL (MariaDB) then grab the package from a repo, verify it, then install it: | + | If you need to install MySQL (MariaDB) then grab the package |
< | < | ||
# For 32 bit package # | # For 32 bit package # | ||
wget http:// | wget http:// | ||
+ | wget http:// | ||
# For 64 bit package # | # For 64 bit package # | ||
wget http:// | wget http:// | ||
- | gpg --verify mariadb-5.5.40...txz {path to your downloaded package} | + | wget http:// |
+ | gpg --verify mariadb-5.5.40...txz.asc {path to your downloaded package | ||
installpkg mariadb-5.5.40...txz | installpkg mariadb-5.5.40...txz | ||
</ | </ | ||
Line 56: | 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 146: | Line 155: | ||
For troubleshooting, | For troubleshooting, | ||
[[howtos: | [[howtos: | ||
+ | ====== Sources ====== | ||
+ | * Originally written by [[wiki: | ||
{{tag> | {{tag> |