[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.

Welcome to the Slackware Documentation Project

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
howtos:network_services:postfix_dovecot_mysql:database [2015/02/15 22:05 (UTC)] – astrogeekhowtos:network_services:postfix_dovecot_mysql:database [2015/02/16 21:09 (UTC)] – astrogeek
Line 1: Line 1:
 ===== Virtual Mail Server Database ===== ===== Virtual Mail Server Database =====
-<note important>This article is under construction and not complete! Please return later...</note> 
  
 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 5:
 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 and sigfile from a repo, verify it, then install it:
 <code> <code>
 # For 32 bit package # # For 32 bit package #
 wget http://slackware.osuosl.org/slackware-14.1/patches/packages/mariadb-5.5.40-i486-2_slack14.1.txz wget http://slackware.osuosl.org/slackware-14.1/patches/packages/mariadb-5.5.40-i486-2_slack14.1.txz
 +wget http://slackware.osuosl.org/slackware-14.1/patches/packages/mariadb-5.5.40-i486-2_slack14.1.txz.asc
 # For 64 bit package # # For 64 bit package #
 wget http://slackware.osuosl.org/slackware64-14.1/patches/packages/mariadb-5.5.40-x86_64-2_slack14.1.txz wget http://slackware.osuosl.org/slackware64-14.1/patches/packages/mariadb-5.5.40-x86_64-2_slack14.1.txz
-gpg --verify mariadb-5.5.40...txz {path to your downloaded package}+wget http://slackware.osuosl.org/slackware64-14.1/patches/packages/mariadb-5.5.40-x86_64-2_slack14.1.txz.asc 
 +gpg --verify mariadb-5.5.40...txz.asc {path to your downloaded package sigfile}
 installpkg mariadb-5.5.40...txz installpkg mariadb-5.5.40...txz
 </code> </code>
Line 114: Line 115:
 </code> </code>
  
-To reset the password for an email user:+To reset the password for an email user, substitute the new password and email values into this query:
 <code>mysql> UPDATE virtual_users SET <code>mysql> UPDATE virtual_users SET
 password=ENCRYPT('new-password', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))) password=ENCRYPT('new-password', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16)))

Trace:

howtos:network_services:postfix_dovecot_mysql:database ()