You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
88 lines
2.6 KiB
88 lines
2.6 KiB
#!/bin/bash
|
|
#
|
|
# Copyright: 2013-2016 Sipwise Development Team <support@sipwise.com>
|
|
#
|
|
# This program is free software: you can redistribute it and/or modify
|
|
# it under the terms of the GNU General Public License as published by
|
|
# the Free Software Foundation, either version 3 of the License, or
|
|
# (at your option) any later version.
|
|
#
|
|
# This package is distributed in the hope that it will be useful,
|
|
# but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
# GNU General Public License for more details.
|
|
#
|
|
# You should have received a copy of the GNU General Public License
|
|
# along with this program. If not, see <http://www.gnu.org/licenses/>.
|
|
#
|
|
# On Debian systems, the complete text of the GNU General
|
|
# Public License version 3 can be found in "/usr/share/common-licenses/GPL-3".
|
|
#
|
|
|
|
|
|
START_TIME=""
|
|
MUTE=false
|
|
|
|
|
|
# sipwise password for mysql connections
|
|
declare -r SIPWISE_EXTRA_CNF="/etc/mysql/sipwise_extra.cnf"
|
|
|
|
if [ ! -f "${SIPWISE_EXTRA_CNF}" ]; then
|
|
echo "Error: missing DB credentials file '${SIPWISE_EXTRA_CNF}'." >&2
|
|
exit 1
|
|
fi
|
|
|
|
|
|
usage() {
|
|
echo "Usage: check.sh [-h] -t START_TIME -s [GROUP] check_name"
|
|
echo "Options:"
|
|
echo -e "\t-t Tests start time in order to better tune the mysql query."
|
|
echo -e "\t-s scenario group. Default: scenarios"
|
|
echo -e "\t-m mute the console output"
|
|
echo "Arguments:"
|
|
echo -e "\tcheck_name. Scenario name to check. This is the name of the directory on GROUP dir."
|
|
}
|
|
|
|
while getopts 'ht:s:m' opt; do
|
|
case $opt in
|
|
h) usage; exit 0;;
|
|
t) START_TIME=$OPTARG;;
|
|
s) GROUP=$OPTARG;;
|
|
m) MUTE=true;;
|
|
esac
|
|
done
|
|
shift $((OPTIND - 1))
|
|
|
|
if [[ $# != 1 ]]; then
|
|
echo "Wrong number of arguments"
|
|
usage
|
|
exit 1
|
|
fi
|
|
|
|
if [ -z "${START_TIME}" ]; then
|
|
echo "Start time not defined"
|
|
usage
|
|
exit 1
|
|
fi
|
|
|
|
|
|
GROUP="${GROUP:-scenarios}"
|
|
NAME_CHECK="$1"
|
|
BASE_DIR="${BASE_DIR:-/usr/share/kamailio-config-tests}"
|
|
LOG_DIR="${BASE_DIR}/log/${GROUP}/${NAME_CHECK}"
|
|
|
|
|
|
if ! "${MUTE}" ; then
|
|
echo "$(date) - Exporting generated CDRs"
|
|
fi
|
|
mysql --defaults-extra-file="${SIPWISE_EXTRA_CNF}" accounting \
|
|
-e "select * from cdr where call_id like 'NGCP\%${NAME_CHECK}\%%' and start_time > ${START_TIME} order by id desc limit 10\G" > "${LOG_DIR}/cdr.txt" || true
|
|
mysql --defaults-extra-file="${SIPWISE_EXTRA_CNF}" accounting \
|
|
-e "select * from cdr_tag_data left join cdr_tag on tag_id = cdr_tag.id,(select id from cdr where call_id like 'NGCP\%${NAME_CHECK}\%%' and start_time > ${START_TIME} order by id desc limit 10) as cdr where cdr_id = cdr.id limit 10\G" > "${LOG_DIR}/cdr_tag_data.txt" || true
|
|
if ! "${MUTE}" ; then
|
|
echo "$(date) - Done"
|
|
fi
|
|
|
|
exit 0
|
|
#EOF
|