/usr/bin/apt-get install cyrus-imapd-2.2 cyrus-admin-2.2 mysql-client \
    libsasl2-modules-sql openssl apg

if [ -z "$MYSQL_HOST" ]; then
  MYSQL_HOST=localhost
fi

MYSQL_HOST=localhost
MYSQL_DB=CYRUS
MYSQL_USERNAME=cyrus
MYSQL_USERPWD=cyrus_password

/usr/bin/wget http://howto.landure.fr/gnu-linux/debian-4-0-etch/installer-le-serveur-imap-cyrus-sur-debian-4-0-etch/cyrus-schema.sql \
    --output-document=/tmp/cyrus-schema.sql
/bin/cat /tmp/cyrus-schema.sql | /usr/bin/mysql --user=$MYSQL_USERNAME --password=$MYSQL_USERPWD --host=$MYSQL_HOST $MYSQL_DB

/bin/chmod go+rx /etc/openssl/PRIVATE_KEYS
/bin/chown cyrus:mail /etc/openssl/PRIVATE_KEYS/imap_key.pem
/bin/chmod go-rwx /etc/openssl/PRIVATE_KEYS/imap_key.pem
/bin/chown Debian-exim:mail /etc/openssl/PRIVATE_KEYS/smtp_key.pem
/bin/chmod go-rwx /etc/openssl/PRIVATE_KEYS/smtp_key.pem

DEFAULT_DOMAIN=main-domain.com

ADMIN_USERNAME=cyrus
ADMIN_PASSWORD=`/usr/bin/apg -q -a  0 -n 1 -M NCL`

/bin/echo "L'administrateur de votre serveur IMAP a pour identifiant '$ADMIN_USERNAME' et pour mot de passe '$ADMIN_PASSWORD'."

/bin/echo "INSERT INTO domain(name) VALUES ('$DEFAULT_DOMAIN');
INSERT INTO user (domain_id, username, password, enabled, has_mailbox) VALUES (
  (SELECT id FROM domain WHERE name='$DEFAULT_DOMAIN'),
  '$ADMIN_USERNAME', '$ADMIN_PASSWORD', 1, 0);" \
    | /usr/bin/mysql --user=$MYSQL_USERNAME --password=$MYSQL_USERPWD --host=$MYSQL_HOST $MYSQL_DB

/usr/sbin/adduser cyrus sasl

/bin/sed -i -e 's/^\([ \t]*\)\(pop3[ \t]\{1\}.*\)$/\1#\2/' \
            -e 's/^\([ \t]*\)\(nntp[ \t]\{1\}.*\)$/\1#\2/' \
            -e 's/^\([ \t]*\)\(imaps[ \t]\{1\}.*\)$/\1#\2/' \
            -e 's/^\([ \t]*\)\(pop3s[ \t]\{1\}.*\)$/\1#\2/' \
            -e 's/^#*\([ \t]*\)#*\(imap[ \t]\{1\}.*imapd.*\)$/\1\2/' \
            -e 's/^#*\([ \t]*\)#*\(lmtp[ \t]\{1\}.*lmtpd.*\)$/\1\2/' \
            -e 's/^#*\([ \t]*\)#*\(lmtpunix[ \t]\{1\}.*lmtpd.*\)$/\1\2/' \
         /etc/cyrus.conf

/bin/sed -i -e 's/^\(.*lmtp[ \t]\{1\}.*cmd="\)[^"]*\(".*$\)/\1lmtpd -a\2/' \
         /etc/cyrus.conf

/bin/echo -e "lmtp\t\t2003/tcp\t\t\t# Cyrus IMAP lmtp" | /usr/bin/tee -a /etc/services

/bin/sed -i -e 's/^\(unixhierarchysep:\).*/\1 yes/' /etc/imapd.conf

/bin/sed -i -e "s/^[#]*\(admins:\).*/\1 $ADMIN_USERNAME/" \
            -e 's/^[#]*\(sasl_mech_list:\).*/\1 PLAIN DIGEST-MD5 CRAM-MD5/' \
            -e 's/^[#]*\(sasl_minimum_layer:\).*/\1 0/' \
            -e 's/^[#]*\(sasl_pwcheck_method:\).*/\1 auxprop/' \
            -e 's/^[#]*\(sasl_pwcheck_method:\).*/\1 auxprop/' \
            -e 's/^[#]*\(sasl_pwcheck_method:\).*/\1 auxprop/' \
            -e 's/^[#]*\(virtdomains:\).*/\1 userid/' \
            -e "s/^[#]*\(defaultdomain:\).*/\1 $DEFAULT_DOMAIN/" \
 /etc/imapd.conf

/bin/sed -i -e 's/^[#]*\(sasl_auxprop_plugin:\).*/\1 sql/' \
            -e "/^[#]*\(sasl_auxprop_plugin:\).*/a\\
sasl_sql_engine: mysql\\
sasl_sql_hostnames: $MYSQL_HOST\\
sasl_sql_user: $MYSQL_USERNAME\\
sasl_sql_passwd: $MYSQL_USERPWD\\
sasl_sql_database: $MYSQL_DB\\
sasl_sql_select: SELECT user.password AS userPassword FROM user JOIN domain ON (user.domain_id = domain.id) WHERE (domain.name='%r' OR ('%r' = 'cyrus' AND domain.name='$DEFAULT_DOMAIN')) AND user.username='%u' AND user.enabled=1;\\
sasl_sql_update: UPDATE user SET user.password = '%v' FROM domain WHERE user.username = '%u' AND user.domain_id = domain.id AND (domain.name='%r' OR ('%r' = 'cyrus' AND domain.name='$DEFAULT_DOMAIN')) AND user.enabled=1;" \
         /etc/imapd.conf

/bin/sed -i -e 's|^[#]*\(tls_cert_file:\).*|\1 /etc/openssl/CERTIFICATES/imap_cert.cert|' \
            -e 's|^[#]*\(tls_key_file:\).*|\1 /etc/openssl/PRIVATE_KEYS/imap_key.pem|' \
            -e 's|^[#]*\(allowplaintext:\).*|\1 no|' \
         /etc/imapd.conf

/etc/init.d/cyrus2.2 restart

/bin/sed -i -e 's/localhost:sieve/sieve/' /etc/cyrus.conf

/etc/init.d/cyrus2.2 restart

/usr/bin/wget http://howto.landure.fr/gnu-linux/debian-4-0-etch/installer-le-serveur-imap-cyrus-sur-debian-4-0-etch/cyrus_create_mailboxes \
    --output-document=/etc/cron.hourly/cyrus_create_mailboxes
/bin/sed -i -e "s/MSQL_HOST/$MYSQL_HOST/" \
            -e "s/MSQL_DB/$MYSQL_DB/" \
            -e "s/MSQL_USERNAME/$MYSQL_USERNAME/" \
            -e "s/MSQL_USERPWD/$MYSQL_USERPWD/" \
            -e "s/ADMIN_LOGIN/$ADMIN_USERNAME/" \
            -e "s/ADMIN_PWD/$ADMIN_PASSWORD/" \
         /etc/cron.hourly/cyrus_create_mailboxes
/bin/chmod 500 /etc/cron.hourly/cyrus_create_mailboxes

/bin/echo "
### main/02_exim4-config_mysql
#################################

# mysql auth
hide mysql_servers = $MYSQL_HOST/$MYSQL_DB/$MYSQL_USERNAME/$MYSQL_USERPWD

" | /usr/bin/tee /etc/exim4/conf.d/main/02_exim4-config_mysql

/usr/bin/wget http://howto.landure.fr/gnu-linux/debian-4-0-etch/installer-le-serveur-imap-cyrus-sur-debian-4-0-etch-et-5-0-lenny/02_exim4-config_mysql_queries \
    --output-document=/etc/exim4/conf.d/main/02_exim4-config_mysql_queries

/bin/echo "
### transport/30_exim4-config_cyrus_ltcp
#################################

# Use this if you want to to deliver to Cyrus mailboxes.
#
cyrus_ltcp:
  driver = smtp
  protocol = lmtp
  hosts = 127.0.0.1
  allow_localhost" \
    | /usr/bin/tee /etc/exim4/conf.d/transport/30_exim4-config_cyrus_ltcp

/usr/bin/wget http://howto.landure.fr/gnu-linux/debian-4-0-etch/installer-le-serveur-imap-cyrus-sur-debian-4-0-etch-et-5-0-lenny/010_exim4-config_cyrus_vdom \
    --output-document=/etc/exim4/conf.d/router/010_exim4-config_cyrus_vdom

/usr/bin/wget http://howto.landure.fr/gnu-linux/debian-4-0-etch/installer-le-serveur-imap-cyrus-sur-debian-4-0-etch/exim4_cyrus_mailbox_checks.conf \
    --output-document=/tmp/exim4_cyrus_mailbox_checks.conf
/bin/sed -i -e '/hosts[ \t]*=[ \t]*:/r /tmp/exim4_cyrus_mailbox_checks.conf' /etc/exim4/conf.d/acl/30_exim4-config_check_rcpt

/etc/init.d/exim4 restart

/usr/bin/apt-get install mailx

/bin/echo "test" | /usr/bin/mail -s "e-mail de test" username@domain.com

/bin/echo '
### main/02_exim4-config_tlscert
#################################

# ENABLING TLS
MAIN_TLS_ENABLE = true

# SSL private key
MAIN_TLS_PRIVATEKEY = /etc/openssl/PRIVATE_KEYS/smtp_key.pem

# SSL public key
MAIN_TLS_CERTIFICATE = /etc/openssl/CERTIFICATES/smtp_cert.cert

# Disabling certificate verification to avoid problems with some
# mail clients when using CACert (or self signed) certificates.
# Concerned mail clients : Outlook 2003, Mail for Mac OS X...
MAIN_TLS_VERIFY_CERTIFICATES = /dev/null
' | /usr/bin/tee /etc/exim4/conf.d/main/02_exim4-config_tlscert

/bin/echo '
### auth/10_exim4-config_mysql
#################################

plain_mysql:
 driver = plaintext
 public_name = PLAIN
 server_prompts = :

 server_condition = "${if and { \
                      {!eq{$2}{}} \
                      {!eq{$3}{}} \
                      {eq{$3}{${lookup mysql{MYSQL_Q_PASSWORD_PLAIN}{$value}fail}} }} {yes}{no}}"
 server_set_id = $2
 .ifndef AUTH_SERVER_ALLOW_NOTLS_PASSWORDS
   server_advertise_condition = ${if eq{$tls_cipher}{}{}{*}}
 .endif


login_mysql:
  driver = plaintext
  public_name = LOGIN
  server_prompts = "Username:: : Password::"
  server_condition = "${if and { \
                      {!eq{$1}{}} \
                      {!eq{$2}{}} \
                      {eq{$2}{${lookup mysql{MYSQL_Q_PASSWORD_LOGIN}{$value}fail}} }} {yes}{no}}"

  server_set_id = $1
  .ifndef AUTH_SERVER_ALLOW_NOTLS_PASSWORDS
    server_advertise_condition = ${if eq{$tls_cipher}{}{}{*}}
  .endif

' | /usr/bin/tee /etc/exim4/conf.d/auth/10_exim4-config_mysql

MAINDOM_IP=$(/sbin/ifconfig eth0 | /bin/grep "inet adr" | /bin/sed -e 's/^.*inet adr:\([^ ]*\) .*$/\1/')
/bin/sed -i -e "s|dc_local_interfaces=.*\$|dc_local_interfaces='127.0.0.1;${MAINDOM_IP}'|" \
         /etc/exim4/update-exim4.conf.conf

/usr/sbin/update-exim4.conf
/etc/init.d/exim4 restart

/bin/rm /var/spool/exim4/gnutls-params

/bin/echo '
### main/00_exim4-local_settings
#################################

# ENABLING RFC 4409
# see http://www.isi.edu/in-notes/rfc4409.txt
daemon_smtp_ports = smtp : submission

' | /usr/bin/tee /etc/exim4/conf.d/main/00_exim4-local_settings

/etc/init.d/exim4 restart

/bin/echo '
### main/00_exim4-local_settings
#################################

# ENABLING RFC 4409 and SSMTP
# see http://www.isi.edu/in-notes/rfc4409.txt
daemon_smtp_ports = smtp : submission : ssmtp

' | /usr/bin/tee /etc/exim4/conf.d/main/00_exim4-local_settings

/bin/echo '
### main/04_exim4-ssmtp
#################################

# ENABLING SSMTP
tls_on_connect_ports = 465

' | /usr/bin/tee /etc/exim4/conf.d/main/04_exim4-ssmtp

/etc/init.d/exim4 restart

/usr/bin/update-bm-folders add /var/spool/cyrus
/usr/bin/update-bm-folders add /var/spool/sieve
/usr/bin/update-bm-folders add /var/lib/cyrus

/bin/sed -i -e 's/^.*\(CYRUS_VERBOSE.*\)$/\1/g' /etc/default/cyrus2.2
/etc/init.d/cyrus2.2 restart

/usr/bin/tail -f /var/log/mail.log

/bin/sed -i -e 's/^\(CYRUS_VERBOSE.*\)$/#\1/g' /etc/default/cyrus2.2
/etc/init.d/cyrus2.2 restart

/bin/su cyrus -c "/usr/lib/cyrus/bin/reconstruct -r 'user/mon.email@domaine.fr'"

/bin/rm /var/lib/cyrus/domain/m/mon-domaine.fr/john^doe.seen
/etc/ini.d/cyrus2.2 restart

/usr/bin/apt-get install imapsync

/usr/bin/imapsync --syncinternaldates --subscribe \
    --host1 "imap.domain.com" --port1 993 --ssl1 --authmech1 PLAIN \
    --user1 "some-user" --password1 "some-password" \
    --host2 "localhost" --port2 143 --authmech2 CRAM-MD5 \
    --user2 "local-user" --password2 "local-password"

/usr/bin/apt-get install fetchmail

set daemon 300
set no bouncemail

poll pop.mail.yahoo.fr with protocol POP3
      user "my-user" there with password "my-password" is "my-imap-account@my-email-domain.com" fetchall

poll pop.free.fr with protocol POP3
      user "my-user" there with password "my-password" is "my-imap-account@my-email-domain.com" fetchall
      user "my-other-user" there with password "my-other-password" is "my-imap-account@my-email-domain.com" fetchall

/bin/sed -i -e 's/START_DAEMON=.*/START_DAEMON=yes/' /etc/default/fetchmail

/etc/init.d/fetchmail restart

CYRUS_ADMIN_USERNAME=$(/bin/grep "^CYRUS_ADMIN_USERNAME" /etc/cron.hourly/cyrus_create_mailboxes \
                       | /usr/bin/cut --characters=22-)
CYRUS_ADMIN_PASSWORD=$(/bin/grep "^CYRUS_ADMIN_PASSWORD" /etc/cron.hourly/cyrus_create_mailboxes \
                       | /usr/bin/cut --characters=22-)

/usr/bin/cyradm --server localhost \
            --user $CYRUS_ADMIN_USERNAME \
            --password $CYRUS_ADMIN_PASSWORD \
            --auth DIGEST-MD5

help

listmailbox

deletemailbox user/adresse.email@mon-domaine.com

setaclmailbox user/adresse.email@mon-domaine.com cyrus c
deletemailbox user/adresse.email@mon-domaine.com

exit