Results

          Sleeping for 120 seconds before running cql
#############################################
############## Let run cql's ################
#############################################
Current Variables in play
Default User
DEF_USER=cassandra
DEF_PASS=***********
New User
USERNAME=nelson24
PASSWORD=***********
TIMEOUT=30
Running cqlsh --request-timeout=30 -u cassandra -p cassandra -e "describe keyspaces;" music-cassandra 9042;

system_traces  system_schema  system_auth  system  system_distributed

Cassandra user still avalable, will continue as usual
Running admin.cql file:
Running cqlsh -u cassandra -p cassandra -f /cql/admin.cql music-cassandra 9042

admin  system_schema  system_auth  system  system_distributed  system_traces

Success - admin.cql - Admin keyspace created
Running admin_pw.cql file:
Running cqlsh -u cassandra -p cassandra -f /cql/admin_pw.cql music-cassandra 9042
Success - admin_pw.cql - Password Changed
Running Test - look for admin keyspace:
Running cqlsh -u nelson24 -p nelson24 -e select bin boot cql dev docker-entrypoint.sh etc home lib lib64 media mnt opt proc root run runcql.sh sbin srv sys tmp usr var from system_auth.roles
/runcql.sh: line 77:  music-cassandra 9042: command not found
:1:Traceback (most recent call last):
  File "/usr/bin/cqlsh.py", line 1050, in perform_simple_statement
    result = future.result()
  File "/usr/share/cassandra/lib/cassandra-driver-internal-only-3.11.0-bb96859b.zip/cassandra-driver-3.11.0-bb96859b/cassandra/cluster.py", line 3925, in result
    raise self._final_exception
Unavailable: Error from server: code=1000 [Unavailable exception] message="Cannot achieve consistency level ONE" info={'required_replicas': 1, 'alive_replicas': 0, 'consistency': 'ONE'}

Failure - running test