| Line 30... |
Line 30... |
| 30 |
if [ $# -ne 1 ]
|
30 |
if [ $# -ne 1 ]
|
| 31 |
then
|
31 |
then
|
| 32 |
echo "A SQL query must be given." >&2
|
32 |
echo "A SQL query must be given." >&2
|
| 33 |
return 1
|
33 |
return 1
|
| 34 |
fi
|
34 |
fi
|
| 35 |
|
- |
|
| 36 |
# Execute the query
|
35 |
# Execute the query
|
| 37 |
/usr/bin/mariadb --user=root --password="$DB_ROOT_PWD" --execute="$1"
|
36 |
/usr/bin/mariadb --user=root --password="$DB_ROOT_PWD" --execute="$1"
|
| 38 |
}
|
37 |
}
|
| 39 |
|
38 |
|
| 40 |
if grep -q "REPLICATION=on" "$ALCASAR_CONF"
|
39 |
if grep -q "REPLICATION=on" "$ALCASAR_CONF"
|
| Line 55... |
Line 54... |
| 55 |
echo "db_replication=$REPL_DB_USER" >> "$PASSWD_FILE"
|
54 |
echo "db_replication=$REPL_DB_USER" >> "$PASSWD_FILE"
|
| 56 |
echo "db_replication_pwd=$REPL_DB_PWD" >> "$PASSWD_FILE"
|
55 |
echo "db_replication_pwd=$REPL_DB_PWD" >> "$PASSWD_FILE"
|
| 57 |
echo "Database replication user: $REPL_DB_USER"
|
56 |
echo "Database replication user: $REPL_DB_USER"
|
| 58 |
echo "Database replication password: $REPL_DB_PWD"
|
57 |
echo "Database replication password: $REPL_DB_PWD"
|
| 59 |
|
58 |
|
| 60 |
# Create local replication user
|
59 |
# Create local database replication user
|
| 61 |
echo "Creating '$REPL_DB_USER' user on database..."
|
60 |
echo "Creating '$REPL_DB_USER' user on database..."
|
| 62 |
exec_query "CREATE USER '$REPL_DB_USER'@'%' IDENTIFIED BY '$REPL_DB_PWD'" || exit
|
61 |
exec_query "CREATE USER '$REPL_DB_USER'@'%' IDENTIFIED BY '$REPL_DB_PWD'" || exit
|
| 63 |
echo "Granting '$REPL_DB_USER' user for replication..."
|
62 |
echo "Granting '$REPL_DB_USER' user for replication..."
|
| 64 |
exec_query "GRANT REPLICATION REPLICA ON *.* TO '$REPL_DB_USER'@'%'" || exit
|
63 |
exec_query "GRANT REPLICATION REPLICA ON *.* TO '$REPL_DB_USER'@'%'" || exit
|
| 65 |
exec_query "FLUSH PRIVILEGES" || exit
|
64 |
exec_query "FLUSH PRIVILEGES" || exit
|
| Line 102... |
Line 101... |
| 102 |
/usr/sbin/useradd -s /bin/sh -m "$REPL_USER"
|
101 |
/usr/sbin/useradd -s /bin/sh -m "$REPL_USER"
|
| 103 |
echo -e "$REPL_PWD\n$REPL_PWD" | passwd "$REPL_USER"
|
102 |
echo -e "$REPL_PWD\n$REPL_PWD" | passwd "$REPL_USER"
|
| 104 |
mkdir "/home/$REPL_USER/.ssh"
|
103 |
mkdir "/home/$REPL_USER/.ssh"
|
| 105 |
touch "/home/$REPL_USER/.ssh/authorized_keys"
|
104 |
touch "/home/$REPL_USER/.ssh/authorized_keys"
|
| 106 |
chown replication:replication -R "/home/$REPL_USER/.ssh"
|
105 |
chown replication:replication -R "/home/$REPL_USER/.ssh"
|
| - |
|
106 |
echo $REPL_DB_PWD > /home/$REPL_USER/db_replication_user_pass.txt
|
| - |
|
107 |
chown $REPL_USER:$REPL_USER /home/$REPL_USER/db_replication_user_pass.txt; chmod 400 /home/$REPL_USER/db_replication_user_pass.txt
|
| 107 |
|
108 |
|
| 108 |
# Generate user SSH key
|
109 |
# Generate user SSH key
|
| 109 |
if ! ls ~/.ssh/id_* &> /dev/null
|
110 |
if ! ls ~/.ssh/id_* &> /dev/null
|
| 110 |
then
|
111 |
then
|
| 111 |
echo "Generating SSH key..."
|
112 |
echo "Generating SSH key..."
|