#Install Postgresql 
apk add postgresql postgresql-client

#Setup postgresql 
/etc/init.d/postgresql setup 

#Direct logging information to syslog 
sed "/^[# ]*log_destination/clog_destination = 'syslog'" -i /var/lib/postgresql/9.1/data/postgresql.conf


#Start postgresql and enable auto start 
/etc/init.d/postgresql start 

rc-update add postgresql

#Create file for Kamailio to start after pg-restore when booting: 

echo 'rc_after=pg-restore' > /etc/conf.d/kamailio

#Configure postgresql and setup LBU backup for the database:
 lbu include /var/lib/postgresql/
	mkdir -p /var/lib/postgresql/backup
 sed '/^[# ]*PGDUMP/cPGDUMP="/var/lib/postgresql/backup/databases.pgdump"' -i /etc/conf.d/pg-restore
	rc-update add pg-restore
	
 mkdir /etc/lbu/pre-package.d
	echo "#!/bin/sh" > /etc/lbu/pre-package.d/postgresdump
 echo "/etc/init.d/pg-restore dump" >> /etc/lbu/pre-package.d/postgresdump
	chmod +x /etc/lbu/pre-package.d/postgresdump
	

apk add kamailio kamailio-presence kamailio-pcre kamailio-postgres

sed "/^[# ]*SIP_DOMAIN/cSIP_DOMAIN=sip.gatorfone.com" -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBENGINE/cDBENGINE=PGSQL' -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBHOST/cDBHOST=localhost' -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBNAME/cDBNAME=openser' -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBRWUSER/cDBRWUSER=openser' -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBRWPW/cDBRWPW="openser"' -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBROUSER/cDBROUSER=openserro' -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBROPW/cDBROPW=openserro' -i /etc/kamailio/kamctlrc
sed '/^[# ]*DBROOTUSER/cDBROOTUSER="postgres" ' -i /etc/kamailio/kamctlrc



echo postgres > /root/.pgpass 
chmod 600 /root/.pgpass 
yes|kamdbctl create openser

rc-update add kamailio 
echo 'rc_after=postgresql' >> /etc/conf.d/kamailio

# Create the directory for pid file:

mkdir -p /var/run/kamailio

# set ownership to /var/run/kamailio
chown kamailio:kamailio /var/run/kamailio