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.
48 lines
1.8 KiB
48 lines
1.8 KiB
#!/bin/bash
|
|
#
|
|
# Crea el usuario administrador en ViciDial: sapian / sap64adm
|
|
# Debe ejecutarse después de que la base de datos asterisk y la tabla vicidial_users existan.
|
|
#
|
|
# Uso: sudo ./create-admin-sapian.sh
|
|
#
|
|
|
|
set -e
|
|
|
|
# Conexión root: probar socket local primero, luego TCP
|
|
MYSQL_OPTS=""
|
|
if mariadb -u root -e "SELECT 1" >/dev/null 2>&1; then
|
|
MYSQL_OPTS="-u root"
|
|
elif mariadb -h 127.0.0.1 -u root -e "SELECT 1" >/dev/null 2>&1; then
|
|
MYSQL_OPTS="-h 127.0.0.1 -u root"
|
|
else
|
|
echo "No se pudo conectar a MariaDB como root (socket ni 127.0.0.1)."
|
|
exit 1
|
|
fi
|
|
DB="asterisk"
|
|
USER="sapian"
|
|
PASS="sap64adm"
|
|
FULL_NAME="Sapian Admin"
|
|
|
|
if [ "$EUID" -ne 0 ]; then
|
|
echo "Ejecutar como root."
|
|
exit 1
|
|
fi
|
|
|
|
if ! mariadb $MYSQL_OPTS -e "USE $DB" 2>/dev/null; then
|
|
echo "La base de datos $DB no existe o no hay acceso. Ejecutar después de la instalación Express."
|
|
exit 1
|
|
fi
|
|
|
|
# Crear usuario administrador (user_level 9 = admin). Si ya existe, actualizar contraseña.
|
|
mariadb $MYSQL_OPTS "$DB" << EOF
|
|
INSERT INTO vicidial_users (user, pass, full_name, user_level, user_group, load_leads, campaign_detail, ast_admin_access, modify_users, alter_agent_interface_options, view_reports, active)
|
|
VALUES ('$USER', '$PASS', '$FULL_NAME', '9', 'ADMIN', '1', '1', '1', '1', '1', '1', 'Y')
|
|
ON DUPLICATE KEY UPDATE pass = VALUES(pass), full_name = VALUES(full_name), user_level = 9, active = 'Y',
|
|
load_leads = '1', campaign_detail = '1', ast_admin_access = '1', modify_users = '1', alter_agent_interface_options = '1', view_reports = '1';
|
|
EOF
|
|
|
|
mariadb $MYSQL_OPTS "$DB" -e "UPDATE system_settings SET first_login_trigger='N' WHERE first_login_trigger='Y' LIMIT 1;" 2>/dev/null || true
|
|
|
|
echo "Usuario administrador creado/actualizado: $USER (password: $PASS)"
|
|
echo "Acceso: http://<IP>/vicidial/admin.php — iniciar sesión con $USER / $PASS"
|