NOTE: This page is a work in progress, and has not been tested. It may
or may not be of any use, may contain numerous errors, and may turn your
tongue a strange color. Use at your own risk.
First, install and configure MySQL (root user and password, access rules, firewall rules, etc) following the directions found on numerous web sites on the internet. This will be operating system dependent, and vary based on your needs.
Next, install Horde and IMP, following directions found elsewhere on this wiki. Specific instructions vary by operating system and your access to the system.
Then, install dovecot, following the instructions on http://wiki.dovecot.org/ and
configure dovecot to use MySQL as per the directions at http://wiki.dovecot.org/AuthDatabase/SQL
Now, configure IMP:
need to login once (Horde passes authentication data to IMP)
Now, configure Horde:
SELECT * FROM users WHERE userid = \L AND password = MD5(\P);
INSERT INTO users (domain,userid,password) VALUES ('example.org', \L, MD5(\P));
NB: Change the domain to your domain in the above query.
UPDATE users SET password = MD5(\P) WHERE userid = TRIM('@example.org' FROM \L) LIMIT 1;
NB: Change the domain to your domain in the above query.
DELETE FROM users WHERE userid = TRIM('@example.org' FROM \L) LIMIT 1;
SELECT * FROM users;
If you need to use multiple virtual domains, you might see the web page
http://wiki.vpslink.com/HOWTO:_ISP-style_Email_Server_with_Debian-Etch_and_Postfix_2.3
which could provide much inspiration for the sql database setup.