[2025-jun-17] The SlackDocs mailing lists at https://lists.alienbase.nl/mailman/listinfo have been retired. No one has been using these lists for years and it's time to say goodbye. The list archives remain available at https://scalzi.slackware.nl/mailman/listinfo/slackdocs
[2025-jun-17] The SlackDocs Wiki has moved to a new server, in order to make it more performant.
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 09:44 (UTC)] – First complete version 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 5: | 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 55: | 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 145: | Line 155: | ||
For troubleshooting, | For troubleshooting, | ||
[[howtos: | [[howtos: | ||
+ | ====== Sources ====== | ||
+ | * Originally written by [[wiki: | ||
{{tag> | {{tag> |