~ibmcharmers/charms/trusty/layer-ibm-mobilefirst-server/devel

#!/bin/bash
set -ex

source charms.reactive.sh

ARCHITECTURE=`uname -m`
ARCHIVE_DIR=$CHARM_DIR/files/archives
DB2_ARCHIVE_DIR=`pwd`
DB2_USER=db2inst1
DB2_USER_PW=db2inst1
DB2_INSTALL_PATH=/opt/ibm/db2/V10.5
AUTH_KEY_FILE=/root/.ssh/authorized_keys

cfgusername=""

remoteunit=$cfgusername
cfgpasswd=""


#Get the cfguser name based on the remote unit name
get_cfgusername()
{
	usr="usr"
	passwd="123"
	db="db"
	cfgusername=$1
	cfgusername=`echo $cfgusername | cut -d"/" -f1`
	cfgusername=`echo "$cfgusername" | sed -r 's/-//g' | sed -r 's/ibm//g'`
	cfgusername=`echo "$cfgusername" | awk '{print substr($0,0,5)}'`
	remoteunit=$cfgusername
	cfgusername="$cfgusername$usr"
	cfgpasswd="$cfgusername$passwd"
	remoteunitdbname="$remoteunit$db"

}
# Check whether DB2 is installed
is_db2_installed()
{
	if [ -d $DB2_INSTALL_PATH/bin ]; then
		echo "True"
	else
		echo "False"
	fi
}


# Remove DB2, if installed
remove_software()
{
	db2_inst=`is_db2_installed`
	if  [ $db2_inst == True ]; then
		juju-log "IBM DB2: Removing IBM DB2 software."
		status-set maintenance "Removing IBM DB2"

		#finding the DB alias names to be dropped and dropping all Databases in that
		for queue1 in `su - $DB2_USER -c 'db2ilist'`;
		do
			juju-log "IBM DB2: Dropping the Databases for the instance $queue1"
			#if db2 is not running, we need to start it first, otherwise db2 drop command will fail
			if su - $queue1 -c 'ps -eaf|grep -i "\bdb2sysc 0\b" |grep -i '$queue1;
			then
				juju-log "IBM DB2: DB2 already started for the user $queue1"
			else
				su - $queue1 -c 'db2start'
				juju-log "IBM DB2: DB2 is started"
			fi

			for queue in `su - $queue1 -c 'db2 list db directory | grep "Database alias" | cut -d"=" -f2'`;
			do
				queue=`echo $queue | xargs`                     
				juju-log "IBM DB2: Dropping the DB $queue"
				su - $queue1 -c 'db2 drop database '$queue
				if [ $? == 0 ]; then
					juju-log "IBM DB2: Dropped the DB $queue"
				else
					juju-log "IBM DB2: Dropping the DB $queue failed"
					status-set blocked "Dropping the DB failed"
					exit 0
				fi
			done
			juju-log "IBM DB2: Stopping the DB for $queue1"

			if su - $queue1 -c 'ps -eaf|grep -i "\bdb2sysc 0\b" |grep -i '$queue1
			then
				su - $queue1 -c 'db2 force application all'
				su - $queue1 -c 'db2stop'
				if [ $? == 0 ]; then
					juju-log "IBM DB2: Stopped the DB for the instance $queue1"
				else
					juju-log "IBM DB2: Stopping the DB for $queue1 failed"
					status-set blocked "Stopping the DB for $queue1 failed"
					exit 0
				fi

			else
				juju-log "IBM DB2: DB2 is already stopped"
			fi
		done

		#drop the das
		cd $DB2_INSTALL_PATH/instance
		juju-log "IBM DB2: Dropping the DAS"
		./dasdrop
		if [ $? == 0 ]; then
			juju-log "IBM DB2: Dropped the DAS"
		else
			juju-log "IBM DB2: Dropping the DAS failed"
			status-set blocked "Dropping the DAS failed"
			exit 0
		fi

		#delete the instances
		su - $DB2_USER -c 'db2ilist'
		for queue1 in `su - $DB2_USER -c 'db2ilist'`;
		do
			juju-log "IBM DB2: Deleting the instance $queue1"
			/opt/ibm/db2/V10.5/instance/db2idrop $queue1
			if [ $? == 0 ]; then
				juju-log "IBM DB2: Deleted  the instance $queue1"
			else
				juju-log "IBM DB2: Deleting the instance $queue1 failed"
				status-set blocked "Deleting the instance $queue1 failed"
				exit 0
			fi

		done

		#Delete the instance entries from /etc/services file
		juju-log "IBM DB2: Deleting the entries from /etc/services"
		sed -i '/db2c_/d' /etc/services
		if [ $? == 0 ]; then
			juju-log "IBM DB2: Deleted the entries from /etc/services"
		else
			juju-log "IBM DB2: Deletion of the entries from /etc/services failed"
			status-set blocked "Deletion of the entries from /etc/services failed"
			exit 0
		fi

		#uninstall
		juju-log "IBM DB2: Uninstall "
		cd /opt/ibm/db2/V10.5/install
		set +e
		./db2_deinstall -a
		if [ $? == 0 ]; then
			juju-log "IBM DB2: Uninstall of db2 successful"
		else
			juju-log "IBM DB2: Uninstall of db2 failed"
			status-set blocked "IBM DB2 Uninstallation failed"
			exit 0
		fi
		set -e
		cd /opt/ibm
		rm -rf db2
		juju-log "IBM DB2: Finished Uninstalling......."
		status-set blocked "IBM DB2 Uninstalled"

	else
		juju-log "IBM DB2: DB2 not installed"
	fi

}

# Update system configuration after installing DB2
configure_system()
{
	juju-log "IBM DB2: Updating system configuration."
	cd $DB2_INSTALL_PATH/instance
	su - $DB2_USER -c 'db2set DB2COMM=tcpip'

	#Start DB for the DB2_user
	if su - $DB2_USER -c 'ps -eaf|grep -i "\bdb2sysc 0\b" |grep -i '$DB2_USER;
	then
		juju-log "IBM DB2: DB2 already started for the user $DB2_USER"
	else
		su - $DB2_USER -c 'db2start'
		juju-log "IBM DB2: DB2 is started"
	fi

	service_name=`su - $DB2_USER -c 'db2 get dbm cfg|grep -i svce|cut -d"=" -f2'`
	port_num=`grep $service_name /etc/services | cut -d"/" -f1 | cut -f2`
	port_num=`echo $port_num | xargs`
	if su - $DB2_USER -c 'netstat -an | grep '$port_num;
	then
		juju-log "IBM DB2: DB2 started on port $port_num"
	else
		juju-log "IBM DB2: DB2 not started on port $port_num"
		exit 1
	fi

	juju-log "IBM DB2: Updated system configuration."

}

#Configure dftdbpath
configure_dftdbpath()
{
	db2_inst=`is_db2_installed`
	if  [ $db2_inst == True ]; then	
		cfgdbpath=`config-get dftdbpath`
		#If null, assign the default value
		if [ "cfgdbpath" == "" ]
		then	
			cfgdbpath="/tmp"
		fi
		
		for queue1 in `su - $DB2_USER -c 'db2ilist'`;	
		do
			#if db2 is not running don't do anything
			if su - $queue1 -c 'ps -eaf|grep -i "\bdb2sysc 0\b" |grep -i '$queue1;
			then
				su - $queue1 -c 'db2 attach to '$queue1
				dbpath=`su - $queue1 -c 'db2 get dbm cfg|grep -i DFTDBPATH|cut -d"=" -f2'`
				cfgdbpath=`echo $cfgdbpath | xargs`
				dbpath=`echo $dbpath | xargs`
				if  [ "$cfgdbpath" != "$dbpath" ]; then
					if [ -d "$cfgdbpath" ]; then
						su - $queue1 -c 'db2 update dbm cfg using DFTDBPATH '$cfgdbpath
						if [ $? == 0 ]; then
							juju-log "IBM DB2: DFTDBPATH changed to $cfgdbpath"
						else
							juju-log "IBM DB2: Unable to set DFTDBPATH to $cfgdbpath"
							exit 0
						fi
					else
						juju-log "IBM DB2: Not a valid path. Please check the path and run the command again"
						exit 0
					fi
				fi
			fi
		done
	else
		juju-log "IBM DB2: DB2 is not installed. Install DB2 to change the dbpath"
		exit 0	
	fi
}
# Edit the response file for UID
edit_responsefile()
{
	rsp_file=db2server_temp.rsp
	if [ "$ARCHITECTURE" = "x86_64" ]; then
		orgrsp_file=db2server.rsp
	else
		orgrsp_file=db2server_ppcle.rsp
	fi
	cp $CHARM_DIR/files/archives/$orgrsp_file $CHARM_DIR/files/archives/$rsp_file

	db2uid=`id $DB2_USER | cut -d"=" -f2 | cut -d"(" -f1`
	sed -i s/db2inst1_uid/$db2uid/g  $CHARM_DIR/files/archives/$rsp_file
	sed -i s/db2inst1_gid/$db2uid/g  $CHARM_DIR/files/archives/$rsp_file
	sed -i s/db2inst1_homedir/$DB2_USER/g $CHARM_DIR/files/archives/$rsp_file
	sed -i s/db2inst1_password/$DB2_USER_PW/g $CHARM_DIR/files/archives/$rsp_file

	db2fenid=`id db2fenc1 | cut -d"=" -f2 | cut -d"(" -f1`
	sed -i s/db2fenc1_uid/$db2fenid/g  $CHARM_DIR/files/archives/$rsp_file	
	sed -i s/db2fenc1_gid/$db2fenid/g  $CHARM_DIR/files/archives/$rsp_file
	dasuid=`id dasusr1 | cut -d"=" -f2 | cut -d"(" -f1`
	sed -i s/das_uid/$dasuid/g $CHARM_DIR/files/archives/$rsp_file
	sed -i s/das_gid/$dasuid/g $CHARM_DIR/files/archives/$rsp_file

}

create_user()
{
	servicename=$1
	passwdchanged=0
	instance_exists=0
	db2_inst=`is_db2_installed`
	get_cfgusername $servicename 
	#juju-log "Suchitra: cfg user name in create user is $cfgusername"
	if  [ $db2_inst == True ]; then
		status-set maintenance "Creating Users"
		#Find the group id for db2inst1 user which is used to install db2 and find all
		#users belonging to this user
		db2inst1grpid=`id $DB2_USER |  cut -d" " -f2`

		#If the user is already available, just change the password.
		for queue2 in `awk -F':' '{ print $1}' /etc/passwd`;
		do
			gid=`id $queue2 |  cut -d" " -f2`
			if [ $gid == $db2inst1grpid ]; then
				if [ $queue2 != "$DB2_USER" ]; then
					if [ $cfgusername == $queue2  ]; then
						juju-log "IBM DB2: Changing the password for the user $cfgusername to $cfgpasswd"
						echo $cfgusername:$cfgpasswd | chpasswd
						passwdchanged=1
						juju-log "IBM DB2: Changed the password for the user $cfgusername to $cfgpasswd"
					fi

				fi
			fi
		done
		#If not available, add a new user
		if [ $passwdchanged != 1 ]; then
			juju-log "IBM DB2: Creating New user"
			create_newuser $servicename
			juju-log "IBM DB2: Created New user"
			juju-log $cfgusername
		fi
		#Creating a new instance for the new user if not existing

		for queue1 in `su - $DB2_USER -c 'db2ilist'`;
		do
			if [ $queue1 == $cfgusername ]; then
				instance_exists=1
			fi
		done
		if [ $instance_exists != 1 ]; then
			juju-log "IBM DB2: Creating new instance for the user"
			/opt/ibm/db2/V10.5/instance/db2icrt -u $cfgusername $cfgusername
			if [ $? = 0 ]; then
				juju-log "IBM DB2: Created new instance for the user"
			else
				juju-log "IBM DB2: Creation of new instance failed"
				exit 0
			fi
		fi

		#Do the configuration for the new instance created
		new_port=50001
		free_port=0
		is_free=0
		#Check whether the port number is already in etc/services file, and then add it
		cd /etc
		if grep -q "db2c_$cfgusername" services
		then
			juju-log "IBM DB2: Services file already updated"
		else
			while [ $free_port == 0 ]
			do
				is_free=`netstat -lnp | grep $new_port | cut -d":" -f2 | cut -d" " -f1`
				if [ "$is_free" != "$new_port" ]; then
					free_port=1
				else
					new_port=$((new_port+1))
				fi
			done
			juju-log "IBM DB2:Updating Services file"
			echo -e "db2c_$cfgusername	$new_port/tcp" >> /etc/services
			su - $cfgusername -c 'set db2instance=$cfgusername'
			su - $cfgusername -c 'db2set DB2COMM=tcpip'
			new_port=`echo $new_port | xargs`
				#port_num_consumer=$new_port
			su - $cfgusername -c 'db2 update dbm cfg using svcename '$new_port
			/opt/ibm/db2/V10.5/instance/db2iupdt $cfgusername
		fi
		cd -

		#Start DB for the new user
		if su - $cfgusername -c 'ps -eaf|grep -i "\bdb2sysc 0\b" |grep -i '$cfgusername;
		then
			juju-log "IBM DB2: Db2 already started for the user $cfgusername"
		else
			su - $cfgusername -c 'db2start'
			juju-log "IBM DB2: DB2 is started"
		fi
		#set_state 'db.dbstarted'

	else
		juju-log "IBM DB2: DB2 is not installed. Install DB2 before creating users"
		exit 0

	fi
	status-set maintenance "Created DB user and Instance"
}

create_newuser()
{
	servicename=$1
	dbcreated="False"
	#Add the new user
	get_cfgusername $servicename
	#juju-log "Suchitra: In create new user cfgname is $cfgusername"
	useradd -g db2grp1 -G dasadm1 -m $cfgusername
	if [ $? != 0 ]; then
		juju-log "IBM DB2: Addition of user $queue2 failed."
		status-set blocked "Addition of new used failed, Try again"
		exit 0
	fi
	#Set the password for the new user
	echo $cfgusername:$cfgpasswd | chpasswd
	if [ $? != 0 ]; then
		juju-log "IBM DB2: Setting password for user $queue2 failed."
		status-set blocked "Setting the password for user failed, Try again"
		exit 0
	fi
	#Check whether test DB is already existing. If not create it

	dbname=`su - $DB2_USER -c 'db2 list db directory' | grep "Database name" | grep -i "\bTEST\b" | cut -d"=" -f2`
	dbname=`echo $dbname | xargs`
	if [ "$dbname" != "TEST" ]; then
		juju-log "IBM DB2: Creating DB Test"
		su - $DB2_USER -c 'db2 create database test'
		if [ $? != 0 ]; then
			juju-log "IBM DB2: DB creation failed"
			status-set blocked "DB creation failed, Try again"
			exit 0
		fi
		juju-log "IBM DB2: Created DB Test"
	fi
	#Connect to the DB and grant data access
	su - $DB2_USER -c 'db2 connect to test;db2 grant dataaccess on database to user '$cfgusername
	if [ $? != 0 ]; then
		juju-log "IBM DB2: Grant access failed"
		status-set blocked "Grant dataaccess on database failed, Try again"
		exit 0
	fi
	su - $DB2_USER -c 'db2 connect to test;db2 disconnect test'
	if [ $? != 0 ]; then
		juju-log "IBM DB2: Disconnect DB failed"
		status-set blocked "Disconnect DB failed"
		exit 0
	fi

}

create_database()
{
	dbtocreate=$1
	servicename=$2
	get_cfgusername $servicename
	#create the db for $dbnametocreate if it doesn't exist
	dbname=`su - $cfgusername -c 'db2 list db directory' | grep "Database name" | grep -i "\b$dbtocreate\b" | cut -d"=" -f2`
	dbname=`echo $dbname | xargs`
	dbname=`echo "$dbname" | awk '{ print tolower($1) }'`
	dbtocreate=`echo "$dbtocreate" | awk '{ print tolower($1) }'`
	#check whether dbname is more than 8 chars
	juju-log "No ofchars ${#dbtocreate}"
	if [ ${#dbtocreate} -gt 8 ]; then
		juju-log "Faield to create DB $dbtocreate. DB name should be <= 8 chars"
		#status-set blocked "DB creation for $dbtocreate failed as it contains more than 8 chars"
	else
		if [ "$dbname" != "$dbtocreate" ]; then
			juju-log "IBM DB2: Creating DB $dbtocreate"
			su - $cfgusername -c 'db2 create database '$dbtocreate
			if [ $? != 0 ]; then
				juju-log "IBM DB2: DB creation failed"
				status-set blocked "DB creation failed, Try again"
				exit 0
			fi
			juju-log "IBM DB2: Created DB $dbtocreate"
		fi
	fi

}
create_dbs()
{
servicename=$1
dbnames=$(relation_call --state=db.ready get_dbnames $servicename) || true

#If dbnames is null, create a default DB as per service name. Else create create the DBs requested by the related charm
if [ -z "$dbnames" ] ; then
	juju-log "IBM DB2: Creating a default DB $remoteunitdbname based on remote service name"
	create_database $remoteunitdbname $servicename
elif [ "$dbnames" == "None" ]; then
	juju-log "IBM DB2: DB name caught as None, Creating default DB $remoteunitdbname based on remote service name"
	create_database $remoteunitdbname $servicename
else
	juju-log "IBM DB2: Creating the DB names as passed by consumer"
	#parse the $dbnames string to get the names of dbs to be created
	for queue in `echo $dbnames | cut -d"," -f1`;
	do
		#create the db for $queue
		count=2
		create_database $queue $servicename
		dbnames=`echo $dbnames | cut -d"," -f$count`
		if [ `echo $dbnames | grep ","` ]; then
			juju-log "IBM DB2: Found the next DB to be created"
		else
			juju-log "IBM DB2: Creating new DB $dbnames"
			#create DB for last one and then quit
			create_database $dbnames $servicename
			#break
		fi
		count=count+1
	done

fi
}


@when 'ibm-db2.installed'
@when_not 'ibm-base.license.accepted'
function uninstall(){
	juju-log "IBM DB2: Removing IBM DB2 (if installed) as the license agreement is not accepted."
	status-set maintenance "IBM DB2 is getting uninstalled"
	remove_software
	remove_state 'ibm-db2.installed'
	remove_state 'ibm-db2.client.sshconfigured'
	set_state 'ibm-db2.uninstalled'
	status-set maintenance "IBM DB2 is uninstalled"
	
}

#Setting the interface states after uninstall
@when 'ibm-db2.uninstalled'
@when 'db.available'
function reset_interface_states(){
	services=$(relation_call --state=db.available services) || true
	for service in $services; do
		juju-log "IBM DB2: Resetting states for the service $service"
		relation_call --state=db.available reset_states $service
	done

	remove_state 'ibm-db2.uninstalled'
}


@when_not 'ibm-db2.prereqsinstalled'
function init() {
	set -e
	juju-log "IBM DB2: Begin Install."
	apt-get update
	status-set maintenance "Installing pre requisites for IBM DB2"
	juju-log "IBM DB2: Installing binutils"
	#apt-get install binutils
	juju-log "IBM DB2: Installed binutils"
	if [ "$ARCHITECTURE" != "x86_64" -a "$ARCHITECTURE" != "ppc64le" ]; then
		juju-log "IBM DB2: Unsupported platform. IBM DB2 installed with this Charm supports only the x86_64 and POWER LE (ppc64le) platforms."
		exit 1
	fi

	if [ "$ARCHITECTURE" == "x86_64" ]; then
		juju-log "IBM DB2: Installing 32 bit libstdc++.so.6"
		apt-get update
		apt-get install lib32stdc++6 -y
		juju-log "IBM DB2: Installed 32 bit libstdc++.so.6"
	fi
	if [ "$ARCHITECTURE" == "ppc64le" ]; then
		juju-log "IBM DB2:  Installing libnuma package for POWER LE (ppc64le) platforms."
		apt-get install libnuma-dev -y
		#Installing XL compiler runtime packages for Linux on Power as this is one of the prerequisite software/configuration requirements
		echo "deb http://public.dhe.ibm.com/software/server/POWER/Linux/rte/xlcpp/le/ubuntu $(lsb_release -s -c) main" | tee -a /etc/apt/sources.list.d/ibm-xlcpp-rte.list
		apt-get update
		apt-get install libxlc -y --force-yes
		juju-log "IBM DB2:  Installed libnuma package for POWER LE (ppc64le) platforms."
	fi

	#create the userids required for db2 installation
	DB2_USER=db2inst1
	DB2_USER_PW=db2inst1

	juju-log "IBM DB2: Creating the user ids for db2 installation"
	groupadd db2grp1
	groupadd dasadm1
	groupadd db2fgrp1

	useradd -g db2grp1 -G dasadm1 -m $DB2_USER
	echo $DB2_USER:$DB2_USER_PW | chpasswd
	useradd -g dasadm1 -G db2grp1 -m dasusr1
	echo dasusr1:dasusr1 | chpasswd
	useradd -g db2fgrp1 -m db2fenc1
	echo db2fenc1:db2fenc1 | chpasswd

	juju-log "IBM DB2: Created the user ids for db2 installation"
	status-set maintenance "Installed pre requisites for IBM DB2"
	set_state 'ibm-db2.prereqsinstalled'

}
@when 'ibm-db2.prereqsinstalled' 'ibm-base.license.accepted' 'ibm-base.curl.resource.fetched'
@when_not 'ibm-db2.installed'
function install() {
	juju-log "IBM DB2: License accepted"
	db2_inst=`is_db2_installed`
	if [[ ! -d $ARCHIVE_DIR ]]; then
		mkdir $ARCHIVE_DIR
	fi
	#Install if download succeeded
	if  [ $db2_inst == False ]; then
		if [ -f  $ARCHIVE_DIR/*.gz ]; then

			cd $CHARM_DIR/files/archives
			tar -zxvf $ARCHIVE_DIR/*.gz
			if [ $? != 0 ]; then
				juju-log "IBM DB2: Unable to extract the DB2 package content. Verify whether the package is corrupt."
				status-set maintenance "Unable to extract the DB2 package content"
				#Remove corrupt archive file
				rm -rf $ARCHIVE_DIR/*.gz
				exit 0
			fi
			if [ "$ARCHITECTURE" = "x86_64" ]; then
				rsp_file=db2server.rsp
			else
				rsp_file=db2server_ppcle.rsp
			fi
			edit_responsefile
			cd $CHARM_DIR/files/archives/server*
			juju-log "IBM DB2: Edited the response file"
			
			juju-log "IBM DB2: Checking etc/hosts file."
			private_address=`unit-get private-address`
			#juju-log "private_address : $private_address"
			cd /etc
			if grep -q "$private_address" hosts
			then
				juju-log "IBM DB2: Host file already updated"
			else
				juju-log "IBM DB2: Updating Host file"
				echo "$private_address `hostname`" >> /etc/hosts
			fi
			juju-log "IBM DB2: Installing db2 package."
			status-set maintenance "Installing IBM DB2"
			cd -
			./db2setup -r $CHARM_DIR/files/archives/$rsp_file
			juju-log "IBM DB2: Installation of db2 complete."
		fi
	fi
	# Configure system values  for Db2
	configure_system
	#Configure DFTDBPATH
	configure_dftdbpath
	set_state 'ibm-db2.installed'
	remove_state 'ibm-db2.uninstalled'
	status-set active "IBM DB2 Installed"
}

@when 'config.changed.dftdbpath'
function configurevalues(){
	configure_dftdbpath
}

@when 'ibm-base.license.accepted'
@when 'db.ready'
function configure_sshkeys(){
	#juju-log "************************In db available function ***********"
	services=$(relation_call --state=db.available services)
        for service in $services; do
		key=$(relation_call --state=db.available get_sshkeys $service) || true
		juju-log "IBM DB2: Received the ssh key $key from the service $service"
		
		if [ -z "$key" ]; then
			juju-log "IBM DB2: No data sent yet"
			continue
		fi

		# Add the key to the authorized_keys file, if it exists
		set +e
		if [ -f $AUTH_KEY_FILE ]; then
			# Append only if the key is not present
			juju-log "IBM DB2: Updating the key file"
			grep "$key" $AUTH_KEY_FILE > /dev/null 
			if [ $? != 0 ]; then
				juju-log "IBM DB2: Updating authorized keys file"
				echo "$key" >> $AUTH_KEY_FILE
			else
				juju-log "IBM DB2: Key already present"
			fi
		else
			juju-log "IBM DB2: Creating authorized keys file"
			echo "$key" > $AUTH_KEY_FILE
		fi
		set -e
	done
	juju-log "IBM DB2: Completed updating the authorized key"
	set_state 'ibm-db2.client.sshconfigured'
}

@when 'db.ready'
@when 'ibm-db2.installed'
@when 'ibm-db2.client.sshconfigured'
function create_consumer_dbs(){
	DB2_INSTALL_PATH=/opt/ibm/db2/V10.5
	services=$(relation_call --state=db.available services)
	for service in $services; do
		#Create the user for the remote unit connected
		juju-log "IBM DB2: Creating the users for the consumer $service"
		create_user $service

		#Create the DBs after parsing
		create_dbs $service
		juju-log "IBM DB2: Create DBs completed"	
	
		get_cfgusername $service
		service_name=`su - $cfgusername -c 'db2 get dbm cfg|grep -i svce|cut -d"=" -f2'`
		db2_port=`grep $service_name /etc/services | cut -d"/" -f1 | cut -f2`
		db2_path="/opt/ibm/db2"
		hostname=`unit-get private-address`
		dbusername=$cfgusername
		dbuserpw=$cfgpasswd
		db2_instance_name=$cfgusername

		dbs=$(relation_call --state=db.ready get_dbnames $servicename) || true

		juju-log "IBM DB2: Sending the DB details to the consumer $service"
		juju-log "Port number: $db2_port"
		juju-log "Hostname: $hostname"
		juju-log "DBusername: $dbusername DBuserpw: $dbuserpw"
		juju-log "DB Instance name: $db2_instance_name"
		juju-log "Service: $service_name"
		juju-log "DBname: $dbs"
		
		relation_call --state=db.connected set_db_details $service $db2_path $db2_port $hostname $dbusername $dbuserpw $db2_instance_name || true
	done
}

@when 'db.departed'
function stop_db2(){
	juju-log "IBM DB2: Stopping the DB when relation is broken"
	services=$(relation_call --state=db.departed services) || true
	for service in $services; do
		juju-log "IBM DB2: Service name is $service"
		get_cfgusername $service
		if su - $cfgusername -c 'ps -eaf|grep -i "\bdb2sysc 0\b" |grep -i '$cfgusername
		then
			su - $cfgusername -c 'db2stop'
			juju-log "IBM DB2: DB2 stopped for instance $cfgusername"
		else
			juju-log "IBM DB2: DB2 is already stopped for the instance $cfgusername"
		fi
		#juju-log "Calling dismiss for $service"
		relation_call --state=db.departed dismiss $service || true
	done
	remove_state 'ibm-db2.client.sshconfigured'
}


reactive_handler_main