Module: sip-router Branch: master Commit: ef2b3a6ee84f75bd49a06635a486807eeaebc08a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ef2b3a6… Author: Ovidiu Sas &lt;osas(a)voipembedded.com&gt; Committer: Ovidiu Sas &lt;osas(a)voipembedded.com&gt; Date: Thu Jan 10 12:50:06 2013 -0500 kamdbctl: new command - kamdbctl pframework create - creates a provisioning framework for the installed db tables --- utils/kamctl/Makefile | 1 + utils/kamctl/kamdbctl | 75 ++++++++++++++++++++++++++++++++++++++++++++ utils/kamctl/kamdbctl.base | 25 +++++++++----- 3 files changed, 92 insertions(+), 9 deletions(-) diff --git a/utils/kamctl/Makefile b/utils/kamctl/Makefile index ba3d67a..3056ae0 100644 --- a/utils/kamctl/Makefile +++ b/utils/kamctl/Makefile @@ -70,6 +70,7 @@ install-bin: $(bin_prefix)/$(bin_dir) # install db setup base script sed -e "s#/usr/local/sbin#$(bin_target)#g" \ -e "s#/usr/local/etc/kamailio#$(cfg_target)#g" \ + -e "s#/usr/local/share/kamailio#$(data_target)#g" \ < kamdbctl.base > /tmp/kamdbctl.base $(INSTALL_CFG) /tmp/kamdbctl.base \ $(modules_prefix)/$(lib_dir)/kamctl/kamdbctl.base diff --git a/utils/kamctl/kamdbctl b/utils/kamctl/kamdbctl index 681818e..4784729 100755 --- a/utils/kamctl/kamdbctl +++ b/utils/kamctl/kamdbctl @@ -168,6 +168,76 @@ kamailio_restore() #pars: <database name> <filename> } +kamailio_pframework_create() #pars: none +{ + touch $DEFAULT_CFG_DIR/pi_framework_sample + if [ $? -ne 0 ] ; then + merr "Unable to create $DEFAULT_CFG_DIR/pi_framework_sample" + exit 1 + fi + + if [ -d "$DATA_DIR/xhttp_pi" ] ; then + PI_MODULES="$STANDARD_MODULES" + else + merr "Please install first the xhttp_pi module" + exit 1 + fi + + + get_answer $INSTALL_EXTRA_TABLES "Add provisionning framework for extra tables? (y/n): " + if [ "$ANSWER" = "y" ]; then + PI_MODULES="$PI_MODULES $EXTRA_MODULES" + fi + + get_answer $INSTALL_PRESENCE_TABLES "Add provisionning framework for presence tables? (y/n): " + if [ "$ANSWER" = "y" ]; then + PI_MODULES="$PI_MODULES $PRESENCE_TABLES" + fi + + cat $DATA_DIR/xhttp_pi/pi_framework-00 > $DEFAULT_CFG_DIR/pi_framework_sample + for TABLE in $PI_MODULES; do + if [ -e $DATA_DIR/xhttp_pi/$TABLE-table ]; then + cat $DATA_DIR/xhttp_pi/$TABLE-table >> $DEFAULT_CFG_DIR/pi_framework_sample + else + merr "Unable to configure: $TABLE - missing table descriptor" + fi + done + cat $DATA_DIR/xhttp_pi/pi_framework-01 >> $DEFAULT_CFG_DIR/pi_framework_sample + for TABLE in $PI_MODULES; do + if [ -e $DATA_DIR/xhttp_pi/$TABLE-mod ]; then + cat $DATA_DIR/xhttp_pi/$TABLE-mod >> $DEFAULT_CFG_DIR/pi_framework_sample + else + merr "Unable to configure: $TABLE - missing mod descriptor" + fi + done + cat $DATA_DIR/xhttp_pi/pi_framework-02 >> $DEFAULT_CFG_DIR/pi_framework_sample + + minfo "Sample provisionning framework saved as: $DEFAULT_CFG_DIR/pi_framework_sample" +} + +kamailio_pframework() #pars: <action> +{ + if [ $# -ne 1 ] ; then + merr "kamailio_pframework function takes one parameter" + exit 1 + fi + + case $1 in + create) + shift + kamailio_pframework_create "$@" + exit $? + ;; + *) + merr "Unexpected pframework action: $1" + usage + exit 1 + ;; + esac +} + + + case $1 in migrate) if [ "$USED_DBENGINE" != "mysql" ] ; then @@ -303,6 +373,11 @@ case $1 in kamailio_berkeley "$@" exit $? ;; + pframework) + shift + kamailio_pframework "$@" + exit $? + ;; version) echo "$0 $VERSION" ;; diff --git a/utils/kamctl/kamdbctl.base b/utils/kamctl/kamdbctl.base index 8e367be..f387aa2 100644 --- a/utils/kamctl/kamdbctl.base +++ b/utils/kamctl/kamdbctl.base @@ -56,6 +56,12 @@ DEFAULT_CSEQ=${DEFAULT_CSEQ:-13} DEFAULT_LOCATION_EXPIRES=${DEFAULT_LOCATION_EXPIRES:-${FOREVER}} +# default location for config files +DEFAULT_CFG_DIR=/usr/local/etc/kamailio + +# default location for data files +DEFAULT_DATA_DIR=/usr/local/share/kamailio + # Needed programs MD5=${MD5:-md5sum} AWK=${AWK:-awk} @@ -79,21 +85,22 @@ COMMAND=`basename $0` cat <<EOF $0 $VERSION -usage: $COMMAND create <db name or db_path, optional> .....(creates a new database) - $COMMAND drop <db name or db_path, optional> .......(!entirely deletes tables!) - $COMMAND reinit <db name or db_path, optional> .....(!entirely deletes and than re-creates tables!) - $COMMAND backup <file> .................................(dumps current database to file) - $COMMAND restore <file> ................................(restores tables from a file) - $COMMAND copy <new_db> .................................(creates a new db from an existing one) - $COMMAND migrate <old_db> <new_db> .....................(migrates DB from 1.2 to 1.3, not implemented yet!) - $COMMAND presence ......................................(adds the presence related tables) - $COMMAND extra .........................................(adds the extra tables) +usage: $COMMAND create <db name or db_path, optional> ...(creates a new database) + $COMMAND drop <db name or db_path, optional> .....(!entirely deletes tables!) + $COMMAND reinit <db name or db_path, optional> ...(!entirely deletes and than re-creates tables!) + $COMMAND backup <file> ...........................(dumps current database to file) + $COMMAND restore <file> ..........................(restores tables from a file) + $COMMAND copy <new_db> ...........................(creates a new db from an existing one) + $COMMAND migrate <old_db> <new_db> ...............(migrates DB from 1.2 to 1.3, not implemented yet!) + $COMMAND presence ................................(adds the presence related tables) + $COMMAND extra ...................................(adds the extra tables) if you want to manipulate database as other database user than root, want to change database name from default value "$DBNAME", or want to use other values for users and password, edit the "config vars" section of the command $COMMAND. + $COMMAND pframework create .......................(creates a sample provisioning framework file) EOF } #usage