3 CASSANDRA_USER=asdc_user
4 CASSANDRA_PASS='Aa1234%^!'
6 KEYSPACE="CREATE KEYSPACE IF NOT EXISTS dox WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', '<%= @DC_NAME %>': '1'};"
7 KEYSPACE1="CREATE KEYSPACE IF NOT EXISTS zusammen_dox WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', '<%= @DC_NAME %>': '1'};"
9 echo "run create_dox_keyspace.cql"
10 echo -e "$KEYSPACE\n$KEYSPACE1" > /tmp/create_dox_keyspace.cql
12 chmod 755 /tmp/create_dox_keyspace.cql
13 cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS -f /tmp/create_dox_keyspace.cql > /dev/null 2>&1
16 res=`echo "select keyspace_name from system.schema_keyspaces ;" | cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS |grep -c dox 2>/dev/null`
18 if [ $res -gt 0 ]; then
19 echo "`date` --- dox keyspace was created "
21 echo "`date` --- Failed to create dox keyspace"
25 echo "run create_dox_db.cql"
26 chmod 755 /tmp/create_dox_db.cql
27 cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS -f /tmp/create_dox_db.cql > /dev/null 2>&1
31 echo "run alter_dox_db.cql"
32 chmod 755 /tmp/alter_dox_db.cql
33 cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS -f /tmp/alter_dox_db.cql > /dev/null 2>&1