36 lines
1.3 KiB
Bash
Executable file
36 lines
1.3 KiB
Bash
Executable file
#!/bin/bash
|
|
#
|
|
# Author: Daulton
|
|
# Website: daulton.ca
|
|
# Purpose: Enables enablepop3,enablepop3secured,enablepop3tls in the mailbox table for a given user to be 1 (enabled) in iRedmail so to disable pop3.
|
|
# License: 2-clause BSD license
|
|
#
|
|
# bash enable-pop3-for-user.sh jeff@example.com
|
|
#
|
|
# This will print SQL commands on the console directly, you can redirect the
|
|
# output to a file for further use like this:
|
|
#
|
|
# bash enable-pop3-for-user.sh jeff@example.com > output.sql
|
|
#
|
|
# Import output.sql into SQL database like below:
|
|
#
|
|
# mysql -uroot -p
|
|
# mysql> USE vmail;
|
|
# mysql> SOURCE /path/to/output.sql;
|
|
#
|
|
# psql -U vmailadmin -d vmail
|
|
# sql> \i /path/to/output.sql;
|
|
|
|
# Read input
|
|
username="$1"
|
|
|
|
if [ "$1" == "-h" ] || [ "$1" == "--h" ] || [ "$1" == "/h" ] || [ $# -ne 1 ]; then
|
|
printf "Purpose: Enables enablepop3,enablepop3secured,enablepop3tls in the mailbox table for a given user to be 1 (enabled) in iRedmail so to disable pop3. \n"
|
|
printf "Usage: bash enable-pop3-for-user.sh jeff@example.com \n"
|
|
exit 0
|
|
fi
|
|
|
|
printf "UPDATE mailbox SET enablepop3 = '1' WHERE username = '$username' AND enablepop3 = '0';\n"
|
|
printf "UPDATE mailbox SET enablepop3secured = '1' WHERE username = '$username' AND enablepop3secured = '0';\n"
|
|
printf "UPDATE mailbox SET enablepop3tls = '1' WHERE username = '$username' AND enablepop3tls = '0';\n"
|