You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
933 lines
29 KiB
933 lines
29 KiB
#!/bin/bash
|
|
|
|
#===========================================================================#
|
|
# #
|
|
# Hestia Control Panel - Rebuild Function Library #
|
|
# #
|
|
#===========================================================================#
|
|
|
|
# User account rebuild
|
|
rebuild_user_conf() {
|
|
|
|
sanitize_config_file "user"
|
|
|
|
# Get user variables
|
|
source_conf "$USER_DATA/user.conf"
|
|
|
|
# Creating user data files
|
|
chmod 770 $USER_DATA
|
|
chmod 660 $USER_DATA/user.conf
|
|
touch $USER_DATA/backup.conf
|
|
chmod 660 $USER_DATA/backup.conf
|
|
touch $USER_DATA/history.log
|
|
chmod 660 $USER_DATA/history.log
|
|
touch $USER_DATA/stats.log
|
|
chmod 660 $USER_DATA/stats.log
|
|
|
|
# Update FNAME LNAME to NAME
|
|
if [ -z "$NAME" ]; then
|
|
NAME="$FNAME $LNAME"
|
|
if [ -z $FNAME ]; then NAME=""; fi
|
|
|
|
sed -i "s/FNAME='$FNAME'/NAME='$NAME'/g" $USER_DATA/user.conf
|
|
sed -i "/LNAME='$LNAME'/d" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${TWOFA+x}" ]; then
|
|
sed -i "/RKEY/a TWOFA=''" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${QRCODE+x}" ]; then
|
|
sed -i "/TWOFA/a QRCODE=''" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${PHPCLI+x}" ]; then
|
|
sed -i "/QRCODE/a PHPCLI=''" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${ROLE+x}" ]; then
|
|
sed -i "/PHPCLI/a ROLE='user'" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${THEME+x}" ]; then
|
|
sed -i "/LANGUAGE/a THEME=''" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${PREF_UI_SORT+x}" ]; then
|
|
sed -i "/NOTIFICATIONS/a PREF_UI_SORT='name'" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${LOGIN_DISABLED+x}" ]; then
|
|
sed -i "/PREF_UI_SORT/a LOGIN_DISABLED=''" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${LOGIN_USE_IPLIST+x}" ]; then
|
|
sed -i "/LOGIN_DISABLED/a LOGIN_USE_IPLIST=''" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${LOGIN_ALLOW_IPS+x}" ]; then
|
|
sed -i "/LOGIN_USE_IPLIST/a LOGIN_ALLOW_IPS=''" $USER_DATA/user.conf
|
|
fi
|
|
if [ -z "${RATE_LIMIT+x}" ]; then
|
|
sed -i "/MAIL_ACCOUNTS/a RATE_LIMIT='200'" $USER_DATA/user.conf
|
|
fi
|
|
# Run template trigger
|
|
if [ -x "$HESTIA/data/packages/$PACKAGE.sh" ]; then
|
|
$HESTIA/data/packages/$PACKAGE.sh "$user" "$CONTACT" "$NAME"
|
|
fi
|
|
|
|
# Rebuild user
|
|
shell=$(grep -w "$SHELL" /etc/shells | head -n1)
|
|
/usr/sbin/useradd "$user" -s "$shell" -c "$CONTACT" \
|
|
-m -d "$HOMEDIR/$user" > /dev/null 2>&1
|
|
|
|
# Add a general group for normal users created by Hestia
|
|
if [ -z "$(grep "^hestia-users:" /etc/group)" ]; then
|
|
groupadd --system "hestia-users"
|
|
fi
|
|
|
|
# Add membership to hestia-users group to non-admin users
|
|
if [ "$user" = "admin" ]; then
|
|
setfacl -m "g:admin:r-x" "$HOMEDIR/$user"
|
|
else
|
|
usermod -a -G "hestia-users" "$user"
|
|
setfacl -m "u:$user:r-x" "$HOMEDIR/$user"
|
|
fi
|
|
setfacl -m "g:hestia-users:---" "$HOMEDIR/$user"
|
|
|
|
# Update user shell
|
|
/usr/bin/chsh -s "$shell" "$user" &> /dev/null
|
|
|
|
# Update password
|
|
chmod u+w /etc/shadow
|
|
sed -i "s|^$user:[^:]*:|$user:$MD5:|" /etc/shadow
|
|
chmod u-w /etc/shadow
|
|
|
|
# Building directory tree
|
|
if [ -e "$HOMEDIR/$user/conf" ]; then
|
|
chattr -i $HOMEDIR/$user/conf > /dev/null 2>&1
|
|
fi
|
|
|
|
# Create default writeable folders
|
|
mkdir -p \
|
|
$HOMEDIR/$user/conf \
|
|
$HOMEDIR/$user/.config \
|
|
$HOMEDIR/$user/.cache \
|
|
$HOMEDIR/$user/.local \
|
|
$HOMEDIR/$user/.composer \
|
|
$HOMEDIR/$user/.vscode-server \
|
|
$HOMEDIR/$user/.ssh \
|
|
$HOMEDIR/$user/.npm
|
|
chmod a+x $HOMEDIR/$user
|
|
chmod a+x $HOMEDIR/$user/conf
|
|
chown --no-dereference $user:$user \
|
|
$HOMEDIR/$user \
|
|
$HOMEDIR/$user/.config \
|
|
$HOMEDIR/$user/.cache \
|
|
$HOMEDIR/$user/.local \
|
|
$HOMEDIR/$user/.composer \
|
|
$HOMEDIR/$user/.vscode-server \
|
|
$HOMEDIR/$user/.ssh \
|
|
$HOMEDIR/$user/.npm
|
|
chown root:root $HOMEDIR/$user/conf
|
|
|
|
$BIN/v-add-user-sftp-jail "$user"
|
|
|
|
# Update disk pipe
|
|
sed -i "/ $user$/d" $HESTIA/data/queue/disk.pipe
|
|
echo "$BIN/v-update-user-disk $user" >> $HESTIA/data/queue/disk.pipe
|
|
|
|
# WEB
|
|
if [ -n "$WEB_SYSTEM" ] && [ "$WEB_SYSTEM" != 'no' ]; then
|
|
mkdir -p $USER_DATA/ssl
|
|
chmod 770 $USER_DATA/ssl
|
|
touch $USER_DATA/web.conf
|
|
chmod 660 $USER_DATA/web.conf
|
|
if [ "$(grep -w $user $HESTIA/data/queue/traffic.pipe)" ]; then
|
|
echo "$BIN/v-update-web-domains-traff $user" \
|
|
>> $HESTIA/data/queue/traffic.pipe
|
|
fi
|
|
echo "$BIN/v-update-web-domains-disk $user" \
|
|
>> $HESTIA/data/queue/disk.pipe
|
|
|
|
if [[ -L "$HOMEDIR/$user/web" ]]; then
|
|
rm $HOMEDIR/$user/web
|
|
fi
|
|
mkdir -p $HOMEDIR/$user/conf/web/$domain
|
|
mkdir -p $HOMEDIR/$user/web
|
|
mkdir -p $HOMEDIR/$user/tmp
|
|
chmod 751 $HOMEDIR/$user/conf/web
|
|
chmod 751 $HOMEDIR/$user/web
|
|
chmod 771 $HOMEDIR/$user/tmp
|
|
chown --no-dereference $root:$user $HOMEDIR/$user/web
|
|
if [ "$create_user" = "yes" ]; then
|
|
$BIN/v-rebuild-web-domains $user $restart
|
|
fi
|
|
fi
|
|
|
|
# DNS
|
|
if [ -n "$DNS_SYSTEM" ] && [ "$DNS_SYSTEM" != 'no' ]; then
|
|
mkdir -p $USER_DATA/dns
|
|
chmod 770 $USER_DATA/dns
|
|
touch $USER_DATA/dns.conf
|
|
chmod 660 $USER_DATA/dns.conf
|
|
|
|
mkdir -p $HOMEDIR/$user/conf/dns
|
|
chmod 771 $HOMEDIR/$user/conf/dns
|
|
if [ "$DNS_SYSTEM" = 'named' ]; then
|
|
dns_group='named'
|
|
else
|
|
dns_group='bind'
|
|
fi
|
|
chown $dns_group:$dns_group $HOMEDIR/$user/conf/dns
|
|
if [ "$create_user" = "yes" ]; then
|
|
$BIN/v-rebuild-dns-domains $user $restart
|
|
fi
|
|
fi
|
|
|
|
if [ -n "$MAIL_SYSTEM" ] && [ "$MAIL_SYSTEM" != 'no' ]; then
|
|
mkdir -p $USER_DATA/mail
|
|
chmod 770 $USER_DATA/mail
|
|
touch $USER_DATA/mail.conf
|
|
chmod 660 $USER_DATA/mail.conf
|
|
echo "$BIN/v-update-mail-domains-disk $user" \
|
|
>> $HESTIA/data/queue/disk.pipe
|
|
|
|
if [[ -L "$HOMEDIR/$user/mail" ]]; then
|
|
rm $HOMEDIR/$user/mail
|
|
fi
|
|
mkdir -p $HOMEDIR/$user/conf/mail/$domain
|
|
mkdir -p $HOMEDIR/$user/mail
|
|
chmod 751 $HOMEDIR/$user/mail
|
|
chmod 751 $HOMEDIR/$user/conf/mail
|
|
if [ "$create_user" = "yes" ]; then
|
|
$BIN/v-rebuild-mail-domains $user
|
|
fi
|
|
fi
|
|
|
|
if [ -n "$DB_SYSTEM" ] && [ "$DB_SYSTEM" != 'no' ]; then
|
|
touch $USER_DATA/db.conf
|
|
chmod 660 $USER_DATA/db.conf
|
|
echo "$BIN/v-update-databases-disk $user" >> $HESTIA/data/queue/disk.pipe
|
|
|
|
if [ "$create_user" = "yes" ]; then
|
|
$BIN/v-rebuild-databases $user
|
|
fi
|
|
fi
|
|
|
|
if [ -n "$CRON_SYSTEM" ] && [ "$CRON_SYSTEM" != 'no' ]; then
|
|
touch $USER_DATA/cron.conf
|
|
chmod 660 $USER_DATA/cron.conf
|
|
|
|
if [ "$create_user" = "yes" ]; then
|
|
$BIN/v-rebuild-cron-jobs $user $restart
|
|
fi
|
|
fi
|
|
|
|
# Set immutable flag
|
|
chattr +i $HOMEDIR/$user/conf > /dev/null 2>&1
|
|
}
|
|
|
|
# WEB domain rebuild
|
|
rebuild_web_domain_conf() {
|
|
WWW_USER="www-data"
|
|
if [ -f /etc/redhat-release ]; then
|
|
WWW_USER="apache"
|
|
fi
|
|
|
|
if [ "$WEB_SYSTEM" = "httpd" ]; then
|
|
confd="conf.h.d"
|
|
else
|
|
confd="conf.d"
|
|
fi
|
|
if [ "$PROXY_SYSTEM" = "httpd" ]; then
|
|
pconfd="conf.h.d"
|
|
else
|
|
pconfd="conf.d"
|
|
fi
|
|
# Ensure that global domain folders are available
|
|
if [ ! -d /etc/$WEB_SYSTEM/$confd/domains ]; then
|
|
mkdir -p /etc/$WEB_SYSTEM/$confd/domains
|
|
fi
|
|
if [ ! -d /etc/$PROXY_SYSTEM/$pconfd/domains ]; then
|
|
mkdir -p /etc/$PROXY_SYSTEM/$pconfd/domains
|
|
fi
|
|
|
|
syshealth_repair_web_config
|
|
get_domain_values 'web'
|
|
is_ip_valid $IP
|
|
prepare_web_domain_values
|
|
|
|
# Remove old web configuration files
|
|
if [ -f /etc/$WEB_SYSTEM/$confd/$domain.conf ]; then
|
|
rm -f /etc/$WEB_SYSTEM/$confd/$domain*.conf
|
|
fi
|
|
if [ -f /etc/$PROXY_SYSTEM/$pconfd/$domain.conf ]; then
|
|
rm -f /etc/$PROXY_SYSTEM/$pconfd/$domain*.conf
|
|
fi
|
|
|
|
# Temporary allow write permissions to owner
|
|
[ -d "$HOMEDIR/$user/web/$domain" ] && chmod 751 "$HOMEDIR/$user/web/$domain"
|
|
|
|
# Rebuilding domain directories
|
|
if [ -d "$HOMEDIR/$user/web/$domain/document_errors" ]; then
|
|
if [ "$POLICY_SYNC_ERROR_DOCUMENTS" != "no" ]; then
|
|
$BIN/v-delete-fs-directory "$user" "$HOMEDIR/$user/web/$domain/document_errors"
|
|
fi
|
|
fi
|
|
|
|
if [ ! -d $HOMEDIR/$user/web/$domain ]; then
|
|
mkdir $HOMEDIR/$user/web/$domain
|
|
fi
|
|
chown --no-dereference $user:$user $HOMEDIR/$user/web/$domain
|
|
$BIN/v-add-fs-directory "$user" "$HOMEDIR/$user/web/$domain/public_html"
|
|
if [ ! -d "$HOMEDIR/$user/web/$domain/document_errors" ]; then
|
|
$BIN/v-add-fs-directory "$user" "$HOMEDIR/$user/web/$domain/document_errors"
|
|
# Propagating html skeleton
|
|
user_exec cp -r "$WEBTPL/skel/document_errors/" "$HOMEDIR/$user/web/$domain/"
|
|
fi
|
|
$BIN/v-add-fs-directory "$user" "$HOMEDIR/$user/web/$domain/cgi-bin"
|
|
$BIN/v-add-fs-directory "$user" "$HOMEDIR/$user/web/$domain/private"
|
|
$BIN/v-add-fs-directory "$user" "$HOMEDIR/$user/web/$domain/stats"
|
|
$BIN/v-add-fs-directory "$user" "$HOMEDIR/$user/web/$domain/logs"
|
|
|
|
# Creating domain logs
|
|
if [ ! -e "/var/log/$WEB_SYSTEM/domains" ]; then
|
|
mkdir -p /var/log/$WEB_SYSTEM/domains
|
|
chmod 771 /var/log/$WEB_SYSTEM/domains
|
|
fi
|
|
touch /var/log/$WEB_SYSTEM/domains/$domain.bytes \
|
|
/var/log/$WEB_SYSTEM/domains/$domain.log \
|
|
/var/log/$WEB_SYSTEM/domains/$domain.error.log
|
|
|
|
# Creating symlinks
|
|
cd $HOMEDIR/$user/web/$domain/logs/
|
|
ln -f -s /var/log/$WEB_SYSTEM/domains/$domain.log .
|
|
ln -f -s /var/log/$WEB_SYSTEM/domains/$domain.error.log .
|
|
cd /
|
|
|
|
# Set ownership
|
|
chown --no-dereference $user:$user \
|
|
$HOMEDIR/$user/web/$domain \
|
|
$HOMEDIR/$user/web/$domain/private \
|
|
$HOMEDIR/$user/web/$domain/cgi-bin \
|
|
$HOMEDIR/$user/web/$domain/public_*html
|
|
chown -R $user:$user $HOMEDIR/$user/web/$domain/document_errors
|
|
chown root:$user /var/log/$WEB_SYSTEM/domains/$domain.*
|
|
|
|
# Adding vhost configuration
|
|
conf="$HOMEDIR/$user/conf/web/$domain/$WEB_SYSTEM.conf"
|
|
add_web_config "$WEB_SYSTEM" "$TPL.tpl"
|
|
|
|
# Adding SSL vhost configuration
|
|
if [ "$SSL" = 'yes' ]; then
|
|
ssl_file_dir="$HOMEDIR/$user/conf/web/$domain/ssl"
|
|
conf="$HOMEDIR/$user/conf/web/$domain/$WEB_SYSTEM.ssl.conf"
|
|
if [ ! -d "$ssl_file_dir" ]; then
|
|
mkdir -p $ssl_file_dir
|
|
fi
|
|
add_web_config "$WEB_SYSTEM" "$TPL.stpl"
|
|
cp -f $USER_DATA/ssl/$domain.crt \
|
|
$HOMEDIR/$user/conf/web/$domain/ssl/$domain.crt
|
|
cp -f $USER_DATA/ssl/$domain.key \
|
|
$HOMEDIR/$user/conf/web/$domain/ssl/$domain.key
|
|
cp -f $USER_DATA/ssl/$domain.pem \
|
|
$HOMEDIR/$user/conf/web/$domain/ssl/$domain.pem
|
|
if [ -e "$USER_DATA/ssl/$domain.ca" ]; then
|
|
cp -f $USER_DATA/ssl/$domain.ca \
|
|
$HOMEDIR/$user/conf/web/$domain/ssl/$domain.ca
|
|
fi
|
|
fi
|
|
|
|
# Refresh HTTPS redirection if previously enabled
|
|
if [ "$SSL_FORCE" = 'yes' ]; then
|
|
$BIN/v-delete-web-domain-ssl-force $user $domain no yes
|
|
$BIN/v-add-web-domain-ssl-force $user $domain no yes
|
|
fi
|
|
|
|
if [ "$SSL_HSTS" = 'yes' ]; then
|
|
$BIN/v-delete-web-domain-ssl-hsts $user $domain no yes
|
|
$BIN/v-add-web-domain-ssl-hsts $user $domain no yes
|
|
fi
|
|
if [ "$FASTCGI_CACHE" = 'yes' ]; then
|
|
$BIN/v-delete-fastcgi-cache $user $domain
|
|
$BIN/v-add-fastcgi-cache $user $domain "$FASTCGI_DURATION"
|
|
fi
|
|
|
|
# Adding proxy configuration
|
|
if [ -n "$PROXY_SYSTEM" ] && [ -n "$PROXY" ]; then
|
|
conf="$HOMEDIR/$user/conf/web/$domain/$PROXY_SYSTEM.conf"
|
|
add_web_config "$PROXY_SYSTEM" "$PROXY.tpl"
|
|
if [ "$SSL" = 'yes' ]; then
|
|
conf="$HOMEDIR/$user/conf/web/$domain/$PROXY_SYSTEM.ssl.conf"
|
|
add_web_config "$PROXY_SYSTEM" "$PROXY.stpl"
|
|
fi
|
|
fi
|
|
|
|
# Adding web stats parser
|
|
if [ -n "$STATS" ]; then
|
|
domain_idn=$domain
|
|
format_domain_idn
|
|
cat $WEBTPL/$STATS/$STATS.tpl \
|
|
| sed -e "s|%ip%|$local_ip|g" \
|
|
-e "s|%web_system%|$WEB_SYSTEM|g" \
|
|
-e "s|%domain_idn%|$domain_idn|g" \
|
|
-e "s|%domain%|$domain|g" \
|
|
-e "s|%user%|$user|g" \
|
|
-e "s|%home%|$HOMEDIR|g" \
|
|
-e "s|%alias%|${aliases//,/ }|g" \
|
|
-e "s|%alias_idn%|${aliases_idn//,/ }|g" \
|
|
> $HOMEDIR/$user/conf/web/$domain/$STATS.conf
|
|
if [ "$STATS" == 'awstats' ]; then
|
|
if [ -e "/etc/awstats/$STATS.$domain_idn.conf" ]; then
|
|
rm -f "/etc/awstats/$STATS.$domain_idn.conf"
|
|
fi
|
|
ln -f -s $HOMEDIR/$user/conf/web/$domain/$STATS.conf \
|
|
/etc/awstats/$STATS.$domain_idn.conf
|
|
fi
|
|
|
|
webstats="$BIN/v-update-web-domain-stat $user $domain"
|
|
check_webstats=$(grep "$webstats" $HESTIA/data/queue/webstats.pipe)
|
|
if [ -z "$check_webstats" ]; then
|
|
echo "$webstats" >> $HESTIA/data/queue/webstats.pipe
|
|
fi
|
|
|
|
if [ -n "$STATS_USER" ]; then
|
|
stats_dir="$HOMEDIR/$user/web/$domain/stats"
|
|
if [ "$WEB_SYSTEM" = 'nginx' ]; then
|
|
echo "auth_basic \"Web Statistics\";" | user_exec tee $stats_dir/auth.conf > /dev/null
|
|
echo "auth_basic_user_file $stats_dir/.htpasswd;" | user_exec tee -a $stats_dir/auth.conf > /dev/null
|
|
else
|
|
echo "AuthUserFile $stats_dir/.htpasswd" | user_exec tee $stats_dir/.htaccess > /dev/null
|
|
echo "AuthName \"Web Statistics\"" | user_exec tee -a $stats_dir/.htaccess > /dev/null
|
|
echo "AuthType Basic" | user_exec tee -a $stats_dir/.htaccess > /dev/null
|
|
echo "Require valid-user" | user_exec tee -a $stats_dir/.htaccess > /dev/null
|
|
fi
|
|
echo "$STATS_USER:$STATS_CRYPT" | user_exec tee $stats_dir/.htpasswd > /dev/null
|
|
fi
|
|
fi
|
|
|
|
# Adding ftp users
|
|
if [ -z "$FTP_SHELL" ]; then
|
|
shell=$(which nologin)
|
|
if [ -e "/usr/bin/rssh" ]; then
|
|
shell='/usr/bin/rssh'
|
|
fi
|
|
else
|
|
shell=$FTP_SHELL
|
|
fi
|
|
for ftp_user in ${FTP_USER//:/ }; do
|
|
if [ -z "$(grep ^$ftp_user: /etc/passwd)" ]; then
|
|
position=$(echo $FTP_USER | tr ':' '\n' | grep -n '' \
|
|
| grep ":$ftp_user$" | cut -f 1 -d:)
|
|
ftp_path=$(echo $FTP_PATH | tr ':' '\n' | grep -n '' \
|
|
| grep "^$position:" | cut -f 2 -d :)
|
|
ftp_md5=$(echo $FTP_MD5 | tr ':' '\n' | grep -n '' \
|
|
| grep "^$position:" | cut -f 2 -d :)
|
|
# rebuild S/FTP users
|
|
$BIN/v-delete-web-domain-ftp "$user" "$domain" "$ftp_user"
|
|
# Generate temporary password to add user but update afterwards
|
|
temp_password=$(generate_password)
|
|
$BIN/v-add-web-domain-ftp "$user" "$domain" "${ftp_user#*_}" "$temp_password" "$ftp_path"
|
|
# Updating ftp user password
|
|
chmod u+w /etc/shadow
|
|
sed -i "s|^$ftp_user:[^:]*:|$ftp_user:$ftp_md5:|" /etc/shadow
|
|
chmod u-w /etc/shadow
|
|
#Update web.conf for next rebuild or move
|
|
update_object_value 'web' 'DOMAIN' "$domain" '$FTP_MD5' "$ftp_md5"
|
|
fi
|
|
done
|
|
|
|
# Adding http auth protection
|
|
htaccess="$HOMEDIR/$user/conf/web/$domain/htaccess"
|
|
htpasswd="$HOMEDIR/$user/conf/web/$domain/htpasswd"
|
|
docroot="$HOMEDIR/$user/web/$domain/public_html"
|
|
for auth_user in ${AUTH_USER//:/ }; do
|
|
# Parsing auth user variables
|
|
position=$(echo $AUTH_USER | tr ':' '\n' | grep -n '' \
|
|
| grep ":$auth_user$" | cut -f 1 -d:)
|
|
auth_hash=$(echo $AUTH_HASH | tr ':' '\n' | grep -n '' \
|
|
| grep "^$position:" | cut -f 2 -d :)
|
|
|
|
# Adding http auth user
|
|
touch $htpasswd
|
|
sed -i "/^$auth_user:/d" $htpasswd
|
|
echo "$auth_user:$auth_hash" >> $htpasswd
|
|
|
|
# Adding htaccess password protection
|
|
if [ "$WEB_SYSTEM" = "nginx" ] || [ "$PROXY_SYSTEM" = "nginx" ]; then
|
|
htaccess="$HOMEDIR/$user/conf/web/$domain/nginx.conf_htaccess"
|
|
shtaccess="$HOMEDIR/$user/conf/web/$domain/nginx.ssl.conf_htaccess"
|
|
if [ ! -f "$htaccess" ]; then
|
|
echo "auth_basic \"$domain password access\";" > $htaccess
|
|
echo "auth_basic_user_file $htpasswd;" >> $htaccess
|
|
ln -s $htaccess $shtaccess
|
|
restart_required='yes'
|
|
fi
|
|
else
|
|
htaccess="$HOMEDIR/$user/conf/web/$domain/apache2.conf_htaccess"
|
|
shtaccess="$HOMEDIR/$user/conf/web/$domain/apache2.ssl.conf_htaccess"
|
|
if [ ! -f "$htaccess" ]; then
|
|
echo "<Directory $docroot>" > $htaccess
|
|
echo " AuthUserFile $htpasswd" >> $htaccess
|
|
echo " AuthName \"$domain access\"" >> $htaccess
|
|
echo " AuthType Basic" >> $htaccess
|
|
echo " Require valid-user" >> $htaccess
|
|
echo "</Directory>" >> $htaccess
|
|
ln -s $htaccess $shtaccess
|
|
restart_required='yes'
|
|
fi
|
|
fi
|
|
chmod 644 $htpasswd $htaccess
|
|
chgrp $user $htpasswd $htaccess
|
|
done
|
|
|
|
# Set folder permissions
|
|
no_symlink_chmod 551 $HOMEDIR/$user/web/$domain \
|
|
$HOMEDIR/$user/web/$domain/stats \
|
|
$HOMEDIR/$user/web/$domain/logs
|
|
no_symlink_chmod 751 $HOMEDIR/$user/web/$domain/private \
|
|
$HOMEDIR/$user/web/$domain/cgi-bin \
|
|
$HOMEDIR/$user/web/$domain/public_*html \
|
|
$HOMEDIR/$user/web/$domain/document_errors
|
|
chmod 640 /var/log/$WEB_SYSTEM/domains/$domain.*
|
|
|
|
chown --no-dereference $user:$WWW_USER $HOMEDIR/$user/web/$domain/public_*html
|
|
}
|
|
# DNS domain rebuild
|
|
rebuild_dns_domain_conf() {
|
|
|
|
# Get domain values
|
|
get_domain_values 'dns'
|
|
domain_idn=$(idn2 --quiet "$domain")
|
|
|
|
if [ "$SLAVE" != "yes" ]; then
|
|
# Checking zone file
|
|
if [ ! -e "$USER_DATA/dns/$domain.conf" ]; then
|
|
cat $DNSTPL/$TPL.tpl \
|
|
| sed -e "s/%ip%/$IP/g" \
|
|
-e "s/%domain_idn%/$domain_idn/g" \
|
|
-e "s/%domain%/$domain/g" \
|
|
-e "s/%ns1%/$ns1/g" \
|
|
-e "s/%ns2%/$ns2/g" \
|
|
-e "s/%ns3%/$ns3/g" \
|
|
-e "s/%ns4%/$ns4/g" \
|
|
-e "s/%time%/$TIME/g" \
|
|
-e "s/%date%/$DATE/g" > $USER_DATA/dns/$domain.conf
|
|
fi
|
|
|
|
# Sorting records
|
|
sort_dns_records
|
|
#Remove old sign files
|
|
rm -fr $HOMEDIR/$user/conf/dns/$domain.db.*
|
|
# Updating zone
|
|
update_domain_zone
|
|
|
|
# Set permissions
|
|
if [ "$DNS_SYSTEM" = 'named' ]; then
|
|
dns_group='named'
|
|
else
|
|
dns_group='bind'
|
|
fi
|
|
# Set file permissions
|
|
chmod 640 $HOMEDIR/$user/conf/dns/$domain.db
|
|
chown $root:$dns_group $HOMEDIR/$user/conf/dns/$domain.db
|
|
else
|
|
rm -fr $HOMEDIR/$user/conf/dns/$domain.db.*
|
|
chown $dns_group:$dns_group $HOMEDIR/$user/conf/dns/$domain.db
|
|
fi
|
|
|
|
# Get dns config path
|
|
if [ -e '/etc/named.conf' ]; then
|
|
dns_conf='/etc/named.conf'
|
|
fi
|
|
|
|
if [ -e '/etc/bind/named.conf' ]; then
|
|
dns_conf='/etc/bind/named.conf'
|
|
fi
|
|
|
|
# Bind config check
|
|
if [ "$SUSPENDED" = 'yes' ]; then
|
|
rm_string=$(grep -n /etc/namedb/$domain.db $dns_conf | cut -d : -f 1)
|
|
if [ -n "$rm_string" ]; then
|
|
sed -i "$rm_string d" $dns_conf
|
|
fi
|
|
suspended_dns=$((suspended_dns + 1))
|
|
else
|
|
sed -i "/dns\/$domain.db/d" $dns_conf
|
|
if [ "$SLAVE" = "yes" ]; then
|
|
named="zone \"$domain_idn\" in {type slave; masters { $MASTER; }; file"
|
|
named="$named \"$HOMEDIR/$user/conf/dns/$domain.db\";};"
|
|
echo "$named" >> $dns_conf
|
|
else
|
|
if [ "$DNSSEC" = "yes" ]; then
|
|
named="zone \"$domain_idn\" in {type master; dnssec-policy default; inline-signing yes; file"
|
|
named="$named \"$HOMEDIR/$user/conf/dns/$domain.db\";};"
|
|
echo "$named" >> $dns_conf
|
|
else
|
|
named="zone \"$domain_idn\" {type master; file"
|
|
named="$named \"$HOMEDIR/$user/conf/dns/$domain.db\";};"
|
|
echo "$named" >> $dns_conf
|
|
fi
|
|
fi
|
|
fi
|
|
user_domains=$((user_domains + 1))
|
|
records=$(wc -l $USER_DATA/dns/$domain.conf | cut -f 1 -d ' ')
|
|
user_records=$((user_records + records))
|
|
update_object_value 'dns' 'DOMAIN' "$domain" '$RECORDS' "$records"
|
|
|
|
# Load new config
|
|
/usr/sbin/rndc reconfig > /dev/null 2>&1
|
|
# Reload config
|
|
/usr/sbin/rndc reload $domain > /dev/null 2>&1
|
|
|
|
if [ "$DNSSEC" = "yes" ]; then
|
|
# Key consists always out of 5 digits when less is used they are "lost"
|
|
key=$(/usr/sbin/rndc dnssec -status $domain_idn | grep ^key: | cut -f2 -d' ' | numfmt --format='%05.0f' --invalid=ignore)
|
|
|
|
if [ ! -d "$USER_DATA/keys/" ]; then
|
|
mkdir -p $USER_DATA/keys/
|
|
fi
|
|
cp /var/cache/bind/K$domain_idn.+013+$key.* $USER_DATA/keys/
|
|
update_object_value 'dns' 'DOMAIN' "$domain" '$KEY' "$key"
|
|
fi
|
|
rndc notify $domain_idn > /dev/null 2>&1
|
|
}
|
|
|
|
# MAIL domain rebuild
|
|
rebuild_mail_domain_conf() {
|
|
syshealth_repair_mail_config
|
|
|
|
get_domain_values 'mail'
|
|
if [[ "$domain" = *[![:ascii:]]* ]]; then
|
|
domain_idn=$(idn2 --quiet $domain)
|
|
else
|
|
domain_idn=$domain
|
|
fi
|
|
|
|
# Inherit web domain local ip address
|
|
unset -v nat ip local_ip domain_ip
|
|
local domain_ip=$(get_object_value 'web' 'DOMAIN' "$domain" '$IP')
|
|
if [ -n "$domain_ip" ]; then
|
|
local local_ip=$(get_real_ip "$domain_ip")
|
|
is_ip_valid "$local_ip" "$user"
|
|
else
|
|
get_user_ip
|
|
fi
|
|
|
|
if [ "$SUSPENDED" = 'yes' ]; then
|
|
SUSPENDED_MAIL=$((SUSPENDED_MAIL + 1))
|
|
fi
|
|
|
|
if [ ! -d "$USER_DATA/mail" ]; then
|
|
rm -f $USER_DATA/mail
|
|
mkdir $USER_DATA/mail
|
|
fi
|
|
|
|
# Rebuilding exim config structure
|
|
if [[ "$MAIL_SYSTEM" =~ exim ]]; then
|
|
rm -f /etc/$MAIL_SYSTEM/domains/$domain_idn
|
|
mkdir -p $HOMEDIR/$user/conf/mail/$domain
|
|
ln -s $HOMEDIR/$user/conf/mail/$domain \
|
|
/etc/$MAIL_SYSTEM/domains/$domain_idn
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/accounts
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/aliases
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/antispam
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/reject_spam
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/antivirus
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/protection
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/passwd
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/fwd_only
|
|
rm -f $HOMEDIR/$user/conf/mail/$domain/ip
|
|
rm -fr $HOMEDIR/$user/conf/mail/$domain/limits
|
|
touch $HOMEDIR/$user/conf/mail/$domain/accounts
|
|
touch $HOMEDIR/$user/conf/mail/$domain/aliases
|
|
touch $HOMEDIR/$user/conf/mail/$domain/passwd
|
|
touch $HOMEDIR/$user/conf/mail/$domain/fwd_only
|
|
touch $HOMEDIR/$user/conf/mail/$domain/limits
|
|
|
|
# Setting outgoing ip address
|
|
if [ -n "$local_ip" ]; then
|
|
echo "$local_ip" > $HOMEDIR/$user/conf/mail/$domain/ip
|
|
fi
|
|
|
|
# Adding antispam protection
|
|
if [ "$ANTISPAM" = 'yes' ]; then
|
|
touch $HOMEDIR/$user/conf/mail/$domain/antispam
|
|
fi
|
|
|
|
# Adding antivirus protection
|
|
if [ "$ANTIVIRUS" = 'yes' ]; then
|
|
touch $HOMEDIR/$user/conf/mail/$domain/antivirus
|
|
fi
|
|
|
|
# Adding reject spam protection
|
|
if [ "$REJECT" = 'yes' ]; then
|
|
touch $HOMEDIR/$user/conf/mail/$domain/reject_spam
|
|
fi
|
|
|
|
# Adding dkim
|
|
if [ "$DKIM" = 'yes' ]; then
|
|
cp $USER_DATA/mail/$domain.pem \
|
|
$HOMEDIR/$user/conf/mail/$domain/dkim.pem
|
|
fi
|
|
|
|
# Rebuild SMTP Relay configuration
|
|
if [ "$U_SMTP_RELAY" = 'true' ]; then
|
|
$BIN/v-add-mail-domain-smtp-relay $user $domain "$U_SMTP_RELAY_HOST" "$U_SMTP_RELAY_USERNAME" "$U_SMTP_RELAY_PASSWORD" "$U_SMTP_RELAY_PORT"
|
|
fi
|
|
|
|
# Removing configuration files if domain is suspended
|
|
if [ "$SUSPENDED" = 'yes' ]; then
|
|
rm -f /etc/$MAIL_SYSTEM/domains/$domain_idn
|
|
rm -f /etc/dovecot/conf.d/domains/$domain_idn.conf
|
|
fi
|
|
|
|
# Adding mail directory
|
|
if [ ! -e $HOMEDIR/$user/mail/$domain_idn ]; then
|
|
mkdir "$HOMEDIR/$user/mail/$domain_idn"
|
|
fi
|
|
|
|
# Webamil client
|
|
if [ "$WEBMAIL" = '' ]; then
|
|
$BIN/v-add-mail-domain-webmail $user $domain 'roundcube' 'no'
|
|
fi
|
|
|
|
# Adding catchall email
|
|
dom_aliases=$HOMEDIR/$user/conf/mail/$domain/aliases
|
|
if [ -n "$CATCHALL" ]; then
|
|
echo "*@$domain_idn:$CATCHALL" >> $dom_aliases
|
|
fi
|
|
fi
|
|
|
|
# Rebuild domain accounts
|
|
accs=0
|
|
dom_disk=0
|
|
if [ -e "$USER_DATA/mail/$domain.conf" ]; then
|
|
accounts=$(search_objects "mail/$domain" 'SUSPENDED' "no" 'ACCOUNT')
|
|
else
|
|
accounts=''
|
|
fi
|
|
for account in $accounts; do
|
|
((++accs))
|
|
object=$(grep "ACCOUNT='$account'" $USER_DATA/mail/$domain.conf)
|
|
FWD_ONLY='no'
|
|
parse_object_kv_list "$object"
|
|
if [ "$SUSPENDED" = 'yes' ]; then
|
|
MD5='SUSPENDED'
|
|
fi
|
|
|
|
if [[ "$MAIL_SYSTEM" =~ exim ]]; then
|
|
if [ "$QUOTA" = 'unlimited' ]; then
|
|
QUOTA=0
|
|
fi
|
|
str="$account:$MD5:$user:mail::$HOMEDIR/$user:${QUOTA}:userdb_quota_rule=*:storage=${QUOTA}M"
|
|
echo $str >> $HOMEDIR/$user/conf/mail/$domain/passwd
|
|
userstr="$account:$account:$user:mail:$HOMEDIR/$user"
|
|
echo $userstr >> $HOMEDIR/$user/conf/mail/$domain/accounts
|
|
for malias in ${ALIAS//,/ }; do
|
|
echo "$malias@$domain_idn:$account@$domain_idn" >> $dom_aliases
|
|
done
|
|
if [ -n "$FWD" ]; then
|
|
echo "$account@$domain_idn:$FWD" >> $dom_aliases
|
|
fi
|
|
if [ "$FWD_ONLY" = 'yes' ]; then
|
|
echo "$account" >> $HOMEDIR/$user/conf/mail/$domain/fwd_only
|
|
fi
|
|
user_rate_limit=$(get_object_value 'mail' 'DOMAIN' "$domain" '$RATE_LIMIT')
|
|
if [ -n "$RATE_LIMIT" ]; then
|
|
#user value
|
|
sed -i "/^$account@$domain_idn:/ d" $HOMEDIR/$user/conf/mail/$domain/limits
|
|
echo "$account@$domain_idn:$RATE_LIMIT" >> $HOMEDIR/$user/conf/mail/$domain/limits
|
|
elif [ -n "$user_rate_limit" ]; then
|
|
#revert to account value
|
|
sed -i "/^$account@$domain_idn:/ d" $HOMEDIR/$user/conf/mail/$domain/limits
|
|
echo "$account@$domain_idn:$user_rate_limit" >> $HOMEDIR/$user/conf/mail/$domain/limits
|
|
else
|
|
#revert to system value
|
|
system=$(cat /etc/exim4/limit.conf)
|
|
sed -i "/^$account@$domain_idn:/ d" $HOMEDIR/$user/conf/mail/$domain/limits
|
|
echo "$account@$domain_idn:$system" >> $HOMEDIR/$user/conf/mail/$domain/limits
|
|
fi
|
|
fi
|
|
done
|
|
|
|
# Set permissions and ownership
|
|
if [[ "$MAIL_SYSTEM" =~ exim ]]; then
|
|
chmod 660 $USER_DATA/mail/$domain.*
|
|
chmod 771 $HOMEDIR/$user/conf/mail/$domain
|
|
chmod 660 $HOMEDIR/$user/conf/mail/$domain/*
|
|
chmod 771 /etc/$MAIL_SYSTEM/domains/$domain_idn
|
|
chmod 770 $HOMEDIR/$user/mail/$domain_idn
|
|
chown -R $MAIL_USER:mail $HOMEDIR/$user/conf/mail/$domain
|
|
if [ "$IMAP_SYSTEM" = "dovecot" ]; then
|
|
chown -R dovecot:mail $HOMEDIR/$user/conf/mail/$domain/passwd
|
|
fi
|
|
chown $MAIL_USER:mail $HOMEDIR/$user/conf/mail/$domain/accounts
|
|
chown $user:mail $HOMEDIR/$user/mail/$domain_idn
|
|
fi
|
|
|
|
# Add missing SSL configuration flags to existing domains
|
|
# for per-domain SSL migration
|
|
sslcheck=$(grep "DOMAIN='$domain'" $USER_DATA/mail.conf | grep SSL)
|
|
if [ -z "$sslcheck" ]; then
|
|
sed -i "s|$domain'|$domain' SSL='no' LETSENCRYPT='no'|g" $USER_DATA/mail.conf
|
|
fi
|
|
|
|
# Remove and recreate SSL configuration
|
|
if [ -f "$HOMEDIR/$user/conf/mail/$domain/ssl/$domain.crt" ]; then
|
|
del_mail_ssl_config
|
|
add_mail_ssl_config
|
|
update_object_value 'mail' 'DOMAIN' "$domain" '$SSL' "yes"
|
|
else
|
|
update_object_value 'mail' 'DOMAIN' "$domain" '$SSL' "no"
|
|
fi
|
|
|
|
dom_disk=0
|
|
for account in $(search_objects "mail/$domain" 'SUSPENDED' "no" 'ACCOUNT'); do
|
|
home_dir=$HOMEDIR/$user/mail/$domain/$account
|
|
if [ -e "$home_dir" ]; then
|
|
udisk=$(nice -n 19 du -shm $home_dir | cut -f 1)
|
|
else
|
|
udisk=0
|
|
fi
|
|
update_object_value "mail/$domain" 'ACCOUNT' "$account" '$U_DISK' "$udisk"
|
|
dom_disk=$((dom_disk + udisk))
|
|
done
|
|
|
|
update_object_value 'mail' 'DOMAIN' "$domain" '$ACCOUNTS' "$accs"
|
|
update_object_value 'mail' 'DOMAIN' "$domain" '$U_DISK' "$dom_disk"
|
|
|
|
# Update usage counters
|
|
U_MAIL_ACCOUNTS=$((U_MAIL_ACCOUNTS + accs))
|
|
U_MAIL_DOMAINS=$((U_MAIL_DOMAINS + 1))
|
|
recalc_user_disk_usage
|
|
}
|
|
|
|
# Rebuild MySQL
|
|
rebuild_mysql_database() {
|
|
mysql_connect $HOST
|
|
mysql_query "CREATE DATABASE \`$DB\` CHARACTER SET $CHARSET" > /dev/null
|
|
if [ "$mysql_fork" = "mysql" ]; then
|
|
# mysql
|
|
mysql_ver_sub=$(echo $mysql_ver | cut -d '.' -f1)
|
|
mysql_ver_sub_sub=$(echo $mysql_ver | cut -d '.' -f2)
|
|
if [ "$mysql_ver_sub" -ge 8 ] || { [ "$mysql_ver_sub" -eq 5 ] && [ "$mysql_ver_sub_sub" -ge 7 ]; }; then
|
|
# mysql >= 5.7
|
|
mysql_query "CREATE USER IF NOT EXISTS \`$DBUSER\`" > /dev/null
|
|
mysql_query "CREATE USER IF NOT EXISTS \`$DBUSER\`@localhost" > /dev/null
|
|
# mysql >= 8, with enabled Print identified with as hex feature
|
|
if [[ "$mysql_ver_sub" -ge 8 && "$MD5" =~ ^0x.* ]]; then
|
|
query="UPDATE mysql.user SET authentication_string=UNHEX('${MD5:2}')"
|
|
else
|
|
query="UPDATE mysql.user SET authentication_string='$MD5'"
|
|
fi
|
|
query="$query WHERE User='$DBUSER'"
|
|
else
|
|
# mysql < 5.7
|
|
query="UPDATE mysql.user SET Password='$MD5' WHERE User='$DBUSER'"
|
|
fi
|
|
else
|
|
# mariadb
|
|
mysql_ver_sub=$(echo $mysql_ver | cut -d '.' -f1)
|
|
mysql_ver_sub_sub=$(echo $mysql_ver | cut -d '.' -f2)
|
|
if [ "$mysql_ver_sub" -eq 5 ]; then
|
|
# mariadb = 5
|
|
mysql_query "CREATE USER \`$DBUSER\`" > /dev/null
|
|
mysql_query "CREATE USER \`$DBUSER\`@localhost" > /dev/null
|
|
query="UPDATE mysql.user SET Password='$MD5' WHERE User='$DBUSER'"
|
|
else
|
|
# mariadb = 10
|
|
mysql_query "CREATE USER IF NOT EXISTS \`$DBUSER\` IDENTIFIED BY PASSWORD '$MD5'" > /dev/null
|
|
mysql_query "CREATE USER IF NOT EXISTS \`$DBUSER\`@localhost IDENTIFIED BY PASSWORD '$MD5'" > /dev/null
|
|
if [ "$mysql_ver_sub_sub" -ge 4 ]; then
|
|
#mariadb >= 10.4
|
|
query="SET PASSWORD FOR '$DBUSER'@'%' = '$MD5';"
|
|
query2="SET PASSWORD FOR '$DBUSER'@'localhost' = '$MD5';"
|
|
else
|
|
#mariadb < 10.4
|
|
query="UPDATE mysql.user SET Password='$MD5' WHERE User='$DBUSER'"
|
|
fi
|
|
fi
|
|
fi
|
|
mysql_query "GRANT ALL ON \`$DB\`.* TO \`$DBUSER\`@\`%\`" > /dev/null
|
|
mysql_query "GRANT ALL ON \`$DB\`.* TO \`$DBUSER\`@localhost" > /dev/null
|
|
mysql_query "$query" > /dev/null
|
|
if [ ! -z "$query2" ]; then
|
|
mysql_query "$query2" > /dev/null
|
|
fi
|
|
mysql_query "FLUSH PRIVILEGES" > /dev/null
|
|
}
|
|
|
|
# Rebuild PostgreSQL
|
|
rebuild_pgsql_database() {
|
|
|
|
host_str=$(grep "HOST='$HOST'" $HESTIA/conf/pgsql.conf)
|
|
parse_object_kv_list "$host_str"
|
|
export PGPASSWORD="$PASSWORD"
|
|
if [ -z $HOST ] || [ -z $USER ] || [ -z $PASSWORD ] || [ -z $TPL ]; then
|
|
echo "Error: postgresql config parsing failed"
|
|
if [ -n "$SENDMAIL" ]; then
|
|
echo "Can't parse PostgreSQL config" | $SENDMAIL -s "$subj" $email
|
|
fi
|
|
log_event "$E_PARSING" "$ARGUMENTS"
|
|
exit "$E_PARSING"
|
|
fi
|
|
|
|
query='SELECT VERSION()'
|
|
psql -h $HOST -U $USER -c "$query" > /dev/null 2>&1
|
|
if [ '0' -ne "$?" ]; then
|
|
echo "Error: Connection failed"
|
|
if [ -n "$SENDMAIL" ]; then
|
|
echo "Database connection to PostgreSQL host $HOST failed" \
|
|
| $SENDMAIL -s "$subj" $email
|
|
fi
|
|
log_event "$E_CONNECT" "$ARGUMENTS"
|
|
exit "$E_CONNECT"
|
|
fi
|
|
|
|
query="CREATE ROLE $DBUSER"
|
|
psql -h $HOST -U $USER -c "$query" > /dev/null 2>&1
|
|
|
|
query="UPDATE pg_authid SET rolpassword='$MD5' WHERE rolname='$DBUSER'"
|
|
psql -h $HOST -U $USER -c "$query" > /dev/null 2>&1
|
|
|
|
query="CREATE DATABASE $DB OWNER $DBUSER"
|
|
if [ "$TPL" = 'template0' ]; then
|
|
query="$query ENCODING '$CHARSET' TEMPLATE $TPL"
|
|
else
|
|
query="$query TEMPLATE $TPL"
|
|
fi
|
|
psql -h $HOST -U $USER -c "$query" > /dev/null 2>&1
|
|
|
|
query="GRANT ALL PRIVILEGES ON DATABASE $DB TO $DBUSER"
|
|
psql -h $HOST -U $USER -c "$query" > /dev/null 2>&1
|
|
|
|
query="GRANT CONNECT ON DATABASE template1 to $DBUSER"
|
|
psql -h $HOST -U $USER -c "$query" > /dev/null 2>&1
|
|
}
|
|
|
|
# Import MySQL dump
|
|
import_mysql_database() {
|
|
|
|
host_str=$(grep "HOST='$HOST'" $HESTIA/conf/mysql.conf)
|
|
parse_object_kv_list "$host_str"
|
|
if [ -z $HOST ] || [ -z $USER ] || [ -z $PASSWORD ]; then
|
|
echo "Error: mysql config parsing failed"
|
|
log_event "$E_PARSING" "$ARGUMENTS"
|
|
exit "$E_PARSING"
|
|
fi
|
|
if [ -f '/usr/bin/mariadb' ]; then
|
|
mariadb -h $HOST -u $USER -p$PASSWORD $DB < $1 > /dev/null 2>&1
|
|
else
|
|
mysql -h $HOST -u $USER -p$PASSWORD $DB < $1 > /dev/null 2>&1
|
|
fi
|
|
|
|
}
|
|
|
|
# Import PostgreSQL dump
|
|
import_pgsql_database() {
|
|
|
|
host_str=$(grep "HOST='$HOST'" $HESTIA/conf/pgsql.conf)
|
|
parse_object_kv_list "$host_str"
|
|
export PGPASSWORD="$PASSWORD"
|
|
if [ -z $HOST ] || [ -z $USER ] || [ -z $PASSWORD ] || [ -z $TPL ]; then
|
|
echo "Error: postgresql config parsing failed"
|
|
log_event "$E_PARSING" "$ARGUMENTS"
|
|
exit "$E_PARSING"
|
|
fi
|
|
|
|
psql -h $HOST -U $USER $DB < $1 > /dev/null 2>&1
|
|
}
|