Module: sip-router
Branch: master
Commit: e395c9bb0131d7fce80af67c54cd813532e5f2ed
URL:
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e395c9bb0131d7fce80af67c54cd813532e5f2ed
Author: Daniel-Constantin Mierla <mico...@gmail.com>
Committer: Daniel-Constantin Mierla <mico...@gmail.com>
Date: Mon Mar 3 18:16:54 2014 +0100
kamctl: db connect - new command for db management subset
- execute to command line client tool and stay connected using the
attributes from kamctlrc
- handy when kamctlrc is set, to avoid typing all the attributes when
willing to connect to kamailio database
---
utils/kamctl/kamctl | 7 +++++++
utils/kamctl/kamctl.mysql | 7 +++++++
2 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/utils/kamctl/kamctl b/utils/kamctl/kamctl
index 519da55..30dddcf 100755
--- a/utils/kamctl/kamctl
+++ b/utils/kamctl/kamctl
@@ -1010,6 +1010,13 @@ db_ops() {
QUERY="SELECT * FROM $1 WHERE $2=$3\\G;"
$DBROCMD "$QUERY"
;;
+ connect)
+ shift
+ if [ -z "$DBCMDCONNECT" ] ; then
+ merr "extension not implemented"
+ exit 1
+ fi
+ $DBCMDCONNECT
*)
usage_db_ops
exit 1
diff --git a/utils/kamctl/kamctl.mysql b/utils/kamctl/kamctl.mysql
index e533e9c..1b25d2a 100644
--- a/utils/kamctl/kamctl.mysql
+++ b/utils/kamctl/kamctl.mysql
@@ -42,7 +42,14 @@ mysql_ro_query() {
$MYSQL $2 -h $DBHOST -u $DBROUSER "-p$DBROPW" -e "$1 ;" $DBNAME
}
+mysql_connect() {
+ # if password not yet queried, query it now
+ prompt_pw "MySQL password for user '$DBRWUSER@$DBHOST'"
+ $MYSQL $2 -h $DBHOST -u $DBRWUSER "-p$DBRWPW" $DBNAME
+}
+
DBCMD=mysql_query
DBROCMD=mysql_ro_query
DBRAWPARAMS="-B"
+DBCMDCONNECT=mysql_connect
_______________________________________________
sr-dev mailing list
sr-dev@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
