| 1 | #!/usr/bin/env bash |
| 2 | set -euo pipefail |
| 3 | |
| 4 | PROXY_HOST="${PROXY_HOST:-proxysql}" |
| 5 | ADMIN_USER="${ADMIN_USER:-admin}" |
| 6 | ADMIN_PASS="${ADMIN_PASS:-admin}" |
| 7 | BACKEND_HOST="${BACKEND_HOST:-mysql}" |
| 8 | BACKEND_PORT="${BACKEND_PORT:-3306}" |
| 9 | |
| 10 | for i in $(seq 1 30); do |
| 11 | if mysql -h "$PROXY_HOST" -P 6032 -u "$ADMIN_USER" -p"$ADMIN_PASS" -e "SELECT 1" > /dev/null 2>&1; then |
| 12 | break |
| 13 | fi |
| 14 | sleep 2 |
| 15 | done |
| 16 | |
| 17 | mysql -h "$PROXY_HOST" -P 6032 -u "$ADMIN_USER" -p"$ADMIN_PASS" <<SQL |
| 18 | UPDATE global_variables SET variable_value='admin:admin;netdata:netdata' WHERE variable_name='admin-admin_credentials'; |
| 19 | UPDATE global_variables SET variable_value='0.0.0.0:6032' WHERE variable_name='admin-mysql_ifaces'; |
| 20 | LOAD ADMIN VARIABLES TO RUNTIME; |
| 21 | SAVE ADMIN VARIABLES TO DISK; |
| 22 | DELETE FROM mysql_servers; |
| 23 | INSERT INTO mysql_servers(hostgroup_id, hostname, port) VALUES (0, '$BACKEND_HOST', $BACKEND_PORT); |
| 24 | DELETE FROM mysql_users; |
| 25 | INSERT INTO mysql_users(username, password, default_hostgroup) VALUES ('netdata', 'netdata', 0); |
| 26 | LOAD MYSQL SERVERS TO RUNTIME; |
| 27 | SAVE MYSQL SERVERS TO DISK; |
| 28 | LOAD MYSQL USERS TO RUNTIME; |
| 29 | SAVE MYSQL USERS TO DISK; |
| 30 | SQL |
| 31 | |
| 32 | mysql -h "$PROXY_HOST" -P 6033 -u netdata -pnetdata <<SQL |
| 33 | CREATE DATABASE IF NOT EXISTS netdata; |
| 34 | CREATE TABLE IF NOT EXISTS netdata.t (id INT PRIMARY KEY, v VARCHAR(10)); |
| 35 | INSERT INTO netdata.t (id, v) VALUES (1, 'a') ON DUPLICATE KEY UPDATE v='a'; |
| 36 | INSERT INTO netdata.t (id, v) VALUES (2, 'b') ON DUPLICATE KEY UPDATE v='b'; |
| 37 | SELECT * FROM netdata.t WHERE id > 0; |
| 38 | SQL |
| 39 | |
| 40 | sleep 2 |