hi,
vladmir it's ok , I'm in stuck in situation . would U like to attach your
script , hoping it may help .
any other idea for my problem ?
thanks,
agung aryo
--- On Fri, 12/12/08, Vladimir Broz <[email protected]> wrote:
From: Vladimir Broz <[email protected]>
Subject: Re: [Sipp-users] add thousand users ?
To: [email protected]
Cc: [email protected]
Date: Friday, December 12, 2008, 5:02 AM
Hi,
I worked with OpenIMSCore a year ago and I created some bash cript, that
creates file with MySQL commands containing all necessary records for different
tables used for HSS users.
If you don't find any other better solution, attached is my script, but
I'm sure that database scheme has changed a lot!!! (Sorry for czech language
and bad format-> I have no time to translate it and copied&pasted from
my pdf docu :) -> it is just for an inspiration.
Regards,
Vladimir Broz
agung aryo wrote:
> hi all,
> I'm trying to benchmark OpenIMSCore
> in scenario there is reg , dereg , call ,etc.
> but that thousands users must be registered in HSS .
> how to add that thousands users (generated by ims_bench) into HSS database
?
> I've tried user_gen.pl but i confused to add that users into HSS
database.
>
>
> thanks,
> agung aryo
>
>
> ------------------------------------------------------------------------
>
>
------------------------------------------------------------------------------
> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,
Nevada.
> The future of the web can't happen without you. Join us at MIX09 to
help
> pave the way to the Next Web now. Learn more and register at
>
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
> ------------------------------------------------------------------------
>
> _______________________________________________
> Sipp-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sipp-users
> Skript sipp-hss-transport.sh
#!/bin/bash
#zalohovani souboru a mazani starych souboru
cd /opt/OpenIMSCore/transport_sipp_Users
cp add-subscribers.sql add-subscribers-backup.sql
rm add-subscribers.sql
cp del-subscribers.sql del-subscribers-backup.sql
rm del-subscribers.sql
#inicializace promennych
EXIT_CODE=0
DBUser=User
IFS=";"
OPTION_ADD=0
OPTION_INIT=0;
Usage()
{
echo "Chybne parametry!"
echo "sipp-hss-transport.sh -f <*.inf soubor > [-a <automaticke
nahrani do databaze>]"
exit -1
}
#cteni vstupnich parametru skriptu
while getopts f:a?:i? option;
do
case $option in
f) OPTION_FILE=$OPTARG) OPTION_ADD=) OPTION_INIT=1ac
done
#osetreni nezadani vstupniho souboru
[ -z "$OPTION_FILE" ] && Usage
#sekvencni cteni zaznamu ze soubru vytvoreneho z IMS Bench SIPp
cat $OPTION_FILE | while read pool Userpart domainpart auth_Username
auth_realm passwd
do
#prirazeni ziskanych polozek do promennych dale ve skriptu pouzitych
IMSUser=$Userpart
REALM=$domainpart
IMPI="$auth_usern...@$realm"
PASSWORD=$passwd
IMPU="sip:$imsu...@$realm"
KEY=`/opt/OpenIMSCore/ser_ims/utils/gen_ha1/gen_ha1 $IMPI $REALM
$PASSWORD`
PASSWORD_FILE=~temp~password~
echo -n $PASSWORD > $PASSWORD_FILE
ENCODED_PASSWORD=`hexdump -C < $PASSWORD_FILE|cut -b 10-60|sed 's/
//g'|cut -b 1-32`00000000000000000000000000000000
ENCODED_PASSWORD=`echo $ENCODED_PASSWORD|cut -b 1-32`
rm $PASSWORD_FILE
#vytvoreni bloku instrukci s MySQL prikazy pro pridani uzivatele
CREATE_SCRIPT_TEMPLATE="insert into hss_db.imsu
(name,scscf_name,diameter_name,
id_capabilities_set,id_preferred_scscf_set)
values('$IMSUser','sip:scscf.open-ims.test:6060','scscf.openims.
test',1,1);
insert into
hss_db.impi(identity,id_imsu,k,auth_scheme,default_auth_scheme,amf,op,sqn,
ip,line_identifier,zh_uicc_type,zh_key_life_time,zh_default_auth_scheme)
values ('$IMPI',(select id from hss_db.imsu where
hss_db.imsu.name='$IMSUser'),'$PASSWORD',127,1,'\\\0\\\0',
'\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0\\\0',
'000000000000','','',0,3600,1);
insert into hss_db.impu (identity,type,barring,User_state,
id_sp,id_charging_info, wildcard_psi, display_name,psi_activation,
can_register) VALUES
('$IMPU', 0,0,0,1,1,'','',0,1);
UPDATE hss_db.impu SET id_implicit_set=id WHERE
hss_db.impu.identity='$IMPU';
INSERT INTO hss_db.impi_impu(id_impi,id_impu) VALUES ((SELECT id FROM
hss_db.impi WHERE hss_db.impi.identity='$IMPI'),
(SELECT id FROM hss_db.impu WHERE hss_db.impu.identity='$IMPU'));
INSERT INTO hss_db.impu_visited_network(id_impu, id_visited_network)
VALUES((SELECT id FROM hss_db.impu WHERE hss_db.impu.identity='$IMPU'),
(SELECT id FROM hss_db.visited_network WHERE
hss_db.visited_network.identity='$REALM'));"
#vytvoreni bloku instrukci s MySQL prikazy pro vymazani uzivatele
DELETE_SCRIPT_TEMPLATE="
delete from hss_db.impu_visited_network where id_impu = (select id from
hss_db.impu where hss_db.impu.identity='$IMPU');
delete from hss_db.impi_impu where id_impi = (select id from hss_db.impi
where hss_db.impi.identity='$IMPI');
delete from hss_db.impi where identity = '$IMPI';
delete from hss_db.impu where identity = '$IMPU';
delete from hss_db.imsu where name = '$IMSUser';"
# zapsani vytvorenych bloku do souboru *.sql
echo "$CREATE_SCRIPT_TEMPLATE" >> add-subscribers.sql
if [ $? -ne 0 ]; then
echo "Failed to create User $IMSUser"
exit -1
fi
echo "Successfully created User $IMSUser"
echo "$DELETE_SCRIPT_TEMPLATE" >> del-subscribers.sql
if [ $? -ne 0 ]; then
echo "Failed to write $DELETE_SCRIPT"
exit -1
fi
done
#inicializace databaze
77
if [ $OPTION_INIT -eq 1 ]; then
echo "Zapisuji hss_db.sql do databaze"
mysql -u $DBUser hss_db < hss_db.sql
echo "Zapisuji Userdata.sql do databaze"
mysql -u $DBUser hss_db < Userdata.sql
EXIT_CODE=$?
fi
# prime nahrani do databaze
if [ $OPTION_ADD -eq 1 ]; then
echo "Zapisuji add-subscribers.sql do databaze"
mysql -u $DBUser < add-subscribers.sql
EXIT_CODE=$?
SCRIPT=$CREATE_SCRIPT
fi
# Vyhodnoceni vysledku skriptu
if [ $EXIT_CODE -ne 0 ]; then
echo "Nepodarilo se naplnit databazi..."
else
echo "Data uspesne ulozena..."
fi
exit $EXIT_CODE
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Sipp-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sipp-users
