2 if [ $CASS_HOSTNAME ]; then
3 echo "#############################################"
4 echo "############## Let run cql's ################"
5 echo "#############################################"
6 echo "Current Variales in play"
8 echo "DEF_USER="$DEF_USER
9 echo "DEF_PASS=***********"
11 echo "USERNAME="$USERNAME
12 echo "PASSWORD=***********"
13 if cqlsh -u cassandra -p cassandra -e "describe keyspaces;";
15 >&2 echo "Cassandra user still avalable, will continue as usual";
17 if cqlsh -u $USERNAME -p $PASSWORD -e "describe keyspaces;";
19 >&2 echo "Password $USERNAME in play, update Variables"
22 if cqlsh -u $USERNAME -p $PASSWORD -e "describe keyspaces;" | grep admin1;
24 >&2 echo "Admin table exists, everything looks good"
27 >&2 echo "Admin does not exists but password has changed. Continue as usual with proper username set"
28 >&2 echo "DEF_USER=" $DEF_USER
31 >&2 echo "Continue and as usual"
34 echo "admin.cql file:"
36 >&2 echo "Running cqlsh -u $DEF_USER -p $DEF_PASS -f /cql/admin.cql ${CASS_HOSTNAME} ${PORT}"
38 if cqlsh -u $DEF_USER -p $DEF_PASS -f /cql/admin.cql ${CASS_HOSTNAME} ${PORT};
40 >&2 echo "Success - admin.cql - Admin keyspace created";
42 >&2 echo "Failure - admin.cql";
45 echo "admin_pw.cql file:"
47 >&2 echo "Running cqlsh -u $DEF_USER -p $DEF_PASS -f /cql/admin_pw.cql ${CASS_HOSTNAME} ${PORT}"
49 if cqlsh -u $DEF_USER -p $DEF_PASS -f /cql/admin_pw.cql ${CASS_HOSTNAME} ${PORT};
51 >&2 echo "Success - admin_pw.cql - Password Changed";
53 >&2 echo "Failure - admin_pw.cql";
57 for f in /cql/extra/*; do
60 echo "$0: running $f" && cqlsh -u ${USERNAME} -p ${PASSWORD} -f "$f" ${CASS_HOSTNAME} ${PORT};
63 echo "$0: ignoring $f"
68 >&2 echo "Missing CASS_HOSTNAME";