sr-users June 2008

sr-users@lists.kamailio.org

124 participants
230 discussions

by Adrian Georgescu

David, When $RatingEngine['split_rating_table'] setting is true, after changing the rates in the web interface or by importing them, you must run the script from scripts/splitRatingTables.php to split the central billing_rates table into individual tables for each rate id. You do not need this feature if you have less than 100K rates in your system. Adrian On Mon, Jun 16, 2008 at 5:55 PM, Iñaki Baz Castillo <ibc at in.ilimit.es> wrote: > El Monday 16 June 2008 17:44:56 David Villasmil escribió: > > > But as it happens, when you specify a profile like I did: billing profile > > is NORMAL, but RATE NAME is 1, then you MUST CREATE A TABLE CALLED > > "BILLING_RATES_1", I don't know if cdrtool is supposed to create it but > > didn't do it for me. I had to manually create the table: > > What about if you don't use numeric values as Rate Id? > I use Rate id with textual value ("Reducida", "Normal"...) and had not your > problem. > At least in my case, it doesn't find the rate... Same thing, I had to create the table... without creating the table: Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for callid= 00808260004800068104000005E9 at 82.144.106.187, billing party=user at 1.2.3.4, customer gateway=1.2.3.4, gateway=1.2.3.4, destination=1, profile=Normal, app=audio and then, having created the billing_rates_reducida table: Jun 16 12:03:16 rgi-sql CDRTool[21793]: ConnectFee=0.0000 Span=1 Duration=6 DestId=1 gateway=1.2.3.4 Profile=Normal Period=weekday Rate=reducida Interval=0-24 Cost=0.0500/60 Price=0.0050

16 years, 5 months

[OpenSER-Users] lots of OpenSER processes

by Mike Li

Hi, everyone, I have installed OpenSER 1.3.2, and it works fine for me, but i found lots of active processes for OpenSER, what's happened? I was using CentOS for the server. [root@localhost ~]# ps -aux Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.5 0.2 2428 548 ? S 17:18 0:02 init [3] root 2 0.0 0.0 0 0 ? S 17:18 0:00 [migration/0] root 3 0.0 0.0 0 0 ? SN 17:18 0:00 [ksoftirqd/0] root 4 0.0 0.0 0 0 ? S< 17:18 0:00 [events/0] root 5 0.0 0.0 0 0 ? S< 17:18 0:00 [khelper] root 6 0.0 0.0 0 0 ? S< 17:18 0:00 [kacpid] root 14 0.0 0.0 0 0 ? S< 17:18 0:00 [kblockd/0] root 15 0.0 0.0 0 0 ? S 17:18 0:00 [khubd] root 32 0.0 0.0 0 0 ? S 17:18 0:00 [pdflush] root 33 0.0 0.0 0 0 ? S 17:18 0:00 [pdflush] root 35 0.0 0.0 0 0 ? S< 17:18 0:00 [aio/0] root 34 0.0 0.0 0 0 ? S 17:18 0:00 [kswapd0] root 179 0.0 0.0 0 0 ? S 17:18 0:00 [kseriod] root 301 0.0 0.0 0 0 ? S< 17:18 0:00 [kmirrord] root 311 0.0 0.0 0 0 ? S 17:18 0:00 [kjournald] root 1348 0.0 0.1 2668 440 ? S<s 17:18 0:00 udevd root 1404 0.0 0.0 0 0 ? S< 17:18 0:00 [kauditd] root 1457 0.0 0.0 0 0 ? S 17:18 0:00 [kjournald] root 1926 0.0 3.9 30504 9952 ? Ss 17:19 0:00 /usr/local/apache2/bin/httpd -k start daemon 1990 0.0 3.5 296848 9024 ? Sl 17:19 0:00 /usr/local/apache2/bin/httpd -k start daemon 1992 0.0 3.5 296848 9028 ? Sl 17:19 0:00 /usr/local/apache2/bin/httpd -k start daemon 1994 0.0 3.5 296848 9028 ? Sl 17:19 0:00 /usr/local/apache2/bin/httpd -k start root 2191 0.0 0.2 2428 532 ? Ss 17:19 0:00 syslogd -m 0 root 2195 0.0 0.1 2912 376 ? Ss 17:19 0:00 klogd -x rpc 2222 0.0 0.2 2760 548 ? Ss 17:19 0:00 portmap root 2241 0.0 0.2 1836 708 ? Ss 17:19 0:00 rpc.statd root 2269 0.0 0.1 5312 348 ? Ss 17:19 0:00 rpc.idmapd root 2341 0.0 0.1 2212 432 ? Ss 17:19 0:00 /usr/sbin/acpid root 2350 0.0 0.7 9088 1888 ? Ss 17:19 0:00 cupsd root 2398 0.0 0.4 4948 1124 ? Ss 17:19 0:00 /usr/sbin/sshd root 2411 0.0 0.2 3340 748 ? Ss 17:19 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid root 2432 0.0 0.7 8748 1836 ? Ss 17:19 0:00 sendmail: accepting connections smmsp 2440 0.0 0.6 7488 1624 ? Ss 17:19 0:00 sendmail: Queue runner@01:00:00 for /var/spool/clientmqueue root 2450 0.0 0.1 3432 340 ? Ss 17:19 0:00 gpm -m /dev/input/mice -t imps2 root 2473 0.0 0.3 6528 908 ? Ss 17:19 0:00 crond xfs 2513 0.0 0.3 3920 888 ? Ss 17:19 0:00 xfs -droppriv -daemon root 2522 0.0 0.1 2480 484 ? SNs 17:19 0:00 anacron -s root 2530 0.0 0.1 3156 432 ? Ss 17:19 0:00 /usr/sbin/atd dbus 2539 0.0 0.3 3604 800 ? Ss 17:19 0:00 dbus-daemon-1 --system root 2548 0.4 1.3 6084 3316 ? Ss 17:19 0:01 hald root 2581 0.0 0.4 5844 1232 ? S 17:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/lo mysql 2622 0.1 18.7 439736 47852 ? S 17:19 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 2633 0.0 18.7 439736 47852 ? S 17:19 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 2634 0.0 18.7 439736 47852 ? S 17:19 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 2641 0.0 0.1 2052 416 tty1 Ss+ 17:19 0:00 /sbin/mingetty tty1 root 2642 0.0 0.1 1852 416 tty2 Ss+ 17:19 0:00 /sbin/mingetty tty2 root 2643 0.0 0.1 3064 416 tty3 Ss+ 17:19 0:00 /sbin/mingetty tty3 root 2644 0.0 0.1 1876 416 tty4 Ss+ 17:19 0:00 /sbin/mingetty tty4 root 2645 0.0 0.1 1500 412 tty5 Ss+ 17:19 0:00 /sbin/mingetty tty5 root 2951 0.0 0.1 3332 416 tty6 Ss+ 17:19 0:00 /sbin/mingetty tty6 root 3214 0.0 1.3 40360 3360 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3216 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3217 0.0 0.4 40360 1140 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid root 3218 0.0 0.4 40360 1076 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid root 3219 0.0 0.4 40360 1076 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid root 3220 0.0 0.4 40360 1076 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3221 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3222 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3223 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3224 0.0 0.4 40360 1076 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3225 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3226 0.0 0.4 40360 1076 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3227 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3228 0.0 0.4 40360 1076 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3229 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3230 0.0 0.4 40360 1076 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3231 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3232 0.0 0.4 40360 1160 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid root 3233 0.0 0.4 40364 1108 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3234 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3235 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3236 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3237 0.0 0.4 40360 1196 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3238 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3239 0.0 0.4 40360 1196 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3240 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3241 0.0 0.4 40360 1196 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3242 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3243 0.0 0.4 40360 1196 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid root 3244 0.0 0.4 40360 1200 ? S 17:20 0:00 /usr/local/sbin/openser -P /var/run/openser.pid mysql 3245 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3246 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3247 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3248 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys mysql 3249 0.0 18.7 439736 47852 ? S 17:20 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3253 0.4 0.8 8484 2264 ? Ss 17:22 0:00 sshd: root@pts/0 root 3255 0.0 0.5 5088 1428 pts/0 Ss 17:22 0:00 -bash mysql 3329 0.0 18.7 439736 47852 ? S 17:22 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mys root 3339 0.0 0.3 3152 768 pts/0 R+ 17:25 0:00 ps -aux [root@localhost ~]# BR Mike Li

16 years, 5 months

[OpenSER-Users] packet analyzing

by Pezhman Lali

Dear, What is the best solution for sip packet analyzing, on the busy server, to find the reason of one-way calling? best

16 years, 5 months

[OpenSER-Users] Critical issues about OPENSER PUA_XMPP.

by Gaoqiang Qian

Hi, I have setup the Openser 1.3.2 (mysql, presence, presence_xml, pua, xmpp, and Pua_xmpp) module for evaluation. Now I found two critical issue about the presence gateway of SIMPLE_XMPP module PUA_XMPP of openser. 1. missing two side authorisation, gateway only send sip level subsribe message to XMPP server, but the gateway needs to send similar XMPP level subscribe message what is seen in the other direction when a buddy is addded to the XMPP clients' roster. 2. empty NOTIFY for initial SIP SUBSRIBE request Please verify me if this is the known issue going to be fixed later or configuration bug. Thanks a lot. Br, Gaoqiang -- Gaoqiang Qian

16 years, 5 months

Re: [OpenSER-Users] OPenser+mediaproxy

by David Villasmil

> > >> > select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from radacct where >> > (1=1) and Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00' >> and >> > (ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '') >> > >> > >> > MediaInfo (after update from mediaproxy) is NOT null... the rest of the >> > fields are ok. >> >> Look again at the SQL query of above: >> >> MediaInfo is NULL or MediaInfo != '' >> >> It's not needed that MediaInfo is NULL, it can be any value except NULL or >> empty string. >> > That's it, it IS an empry string, so it will never rate it

16 years, 5 months

[OpenSER-Users] openser board updates

by Daniel-Constantin Mierla

Hello, Cesc Santasusana has retired from the board of OPENSER as he is no longer involved in projects using OPENSER -- he may come back in the near future. I want to thank Cesc for all his contributions in technical and organizational aspects of OPENSER. To complete the board, Henning Westerholt will take his seat. Now, one of the main tasks of the board is to define the election mechanisms for board members, where the community has a relevant contribution. Welcome to Henning, who did a lot of improvements to OPENSER and advocated the project to many events worldwide. His experience from other open source projects will help a lot. Cheers, Daniel -- http://www.asipto.com

16 years, 5 months

Re: [OpenSER-Users] Enter Dialog info to database

by Ali Jawad

Well I did :-) and it did not work, no info is written into the db With Regards Ali Jawad System Administrator Splendor Telecom (www.splendor.net) Beirut, Lebanon Phone: +961 1 373725 Fax: + 961 1 375554 ________________________________ From: David Villasmil [mailto:david.villasmil.work@gmail.com] Sent: Tuesday, June 17, 2008 3:27 PM To: Ali Jawad Subject: Re: [OpenSER-Users] Enter Dialog info to database try it and you'll see ;) On Tue, Jun 17, 2008 at 2:22 PM, Ali Jawad <ali.jawad(a)splendor.net> wrote: Hi I am setting the flag as follows if (is_method("INVITE")) { setflag(4); } Is that the correct way ? With Regards ________________________________ From: David Villasmil [mailto:david.villasmil.work@gmail.com] Sent: Tuesday, June 17, 2008 3:21 PM To: Ali Jawad Subject: Re: [OpenSER-Users] Enter Dialog info to database You have to set the flag on incoming INVITEs to enable db on the dialog. On Tue, Jun 17, 2008 at 2:18 PM, Ali Jawad <ali.jawad(a)splendor.net> wrote: Hi All I have the following dialog module setup # ----- Dialog ----------- modparam("dialog", "db_url","mysql://openser:xxxxxxxxxxxxx@localhost/openser") modparam("dialog", "db_mode", 1) modparam("dialog", "dlg_flag", 4) modparam("dialog", "enable_stats", 1) modparam("dialog", "rr_param", "did") If I execute /usr/local/sbin/openserctl fifo dlg_list I get the dialogs that are taking place. However there is nothing written into the database even for calls longer than 2 minute Anything I missed here? Thanks _______________________________________________ Users mailing list Users(a)lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean.

16 years, 5 months

Re: [OpenSER-Users] OPenser+mediaproxy

by David Villasmil

This is obvioulsy the problem, if I go and set MediaInfo to NULL by hand, the call get rated! ----- Original Message ----- From: David Villasmil To: openser users Sent: Tuesday, June 17, 2008 2:42 PM Subject: Re: [OpenSER-Users] OPenser+mediaproxy Looking at mysql's log, this is what I see: ---> BY OPENSER_: 24 Query INSERT INTO radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, AcctStartTime, AcctStopTime, AcctSessionTime, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, ENUMtld, FramedIPAddress, AcctStartDelay, AcctStopDelay, SipResponseCode, SipMethod, SipTranslatedRequestURI, SipToTag, SipFromTag, SipRPID, SourceIP, SourcePort, CanonicalURI) VALUES (NULL, 'OWNhNDAwMmIyOTM5NDU3MjQ4MGJjMTk2YWIwZmE0NGE.', 'd986b295f8a55559', '', SUBSTRING_INDEX('', '@',-1), '1.2.3.4', '5060', '2008-06-17 08:27:52', '0', '0', '0', '0', trim(leading 'sip:' from trim(leading 'sips:' from 'sip:0013058883456@1.2.3.4')), trim(leading 'sip:' from trim(leading 'sips:' from 'sip:915568911@1.2.3.4')), '200', 'Sip-Session', '', '', '0', '0', '200', 'Invite', trim(leading 'sip:' from trim(leading 'sips:' from 'sip:13058883456@5.6.7.8:5060=3Btransport=3Dudp')), '17062708081947605004610377', '34794a17', '', '9.8.7.6', '27374', trim(leading 'sip:' from trim(leading 'sips:' from '')) ) ------------------------------------------------------------------------------------------------------------------------------------------------- ---> THE CALL DROPS, THE BY MEDIAPROXY: 29 Connect openser@localhost on radius 29 Query SET NAMES latin1 29 Query UPDATE radacct SET AcctSessionTime = AcctSessionTime + IF(ConnectInfo_stop IS NULL, 53, 0), AcctStopTime = DATE_ADD(AcctStartTime, INTERVAL AcctSessionTime SECOND), AcctInputOctets = AcctInputOctets + 77488, AcctOutputOctets = AcctOutputOctets + 152760, SipUserAgents = 'eyeBeam release 1014c stamp 46090 + unknown-agent', SipCodecs = 'G729', SipApplicationType = 'Audio', MediaInfo = '', <------------------ LOOK AT THIS! ITS AN EMPTY STRING!! Normalized = '0' WHERE AcctSessionId = 'OWNhNDAwMmIyOTM5NDU3MjQ4MGJjMTk2YWIwZmE0NGE.' AND SipFromTag = '34794a17' AND SipToTag = '17062708081947605004610377' ------------------------------------------------------------------------------------------------------------------------------------------------- ---> THEN BY CDRTOOL, GETTING CDRs TO RATE: select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from radacct where (1=1) and Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00' and (ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '') <------------- CDRTOOL DOESN'T WANT AN EMPTY STRING!! ------------------------------------------------------------------------------------------------------------------------------------------------- this of course will never work, I wonder whether it is a configuration problem or a cdrtool/mediaproxy bug... Any thoughts? David

16 years, 5 months

[OpenSER-Users] Need help with running CDRTool with Openser

by Pete Kay

Hi, I am trying to setup CDRTool to work with Openser. After installation, I try to bring up the web UI and login with username=admin and password=admin. But it does not log me in. In the CDRTool DB, I can find the admin username in the auth_user table. Could someone tell me what could be wrong? Where can I check the log file for CDRTool? In the documentation, it says that CDRTool can provide 100% accuracy when use with MediaProxy. If I use rptProxy instead, can CDRTool still provide 100% accuracy? Thanks alot for all your help in advance. Regards, Pete

16 years, 5 months

[OpenSER-Users] Enter Dialog info to database

by Ali Jawad

Hi All I have the following dialog module setup # ----- Dialog ----------- modparam("dialog", "db_url","mysql://openser:xxxxxxxxxxxxx@localhost/openser") modparam("dialog", "db_mode", 1) modparam("dialog", "dlg_flag", 4) modparam("dialog", "enable_stats", 1) modparam("dialog", "rr_param", "did") If I execute /usr/local/sbin/openserctl fifo dlg_list I get the dialogs that are taking place. However there is nothing written into the database even for calls longer than 2 minute Anything I missed here? Thanks

16 years, 5 months

← Newer
1
...
7
8
9
10
11
12
13
...
23
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users June 2008