3 SDNC_DB_USER=${SDNC_DB_USER:-sdnctl}
4 SDNC_DB_PASSWORD=${SDNC_DB_PASSWORD:-gamma}
5 SDNC_DB_DATABASE=${SDNC_DB_DATABASE:-sdnctl}
6 MYSQL_HOST=${MYSQL_HOST:-dbhost}
14 mysql --user=${SDNC_DB_USER} --password=${SDNC_DB_PASSWORD} --host=${MYSQL_HOST} ${SDNC_DB_DATABASE} <<EOF
15 INSERT INTO IPV4_ADDRESS_POOL VALUES('', '$universe', 'AVAILABLE', '${subnet}.${start}');
22 while [ $ip -le $stop ]
24 mysql --user=${SDNC_DB_USER} --password=${SDNC_DB_PASSWORD} --host=${MYSQL_HOST} ${SDNC_DB_DATABASE} <<EOF
25 INSERT INTO IPV4_ADDRESS_POOL VALUES('', '$universe', 'AVAILABLE','${subnet}.${ip}');
30 echo "Usage: $0 universe subnet start [stop]"