iRedMail-1.3.1/tools/create_mail_user_SQL.sh

126 lines

-4 Removals

126 lines

+6 Additions

#!/usr/bin/env bash

# Author: Zhang Huangbin (zhb _at_ iredmail.org)

# Purpose: Import users to SQL database from plain text file.

# Project: iRedMail (http://www.iredmail.org/)

# -------------------------------------------------------------------

# Usage:

# * Edit these variables:

# STORAGE_BASE_DIRECTORY

# DEFAULT_QUOTA='1024' # 1024 is 1GB

# * Run this script to generate SQL command used to create new user.

# bash create_mail_user_SQL.sh <new-email> <plain-password>

# For example:

# bash create_mail_user_SQL.sh user@domain.ltd plain_password

# bash create_mail_user_SQL.sh user@domain.ltd plain_password mail_quota

# It will print SQL commands on console directly, you can redirect the

# output to a file for further use like this:

# bash create_mail_user_SQL.sh user@domain.ltd plain_password > output.sql

# bash create_mail_user_SQL.sh user@domain.ltd plain_password mail_quota > output.sql

# * Import output.sql into SQL database like below:

# # mysql -uroot -p

# mysql> USE vmail;

# mysql> SOURCE /path/to/output.sql;

# # psql -d vmail

# sql> \i /path/to/output.sql;

# --------- CHANGE THESE VALUES ----------

# Storage base directory used to store users' mail.

STORAGE_BASE_DIRECTORY="/var/vmail/vmail1"

###########

# Password

# Password scheme. Available schemes: BCRYPT, SSHA512, SSHA, PLAIN.

# Check file Available

PASSWORD_SCHEME='SSHA512'

# Default mail quota (in MB).

DEFAULT_QUOTA='1024'

DEFAULT_QUOTA=$3

# Maildir settings

# Maildir style: hashed, normal.

# Hashed maildir style, so that there won't be many large directories

# in your mail storage file system. Better performance in large scale

# deployment.

# Format: e.g. username@domain.td

# hashed -> domain.ltd/u/us/use/username/

# normal -> domain.ltd/username/

# Default hash level is 3.

MAILDIR_STYLE='hashed' # hashed, normal.

if [ X"$#" != X'2' ]; then

if [ X"$#" != X'3' ]; then

echo "Invalid command arguments. Usage:"

echo "bash create_mail_user_SQL.sh user@domain.ltd plain_password"

echo "bash create_mail_user_SQL.sh user@domain.ltd plain_password mail_quota"

exit 255

# Time stamp, will be appended in maildir.

DATE="$(date +%Y.%m.%d.%H.%M.%S)"

WC_L='wc -L'

if [ X"$(uname -s)" == X'OpenBSD' ]; then

WC_L='wc -l'

STORAGE_BASE="$(dirname ${STORAGE_BASE_DIRECTORY})"

STORAGE_NODE="$(basename ${STORAGE_BASE_DIRECTORY})"

generate_password_hash()

{

# Usage: generate_password_hash <password-scheme> <plain-password>

_scheme="${1}"

_password="${2}"

if [ X"${_scheme}" == X'BCRYPT' ]; then

_scheme='BLF-CRYPT'

doveadm pw -s "${_scheme}" -p "${_password}"

}

# Read input

mail="$1"

plain_password="$2"

username="$(echo $mail | awk -F'@' '{print $1}')"

domain="$(echo $mail | awk -F'@' '{print $2}')"

# Cyrpt default password.

export CRYPT_PASSWD="$(generate_password_hash ${PASSWORD_SCHEME} ${plain_password})"

# Different maildir style: hashed, normal.

if [ X"${MAILDIR_STYLE}" == X"hashed" ]; then

length="$(echo ${username} | ${WC_L} )"

str1="$(echo ${username} | cut -c1)"

str2="$(echo ${username} | cut -c2)"

str3="$(echo ${username} | cut -c3)"

test -z "${str2}" && str2="${str1}"

test -z "${str3}" && str3="${str2}"

# Use mbox, will be changed later.

maildir="${domain}/${str1}/${str2}/${str3}/${username}-${DATE}/"

else

maildir="${domain}/${username}-${DATE}/"

cat <<EOF

INSERT INTO mailbox (username, password, name,

storagebasedirectory,storagenode, maildir,

quota, domain, active, passwordlastchange, created)

VALUES ('${mail}', '${CRYPT_PASSWD}', '${username}',

VALUES ('${mail}', '${CRYPT_PASSWD}', "$(echo ${username} | awk '{print toupper(substr($0,0,1))tolower(substr($0,2))}')",

'${STORAGE_BASE}','${STORAGE_NODE}', '${maildir}',

'${DEFAULT_QUOTA}', '${domain}', '1', NOW(), NOW());

INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_forwarding)

VALUES ('${mail}', '${mail}','${domain}', '${domain}', 1);

EOF

Original Text

#!/usr/bin/env bash

# Author:   Zhang Huangbin (zhb _at_ iredmail.org)
# Purpose:  Import users to SQL database from plain text file.
# Project:  iRedMail (http://www.iredmail.org/)

# -------------------------------------------------------------------
# Usage:
#   * Edit these variables:
#       STORAGE_BASE_DIRECTORY
#       DEFAULT_QUOTA='1024'   # 1024 is 1GB
#
#   * Run this script to generate SQL command used to create new user.
#
#       bash create_mail_user_SQL.sh <new-email> <plain-password>
#
#     For example:
#
#       bash create_mail_user_SQL.sh user@domain.ltd plain_password
#
#     It will print SQL commands on console directly, you can redirect the
#     output to a file for further use like this:
#
#       bash create_mail_user_SQL.sh user@domain.ltd plain_password > output.sql
#
#   * Import output.sql into SQL database like below:
#
#       # mysql -uroot -p
#       mysql> USE vmail;
#       mysql> SOURCE /path/to/output.sql;
#
#       # psql -d vmail
#       sql> \i /path/to/output.sql;

# --------- CHANGE THESE VALUES ----------
# Storage base directory used to store users' mail.
STORAGE_BASE_DIRECTORY="/var/vmail/vmail1"

###########
# Password
#
# Password scheme. Available schemes: BCRYPT, SSHA512, SSHA, PLAIN.
# Check file Available
PASSWORD_SCHEME='SSHA512'

# Default mail quota (in MB).
DEFAULT_QUOTA='1024'

#
# Maildir settings
#
# Maildir style: hashed, normal.
# Hashed maildir style, so that there won't be many large directories
# in your mail storage file system. Better performance in large scale
# deployment.
# Format: e.g. username@domain.td
#   hashed  -> domain.ltd/u/us/use/username/
#   normal  -> domain.ltd/username/
# Default hash level is 3.
MAILDIR_STYLE='hashed'      # hashed, normal.

if [ X"$#" != X'2' ]; then
    echo "Invalid command arguments. Usage:"
    echo "bash create_mail_user_SQL.sh user@domain.ltd plain_password"
    exit 255
fi

# Time stamp, will be appended in maildir.
DATE="$(date +%Y.%m.%d.%H.%M.%S)"
WC_L='wc -L'
if [ X"$(uname -s)" == X'OpenBSD' ]; then
    WC_L='wc -l'
fi

STORAGE_BASE="$(dirname ${STORAGE_BASE_DIRECTORY})"
STORAGE_NODE="$(basename ${STORAGE_BASE_DIRECTORY})"

generate_password_hash()
{
    # Usage: generate_password_hash <password-scheme> <plain-password>
    _scheme="${1}"
    _password="${2}"

if [ X"${_scheme}" == X'BCRYPT' ]; then
        _scheme='BLF-CRYPT'
    fi

doveadm pw -s "${_scheme}" -p "${_password}"
}

# Read input
mail="$1"
plain_password="$2"

username="$(echo $mail | awk -F'@' '{print $1}')"
domain="$(echo $mail | awk -F'@' '{print $2}')"

# Cyrpt default password.
export CRYPT_PASSWD="$(generate_password_hash ${PASSWORD_SCHEME} ${plain_password})"

# Different maildir style: hashed, normal.
if [ X"${MAILDIR_STYLE}" == X"hashed" ]; then
    length="$(echo ${username} | ${WC_L} )"
    str1="$(echo ${username} | cut -c1)"
    str2="$(echo ${username} | cut -c2)"
    str3="$(echo ${username} | cut -c3)"

test -z "${str2}" && str2="${str1}"
    test -z "${str3}" && str3="${str2}"

# Use mbox, will be changed later.
    maildir="${domain}/${str1}/${str2}/${str3}/${username}-${DATE}/"
else
    maildir="${domain}/${username}-${DATE}/"
fi

cat <<EOF
INSERT INTO mailbox (username, password, name,
                     storagebasedirectory,storagenode, maildir,
                     quota, domain, active, passwordlastchange, created)
             VALUES ('${mail}', '${CRYPT_PASSWD}', '${username}',
                     '${STORAGE_BASE}','${STORAGE_NODE}', '${maildir}',
                     '${DEFAULT_QUOTA}', '${domain}', '1', NOW(), NOW());
INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_forwarding)
                 VALUES ('${mail}', '${mail}','${domain}', '${domain}', 1);
EOF

Changed Text

#!/usr/bin/env bash

# Author:   Zhang Huangbin (zhb _at_ iredmail.org)
# Purpose:  Import users to SQL database from plain text file.
# Project:  iRedMail (http://www.iredmail.org/)

# -------------------------------------------------------------------
# Usage:
#   * Edit these variables:
#       STORAGE_BASE_DIRECTORY
#       DEFAULT_QUOTA='1024'   # 1024 is 1GB
#
#   * Run this script to generate SQL command used to create new user.
#
#       bash create_mail_user_SQL.sh <new-email> <plain-password>
#
#     For example:
#
#       bash create_mail_user_SQL.sh user@domain.ltd plain_password mail_quota
#
#     It will print SQL commands on console directly, you can redirect the
#     output to a file for further use like this:
#
#       bash create_mail_user_SQL.sh user@domain.ltd plain_password mail_quota > output.sql
#
#   * Import output.sql into SQL database like below:
#
#       # mysql -uroot -p
#       mysql> USE vmail;
#       mysql> SOURCE /path/to/output.sql;
#
#       # psql -d vmail
#       sql> \i /path/to/output.sql;

# --------- CHANGE THESE VALUES ----------
# Storage base directory used to store users' mail.
STORAGE_BASE_DIRECTORY="/var/vmail/vmail1"

###########
# Password
#
# Password scheme. Available schemes: BCRYPT, SSHA512, SSHA, PLAIN.
# Check file Available
PASSWORD_SCHEME='SSHA512'

# Default mail quota (in MB).
DEFAULT_QUOTA=$3

if [ X"$#" != X'3' ]; then
    echo "Invalid command arguments. Usage:"
    echo "bash create_mail_user_SQL.sh user@domain.ltd plain_password mail_quota"
    exit 255
fi

# Time stamp, will be appended in maildir.
DATE="$(date +%Y.%m.%d.%H.%M.%S)"
WC_L='wc -L'
if [ X"$(uname -s)" == X'OpenBSD' ]; then
    WC_L='wc -l'
fi

STORAGE_BASE="$(dirname ${STORAGE_BASE_DIRECTORY})"
STORAGE_NODE="$(basename ${STORAGE_BASE_DIRECTORY})"

generate_password_hash()
{
    # Usage: generate_password_hash <password-scheme> <plain-password>
    _scheme="${1}"
    _password="${2}"

if [ X"${_scheme}" == X'BCRYPT' ]; then
        _scheme='BLF-CRYPT'
    fi

doveadm pw -s "${_scheme}" -p "${_password}"
}

# Read input
mail="$1"
plain_password="$2"

username="$(echo $mail | awk -F'@' '{print $1}')"
domain="$(echo $mail | awk -F'@' '{print $2}')"

# Cyrpt default password.
export CRYPT_PASSWD="$(generate_password_hash ${PASSWORD_SCHEME} ${plain_password})"

test -z "${str2}" && str2="${str1}"
    test -z "${str3}" && str3="${str2}"

# Use mbox, will be changed later.
    maildir="${domain}/${str1}/${str2}/${str3}/${username}-${DATE}/"
else
    maildir="${domain}/${username}-${DATE}/"
fi

cat <<EOF
INSERT INTO mailbox (username, password, name,
                     storagebasedirectory,storagenode, maildir,
                     quota, domain, active, passwordlastchange, created)
             VALUES ('${mail}', '${CRYPT_PASSWD}', "$(echo ${username} | awk '{print toupper(substr($0,0,1))tolower(substr($0,2))}')",
                     '${STORAGE_BASE}','${STORAGE_NODE}', '${maildir}',
                     '${DEFAULT_QUOTA}', '${domain}', '1', NOW(), NOW());
INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_forwarding)
                 VALUES ('${mail}', '${mail}','${domain}', '${domain}', 1);
EOF

Saved Diffs

Diff history

iRedMail-1.3.1/tools/create_mail_user_SQL.sh