Re: [OpenSIPS-Users] Mediaproxy and Debian 8.11
Hi Simone, Thanks for your suggestion and we updated the download and install guide. Best regards, Tijmen de Mes — AG Projects > On 24 jul. 2018, at 15:17, Simone Sestini wrote: > > Dear Dan, > > this is very clear to me.. this way fix the issue .. but i can suggest you > and the stuff to update the Doc pages.. > > --> http://mediaproxy.ag-projects.com/download/ > > > The right way for configure is to add on the source list of apt the follow > lines.. where you need to substitude "jessie" with the debian release.. > > > deb http://ftp.debian.org/debian/ jessie-backports main > deb-src http://ftp.debian.org/debian/ jessie-backports main > > deb http://ag-projects.com/debian jessie main > deb-src http://ag-projects.com/debian jessie main > > > Thanks a lot for your support. > > Regards > > > > Il 24/07/18 13:27, Dan Pascu ha scritto: >> Your problem is that you mix debian 8.11 (jessie) with ag-projects' debian >> unstable repositories. >> >> Change your ag-projects repositories to read 'jessie main' instead of >> 'unstable main', rerun apt-get update and it should work. >> >> You might also consider adding the jessie-backports repository: >> >> deb http://ftp.it.debian.org/debian/ jessie-bakcports main >> deb-src http://ftp.it.debian.org/debian/ jessie-bakcports main >> >> Some of our software needs newer versions of some packages that are only >> available in the jessie-backports repository (not sure if mediaproxy is one >> of them, but others like blink or sipsimple are). >> >> On 24 Jul 2018, at 13:48, Simone Sestini wrote: >> >>> Hi, >>> >>> only the standard and official repository here.. >>> >>> --- >>> deb http://ftp.it.debian.org/debian/ jessie main >>> deb-src http://ftp.it.debian.org/debian/ jessie main >>> >>> deb http://security.debian.org/ jessie/updates main >>> deb-src http://security.debian.org/ jessie/updates main >>> >>> # jessie-updates, previously known as 'volatile' >>> deb http://ftp.it.debian.org/debian/ jessie-updates main >>> deb-src http://ftp.it.debian.org/debian/ jessie-updates main >>> >>> # AG Projects software >>> deb http://ag-projects.com/debian unstable main >>> deb-src http://ag-projects.com/debian unstable main >>> >>> --- >>> >>> and here the output for the policy you requested. >>> >>> test-rtp:~# apt-cache policy iptables mediaproxy-common >>> iptables: >>> Installato: 1.4.21-2+b1 >>> Candidato: 1.4.21-2+b1 >>> Tabella versione: >>> *** 1.4.21-2+b1 0 >>> 500 http://ftp.it.debian.org/debian/ jessie/main amd64 Packages >>> 100 /var/lib/dpkg/status >>> mediaproxy-common: >>> Installato: (nessuno) >>> Candidato: 2.6.6 >>> Tabella versione: >>> 2.6.6 0 >>> 500 http://ag-projects.com/debian/ unstable/main amd64 Packages >>> >>> >>> Thanks >>> >>> >>> Il 24/07/18 12:32, Dan Pascu ha scritto: >>>> Please paste apt's sources list (you can delete private repositories if >>>> you have any, I only want to see debian's and ag-projects' repositories). >>>> Alternatively you can paste the output from >>>> >>>> apt-cache policy iptables mediaproxy-common >>>> >>>> On 24 Jul 2018, at 12:20, Simone Sestini wrote: >>>> >>>>> Dear list.. >>>>> >>>>> I'm trying to install mediaproxy software on Debian 8.11. >>>>> >>>>> I'm looking around for a solution.. because i'm receiving >>>>> test-rtp:/# apt-get install mediaproxy-common mediaproxy-relay >>>>> mediaproxy-web-sessions >>>>> Lettura elenco dei pacchetti... Fatto >>>>> Generazione albero delle dipendenze >>>>> Lettura informazioni sullo stato... Fatto >>>>> Alcuni pacchetti non possono essere installati. Questo pu√≤ voler dire >>>>> che √® stata richiesta una situazione impossibile oppure, se si sta >>>>> usando una distribuzione in sviluppo, che alcuni pacchetti richiesti >>>>> non sono ancora stati creati o sono stati rimossi da Incoming. >>>>> Le seguenti informazioni possono aiutare a risolvere la situazione: >>>>> >>>>> I seguenti pacchetti hanno dipendenze non soddisfatte: >>>>>
Re: [OpenSIPS-Users] Could not start cdrtool 9.5.0
Hi,
Unfortunately some code still uses short open tags in PHP. Please check if
short_open_tag is set to On in /etc/php5/apache2/php.ini and
/etc/php5/cli/php.ini.
Best regards,
Tijmen de Mes
—
AG Projects
> On 7 jul. 2017, at 11:22, Aqs Younas <aqsyou...@gmail.com> wrote:
>
> Thanks for reply, David.
>
> I think you might missed the part of log.
>
> Jun 5 02:47:31 debian systemd[1]: Failed to start CDR mediation and rating
> engine for Call Details Records..
> Jun 5 02:47:31 debian systemd[1]: Unit cdrtool.service entered failed state.
> Jun 5 02:47:31 debian systemd[1]: cdrtool.service start request repeated too
> quickly, refusing to start.
> Jun 5 02:47:31 debian systemd[1]: Failed to start CDR mediation and rating
> engine for Call Details Records..
> Jun 5 02:47:31 debian systemd[1]: Unit cdrtool.service entered failed state.
>
> Well by manually running the Cdrtool it is failing too.
>
> root@debian:/var/www/CDRTool/scripts# php ratingEngine.php
> set_time_limit (0);
> ini_set('mbstring.func_overload', '0');
> ini_set('output_handler', '');
> @ob_end_flush();
>
> require('/etc/cdrtool/global.inc');
> require('cdr_generic.php');
> require('rating.php');
> require('rating_server.php');
>
> // Init Rating Engine
> syslog(LOG_NOTICE,"Starting CDRTool Rating Engine...");
>
> $RatingEngineServer = new RatingEngine();
>
> if (!$RatingEngineServer->init_ok) {
> syslog(LOG_NOTICE,'Error: Cannot start Rating Engine, fix the errors and
> try again');
> exit;
> }
>
> syslog(LOG_NOTICE,"Rating Engine started sucesfully, going to background...");
>
> // Go to the background
> $d = new Daemon('/var/run/ratingEngine.pid');
> $d->start();
>
> $daemon = new socketDaemon();
> $server = $daemon->create_server('ratingEngineServer', 'ratingEngineClient',
> $RatingEngine['socketIP'], $RatingEngine['socketPort']);
>
> syslog(LOG_NOTICE,"Rating Engine is now ready to serve network requests");
>
> $daemon->process();
>
> ?>
>
> It is simply printing the contents of script.
>
> I think it is due to php version compatibility issue. It is having compatible
> issues with php 5.6 even though release announcements proclaimed this.
>
> Any pointer?
> Best Regards.
>
> On 7 July 2017 at 05:10, David Villasmil <david.villasmil.w...@gmail.com
> <mailto:david.villasmil.w...@gmail.com>> wrote:
> I didn't see any errors, in fact it says the engine is ready... Seems to me
> like a startup script problem, the startup has changed in debian, maybe
> cdrtool hasn't been updated? Have you tried starting it up manually instead
> of using the startup script?
> On Thu, Jul 6, 2017 at 11:25 PM Aqs Younas <aqsyou...@gmail.com
> <mailto:aqsyou...@gmail.com>> wrote:
> Good Day.
>
> I am trying to start cdrtool 9.5.0 after installation on Debian Jessie 8.3
> having php 5.6.24 but it is failing with below errors.
>
> root@debian:~# /etc/init.d/cdrtool start
> [] Starting cdrtool (via systemctl): cdrtool.serviceJun 5 02:47:30
> debian ratingEngine.php[13021]: Jun 5 02:47:30 debian ratingEngine.php[13021]: set_time_limit (0);
> Jun 5 02:47:30 debian ratingEngine.php[13021]:
> ini_set('mbstring.func_overload', '0');
> Jun 5 02:47:30 debian ratingEngine.php[13021]: ini_set('output_handler', '');
> Jun 5 02:47:30 debian ratingEngine.php[13021]: @ob_end_flush();
> Jun 5 02:47:30 debian ratingEngine.php[13021]:
> require('/etc/cdrtool/global.inc');
> Jun 5 02:47:30 debian ratingEngine.php[13021]: require('cdr_generic.php');
> Jun 5 02:47:30 debian ratingEngine.php[13021]: require('rating.php');
> Jun 5 02:47:30 debian ratingEngine.php[13021]: require('rating_server.php');
> Jun 5 02:47:30 debian ratingEngine.php[13021]: // Init Rating Engine
> Jun 5 02:47:30 debian ratingEngine.php[13021]: syslog(LOG_NOTICE,"Starting
> CDRTool Rating Engine...");
> Jun 5 02:47:30 debian ratingEngine.php[13021]: $RatingEngineServer = new
> RatingEngine();
> Jun 5 02:47:30 debian ratingEngine.php[13021]: if
> (!$RatingEngineServer->init_ok) {
> Jun 5 02:47:30 debian ratingEngine.php[13021]: syslog(LOG_NOTICE,'Error:
> Cannot start Rating Engine, fix the errors and try again');
> Jun 5 02:47:30 debian ratingEngine.php[13021]: exit;
> Jun 5 02:47:30 debian ratingEngine.php[13021]: }
> Jun 5 02:47:30 debian ratingEngine.php[13021]: syslog(LOG_NOTICE,"Rating
> Engine started sucesfully, going to background...");
> Jun 5 02:47:30 debian ratingEngine.php[13021]: // Go to the background
> Jun 5 02:47:30 debian ratingEngine.php[13021]: $d = new
> Daemon('/var/run/ratingEngine.pid');
> Jun
Re: [OpenSIPS-Users] freeradius-xs / cdrtool / ag-projects
Hi Alex, Currently Debian 8 is not tested/supported for Freeradius-XS / CDRTool. Soon (I can't give you an ETA) we will build some new packages which should be compatible Debian >= 8. BTW the Freeradius-XS is not for the stored procedure, it contains patches to allow for FAILED type radius packets. I’ve to check if this is present in upstream, but I don’t think so. Best regards, Tijmen de Mes — AG Projects > On 21 jan. 2017, at 19:42, abc1 <haus.v...@gmail.com> wrote: > > Hi There > > I'm trying to install the freeradius-xs on Debian 8 - there are unmet > dependencies... > > The following packages have unmet dependencies: > freeradius-xs : Depends: libperl5.10 (>= 5.10.1) but it is not installable > Depends: libpython2.6 (>= 2.6) but it is not installable > Depends: libssl0.9.8 (>= 0.9.8m-1) but it is not installable > > I downloaded the source and I'm having issues there too.. > > //usr/src/freeradius-2.1.10/src/lib/.libs/libfreeradius-radius-2.1.10.so > <http://libfreeradius-radius-2.1.10.so/>: error adding symbols: DSO missing > from command line > collect2: error: ld returned 1 exit status > Makefile:33: recipe for target 'radeapclient' failed > > > Couple of questions - is this still necessary? Do the official freeradius not > have the stored procedure support yet? > I can see there is ubuntu xenial repo so would it be better to use this OS > now? > > What OS are you guys aiming for these days with packages, it used always be > debian - is this no longer the case? > > Thanks > Alex. > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users signature.asc Description: Message signed with OpenPGP using GPGMail ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDR search slow in CDRTool
Hi, As for the usability questions, from trusted peers it matches the ip to a reseller so this can be billed. The subscriber table is used to find the RPID from the local caller and get quotas. As for the delay, to me it sounds like a timeout of some sort if it is 10s each time. So you see the delay after this query? Can you tell me what it shows for ‘flow', and does the delay change based on the flow? Also does php5-geoip work? Best regards, Tijmen de Mes — AG Projects > On 30 nov. 2015, at 13:43, Tomas Andersen <tomas.ander...@ipco.no> wrote: > > Sorry for “spamming” the list, but the sql query request/response itself to > the subscriber list is fast. > So as you say there must be some more logic before the next caller is checked > that takes time. > CDRTool “waits” 10 seconds between each query. > > Regards, > Tomas > > > From: <users-boun...@lists.opensips.org > <mailto:users-boun...@lists.opensips.org>> on behalf of Tomas Andersen > Reply-To: OpenSIPS users mailling list > Date: Monday 30 November 2015 at 13:31 > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool > > Hi. > > Thank you for responding. I have now tried to add the parameter you specified > in my global.inc file. I have also added “skipNormalize” => 1. > The search does still use forever, and according to my RadiusAcct table all > CDRs are already normalized, as the value is set to 1. I don’t see why it > still should use that much time.. > as they already are normalized..? > > By checking wireshark, the calls to OpenSIPS db still searches for rpid in > the subscriber table and each call takes 10 minutes. > The latest search i did now resulted in 8 CDRs and the search took > 8x10seconds = 1m 20s. > > My concern is that CDRTool relies on a strict way to use OpenSIPS, as it need > certain tables to be filled out? > > We have made another approach to OpenSIPS and are using the grp table for > listing our subscribers (not the subscriber table). > We are also using dr_gateways to list our external Gateways (e.g other SIP > servers or external GWs). > > We do not use the trusted_peers or subscriber tables which I see are queried > from cdrtool. > > My hope was to use CDRTool to rate calls differently if the call is placed > internally (userloc-userloc) or from an internal user to an external user > (and then lookup destinations with country code). > > Do you see any limitations based on how we use OpenSIPS? > > I really appreciate if you could assist me in the question. > > Regards, > Tomas Andersen > > From: <users-boun...@lists.opensips.org > <mailto:users-boun...@lists.opensips.org>> on behalf of Tijmen de Mes > Reply-To: OpenSIPS users mailling list > Date: Monday 30 November 2015 at 13:01 > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool > > Hi Tomas, > > That query should not take 10 seconds. Here it completes in 0.02s according > to mysql. The query is used to determine the flow of the calls. After the > query is executed in CDRTool, more logic follows. It can easily be that the > delay is in there. > > If web normalizing is enabled and the call is not normalized, it will also > try to normalize and rate the calls while searching. This can be disabled if > you don’t need/want it. Perhaps you can disable this to check if this causes > the delay. > > To disable it add to the opensips datasource in global.inc: > "skipNormalizeOnPageLoad" => 1 > > > Best regards, > > Tijmen de Mes > — > AG Projects > > >> On 30 nov. 2015, at 10:26, Tomas Andersen <tomas.ander...@ipco.no >> <mailto:tomas.ander...@ipco.no>> wrote: >> >> Hi again. >> >> I have set up wireshark to check why the CDR rating engine uses so much time. >> >> The following SQL queries are run from CDRTool to my OpenSIPS server: >> select * from domain; >> select * from trusted_peers; >> Select rpid from subscriber where username = ‘+47’ and domain = >> ‘example.sip.com <http://example.sip.com/>’ >> >> (with username and domain scrambled here) >> >> The rpid select statement is run for each caller in the search period. What >> is strange is that these selects are only run each 10 second, and if I am >> searching >> Within a period of time and there has been 7 different callers, it will take >> 70 seconds. After this the GUI is “released” and updated with the maching >> CDR list. >> >> My subscriber table in open sips is empty. Why does this take so long? >> >>
Re: [OpenSIPS-Users] CDR search slow in CDRTool
Hi Tomas, That query should not take 10 seconds. Here it completes in 0.02s according to mysql. The query is used to determine the flow of the calls. After the query is executed in CDRTool, more logic follows. It can easily be that the delay is in there. If web normalizing is enabled and the call is not normalized, it will also try to normalize and rate the calls while searching. This can be disabled if you don’t need/want it. Perhaps you can disable this to check if this causes the delay. To disable it add to the opensips datasource in global.inc: "skipNormalizeOnPageLoad" => 1 Best regards, Tijmen de Mes — AG Projects > On 30 nov. 2015, at 10:26, Tomas Andersen <tomas.ander...@ipco.no> wrote: > > Hi again. > > I have set up wireshark to check why the CDR rating engine uses so much time. > > The following SQL queries are run from CDRTool to my OpenSIPS server: > select * from domain; > select * from trusted_peers; > Select rpid from subscriber where username = ‘+47’ and domain = > ‘example.sip.com’ > > (with username and domain scrambled here) > > The rpid select statement is run for each caller in the search period. What > is strange is that these selects are only run each 10 second, and if I am > searching > Within a period of time and there has been 7 different callers, it will take > 70 seconds. After this the GUI is “released” and updated with the maching CDR > list. > > My subscriber table in open sips is empty. Why does this take so long? > > Regards, > Tomas Andersen > > > From: Tomas Andersen > Date: Friday 27 November 2015 at 09:10 > To: "users@lists.opensips.org <mailto:users@lists.opensips.org>" > Subject: CDR search slow in CDRTool > > Hi > > I have set up CDRTool to read CDRs from my radius database for OpenSIP calls. > I am successfully rating calls, but everytime I search for CDR records using > the > CDRTool GUI it takes 1-3 minutes before the search result window is shown. > > If there are no matching records the result window is shown immediately. Does > anyone else have any experience with this? I suspect that there might be a > database lock, > Database connection pool problems or just some configuration error somewhere. > > In my browser I get the following in my developer console / network (note the > huge duration for the HTTP POST): > > 200 POST callsearch.pthml > html105.41 kb > 150212 ms > 200 GET date picker.css > css9.96 kb > 14 ms > > Followed by several lines of > 304 GETs > > > When checking with Wireshark I notice that after the HTTP POST to callsearch, > I get several TCP Keep-Alive messages as the server is slow.. > After 2m 38 seconds everything is suddenly released and some HTTP GETs make > the page to update. > > I see nothing in syslog (from cdrtool) but some mysql connection statements.. > No lock/unlock or similar statements.. > > I appreciate if anyone could enlighten me on this subject. > > > Best Regards, > Tomas Andersen > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users signature.asc Description: Message signed with OpenPGP using GPGMail ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRtool 9.3 web interface
Hi, I see the problem now. I will send a patch to you private email which you can apply to CDRTool. Hopefully it will fix this problem. Best regards, Tijmen de Mes — AG Projects On 3 mrt. 2015, at 17:02, Adrià Vidal adriavi...@gmail.com wrote: 2015-03-03 11:30 GMT+01:00 Tijmen de Mes tij...@ag-projects.com mailto:tij...@ag-projects.com: Hi, Clicking on the icons does not work. If you click on the input field you should get a date picker. If you don’t get it please take a look at the webbrowsers console if get any error or exception. Best regards, Tijmen de Mes I see no input field to click on https://www.dropbox.com/s/w55ynwrc1kbps6d/Captura%20de%20pantalla%202015-03-03%2017.02.14.png?dl=0 https://www.dropbox.com/s/w55ynwrc1kbps6d/Captura%20de%20pantalla%202015-03-03%2017.02.14.png?dl=0 -- -- Adrià Vidal T. 93 150 31 80 | M 607 28 89 56 @ ad...@gmail.com mailto:ad...@gmail.com www www.xpreme.net http://www.xpreme.net/ | centralitaip.xpreme.net http://centralitaip.xpreme.net/ twitter xpreme_it https://twitter.com/intent/user?screen_name=xpreme_it___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users signature.asc Description: Message signed with OpenPGP using GPGMail ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRtool 9.3 web interface
Hi, Clicking on the icons does not work. If you click on the input field you should get a date picker. If you don’t get it please take a look at the webbrowsers console if get any error or exception. Best regards, Tijmen de Mes — AG-Projects On 3 mrt. 2015, at 10:44, Adrià Vidal adriavi...@gmail.com wrote: I'm facing a problem with CDRTool 9.3, on the web interface i can't select the date or time, i try to click the icons but nothing happen. I've located the problem at cdr_generic.php $f-show_element(begin_date,); print span class=\add-on\ i class=\icon-calendar\/i /span/div ; p.d. I've tried with different browsers/systems too -- -- Adrià Vidal ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users signature.asc Description: Message signed with OpenPGP using GPGMail ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRtool
Hi,
At this point in the code the call is already prepaid since the account has
been found with the query:
$query=sprintf(select * from %s where account =
'%s',addslashes($this-prepaid_table),addslashes($CDR-BillingPartyId));
Normally if the normalized number starts with a 0 it is routed to PSTN, what in
most cases has a price. If a number resolves over ENUM, the Normalized URI
would not start with a 0, but will be a sip account.
This is just a convention we made and therefore you also should not have
accounts starting with a 0
--
Tijmen de Mes
AG-Projects
From: Pavel Eremin eremina@gmail.com
Reply: OpenSIPS users mailling list users@lists.opensips.org
Date: 29 september 2014 at 18:30:00
To: OpenSIPS users mailling list users@lists.opensips.org
Subject: Re: [OpenSIPS-Users] CDRtool
This code in rating.php...
2014-09-29 22:18 GMT+06:00 Pavel Eremin eremina@gmail.com:
Hi, All! Let's dance with CDRTool
I am trying to use it on heavy load system and get stack.
Why in this code author match canonical number with string started by 0?(in
hard way) Because of this line all calls are postpaid...:(
if (!preg_match(/^0[9-0]{1,}@/,$CDR-CanonicalURINormalized)) {
$log=sprintf (MaxSessionTime=unlimited Type=prepaid CallId=%s
BillingParty=%s DestId=None,$NetFields['callid'],$CDR-BillingPartyId);
syslog(LOG_NOTICE, $log);
$this-logRuntime();
$ret=none.\n.type=prepaid;
return $ret;
} else {
if (!$CDR-DestinationId) {
$log = sprintf (error: cannot figure out the destination
id for %s,$CDR-CanonicalURI);
$this-logRuntime();
syslog(LOG_NOTICE, $log);
$ret=$log.\n.type=prepaid;
return $ret;
}
}
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question
Hi, The latest code from darcs should be compatible with 5.4. Soon there will be a release with this included. -- Tijmen de Mes AG-Projects From: Craig Guy craig.a@gmail.com Reply: OpenSIPS users mailling list users@lists.opensips.org Date: 25 augustus 2014 at 06:31:20 To: OpenSIPS users mailling list users@lists.opensips.org Subject: Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question CDRTool will not work with PHP 5.4, you'll need to use PHP 5.3. Craig On 23 August 2014 21:41, Mo Rajib mrajib...@yahoo.com wrote: Satish, When you installed CDRTool with opensips, what PHP version did you use? I am running PHP 4.4 and I suspect that CDRTool is not yet compatible with PHP 4.4. Thanks, Mo ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently
Hi, It is in CDRTool. Soon we will release a new version of call control which should be safe if OpenSIPS does not have support for this. -- Tijmen de Mes AG-Projects On 7 augustus 2014 at 04:16:01, osiris123d (duane.lar...@gmail.com) wrote: I fell off this for a while. Did this ever get officially put into CDRTool? -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Re-CDRTool-Rating-Origination-and-Termination-differently-tp7589320p7592835.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Radius accounting for CDRTool
Hi, I’ve updated the docs and included a sample for OpenSIPS 1.10: http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide#OpenSIPS-setup If you are unable to make it work with this sample, please look at the docs of the acc module. -- Tijmen de Mes AG-Projects On 22 juli 2014 at 08:49:39, Jay Desai (rangeare...@gmail.com) wrote: Hi, I'm trying to configure CDRTool with opensips 1.8 as per the installation document from http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide, since acc and other modules have been changed, I'm unable to send radius accounting to MySQL. Is there a documentation available to configure opensips with CDRTool? Thanks, Jay ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Is Freeradius-xs agproject package is Available for Ubuntu X86 Architecture ???
Hi, Thanks for the info, I build a package for precise - x86_64 and pushed it to our repo. (apt-get update apt-get install freeradius-xs should work now) The difference between *-xs and normal is indeed inclusion of the failed patch and some config changes and the include of some extra dictionaries for OpenSIPS and Mediaproxy -- Tijmen de Mes AG-Projects On 26 mei 2014 at 07:51:13, Venkatesh Macha (linuxven...@gmail.com) wrote: Hi Tijmen de Mes, Thanks for your reply and sorry for late reply.. Here is my system architecture Distributor ID :Ubuntu Description : Ubuntu 12.04.4 LTS Release : 12.04 Codename : precise and my architecture is *x86_64 (64-bit).* And i am able to install freeradius-xs in my 32-bit ubuntu it is working fine for Prepaid billing i am able to see CDR's in database and from Web Interface also. But for 64bit ubuntu i am experiencing these problem. I also have another doubt(or Confused) Tijmen, *What is the main Difference between freeradius and freeradius-xs ?? *After reading our CDRTool Installation guide i got this thing *Freeradius server is not able to cope with FAILED packets. The server must be patched and recompiled if you wish to support accounting for failed SIP sessions.* is this only difference between freeradius and freeradius-xs?? please Correct me if anything went wrong.. Thank you in advance. Venkatesh Macha, @ sillycodes4u http://www.sillycodes4u.blogspot.in -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Is-Freeradius-xs-agproject-package-is-Available-for-Ubuntu-X86-Architecture-tp7591355p7591566.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently
Hi All, Already sent it to David in private, but will post it here to be complete. We have trouble with the patch for call control. We get: Feb 18 12:51:09 node04 call-control[19257]: error: 'Request' object has no attribute ‘application' I looked into in and the call_control module of OpenSIPS seems to be not passing the application type. So is this module also patched ? -- Tijmen de Mes AG-Projects On 12 februari 2014 at 21:05:32, David M. Lee (d...@digium.com) wrote: For everyone following along at home: I’ve updated my CDRTool patch (again) to fix MaxSessionTime and ShowPrice commands, and fix some minor issues that cropped up with DebitBalance. CDRTool patch - https://gist.github.com/leedm777/8585690 I’ve also discovered that the call_control daemon also needs to be patched to pass through the SIP Application Type from the call_control module onto the CDRTool prepaid engine. callcontrol patch - https://gist.github.com/leedm777/8926025 I’ll be sending both patches to de...@ag-projects.com. Feedback welcome on both! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org On Feb 6, 2014, at 9:29 AM, David M. Lee d...@digium.com wrote: I figured that out. I’ve updated the patch on my gist, and updated the rating doc to include a description of how the subtypes work. I’m sending the patch to de...@ag-projects.com now. Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org On Jan 28, 2014, at 6:12 AM, Tijmen de Mes tij...@ag-projects.com wrote: Hi, I run into trouble and reversed the patch. In the rating engine (telnet) DebitBalance function does not return anything anymore with the patch applied, so something goes wrong. -- Tijmen de Mes AG-Projects On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) wrote: Hi I tested the patch and for now I don’t see any problem with it. Before adding it to trunk, can you update the rating docs and record all changes in 1 patch using darcs? After that I can apply it directly on trunk with your credentials. These instructions to submit the patch also apply on CDRTool: http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport You don’t need to open a ticket however, just tell me after you send the patch. -- Tijmen de Mes AG-Projects On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote: Ugh Nevermind. My Max Duration was set to 6 on the Destinations rate setup. I set it to zero and I think things are looking better now. Think I'm done for the day. Good work David! Really appreciate the patch. On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson duane.lar...@gmail.com wrote: Not sure my price is being calculated correctly. My audio.outbound should be $0.005 My audio.inbound should be $0.0035 Here is an example of a call that lasted 2:06 minutes and is audio.outbound Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. CallId=dc1e32b1ba18ff91a3 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos t=0.0050/60 Price=0.0005 PriceIn=0. Here is an example of a call that lasted 1:33 minutes and is audio.inbound Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. CallId=2e0334513a34964e7c0 a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C ost=0.0035/60 Price=0.0003 PriceIn=0. Looks like no matter what the duration is for the inbound calls it costs $0.0003 and the outbound calls all cost $0.0005. On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson duane.lar...@gmail.com wrote: David/Tijmen/Adrian, It is working for me too. Both inbound and outbound are being recognized and the different rates are being applied. I will keep looking at it while more calls are being made to make sure there are no unforeseen issues. On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes tij...@ag-projects.com wrote: Hi David, Thanks for the patch. If have some time Monday I will analyze it and give you some feedback so we include this in CDRTool. Besides the rating, I’ve to check if the code that now sets the the ‘route’ for the CDRs and if there are no problems. -- Tijmen de Mes AG-Projects On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote: I’ve got a first attempt at a patch: https://gist.github.com/leedm777/8585690 To get this to work, your CDR’s will have to record the application subtype. For me, I set $avp(s:call_class) = “audio.inbound” or “audio.outbound” as appropriate in the routes, and added Sip-Application-Type=$avp(s:call_class) to “radius_extra”. Billing rates will be matched on the full application, allowing different rates depending on the application subtype
Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently
Hi, I run into trouble and reversed the patch. In the rating engine (telnet) DebitBalance function does not return anything anymore with the patch applied, so something goes wrong. -- Tijmen de Mes AG-Projects On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) wrote: Hi I tested the patch and for now I don’t see any problem with it. Before adding it to trunk, can you update the rating docs and record all changes in 1 patch using darcs? After that I can apply it directly on trunk with your credentials. These instructions to submit the patch also apply on CDRTool: http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport You don’t need to open a ticket however, just tell me after you send the patch. -- Tijmen de Mes AG-Projects On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote: Ugh Nevermind. My Max Duration was set to 6 on the Destinations rate setup. I set it to zero and I think things are looking better now. Think I'm done for the day. Good work David! Really appreciate the patch. On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson duane.lar...@gmail.com wrote: Not sure my price is being calculated correctly. My audio.outbound should be $0.005 My audio.inbound should be $0.0035 Here is an example of a call that lasted 2:06 minutes and is audio.outbound Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. CallId=dc1e32b1ba18ff91a3 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos t=0.0050/60 Price=0.0005 PriceIn=0. Here is an example of a call that lasted 1:33 minutes and is audio.inbound Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. CallId=2e0334513a34964e7c0 a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C ost=0.0035/60 Price=0.0003 PriceIn=0. Looks like no matter what the duration is for the inbound calls it costs $0.0003 and the outbound calls all cost $0.0005. On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson duane.lar...@gmail.com wrote: David/Tijmen/Adrian, It is working for me too. Both inbound and outbound are being recognized and the different rates are being applied. I will keep looking at it while more calls are being made to make sure there are no unforeseen issues. On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes tij...@ag-projects.com wrote: Hi David, Thanks for the patch. If have some time Monday I will analyze it and give you some feedback so we include this in CDRTool. Besides the rating, I’ve to check if the code that now sets the the ‘route’ for the CDRs and if there are no problems. -- Tijmen de Mes AG-Projects On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote: I’ve got a first attempt at a patch: https://gist.github.com/leedm777/8585690 To get this to work, your CDR’s will have to record the application subtype. For me, I set $avp(s:call_class) = “audio.inbound” or “audio.outbound” as appropriate in the routes, and added Sip-Application-Type=$avp(s:call_class) to “radius_extra”. Billing rates will be matched on the full application, allowing different rates depending on the application subtype. It works with the simple testing I’ve been able to do on my desktop. Feedback, of course, is greatly appreciated. Duane - Does the patch work for you? Adrian - Any objections/concerns with this approach? If it looks good, I’ll work on updating the docs. Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org On Jan 23, 2014, at 4:43 AM, Adrian Georgescu a...@ag-projects.com wrote: I think it would be a good idea. Adrian On 22 Jan 2014, at 16:58, David Lee (digium) d...@digium.com wrote: Duane Larson wrote: I have been playing with CDRTool for a while but I am not sure if it is possible to rate Origination (Inbound) calls differently than Termination (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and for Termination I pay 0.005. Keep in mind these costs are for destination 1”. I've recently run into nearly the same situation. I tried overloading the Sip-Application-Type field, but it's limited by the supportedApplicationTypes array in cdr_generic.php. There also seems to be hard coded logic for the different application types. I think I will patch CDRTool so that you can have subtypes of application types (audio.inbound, audio.outbound, etc.). This would allow the billing rates to be a bit more specific for these situations. Thoughts? -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin
Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently
Hi I tested the patch and for now I don’t see any problem with it. Before adding it to trunk, can you update the rating docs and record all changes in 1 patch using darcs? After that I can apply it directly on trunk with your credentials. These instructions to submit the patch also apply on CDRTool: http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport You don’t need to open a ticket however, just tell me after you send the patch. -- Tijmen de Mes AG-Projects On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote: Ugh Nevermind. My Max Duration was set to 6 on the Destinations rate setup. I set it to zero and I think things are looking better now. Think I'm done for the day. Good work David! Really appreciate the patch. On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson duane.lar...@gmail.com wrote: Not sure my price is being calculated correctly. My audio.outbound should be $0.005 My audio.inbound should be $0.0035 Here is an example of a call that lasted 2:06 minutes and is audio.outbound Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. CallId=dc1e32b1ba18ff91a3 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos t=0.0050/60 Price=0.0005 PriceIn=0. Here is an example of a call that lasted 1:33 minutes and is audio.inbound Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. CallId=2e0334513a34964e7c0 a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C ost=0.0035/60 Price=0.0003 PriceIn=0. Looks like no matter what the duration is for the inbound calls it costs $0.0003 and the outbound calls all cost $0.0005. On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson duane.lar...@gmail.com wrote: David/Tijmen/Adrian, It is working for me too. Both inbound and outbound are being recognized and the different rates are being applied. I will keep looking at it while more calls are being made to make sure there are no unforeseen issues. On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes tij...@ag-projects.com wrote: Hi David, Thanks for the patch. If have some time Monday I will analyze it and give you some feedback so we include this in CDRTool. Besides the rating, I’ve to check if the code that now sets the the ‘route’ for the CDRs and if there are no problems. -- Tijmen de Mes AG-Projects On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote: I’ve got a first attempt at a patch: https://gist.github.com/leedm777/8585690 To get this to work, your CDR’s will have to record the application subtype. For me, I set $avp(s:call_class) = “audio.inbound” or “audio.outbound” as appropriate in the routes, and added Sip-Application-Type=$avp(s:call_class) to “radius_extra”. Billing rates will be matched on the full application, allowing different rates depending on the application subtype. It works with the simple testing I’ve been able to do on my desktop. Feedback, of course, is greatly appreciated. Duane - Does the patch work for you? Adrian - Any objections/concerns with this approach? If it looks good, I’ll work on updating the docs. Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org On Jan 23, 2014, at 4:43 AM, Adrian Georgescu a...@ag-projects.com wrote: I think it would be a good idea. Adrian On 22 Jan 2014, at 16:58, David Lee (digium) d...@digium.com wrote: Duane Larson wrote: I have been playing with CDRTool for a while but I am not sure if it is possible to rate Origination (Inbound) calls differently than Termination (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and for Termination I pay 0.005. Keep in mind these costs are for destination 1”. I've recently run into nearly the same situation. I tried overloading the Sip-Application-Type field, but it's limited by the supportedApplicationTypes array in cdr_generic.php. There also seems to be hard coded logic for the different application types. I think I will patch CDRTool so that you can have subtypes of application types (audio.inbound, audio.outbound, etc.). This would allow the billing rates to be a bit more specific for these situations. Thoughts? -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org
Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently
Hi David, Thanks for the patch. If have some time Monday I will analyze it and give you some feedback so we include this in CDRTool. Besides the rating, I’ve to check if the code that now sets the the ‘route’ for the CDRs and if there are no problems. -- Tijmen de Mes AG-Projects On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote: I’ve got a first attempt at a patch: https://gist.github.com/leedm777/8585690 To get this to work, your CDR’s will have to record the application subtype. For me, I set $avp(s:call_class) = “audio.inbound” or “audio.outbound” as appropriate in the routes, and added Sip-Application-Type=$avp(s:call_class) to “radius_extra”. Billing rates will be matched on the full application, allowing different rates depending on the application subtype. It works with the simple testing I’ve been able to do on my desktop. Feedback, of course, is greatly appreciated. Duane - Does the patch work for you? Adrian - Any objections/concerns with this approach? If it looks good, I’ll work on updating the docs. Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org On Jan 23, 2014, at 4:43 AM, Adrian Georgescu a...@ag-projects.com wrote: I think it would be a good idea. Adrian On 22 Jan 2014, at 16:58, David Lee (digium) d...@digium.com wrote: Duane Larson wrote: I have been playing with CDRTool for a while but I am not sure if it is possible to rate Origination (Inbound) calls differently than Termination (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and for Termination I pay 0.005. Keep in mind these costs are for destination 1”. I've recently run into nearly the same situation. I tried overloading the Sip-Application-Type field, but it's limited by the supportedApplicationTypes array in cdr_generic.php. There also seems to be hard coded logic for the different application types. I think I will patch CDRTool so that you can have subtypes of application types (audio.inbound, audio.outbound, etc.). This would allow the billing rates to be a bit more specific for these situations. Thoughts? -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] media proxy/Rtpproxy in opensips
Hi Nandini, The same things apply for media proxy, if there is no /var/run/mediaproxy/dispatcher.sock two things can be wrong, 1. It is not running, 2. the permissions are wrong on the socket. My guess is that you have the first case. Why do you want Mediaproxy and rtpproxy both running? Best regards, -- Tijmen de Mes AG Projects On 06/03/2013 01:28 PM, Flavio Goncalves wrote: Hi Nandini, The results are showing exactly the opposite, what you see in pas is your own command (grep). Without basic Linux knowledge, it will be a very hard mission to run OpenSIPS. Flavio E. Goncalves 2013/6/3 Nandini madhu sermj2...@gmail.com mailto:sermj2...@gmail.com Thanks for your reply. i have got the following output # ps -ef |grep rtpproxy opensips 4340 2876 0 16:35 pts/000:00:00 grep --color=auto rtpproxy so my rtpproxy is running on host opensips,i believe. still i could not solve the problem the errors are same :- un 3 16:38:05 opensips /usr/local/sbin/opensips[4373]: ERROR:rtpproxy:send_rtpp_command: can't send command to a RTP proxy Connection refused Jun 3 16:38:05 opensips /usr/local/sbin/opensips[4373]: ERROR:rtpproxy:send_rtpp_command: proxy udp:opensips:5 does not respond, disable it Jun 3 16:38:05 opensips /usr/local/sbin/opensips[4373]: WARNING:rtpproxy:rtpp_test: can't get version of the RTP proxy Jun 3 16:38:05 opensips /usr/local/sbin/opensips[4373]: WARNING:rtpproxy:rtpp_test: support for RTP proxy udp:opensips:5 has been disabled temporarily Jun 3 16:38:05 opensips /usr/local/sbin/opensips[4372]: ERROR:mediaproxy:mediaproxy_connect: failed to connect to /var/run/mediaproxy/dispatcher.sock: No such file or directory please help me. On Mon, Jun 3, 2013 at 4:27 PM, Flavio Goncalves fla...@voffice.com.br mailto:fla...@voffice.com.br wrote: You can use ps -ef |grep rtpproxy, Flavio E. Goncalves 2013/6/3 Nandini madhu sermj2...@gmail.com mailto:sermj2...@gmail.com Dear Flavio, Thanks for your prompt response. opensips server is running on 192.168.2.40.so http://192.168.2.40.so i have given that IP address,in rtpproxy. Please let me know, is it possible ,to check the rtpproxy is loaded, and on which ip address is it running Thanks in advance Nandini On Mon, Jun 3, 2013 at 4:05 PM, Flavio Goncalves fla...@voffice.com.br mailto:fla...@voffice.com.br wrote: Hi Nandini, The addresses specified at the module rtpproxy.so are not matching the addresses specified in the -s parameter of your rtpproxy daemons. Do you have two instances of the rtpproxy running in the addresses 127.0.0.1:5000 http://127.0.0.1:5000 and 192.168.2.40:5 http://192.168.2.40:5. Flavio E. Goncalves Dear All, i have integrated mediaproxy and Rtpproxy with opensips.To get audio call in voip clients. But iam getting the errors in /var/log/syslog as follows:- Jun 3 14:19:48 opensips /usr/local/sbin/opensips[3706]: ERROR:rtpproxy:send_rtpp_command: can't send command to a RTP proxy Connection refused Jun 3 14:19:48 opensips /usr/local/sbin/opensips[3706]: ERROR:rtpproxy:send_rtpp_command: proxy udp:127.0.0.1:5 http://127.0.0.1:5 does not respond, disable it Jun 3 14:19:48 opensips /usr/local/sbin/opensips[3706]: WARNING:rtpproxy:rtpp_test: can't get version of the RTP proxy Jun 3 14:19:48 opensips /usr/local/sbin/opensips[3706]: WARNING:rtpproxy:rtpp_test: support for RTP proxy udp:127.0.0.1:5 http://127.0.0.1:5 has been disabled temporarily Jun 3 14:19:48 opensips /usr/local/sbin/opensips[3706]: ERROR:rtpproxy:send_rtpp_command: can't send command to a RTP proxy Connection refused Jun 3 14:19:48 opensips /usr/local/sbin/opensips[3706]: ERROR:rtpproxy:send_rtpp_command: proxy udp:192.168.2.40:5 http://192.168.2.40:5 does not respond, disable it Jun 3 14:19:48 opensips /usr/local/sbin/opensips[3706]: WARNING:rtpproxy:rtpp_test: can't get version
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi,
You give the solution yourself. After the normalize the number need to
be in the form 00 for PSTN destinations.
--
Tijmen de Mes
AG Projects
On 03/25/2013 07:38 PM, Willian Mazzardo - SYSSVOIP wrote:
Hi again.
Trying Rate module, i have this info:
2013-03-25 15:32:13 on-net 559101001@187.xX
audio 96X@187.5X 00:03 0. 0 0
The rate is 0., but into Rates, I have Destination = 9 and the
tariff.
Into telnet command i tried this:
ShowPrice From=sip:559101001@187.XXX
To=sip:00559X@187.5XXX Gateway=187.5XXX Duration=59
0.0525
Increment: 6 s
Min duration: 30 s
Duration: 60 s
App: audio
Destination: 55
Customer: subscriber=559101001@187.5XX
Connect: 0.
StartTime: 2013-03-25 15:18:47
--
Span: 1
Duration: 60 s
ProfileId: grn_premium / weekday
RateId: grn_premium / 0-24h
Rate: 0.0525 / 60 s
Price: 0.0525
but when I put To=sip:96XX@187.XXX the return is 0.
What am I missing?
Thanks
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030
2013/3/25 Willian Mazzardo - SYSSVOIP will...@syssvoip.com.br
mailto:will...@syssvoip.com.br
Hi ... another thing.
Please review CSV files for importing sample data, because those
errors:
Mar 25 14:10:34 xen cdrtool[31701]: Database error for query
insert into log
(date,login,ip,url,results,description,datasource,reseller_id)#012
values
(NOW(),'ImportScript','localhost','customers.csv-e50d270391eb500aea66cc52600888d4','','Imported
/var/spool/cdrtool/customers.csv','/var/spool/cdrtool',0): Field
'reedit' doesn't have a default value (1364)
and
Reading file /var/spool/cdrtool/customers.csv
Importing customers from /var/spool/cdrtool/customers.csv for
reseller 0:
Database error for query insert into billing_customers
(
reseller_id,
gateway,
domain,
subscriber,
profile_name1,
profile_name2,
timezone,
profile_name1_alt,
profile_name2_alt
) values (
'0',
'',
'',
'',
'grn_premium',
'grn_premium',
'Europe/Amsterdam',
'',
''
): Field 'increment' doesn't have a default
value (1364)Database error for query insert into log
(date,login,ip,url,results,description,datasource,reseller_id)
values
(NOW(),'ImportScript','localhost','customers.csv-e50d270391eb500aea66cc52600888d4','','Imported
/var/spool/cdrtool/customers.csv','/var/spool/cdrtool',0): Field
'reedit' doesn't have a default value (1364)Reading file
/var/spool/cdrtool/destinations.csv
Thanks
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030 tel:55%203537%202030
2013/3/25 Willian Mazzardo - SYSSVOIP will...@syssvoip.com.br
mailto:will...@syssvoip.com.br
Hi ... I`ve made the change in sql.conf
from FROM_UNIXTIME(blablabla) to '%S' and worked.
now I will see how to get rating work.
Thanks for your help Tijmen !! great job.
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030 tel:55%203537%202030
2013/3/25 Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com
Hi,
This is generated by the first radius server the ACC is
arriving. If you use only 1 server without any proxy,
relay or forwarding, I guess you can also use the %S
since there is no possibility to measure the network delay
in this case.
Best regards,
--
Tijmen de Mes
AG Projects
On 03/25/2013 03:58 PM, Willian Mazzardo - SYSSVOIP wrote:
Yes .. but how ? the filed in there is ${Event-Timestamp}
... but where is this generated?
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030 tel:55%203537%202030
2013/3/25 Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com
Hi,
If you find the cause for this, the problem will be
solved:
You see it FROM_UNIXTIME(), is empty , so that
won't work. You have to find out why the
event
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi,
Please check sql.conf in freeradius. The event timestamp should be a
timeststamp not a datetime.
What do you have configured there? It should be like
FROM_UNIXTIME(%{Event-Timestamp}), \
--
Tijmen de Mes
AG Projects
On 03/24/2013 06:34 AM, Willian Mazzardo - SYSSVOIP wrote:
I think I have found the problem
see the log:
Going to the next request
Ready to process requests.
rad_recv: Accounting-Request packet from host 127.0.0.1 port 45662,
id=207, length=327
Acct-Status-Type = Failed
Service-Type = Sip-Session
Sip-Response-Code = 487
Sip-Method = Invite
Event-Timestamp = Mar 24 2013 02:26:30 BRT
Sip-From-Tag = 2008462333
Sip-To-Tag = as4a8dfb83
Acct-Session-Id = 411815482
User-Name = 559101999@187.53.208.109 mailto:559101999@187.53.208.109
Calling-Station-Id = sip:559101999@187.53.208.109
mailto:sip%3A559101999@187.53.208.109
Called-Station-Id = sip:05596412757@187.53.208.109
mailto:sip%3A05596412757@187.53.208.109
Sip-Translated-Request-URI = sip:96412757@177.126.178.106
mailto:sip%3A96412757@177.126.178.106
Canonical-URI = sip:96412757@187.53.208.109
mailto:sip%3A96412757@187.53.208.109
User-Agent = Linphone/3.5.2 (eXosip2/3.6.0)
Contact = sip:559101999@192.168.10.110:5066
http://sip:559101999@192.168.10.110:5066
NAS-Port = 5060
Acct-Delay-Time = 0
NAS-IP-Address = 127.0.0.1
# Executing section preacct from file /etc/freeradius/radiusd.conf
+- entering group preacct {...}
++[preprocess] returns ok
[suffix] Looking up realm 187.53.208.109 for User-Name =
559101999@187.53.208.109 mailto:559101999@187.53.208.109
[suffix] No such realm 187.53.208.109
++[suffix] returns noop
++[files] returns noop
# Executing section accounting from file /etc/freeradius/radiusd.conf
+- entering group accounting {...}
[detail] expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -
/var/log/freeradius/radacct/127.0.0.1/detail-20130324
http://127.0.0.1/detail-20130324
[detail]
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /var/log/freeradius/radacct/127.0.0.1/detail-20130324
http://127.0.0.1/detail-20130324
[detail] expand: %t - Sun Mar 24 02:26:50 2013
++[detail] returns ok
[sql] WARNING: Unknown module Sip-Application-Type in string
expansion %', '%{User-Agent}',
'%{From-Header}' )
[sql] expand: /var/log/freeradius/sqltrace-%Y%m%d.log -
/var/log/freeradius/sqltrace-20130324.log
rlm_sql (sql): Reserving sql socket id: 22
rlm_sql_mysql: MYSQL check_error: 1064 received
rlm_sql (sql): Couldn't insert SQL accounting FAILED record - You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '24 2013
02:26:30 BRT), FROM_UNIXTIME(Mar 24 2013 02:26:30 BRT), ' at line 1
rlm_sql_mysql: MYSQL check_error: 1064 received
rlm_sql_mysql: Cannot store result
rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '24 2013 02:26:30 BRT),
FROM_UNIXTIME(Mar 24 2013 02:26:30 BRT), ' at line 1'
rlm_sql (sql): Released sql socket id: 22
++[sql] returns fail
Finished request 2.
Cleaning up request 2 ID 207 with timestamp +29
Going to the next request
Ready to process requests.
I think is a DATE/TIME problem ...
Am I right?
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030
2013/3/23 Willian Mazzardo - SYSSVOIP will...@syssvoip.com.br
mailto:will...@syssvoip.com.br
Hi Tijmen... thanks for your help... I have installed, but in
mysql, the table radacct.201303 is not creating automatically.
How can I debug this?
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030 tel:55%203537%202030
2013/3/23 Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com
Hi,
I believe you can find everything you need in the install guide:
http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide
Best regards,
--
Tijmen de Mes
AG Projects
Op 24 mrt. 2013, om 02:38 heeft Willian Mazzardo - SYSSVOIP
will...@syssvoip.com.br mailto:will...@syssvoip.com.br het
volgende geschreven:
Hi... im sorry intruding this topic to talk about different,
but, have anyone some tutorial to install cdrtool in debian
with opensips?
Thanks
On Mar 23, 2013 10:31 PM, Tijmen de Mes
tij...@ag-projects.com mailto:tij...@ag-projects.com wrote:
Hi,
We had a bug which sneaked in due to another change and
this is already fixed in trunk and will be part of the
new release.
The patch is here:
http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421
Best regards
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi,
As I said the event-timestamp should be a 'timestamp', not at date. If
it is a date, from_unixtime will not work. If the timestamp is datetime,
like in your case, the FROM_UNIXTIME conversions are not needed. The
question is, why is the timestamp a datetime?
If you use %S it will take the date/time from the sql server. Please be
aware that this is not the start/stop date of the request.
Which radius version are you running? Are you sure the right
dictionaries are loaded? If you specify the application type manually it
will be always audio. In SIP more types are possible, like message.
Best regards,
--
Tijmen de Mes
AG Projects
On 03/25/2013 12:52 PM, Willian Mazzardo - SYSSVOIP wrote:
Hi ... it was like this ... but the date what the script was getting
2013-04-24 00:33 BRT blablabla and this is wrong ...
Yesterday I tried another sql.conf from other CDRTool version I had in
my server, wich is:
accounting_start_query = \
CALL insert_radacct_record( \
'radius', \
'%{Acct-Session-Id}', \
'%{Acct-Unique-Session-Id}', \
'%{Billing-Party}', \
'%{Billing-Party}', \
'%{SIP-Proxy-IP}', \
'%{NAS-Port}', \
*'%S', \*
'0', \
'0', \
'0', \
'0', \
'%{Called-Station-Id}', \
'%{Calling-Station-Id}', \
'%{Sip-Response-Code}', \
'%{Service-Type}', \
'%{ENUM-TLD}', \
'%{Framed-IP-Address}', \
'%{Acct-Delay-Time}', \
'0', \
'%{Sip-Response-Code}', \
'%{Sip-Method}', \
'%{Sip-Translated-Request-URI}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}', \
'%{Sip-RPId}', \
'%{Source-IP}', \
'%{Source-Port}', \
'%{Canonical-URI}', \
'', \
'', \
'audio', \
'%{User-Agent}', \
'%{From-Header}' \
)
accounting_stop_query = \
CALL update_radacct_record( \
'radius', \
*'%S', \*
'%{Acct-Delay-Time}', \
'%{Connect-Info}', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
accounting_update_query = \
CALL update_raddact_record_mediaproxy( \
'radius', \
'%{Acct-Session-Time}', \
'%{Acct-Input-Octets}', \
'%{Acct-Output-Octets}', \
'%{Sip-User-Agents}', \
'%{Media-Codecs}', \
'%{Sip-Application-Type}', \
'%{Media-Info}', \
'0', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
accounting_failed_query = \
CALL insert_radacct_record( \
'radius', \
'%{Acct-Session-Id}', \
'%{Acct-Unique-Session-Id}', \
'%{Billing-Party}', \
'%{Billing-Party}', \
'%{SIP-Proxy-IP}', \
'%{NAS-Port}', \
*'%S', \*
*'%S', \*
'0', \
'0', \
'0', \
'%{Called-Station-Id}', \
'%{Calling-Station-Id}', \
'%{Sip-Response-Code}', \
'%{Service-Type}', \
'%{ENUM-TLD}', \
'%{Framed-IP-Address}', \
'%{Acct-Delay-Time}', \
'0', \
'%{Sip-Response-Code}', \
'%{Sip-Method}', \
'%{Sip-Translated-Request-URI}', \
MD5(RAND()), \
'%{Sip-From-Tag}', \
'%{Sip-RPId}', \
'%{Source-IP}', \
'%{Source-Port}', \
'%{Canonical-URI}', \
'', \
'', \
'audio', \
'%{User-Agent}', \
'%{From-Header}' \
)
}
See the field wich have DATE-TIME, in this sql.conf file, have only
'%S', where the original sql.conf file has
FROM_UNIXTIME(%{Event-Timestamp}), \
FROM_UNIXTIME(%{Event-Timestamp}), \
In field ${Sip-Application-Type}, I had to put audio manually to
work too ...
Now CDRTool is working good, getting Date-Time correctly.
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi,
Please check if the following is present in the OpenSIPS dictionary:
### Attributes added by AG Projects ###
ATTRIBUTE Source-IP 214 string
ATTRIBUTE Source-Port215 string
ATTRIBUTE Canonical-URI 216 string
ATTRIBUTE Delay-Time 217 string
ATTRIBUTE Divert-Reason 219 string
ATTRIBUTE X-RTP-Stat 220 string
ATTRIBUTE From-Header221 string
ATTRIBUTE User-Agent 222 string
ATTRIBUTE Contact223 string
ATTRIBUTE Event 224 string
ATTRIBUTE Event-Timestamp230 integer
ATTRIBUTE SIP-Proxy-IP 231 string
ATTRIBUTE ENUM-TLD 232 string
Best regards,
--
Tijmen de Mes
AG Projects
On 03/25/2013 02:26 PM, Willian Mazzardo - SYSSVOIP wrote:
Hi ..
about date/time issue, what can I do to test? because the %S is
working and give me the right duration time of a call.
My freeradius is FreeRADIUS Version 2.1.10, for host
x86_64-pc-linux-gnu, built on Jan 7 2013 at 17:11:42
the dictionaries loaded are:
$INCLUDE/usr/share/freeradius/dictionary
# OpenSER dictionary
$INCLUDE/etc/freeradius/dictionary.opensips
# MediaProxy dictionary
$INCLUDE/etc/freeradius/dictionary.mediaproxy
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030
2013/3/25 Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com
Hi,
As I said the event-timestamp should be a 'timestamp', not at
date. If it is a date, from_unixtime will not work. If the
timestamp is datetime, like in your case, the FROM_UNIXTIME
conversions are not needed. The question is, why is the timestamp
a datetime?
If you use %S it will take the date/time from the sql server.
Please be aware that this is not the start/stop date of the request.
Which radius version are you running? Are you sure the right
dictionaries are loaded? If you specify the application type
manually it will be always audio. In SIP more types are possible,
like message.
Best regards,
--
Tijmen de Mes
AG Projects
On 03/25/2013 12:52 PM, Willian Mazzardo - SYSSVOIP wrote:
Hi ... it was like this ... but the date what the script was
getting 2013-04-24 00:33 BRT blablabla and this is wrong ...
Yesterday I tried another sql.conf from other CDRTool version I
had in my server, wich is:
accounting_start_query = \
CALL insert_radacct_record( \
'radius', \
'%{Acct-Session-Id}', \
'%{Acct-Unique-Session-Id}', \
'%{Billing-Party}', \
'%{Billing-Party}', \
'%{SIP-Proxy-IP}', \
'%{NAS-Port}', \
*'%S', \*
'0', \
'0', \
'0', \
'0', \
'%{Called-Station-Id}', \
'%{Calling-Station-Id}', \
'%{Sip-Response-Code}', \
'%{Service-Type}', \
'%{ENUM-TLD}', \
'%{Framed-IP-Address}', \
'%{Acct-Delay-Time}', \
'0', \
'%{Sip-Response-Code}', \
'%{Sip-Method}', \
'%{Sip-Translated-Request-URI}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}', \
'%{Sip-RPId}', \
'%{Source-IP}', \
'%{Source-Port}', \
'%{Canonical-URI}', \
'', \
'', \
'audio', \
'%{User-Agent}', \
'%{From-Header}' \
)
accounting_stop_query = \
CALL update_radacct_record( \
'radius', \
*'%S', \*
'%{Acct-Delay-Time}', \
'%{Connect-Info}', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
accounting_update_query = \
CALL update_raddact_record_mediaproxy( \
'radius', \
'%{Acct-Session-Time}', \
'%{Acct-Input-Octets}', \
'%{Acct-Output-Octets}', \
'%{Sip-User-Agents}', \
'%{Media-Codecs}', \
'%{Sip-Application-Type}', \
'%{Media-Info}', \
'0', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi, Yes I noticed the sample provided by CDRTool is outdated. I will update it. It should be: ### Attributes added by AG Projects ### ATTRIBUTE Source-IP 214 string ATTRIBUTE Source-Port215 string ATTRIBUTE Canonical-URI 216 string ATTRIBUTE Delay-Time 217 string ATTRIBUTE Divert-Reason 219 string ATTRIBUTE X-RTP-Stat 220 string ATTRIBUTE From-Header221 string ATTRIBUTE User-Agent 222 string ATTRIBUTE Contact223 string ATTRIBUTE Event 224 string ATTRIBUTE Event-Timestamp230 integer ATTRIBUTE SIP-Proxy-IP 231 string ATTRIBUTE ENUM-TLD 232 string ATTRIBUTE SIP-Application-Type 237 string So including the timestamp and Application type. Also event-timestamp should be integer. Best regards, -- Tijmen de Mes AG Projects On 03/25/2013 02:43 PM, Willian Mazzardo - SYSSVOIP wrote: Damn it!! #ATTRIBUTE Event-Timestamp 230 string Its commented !! I will try comment this out and make a test. Willian Mazzardo Depto TI - SYSSVOIP www.syssvoip.com.br http://www.syssvoip.com.br 55 3537 2030 2013/3/25 Tijmen de Mes tij...@ag-projects.com mailto:tij...@ag-projects.com Hi, Please check if the following is present in the OpenSIPS dictionary: ### Attributes added by AG Projects ### ATTRIBUTE Source-IP 214 string ATTRIBUTE Source-Port215 string ATTRIBUTE Canonical-URI 216 string ATTRIBUTE Delay-Time 217 string ATTRIBUTE Divert-Reason 219 string ATTRIBUTE X-RTP-Stat 220 string ATTRIBUTE From-Header221 string ATTRIBUTE User-Agent 222 string ATTRIBUTE Contact223 string ATTRIBUTE Event 224 string ATTRIBUTE Event-Timestamp230 integer ATTRIBUTE SIP-Proxy-IP 231 string ATTRIBUTE ENUM-TLD 232 string Best regards, -- Tijmen de Mes AG Projects On 03/25/2013 02:26 PM, Willian Mazzardo - SYSSVOIP wrote: Hi .. about date/time issue, what can I do to test? because the %S is working and give me the right duration time of a call. My freeradius is FreeRADIUS Version 2.1.10, for host x86_64-pc-linux-gnu, built on Jan 7 2013 at 17:11:42 the dictionaries loaded are: $INCLUDE/usr/share/freeradius/dictionary # OpenSER dictionary $INCLUDE /etc/freeradius/dictionary.opensips # MediaProxy dictionary $INCLUDE /etc/freeradius/dictionary.mediaproxy Willian Mazzardo Depto TI - SYSSVOIP www.syssvoip.com.br http://www.syssvoip.com.br 55 3537 2030 tel:55%203537%202030 ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi,
This is all just basic setup. I don't know your exact setup, I can only
guess.
You see it FROM_UNIXTIME(), is empty , so that won't work. You have to
find out why the event-timestamp attribute is now empty. To give you any
hints, what is in the detail file, and in which format, is the attribute
only defined once in the dictionaries?
As a side note, if you are using Debian, we have freeradius-xs package
for sqeeuze and sid which is preconfigured with all these things.
--
Tijmen de Mes
AG Projects
On 03/25/2013 02:51 PM, Willian Mazzardo - SYSSVOIP wrote:
Ok .. changed and freeradius is UP.
But, when I do some call, this is the trace:
[detail] expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -
/var/log/freeradius/radacct/127.0.0.1/detail-20130325
http://127.0.0.1/detail-20130325
[detail]
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /var/log/freeradius/radacct/127.0.0.1/detail-20130325
http://127.0.0.1/detail-20130325
[detail] expand: %t - Mon Mar 25 10:50:02 2013
++[detail] returns ok
[sql] expand: CALL update_radacct_record( 'radius',
FROM_UNIXTIME(%{Event-Timestamp}),
UNIX_TIMESTAMP('%S') - '%{Event-Timestamp}', '',
'%{X-RTP-Stat}', '%{Acct-Session-Id}',
'%{Sip-To-Tag}', '%{Sip-From-Tag}' ) - CALL
update_radacct_record( 'radius', FROM_UNIXTIME(),
UNIX_TIMESTAMP('2013-03-25 10:50:02') - '',
'', '',
'280e1cb527443026017094174eee1d7c@187.53.208.106:5060
http://280e1cb527443026017094174eee1d7c@187.53.208.106:5060',
'9309094362166693758', 'as18ead01f' )
[sql] expand: /var/log/freeradius/sqltrace-%Y%m%d.log -
/var/log/freeradius/sqltrace-20130325.log
rlm_sql (sql): Reserving sql socket id: 13
rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN
rlm_sql (sql): Attempting to connect rlm_sql_mysql #13
rlm_sql_mysql: Starting connect to MySQL server for #13
rlm_sql (sql): Connected new DB handle, #13
rlm_sql_mysql: MYSQL check_error: 1582 received
rlm_sql (sql): failed after re-connect
[sql] Couldn't update SQL accounting STOP record - Incorrect parameter
count in the call to native function 'FROM_UNIXTIME'
rlm_sql_mysql: MYSQL check_error: 1582 received
rlm_sql_mysql: Cannot store result
rlm_sql_mysql: MySQL error 'Incorrect parameter count in the call to
native function 'FROM_UNIXTIME''
rlm_sql (sql): Released sql socket id: 13
++[sql] returns fail
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi, If you find the cause for this, the problem will be solved: You see it FROM_UNIXTIME(), is empty , so that won't work. You have to find out why the event-timestamp attribute is now empty. To give you any hints, what is in the detail file, and in which format, is the attribute only defined once in the dictionaries? -- Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi,
This is generated by the first radius server the ACC is arriving. If you
use only 1 server without any proxy, relay or forwarding, I guess you
can also use the %S since there is no possibility to measure the network
delay in this case.
Best regards,
--
Tijmen de Mes
AG Projects
On 03/25/2013 03:58 PM, Willian Mazzardo - SYSSVOIP wrote:
Yes .. but how ? the filed in there is ${Event-Timestamp} ... but
where is this generated?
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br http://www.syssvoip.com.br
55 3537 2030
2013/3/25 Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com
Hi,
If you find the cause for this, the problem will be solved:
You see it FROM_UNIXTIME(), is empty , so that won't work.
You have to find out why the event-timestamp attribute is now
empty. To give you any hints, what is in the detail file, and
in which format, is the attribute only defined once in the
dictionaries?
--
Tijmen de Mes
AG Projects
___
Users mailing list
Users@lists.opensips.org mailto:Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi, We had a bug which sneaked in due to another change and this is already fixed in trunk and will be part of the new release. The patch is here: http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421 Best regards, -- Tijmen de Mes AG Projects Op 24 mrt. 2013, om 00:26 heeft dotnetdub dotnet...@gmail.com het volgende geschreven: On 23 March 2013 20:52, Laszlo las...@voipfreak.net wrote: +1 on this We will do our best to contribute a patch.. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool 9.1.1
Hi, I believe you can find everything you need in the install guide: http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide Best regards, -- Tijmen de Mes AG Projects Op 24 mrt. 2013, om 02:38 heeft Willian Mazzardo - SYSSVOIP will...@syssvoip.com.br het volgende geschreven: Hi... im sorry intruding this topic to talk about different, but, have anyone some tutorial to install cdrtool in debian with opensips? Thanks On Mar 23, 2013 10:31 PM, Tijmen de Mes tij...@ag-projects.com wrote: Hi, We had a bug which sneaked in due to another change and this is already fixed in trunk and will be part of the new release. The patch is here: http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421 Best regards, -- Tijmen de Mes AG Projects Op 24 mrt. 2013, om 00:26 heeft dotnetdub dotnet...@gmail.com het volgende geschreven: On 23 March 2013 20:52, Laszlo las...@voipfreak.net wrote: +1 on this We will do our best to contribute a patch.. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] opensips + freeradius + acc
Hi,
Are you sure database called 'radacct' ? Usually it is something like
'radius'. If it is radius the call needs to be:
CALL update_radacct_record('radius', '2013-03-19 14:14:07','0', '',
'','MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.',
'df421e69','as287910d5');
Best regards,
--
Tijmen de Mes
AG Projects
On 03/19/2013 02:45 PM, andrzej.ciu...@asterisk.edu.pl wrote:
Hello
I have started to use freeradius for acc. Using scripts from cdr-tool.
I have problem with update procedure after BYE.
Insert after answered call goes to the table radacct201303, but
after BYE, when prodecure update_radacct_record is called, there is no
result.
When I create UPDATE based on log from sqltrace log It works.
It looks like:
CALL update_radacct_record( 'radacct', '2013-03-19
14:14:07', '0', '', '',
'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.',
'df421e69', 'as287910d5' );
doesn't update record but handmade UPDATE:
UPDATE radacct201303 SET AcctStopTime = '2013-03-19 14:14:07',
AcctSessionTime = CONCAT( TIME_TO_SEC(TIMEDIFF('2013-03-19 14:14:07',
AcctStartTime)), '.', MICROSECOND(TIMEDIFF('2013-03-19 14:14:07',
AcctStartTime)) ),AcctStopDelay = '', ConnectInfo_stop
= '', RTPStatistics = '', Normalized = '0' WHERE AcctSessionId =
'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.' AND ((SipToTag =
'as287910d5' AND SipFromTag = 'df421e69') OR (SipFromTag =
'as287910d5' AND SipToTag = 'df421e69')) AND ConnectInfo_stop IS NULL
AND (MediaInfo IS NULL OR MediaInfo != 'timeout');
does.
Has someone had same problem ?
Greetings
Andrzej
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] opensips + freeradius + acc
Hi,
Something is not right. I used the exact same query as you did and here
it is successful:
mysql CALL update_radacct_record( 'radius', '2013-03-19 14:14:07',
'0', '', '',
'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.',
'df421e69', 'as287910d5' );
Query OK, 0 rows affected (0.00 sec)
That zero rows affected is because I don't have that session. Nothing
about wrong arguments or any other error.
Are you sure you have the right procedure and table layout? FYI we are
running mysql 5.1.49-3
Best regards,
--
Tijmen de Mes
AG Projects
On 03/19/2013 04:05 PM, andrzej.ciu...@asterisk.edu.pl wrote:
Hello
Yes database is radius, table is radacct. But when I change it to
database name I get error:
ERROR 1210 (HY000): Incorrect arguments to EXECUTE
But @v_db_name = var_db_name, is not used in procedure, after that:
table name is from:
@var_tbl_begin = (SELECT set_radacct_table_name()),
with concat of month.
Greetings
Andrzej
Cytowanie Tijmen de Mes tij...@ag-projects.com:
Hi,
Are you sure database called 'radacct' ? Usually it is something like
'radius'. If it is radius the call needs to be:
CALL update_radacct_record('radius', '2013-03-19 14:14:07','0', '',
'','MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.',
'df421e69','as287910d5');
Best regards,
--
Tijmen de Mes
AG Projects
On 03/19/2013 02:45 PM, andrzej.ciu...@asterisk.edu.pl wrote:
Hello
I have started to use freeradius for acc. Using scripts from cdr-tool.
I have problem with update procedure after BYE.
Insert after answered call goes to the table radacct201303, but
after BYE, when prodecure update_radacct_record is called, there is
no result.
When I create UPDATE based on log from sqltrace log It works.
It looks like:
CALL update_radacct_record( 'radacct', '2013-03-19 14:14:07', '0',
'', '',
'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.', 'df421e69',
'as287910d5' );
doesn't update record but handmade UPDATE:
UPDATE radacct201303 SET AcctStopTime = '2013-03-19 14:14:07',
AcctSessionTime = CONCAT( TIME_TO_SEC(TIMEDIFF('2013-03-19
14:14:07', AcctStartTime)), '.', MICROSECOND(TIMEDIFF('2013-03-19
14:14:07', AcctStartTime)) ),AcctStopDelay = '',
ConnectInfo_stop = '', RTPStatistics = '', Normalized = '0' WHERE
AcctSessionId = 'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.' AND
((SipToTag = 'as287910d5' AND SipFromTag = 'df421e69') OR
(SipFromTag = 'as287910d5' AND SipToTag = 'df421e69')) AND
ConnectInfo_stop IS NULL AND (MediaInfo IS NULL OR MediaInfo !=
'timeout');
does.
Has someone had same problem ?
Greetings
Andrzej
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool
Hi, Yes it needs to connect to radius to rate/normalize the calls. You can skip it by changing the database definition in global.inc for radius: var $Halt_On_Error =no; Best regards, -- Tijmen de Mes AG Projects On 02/06/2013 12:17 AM, leo wrote: Hello: I'm still having problems with the CDRTool. So, the new enviroment is: Debian: Squeeze 6.0.6 - 2.6.32-5-amd64 PHP: 5.3.3 CDRTool: 9.0.1 Now i've logs in the syslog: Feb 6 00:10:52 host cdrtool[7435]: Starting CDRTool Rating Engine... Feb 6 00:10:52 host cdrtool[7435]: Error in connect(): pconnect as radius to localhost failed Feb 6 00:10:52 host cdrtool[7435]: Database error: pconnect as radius to localhost failed. I didn't installed the radius part yet but from the documentation the Rating Engine should be listening on port 9024, but nothing is listening on port 9024. If I try php /var/www/CDRTool/scripts/ratingEngine.php i receive: Session halted. Could you give another clue on it? Thanks a lot. -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-tp7584388p7584449.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool
Hi, You can try to run it manually and see if it gives you any error. You can run the rating engine manually with: php /var/www/CDRTool/scripts/ratingEnginge.php Best regards, -- Tijmen de Mes AG Projects On 02/05/2013 12:13 AM, leo wrote: Hello: I'm trying to run a Kamalio Sip Server with CallControl and CDRTool on a Debian server. Debian: wheezy - 3.2.0-3-amd64 Kamalio: 3.3 This part is running fine. CallControl: 2.0.15 CDRTool: 9.0.1 I've installed CallControl and CDRToll according the instructions described on http://callcontrol.ag-projects.com/projects/callcontrol/wiki/Installation and http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide. The problem i'm having is with the CDRTool, it seems is not starting (invoke-rc.d cdrtool start) does not give any error and there isn't any info in /var/log/syslog. I believe it is not working because doing a netstat there isn't anything in port 9024 and the CallControl logs that is not able to connect. How could i debug this problem with the CDRTool? Thanks a lot. -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-tp7584388.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool
Hi, Yes CDRTool is not yet compatible with php 5.4. You should run it on php 5.3.x Best regards, -- Tijmen de Mes AG Projects On 02/05/2013 12:38 PM, Max Mühlbronner wrote: Hi, I just looked into this because i once had similar problems and this caught my interest... It seems like you have to change: $this-serialize($prefix.['.preg_replace(/([\\\'])/, 1, $k).'], $str); to $this-serialize($prefix.['.preg_replace(/([\\\'])/, 1, $k).'], $str); in /var/www/CDRTool/phplib/session.inc And also a few other instances in the session.inc. Background: http://stackoverflow.com/questions/12322811/call-time-pass-by-reference-has-been-removed Best Regards Max M. On 02/05/2013 11:58 AM, leo wrote: Hello Tijmen: Running it manually i receive the following output: php /var/www/CDRTool/scripts/ratingEnginge.php PHP Fatal error: Call-time pass-by-reference has been removed in /var/www/CDRTool/phplib/session.inc on line 259 # php -v PHP 5.4.4-11 (cli) (built: Dec 17 2012 08:39:10) Copyright (c) 1997-2012 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies Thanks -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-tp7584388p7584418.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool
Hi, We have not tested it in PHP 5.4.X. I can imagine, besides this, that other things could easily be broken as well. So there is always a chance you get more problems. Best regards, -- Tijmen de Mes AG Projects On 02/05/2013 03:23 PM, leo wrote: Thanks Max, that fixed the problem (i've also had to change lines 270, 30 and 308) Thanks Tijmen, your last reply answered one more question (regarding php version) Should i install php v3 or different: with php v4, could i found other problems? -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-tp7584388p7584434.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] AG Projects freeradius-xs
Hi Brian, The package was built for squeeze and on i386. Currently I've no time to repackage it, but you can always do apt-get source freeradius-xs; debuild to get it to work on your system with your perl. I expect I make a new package within a month or so. Best regards, -- Tijmen de Mes AG Projects On 12/21/2012 07:53 PM, dotnetdub wrote: Hi Ag Peeps, I'm trying to install free radius-xs on Ubuntu 12.04 and also on debian wheezy (testing) On Debian Testing I am getting: The following packages have unmet dependencies: freeradius-xs : Depends: libperl5.12 (= 5.12.4) but it is not installable E: Unable to correct problems, you have held broken packages. I have = 5.12.4 installed # perl -v This is perl 5, version 14, subversion 2 (v5.14.2) built for x86_64-linux-gnu-thread-multi (with 75 registered patches, see perl -V for more detail) On Ubuntu 12.04: The following packages have unmet dependencies: freeradius-xs : Depends: libperl5.10 (= 5.10.1) but it is not installable But I have = 5.10.1 installed: ubluntu# perl -v This is perl 5, version 14, subversion 2 (v5.14.2) built for x86_64-linux-gnu-thread-multi How can I get around this? Thanks as always! Brian ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - Unknown module Connect-Info
Hi Duane,
Please replace the stop query by:
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
Best regards,
--
Tijmen de Mes
AG Projects
On 11/10/2012 04:56 AM, Duane Larson wrote:
And just to add to what I already stated this is what I have in the
sql.conf in case someone asks
accounting_stop_query = \
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'%{Connect-Info}', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
On Fri, Nov 9, 2012 at 8:33 PM, Duane Larson duane.lar...@gmail.com
mailto:duane.lar...@gmail.com wrote:
I am trying to get a new CDRTool server up and running and I am
seeing the following issue with Freeradius after a call is
completed (I installed the ag-projects freeradius packages)
rad_recv: Accounting-Request packet from host 10.182.236.97 port
54401, id=41, length=324
Acct-Status-Type = Stop
Service-Type = Sip-Session
Sip-Response-Code = 200
Sip-Method = Bye
Event-Timestamp = 1352513799
Sip-From-Tag = ppkc6hfcm6
Sip-To-Tag = as70add6af
Acct-Session-Id = 00b99d506047-zch6q5chlhq1
User-Name = 9012014...@duanelarson.com
mailto:9012014...@duanelarson.com
Sip-Translated-Request-URI =
sip:9012014563@108.166.97.17:5060
http://sip:9012014563@108.166.97.17:5060
User-Agent = snom821/8.7.3.10 http://8.7.3.10
Contact = sip:9012014561
tel:9012014561@192.168.88.13:3073;line=ci5jnp3t;reg-id=1
From-Header = \Duane Larson\
sip:9012014...@duanelarson.com
mailto:sip%3a9012014...@duanelarson.com;tag=ppkc6hfcm6
NAS-Port = 5060
Acct-Delay-Time = 0
NAS-IP-Address = 10.182.236.97
# Executing section preacct from file /etc/freeradius/radiusd.conf
+- entering group preacct {...}
++[preprocess] returns ok
[acct_unique] Hashing 'Sip-To-Tag = as70add6af,Sip-From-Tag =
ppkc6hfcm6,Client-IP-Address = 10.182.236.97,Acct-Session-Id =
00b99d506047-zch6q5chlhq1'
[acct_unique] Acct-Unique-Session-ID = 3508a1820be8a06a.
++[acct_unique] returns ok
[suffix] Looking up realm duanelarson.com
http://duanelarson.com for User-Name =
9012014...@duanelarson.com mailto:9012014...@duanelarson.com
[suffix] No such realm duanelarson.com http://duanelarson.com
++[suffix] returns noop
# Executing section accounting from file /etc/freeradius/radiusd.conf
+- entering group accounting {...}
[detail]expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -
/var/log/freeradius/radacct/10.182.236.97/detail-20121109
http://10.182.236.97/detail-20121109
[detail]
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to
/var/log/freeradius/radacct/10.182.236.97/detail-20121109
http://10.182.236.97/detail-20121109
[detail]expand: %t - Fri Nov 9 20:16:39 2012
++[detail] returns ok
[sql] WARNING: *Unknown module Connect-Info* in string expansion
%', '%{X-RTP-Stat}', '%{Acct-Session-Id}',
'%{Sip-To-Tag}', '%{Sip-From-Tag}' )
rlm_sql (sql): Reserving sql socket id: 23
rlm_sql_mysql: MYSQL check_error: 1064 received
[sql] Couldn't update SQL accounting STOP record - You have an
error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ''' at
line 1
rlm_sql_mysql: MYSQL check_error: 1064 received
rlm_sql_mysql: Cannot store result
rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near ''' at line 1'
rlm_sql (sql): Released sql socket id: 23
++[sql] returns fail
Finished request 1.
Cleaning up request 1 ID 41 with timestamp +23
--
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - Unknown module Connect-Info
Hi,
It has to be removed. Connect-Info is not in the dictionary any more. In
version 1 freeradius skipped the field when it was not set or known,
unlike version 2. So that's why the sql broke, simply because the field
is not supplied.
I will push a patch to remove it from CDRTool as well, so the next
version has the right sql.conf.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/12/2012 04:17 PM, Duane Larson wrote:
That fixed it. Is there a reason why the latest
download cdrtool_9.0.0.tar.gz has
/cdrtool_9.0.0/CDRTool/setup/radius/OpenSIPS/sql.conf where it does
include the line
'%{Connect-Info}', \
?
On Mon, Nov 12, 2012 at 5:22 AM, Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com wrote:
Hi Duane,
Please replace the stop query by:
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
Best regards,
--
Tijmen de Mes
AG Projects
On 11/10/2012 04:56 AM, Duane Larson wrote:
And just to add to what I already stated this is what I have in
the sql.conf in case someone asks
accounting_stop_query = \
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'%{Connect-Info}', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
On Fri, Nov 9, 2012 at 8:33 PM, Duane Larson
duane.lar...@gmail.com mailto:duane.lar...@gmail.com wrote:
I am trying to get a new CDRTool server up and running and I
am seeing the following issue with Freeradius after a call is
completed (I installed the ag-projects freeradius packages)
rad_recv: Accounting-Request packet from host 10.182.236.97
port 54401, id=41, length=324
Acct-Status-Type = Stop
Service-Type = Sip-Session
Sip-Response-Code = 200
Sip-Method = Bye
Event-Timestamp = 1352513799
Sip-From-Tag = ppkc6hfcm6
Sip-To-Tag = as70add6af
Acct-Session-Id = 00b99d506047-zch6q5chlhq1
User-Name = 9012014...@duanelarson.com
mailto:9012014...@duanelarson.com
Sip-Translated-Request-URI =
sip:9012014563@108.166.97.17:5060
http://sip:9012014563@108.166.97.17:5060
User-Agent = snom821/8.7.3.10 http://8.7.3.10
Contact = sip:9012014561
tel:9012014561@192.168.88.13:3073;line=ci5jnp3t;reg-id=1
From-Header = \Duane Larson\
sip:9012014...@duanelarson.com
mailto:sip%3a9012014...@duanelarson.com;tag=ppkc6hfcm6
NAS-Port = 5060
Acct-Delay-Time = 0
NAS-IP-Address = 10.182.236.97
# Executing section preacct from file
/etc/freeradius/radiusd.conf
+- entering group preacct {...}
++[preprocess] returns ok
[acct_unique] Hashing 'Sip-To-Tag = as70add6af,Sip-From-Tag
= ppkc6hfcm6,Client-IP-Address =
10.182.236.97,Acct-Session-Id = 00b99d506047-zch6q5chlhq1'
[acct_unique] Acct-Unique-Session-ID = 3508a1820be8a06a.
++[acct_unique] returns ok
[suffix] Looking up realm duanelarson.com
http://duanelarson.com for User-Name =
9012014...@duanelarson.com mailto:9012014...@duanelarson.com
[suffix] No such realm duanelarson.com http://duanelarson.com
++[suffix] returns noop
# Executing section accounting from file
/etc/freeradius/radiusd.conf
+- entering group accounting {...}
[detail]expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -
/var/log/freeradius/radacct/10.182.236.97/detail-20121109
http://10.182.236.97/detail-20121109
[detail]
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /var/log/freeradius/radacct/10.182.236.97/detail-20121109
http://10.182.236.97/detail-20121109
[detail]expand: %t - Fri Nov 9 20:16:39 2012
++[detail] returns ok
[sql] WARNING: *Unknown module Connect-Info* in string
expansion %', '%{X-RTP-Stat}',
'%{Acct-Session-Id}', '%{Sip-To-Tag}',
'%{Sip-From-Tag}' )
rlm_sql (sql): Reserving sql socket id: 23
rlm_sql_mysql: MYSQL check_error: 1064 received
[sql] Couldn't update SQL accounting STOP record - You have
an error in your SQL
Re: [OpenSIPS-Users] CDRTool - Unknown module Connect-Info
Hi,
Why should I take out these fields? These are separate fields and should
be set by radius and your radius client.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/12/2012 04:35 PM, Duane Larson wrote:
Thanks Tijmen. So the OpenSIPS client shouldn't be sending the
Connect-Info like Adrian says? If that is the case then would you
also need to update the radius_accounting.proc and take out the
following
`CalledStationId` varchar(50) NOT NULL default '',
`CallingStationId` varchar(50) NOT NULL default '',
Not that it concerns me just I just remembered see the columns in the
database when I was trying to figure out this issue.
On Mon, Nov 12, 2012 at 9:27 AM, Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com wrote:
Hi,
It has to be removed. Connect-Info is not in the dictionary any
more. In version 1 freeradius skipped the field when it was not
set or known, unlike version 2. So that's why the sql broke,
simply because the field is not supplied.
I will push a patch to remove it from CDRTool as well, so the next
version has the right sql.conf.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/12/2012 04:17 PM, Duane Larson wrote:
That fixed it. Is there a reason why the latest
download cdrtool_9.0.0.tar.gz has
/cdrtool_9.0.0/CDRTool/setup/radius/OpenSIPS/sql.conf where it
does include the line
'%{Connect-Info}', \
?
On Mon, Nov 12, 2012 at 5:22 AM, Tijmen de Mes
tij...@ag-projects.com mailto:tij...@ag-projects.com wrote:
Hi Duane,
Please replace the stop query by:
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
Best regards,
--
Tijmen de Mes
AG Projects
On 11/10/2012 04:56 AM, Duane Larson wrote:
And just to add to what I already stated this is what I have
in the sql.conf in case someone asks
accounting_stop_query = \
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'%{Connect-Info}', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)
On Fri, Nov 9, 2012 at 8:33 PM, Duane Larson
duane.lar...@gmail.com mailto:duane.lar...@gmail.com wrote:
I am trying to get a new CDRTool server up and running
and I am seeing the following issue with Freeradius
after a call is completed (I installed the ag-projects
freeradius packages)
rad_recv: Accounting-Request packet from host
10.182.236.97 port 54401, id=41, length=324
Acct-Status-Type = Stop
Service-Type = Sip-Session
Sip-Response-Code = 200
Sip-Method = Bye
Event-Timestamp = 1352513799
Sip-From-Tag = ppkc6hfcm6
Sip-To-Tag = as70add6af
Acct-Session-Id = 00b99d506047-zch6q5chlhq1
User-Name = 9012014...@duanelarson.com
mailto:9012014...@duanelarson.com
Sip-Translated-Request-URI =
sip:9012014563@108.166.97.17:5060
http://sip:9012014563@108.166.97.17:5060
User-Agent = snom821/8.7.3.10 http://8.7.3.10
Contact = sip:9012014561
tel:9012014561@192.168.88.13:3073;line=ci5jnp3t;reg-id=1
From-Header = \Duane Larson\
sip:9012014...@duanelarson.com
mailto:sip%3a9012014...@duanelarson.com;tag=ppkc6hfcm6
NAS-Port = 5060
Acct-Delay-Time = 0
NAS-IP-Address = 10.182.236.97
# Executing section preacct from file
/etc/freeradius/radiusd.conf
+- entering group preacct {...}
++[preprocess] returns ok
[acct_unique] Hashing 'Sip-To-Tag =
as70add6af,Sip-From-Tag =
ppkc6hfcm6,Client-IP-Address =
10.182.236.97,Acct-Session-Id = 00b99d506047-zch6q5chlhq1'
[acct_unique] Acct-Unique-Session-ID = 3508a1820be8a06a.
++[acct_unique] returns ok
[suffix] Looking up realm duanelarson.com
http://duanelarson.com for User-Name =
9012014...@duanelarson.com
mailto:9012014...@duanelarson.com
[suffix] No such realm duanelarson.com
http://duanelarson.com
++[suffix] returns noop
# Executing section accounting from file
Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist
Hi,
I am unable to reproduce it. Just as a quick test can you insert an
iptables rule on the mysql server to divert requests on port 3306 from
the cdr machine to 19994? That way we can check if CDRTool tries to use
that port even though you specified an other and rule. You can even put
the config back then and see if it works then.
In my testing I changed the config to use 19994 and redirected the port
19994 to 3306 on the mysql server. I got no errors an all was working.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/07/2012 05:27 PM, Duane Larson wrote:
Ok. Just to test I swung back over to the old CDRTool mysql database
and everything works like normal (plus CDRTool is now version 9
instead of the older version I was running). Here is the global.inc
config for database connectivity.
class DB_CDRTool extends DB_Sql {
var $Host = 10.178.225.*;
var $Database = cdrtool;
var $User = user;
var $Password = pass;
var $Halt_On_Error =yes;
}
class DB_Locker extends DB_Sql {
var $Host = 10.178.225.*;
var $Database = cdrtool;
var $User = locker;
var $Password = pass;
var $Halt_On_Error =yes;
}
class DB_radius extends DB_Sql {
var $Host = 10.178.225.*;
var $Database = radius;
var $User = radadmin;
var $Password = pass;
var $Halt_On_Error =yes;
}
class DB_opensips extends DB_Sql {
var $Host = 10.178.225.*;
var $Database = opensips;
var $User = opensips;
var $Password = aether1234;
var $Halt_On_Error =yes;
}
class DB_mediaproxy extends DB_Sql {
var $Host = 10.178.225.*;
var $Database = mediaproxy;
var $User = mediaadmin;
var $Password = pass;
var $Halt_On_Error =yes;
}
So it works with the old mysql server but not with the new server.
On Wed, Nov 7, 2012 at 9:18 AM, Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com wrote:
Hi,
Ok, I can't see quickly where it goes wrong, in my opinion it
should just work.
Tomorrow I can do some tests to see if I can track where it goes
wrong.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/07/2012 04:02 PM, Duane Larson wrote:
Hey Tijmen,
Yes
show processlist
| 386 | aethercom | 10.179.74.213:57335
http://10.179.74.213:57335 | cdrtool | Sleep |6 |
| NULL
I even changed the the mysql server name on my global.inc to be
something wrong to see if restarting cdrtool would fail and it
did fail. So its not failing when the info is correct. This is
what I have.
class DB_CDRTool extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = cdrtool;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_Locker extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = cdrtool;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_radius extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = radius;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_opensips extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = opensips;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_mediaproxy extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = mediaproxy;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
On Wed, Nov 7, 2012 at 8:33 AM, Tijmen de Mes
tij...@ag-projects.com mailto:tij...@ag-projects.com wrote:
Hi Duane,
So to narrow it down, CDRTool is able to connect to the db (
you see them in the processlist?), but then it looks in the
wrong databases?
Best regards,
--
Tijmen de Mes
AG Projects
On 11/07/2012 05:27 AM, Duane Larson wrote:
I have been running CDRTool for a long time (about 2 or 3
years) and today I moved the mysql database over to a new
server. For some reason when I log into CDRTool I see the
following at the bottom of the screen
MySQL error: 1146 (Table 'opensips.active_sessions' doesn't
exist) Session halted.
then if I click the search button it says
MySQL error: 1146 (Table 'opensips.radacct201211' doesn't
exist) Session halted.
The only big change that I made was in the global.inc for
CDRTool I set the $Host variables to point to
server.dns.name:19994 http://server.dns.name:19994. So
the only real difference is that I have added a port that
isn't 3306.
I don't see any issues with CDRTool connecting to the
database but I have no clue why it now wants to try and look
in the opensips
Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist
Hi Duane, So to narrow it down, CDRTool is able to connect to the db ( you see them in the processlist?), but then it looks in the wrong databases? Best regards, -- Tijmen de Mes AG Projects On 11/07/2012 05:27 AM, Duane Larson wrote: I have been running CDRTool for a long time (about 2 or 3 years) and today I moved the mysql database over to a new server. For some reason when I log into CDRTool I see the following at the bottom of the screen MySQL error: 1146 (Table 'opensips.active_sessions' doesn't exist) Session halted. then if I click the search button it says MySQL error: 1146 (Table 'opensips.radacct201211' doesn't exist) Session halted. The only big change that I made was in the global.inc for CDRTool I set the $Host variables to point to server.dns.name:19994 http://server.dns.name:19994. So the only real difference is that I have added a port that isn't 3306. I don't see any issues with CDRTool connecting to the database but I have no clue why it now wants to try and look in the opensips database for the active_sessions and radacct201211 table. Like I say all I did was move over to a new mysql server so the configs for freeradius and cdrtool didn't change except for pointing to the new server. I went ahead and upgraded to the latest version of CDRTool and I still see the issue. So the upgrade didn't help any. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist
Hi,
Ok, I can't see quickly where it goes wrong, in my opinion it should
just work.
Tomorrow I can do some tests to see if I can track where it goes wrong.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/07/2012 04:02 PM, Duane Larson wrote:
Hey Tijmen,
Yes
show processlist
| 386 | aethercom | 10.179.74.213:57335 http://10.179.74.213:57335 |
cdrtool | Sleep |6 | | NULL
I even changed the the mysql server name on my global.inc to be
something wrong to see if restarting cdrtool would fail and it did
fail. So its not failing when the info is correct. This is what I have.
class DB_CDRTool extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = cdrtool;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_Locker extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = cdrtool;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_radius extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = radius;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_opensips extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = opensips;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
class DB_mediaproxy extends DB_Sql {
var $Host = int.serverdnsname:19994;
var $Database = mediaproxy;
var $User = user;
var $Password = password;
var $Halt_On_Error =yes;
}
On Wed, Nov 7, 2012 at 8:33 AM, Tijmen de Mes tij...@ag-projects.com
mailto:tij...@ag-projects.com wrote:
Hi Duane,
So to narrow it down, CDRTool is able to connect to the db ( you
see them in the processlist?), but then it looks in the wrong
databases?
Best regards,
--
Tijmen de Mes
AG Projects
On 11/07/2012 05:27 AM, Duane Larson wrote:
I have been running CDRTool for a long time (about 2 or 3 years)
and today I moved the mysql database over to a new server. For
some reason when I log into CDRTool I see the following at the
bottom of the screen
MySQL error: 1146 (Table 'opensips.active_sessions' doesn't
exist) Session halted.
then if I click the search button it says
MySQL error: 1146 (Table 'opensips.radacct201211' doesn't exist)
Session halted.
The only big change that I made was in the global.inc for CDRTool
I set the $Host variables to point to server.dns.name:19994
http://server.dns.name:19994. So the only real difference is
that I have added a port that isn't 3306.
I don't see any issues with CDRTool connecting to the database
but I have no clue why it now wants to try and look in the
opensips database for the active_sessions and radacct201211 table.
Like I say all I did was move over to a new mysql server so the
configs for freeradius and cdrtool didn't change except for
pointing to the new server.
I went ahead and upgraded to the latest version of CDRTool and I
still see the issue. So the upgrade didn't help any.
___
Users mailing list
Users@lists.opensips.org mailto:Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org mailto:Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] opensips + CDRTool + mediaproxy
Hi, Did you setup media proxy on the same machine as CDRTool? You should configure the address for media proxy in CDRTool. See also http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide#MediaProxy-setup Best regards, -- Tijmen de Mes AG Projects On 06/06/2012 04:55 PM, yassine.ab wrote: hi, now, i have this error Error connecting to tcp://127.0.0.1:25061: Connection refused (111) if you can help me thanks in advance Message du 05/06/12 17:54 De : Laszlo A : OpenSIPS users mailling list Copie à : Objet : Re: [OpenSIPS-Users] opensips + CDRTool + mediaproxy maybe you also facing this problem: http://opensips.org/pipermail/users/2011-November/019775.html -Laszlo 2012/6/5 yassine.ab : Hi all, when I run: http://localhost/CDRTool/network_status.phtml I have this error: Error connecting to tcp://127.0.0.1:25061: (Could not enable crypto) thanks in advance for your help ___ Les photos des plus beaux baisers de stars sont sur Voila.fr http://people.voila.fr/people/mediatheque/dossiers/les-plus-beaux-baisers-de-stars/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool instal
Hi, Can you check what is in the table auth_user from the CDRTool database? On 06/03/2012 09:29 PM, yassine.ab wrote: hi list, I have a problem with CDRTool, I followed the steps in the install.txt file, but when I type localhost / CDRTool , i have web interface, but I can not access with login and password: admin admin if you can help me thanks -- Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool instal
Hi, I think I spotted the error. There is an error in the setup files for mysql. You can repair it on two ways: - Do update auth_user set password_hashed='' where username='admin'; in the cdrtool database or, - Do update auth_user set password_hashed='21232f297a57a5a743894a0e4a801fc3' where username='admin'; Both methods should work. Please let me know if they do and I will change the install file. Best regards, -- Tijmen de Mes AG Projects On 06/04/2012 02:33 PM, yassine.ab wrote: Hi, thanks for your response in the auth_user table, I have user with login and password -- admin admin for more information: i use opensips1.8 and cdrtool8.3.0 Message du 04/06/12 10:35 De : Tijmen de Mes A : yassine.ab , OpenSIPS users mailling list Copie à : Objet : Re: [OpenSIPS-Users] CDRTool instal Hi, Can you check what is in the table auth_user from the CDRTool database? On 06/03/2012 09:29 PM, yassine.ab wrote: hi list, I have a problem with CDRTool, I followed the steps in the install.txt file, but when I type localhost / CDRTool , i have web interface, but I can not access with login and password: admin admin if you can help me thanks ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Quota - CDRTool Question
Hi Brian,
On 05/23/2012 06:02 PM, dotnetdub wrote:
No quota has been exceeded
So I am not php expert. Is this line a problem?
} else if ($this-daily_quota
($this-db-f('cost_daily')= $this-db-f('quota') *
$this-daily_quota/100)) {
If we look in detail at this line:
- $this-daily_quota is true (it exists),
- the daily cost field in the db is greater then
quota_amount*(daily_quota/100)
- they are both true so it should match
So this line *should* work if it does not maybe you can add some debug
and check the values of the db fields in between.
--
Tijmen de Mes
AG Projects
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Quota - CDRTool Question
Hi Brian,
On 05/24/2012 11:24 AM, dotnetdub wrote:
Hi Tijmen,
Been looking at this for Stephen.
So I think I fixed some bugs!
in rating.php on line 6006 it was never checking if the daily quota
was being exceeded.
I've changed it to:
$query=sprintf(select * from quota_usage where datasource = '%s' and
quota 0 and (cost quota or cost_today=
quota/$this-daily_quota),$this-CDRS-cdr_source);
Then on line 6027 currently is:
else if ($this-daily_quota ($this-db-f('cost_daily')=
$this-db-f('quota') * $this-daily_quota/100)) {
the variable cost_daily is incorrect - it should be cost_today
Can you make a patch of this an mail it to supp...@ag-projects.com? I
will include it in the next release.
--
Tijmen de Mes
AG Projects
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Quota - CDRTool Question
Hi, On 05/24/2012 11:48 AM, dotnetdub wrote: Course - will send on now. Thanks again for your help. No problem, looking forward to see the patch. -- Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Quota - CDRTool Question
Hi Stephen What exactly needs to be defined in global.inc for the quota system to function correctly? A few things can be configured in global.inc. Please see look at http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/setup/global.inc.complex.sample Is there detailed documentation anywhere? Quota docs are here http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/doc/QuotaSystem.txt If you still don't get it working or things are unclear, please let me know. -- Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Quota - CDRTool Question
On 05/23/2012 01:47 PM, dotnetdub wrote: Just one question. I want to enable a daily limit of 10% of the monthly limit. I've added daily_quota= 10, to my global.inc I've noticed that in rating.php that this is here: var $daily_quota = 0; // by default do not check daily quota Do I comment this out, set it to 10 or 1 to enable or delete it? Don't edit rating.php. the value in global.inc should be enough. (line 5685 of rating.php overrides it) And one other question. I add a quota to the opensips table. When does it get copied to the cdrtool.quota_usage table? I have added quota now for all subscribers but they don't go the cdrtool table. Try the quotaReset script and then quotaCheck. It should now rebuild from radius/opensips db -- Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool incoming calls
Hi, On 04/02/2012 02:05 PM, Remco . wrote: Is there a way to log incoming calls using CDRTool? (e.g. PSTN - OpenSIPS - User). Yes, it will display any call if it is correctly setup. It is depending on radius. If OpenSIPS is configured to write the accounting records to the radius server, CDRTool will/can display them. -- Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Opensips blocked when using with Radius accounting and mysql stops
Hi, A work around is use a radius as a proxy on the Opensips machine. So the proxy will always be available even if the radius server is not. The setup would look like the following: Opensips -- radius proxy -- radius server doing the sql -- Tijmen de Mes AG Projects On 03/22/2012 11:14 AM, Iulian Macare wrote: Hello I have the following scenario: 1 x Opensips with CDRTool installed on a machine ( Opensips,Mysql, Freeradius CDRTool ) 1 x DB with MySQL that I have only the radius database So on the Opensips machine I have the opensips cdrtool databases , and on the DB server I have the radius database Opensips aaa module sends the accounting information to Freeradius that is configured to write sql queries on the DB server . If the DB server get's overloaded ( I make a big select that locks the table ) or unavailable , opensips get's blocked and no other calls can be made Of course, in radius log i get: Thu Mar 22 11:05:17 2012 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - rlm_sql_mysql: no connection to db Thu Mar 22 11:05:17 2012 : Error: rlm_sql (sql): reconnect failed, database down? Thu Mar 22 11:05:17 2012 : Error: rlm_sql (sql): Failed to connect DB handle #13 Thu Mar 22 11:05:17 2012 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.4.63' (111)' Thu Mar 22 11:05:17 2012 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server radius@192.168.4.63:radius But when this is happening, all opensips childs use 100% of CPU and nothing works. How can I prevent opensips in getting blocked if my database server containing the radius database fails? ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool Rating : Destinations Table
Hi, Please see rating.txt in the docs from CDRTool. The purpose is providing destinations per gateway, Domain or subscriber. Best regards, -- Tijmen de Mes AG Projects On 02/21/2012 11:12 AM, Reda Aouad wrote: Hi, What is the purpose of the columns : Gateway, Domain and Subscriber in the DESTINATIONS table of CDRTool ? Thanks Reda ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool Rating : Destinations Table
Hi,
On 02/21/2012 12:56 PM, Reda Aouad wrote:
I mean : if I have two destinations with the same prefix, a general
one without a subscriber defined, and a second one attached to a
subscriber, how can I define a different rate for each to achieve
subscriber-based exceptions ?
This is not the purpose of that table. If you want a different rate for
a subscriber a typical solution is define the rates and give them a name
('subscriber'). After this make a profile and give it a name
('profile_subscriber').
Then define a customer for the subscriber and associate the profiles
('profile_subscriber') to it
Hope this clarifies it.
--
Tijmen de Mes
AG Projects
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] domain in prepaid scenarios not honoured
Hi Samuel, A domain can be defined in the billing_customers table. In your case testintern.domain.com mailto:0034123456...@testintern.domain.com. You should also add the timezone to this domain in the same table. If this still does not work, and like you said, the domain is not properly split/retrieved from the uri, I've to look deeper in the code why this can happen. So can you please add the domain and let me know the outcome? Best regards, -- Tijmen de Mes AG Projects On 02/13/2012 05:30 PM, samuel wrote: Hi all, Recently I was playing with the prepaid functionallity of CDRTool (8.2.3) and found out that when the customer is not explicitely defined in the field Subscriber, the domain is not looked up. I have opensips (1.7.1) with call control application from apt sources (2.0.15) and when the following call is sent: sent from opensips to CDRTool: MaxSessionTime Duration=36000 CallId=JeJ5LJz8iCXozC1AGxhqoOIliuToIm53 From=sip:m...@testintern.domain.com mailto:sip%3a...@testintern.domain.com Gateway=X.Y.Z.W To=sip :0034123456...@testintern.domain.com mailto:0034123456...@testintern.domain.com.. ## reply from CDRTool error: cannot figure out the billing timezone.type=prepaid.type=prepaid Looking in the syslog we find the right answer: Feb 13 17:18:30 cdrtool cdrtool[30106]: Error: no customer found in billing_customers table for billing party=m...@testintern.domain.com mailto:m...@testintern.domain.com, domain=, gateway=X.Y.Z.W Feb 13 17:18:30 cdrtool cdrtool[30106]: error: cannot figure out the billing timezone#012type=prepaid so it looks like the domain is not extracted from the user part and it is not checked in the billing_customers table. The query in the function lookupProfiles (file rating.php) uses $this-dictionary['domain'] as the source for the domain but in the prepaid scenario, this parameter hasn't got a value. Am I right? I've tried to dig further in the code but unfortunately got lost in the exportation of the CDR's dictionary to the function that is used in prepaid scenarios. Is there any option I'm missing? Is it possible to setup just the domain in the billing_customers table and not a line foreach prepaid customer? Congratulations for the project and thanks in advance, Samuel ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] MediaProxy/FreeRadius configuration file read Error
Hi Nick, You can specify the config file for radius in the [radius] section of config.ini in /etc/mediaproxy Best regards, Tijmen de Mes AG Projects On 12/09/2011 04:10 AM, Nick Khamis wrote: Hello Everyone, When adding the FreeRadius material to MediaProxy, I am recieving the following error when trying to start MediaProxy: media-dispatcher --no-fork Starting MediaProxy Dispatcher 2.5.2 using set_wakeup_fd Twisted is using epollreactor gc: collectablelist 0x95c0cac gc: collectablelist 0x95bbe2c gc: collectablelist 0x95bbb8c gc: collectablelist 0x95bbaac fatal error: cannot read the RADIUS configuration file fatal error: failed to create MediaProxy Dispatcher: 'localhost' Traceback (most recent call last): File /usr/local/bin/media-dispatcher, line 62, inmodule dispatcher = Dispatcher() File /usr/lib/python2.7/site-packages/mediaproxy/dispatcher.py, line 526, in __init__ self.accounting = [__import__(mediaproxy.interfaces.accounting.%s % mod.lower(), globals(), locals(), []).Accounting() for mod in set(Config.accounting)] File /usr/lib/python2.7/site-packages/mediaproxy/interfaces/accounting/radius.py, line 59, in __init__ self.handler = RadiusAccounting() File /usr/lib/python2.7/site-packages/mediaproxy/interfaces/accounting/radius.py, line 87, in __init__ secret = secrets[server] KeyError: 'localhost' I was not sure which client.conf MediaProxy needed so I tried both: /etc/radiusclient-ng/radiusclient.conf, and /etc/freeradius/clients.conf However, got the same error in both cases. Thanks in Advance, Nick. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] MediaProxy/FreeRadius configuration file read Error
Hi Nick I think it is best explained with an example. We use /etc/opensips/radius/client.conf: auth_order radius,local login_tries 4 login_timeout 60 nologin /etc/nologin authserver localhost acctserver localhost servers /etc/opensips/radius/servers dictionary /etc/opensips/radius/dictionary seqfile /var/run/opensips/opensips_radius.seq mapfile /etc/opensips/radius/port-id-map default_realm radius_timeout 5 radius_retries 3 And in the dictonary file we include : $INCLUDE/etc/radiusclient-ng/dictionary and specify some extra sip attributes needed for opensips and mediaproxy. In the /etc/radiusclient-ng/dictionary we have no extra dictionaries just the default attributes. Please also note the attributes mediaproxy needs. The localhost 127.0.0.1 problem has to do with /etc/hosts and the network configuration.\ BTW on which distro are you trying to install? Best regards, Tijmen de Mes AG Projects On 12/12/2011 05:26 PM, Nick Khamis wrote: Hello Tijmen, Thank you so much for your response. I think I was not able to explain my problem: I have the config file specified in /etc/mediaproxy/config.ini: config_file = /etc/radiusclient-ng/radiusclient.conf When running media dispatcher media-dispatcher --no-fork, I get the following: gc: collectablelist 0x9bceaec fatal error: cannot read the RADIUS configuration file fatal error: failed to create MediaProxy Dispatcher: 'localhost' Traceback (most recent call last): File /usr/local/bin/media-dispatcher, line 62, inmodule dispatcher = Dispatcher() File /usr/lib/python2.7/site-packages/mediaproxy/dispatcher.py, line 526, in __init__ self.accounting = [__import__(mediaproxy.interfaces.accounting.%s % mod.lower(), globals(), locals(), []).Accounting() for mod in set(Config.accounting)] File /usr/lib/python2.7/site-packages/mediaproxy/interfaces/accounting/radius.py, line 59, in __init__ self.handler = RadiusAccounting() File /usr/lib/python2.7/site-packages/mediaproxy/interfaces/accounting/radius.py, line 87, in __init__ secret = secrets[server] KeyError: 'localhost' By changing acctserver in radiusclient.conf from localhost, to 127.0.0.1 fixes the issue however, I am now having problems with additonal dictionaries (e.g.): fatal error: failed to create MediaProxy Dispatcher: dictionary.rfc5904(16): Parse error: Illegal type: short Commenting out the lines in the different dictionary files, I would have to go through many FreeRadius dictionary files in /usr/share/freeradius/dictionary. Thanks in Advance, Nick. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] quota documentation
Hi Quota reset will reset the quota for the month. If quota check is executed after this it will rebuild the quota from the beginning of the month until the moment of running. So when you renormalize, you can reset and rebuild the Quota and it will be correct again and the accounts over quota will be blocked. Hope this answers your questions. Best regards, Tijmen de Mes AG Projects Op 14-11-11 18:35, samuel schreef: Hi folks, I'm starting understanding the quota system for CDRTool (8.2.2) but there's something that I might be missing...and would like more information about its internals. As far as I know there are the 3 following scripts: /var/www/CDRTool/scripts/OpenSIPS/quotaCheck.php check for users with quota exceeded /var/www/CDRTool/scripts/OpenSIPS/quotaReset.php monthly wipe out of data /var/www/CDRTool/scripts/OpenSIPS/quotaDailyReset.php accumulative daily traffic That MUST be called in the right time or the collected data is meaningless. Besides, if you renormalize de calls, quota system does not work anymore (it looks like as if quotaReset had been called). My question is if there's any documentation besides the doc/QuotaSystem.txt file that explain how is it calculed and what to do, for instance, if in the middle of a month, ReNormalize is called. How can you rebuild the quota for the last days? Because it looks like it's not possible (probably modifying somehow memcache table (?)). What to do if, in the middle of a day, quotaDailyReset.php is called several times? So, my main call is to get some more information about the Quota system works and how to recover for a failure. Thank you very much for such a complete suite of products, Samuel. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] quota documentation
Hi, I turns out that after re normalization, the quotaCheck script should be able to recalculate the quota on its own. So there is no need to call quota reset for this. Regards, Tijmen de Mes AG Projects Op 14-11-11 19:29, Tijmen de Mes schreef: Hi Quota reset will reset the quota for the month. If quota check is executed after this it will rebuild the quota from the beginning of the month until the moment of running. So when you renormalize, you can reset and rebuild the Quota and it will be correct again and the accounts over quota will be blocked. Hope this answers your questions. Best regards, Tijmen de Mes AG Projects Op 14-11-11 18:35, samuel schreef: Hi folks, I'm starting understanding the quota system for CDRTool (8.2.2) but there's something that I might be missing...and would like more information about its internals. As far as I know there are the 3 following scripts: /var/www/CDRTool/scripts/OpenSIPS/quotaCheck.php check for users with quota exceeded /var/www/CDRTool/scripts/OpenSIPS/quotaReset.php monthly wipe out of data /var/www/CDRTool/scripts/OpenSIPS/quotaDailyReset.php accumulative daily traffic That MUST be called in the right time or the collected data is meaningless. Besides, if you renormalize de calls, quota system does not work anymore (it looks like as if quotaReset had been called). My question is if there's any documentation besides the doc/QuotaSystem.txt file that explain how is it calculed and what to do, for instance, if in the middle of a month, ReNormalize is called. How can you rebuild the quota for the last days? Because it looks like it's not possible (probably modifying somehow memcache table (?)). What to do if, in the middle of a day, quotaDailyReset.php is called several times? So, my main call is to get some more information about the Quota system works and how to recover for a failure. Thank you very much for such a complete suite of products, Samuel. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] RTPProxy + Call_control
Hi, Next to the view you need to make for opensips you'll need to create the CDRTool database and point to it in the config. (/var/www/CDRtool/setup/mysql/setup_mysql.sh pass server) Best regards, -- Tijmen de Mes AG Projects Op 04-11-11 08:22, Nick schreef: Hello About Call Control : You need to setup the following components: * OpenSIPS callcontrol module, version =1.5 == It's OK. * Call Control application (this software) * CDRTool rating engine, version =6.7.0 == - The RatingEngine IP address - The mysql connection details to cdrtool, radius, opensisps, siptrace and mediaproxy MySQL databases, which are described in the following sections of this document - The mediaDispatcher address This is a cdrtool documtn. http://download.dns-hosting.info/CDRTool/doc/INSTALL.txt But, I don't used radius, mediaproxy. How does cdrtool work??? When I input command start-stop-daemon --start --quiet --pidfile /var/run/ratingEngine.pid --exec /var/www/CDRTool/scripts/ratingEngine.php It always display error. Database error for query select `value` from memcache where `key` = 'destinations': ()Database DB_opensips error: Table 'opensips.trusted_peers' doesn't exist (1146) select * from trusted_peers Database error for query select * from billing_profiles order by name: ()Database error for query select *, UNIX_TIMESTAMP(startDate) as startDateTimestamp, UNIX_TIMESTAMP(endDate) as endDateTimestamp from billing_rates_history order by name ASC,destination ASC,startDate DESC: ()Database error for query select * from billing_holidays order by day: ()Database error for query select * from billing_enum_tlds: ()PHP Fatal error: Call to undefined function posix_setsid() in /var/www/CDRTool/library/rating_server.php on line 81 How to solve this problem?? I want to used opensips, call_control, rtpproxy, mysql and cdrtool, But I don't want to used mediaproxy and radius. I need billing system with opensips. Thanks for your support. Nick On 2011?11?04? 10:06, Nick wrote: Hello So, I used rtpproxy + callcontrol + CDRTOOL . Is it OK??? In Document, I don't this part. Thanks for your support. Nick On 2011?11?04? 07:08, Saul Ibarra Corretge wrote: On Nov 2, 2011, at 5:08 AM, Nick wrote: Hello I see document. In opensips, it has call_control this module. But it can't support rtpproxy, only support media-proxy If I want to a billing system for opensips. Can you give me a another suggest?? CallControl doesn't require MediaProxy to operate, you may use any other media relaying software. Regards, ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool prepaid bebits correct customer with wrong pricing of another
Hi, We have never seen this before. Have you done al the migration steps required to go to 8.1.2? Also which php version are you using? Best regards, Tijmen de Mes AG Projects. Op 6/30/11 1:40 PM, Jan Baumann schreef: Good afternoon, I have updated to CDRTool 8.1.2, callcontrol 2.0.12 and mediaproxy 2.5.0 running together with an older opensips 1.5.3. Everything works perfectly for postpaid calls. I now have come across very strange behaviour when testing prepaid calls. After terminating a prepaid call I get the following syslog - all with the same callid and surely belonging together. Default is the name of the fallback billing profile for all customer accounts. The calling user has in fact assigned a dedicated rating plan euroflat with free calls to Austria. When user 0821723xxx now calls to Austria the prepaid system uses the rating profile of subscriber 08219987xyz(!) to calculate the pricing and debits 0821723xxx's prepaid account with the inappropriate default rate of the wrong other customer. The wrongly chosen 08219987xyz seems a random, but always the same choice, even for different prepaid callers. If I delete the 08219987xyz user the system chooses another wrong one and sticks with that. Immediately after prepaid call ends: First line wrong customer choice, second line correct caller's balance debited with wrong rate: Jun 30 13:12:24 voip cdrtool[4901]: Increment=60 MinDuration=60 ConnectFee=0. CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5p Span=1 Duration=60 DestId=43 subscriber=08219987...@mysipserver.de Profile=default Period=weekday Rate=default Interval=0-24 Cost=0.0250/60 Price=0.0250 PriceIn=0.0181 Jun 30 13:12:24 voip cdrtool[4901]: DebitBalance=0.0250 Duration=4 CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5pBillingParty=0821723...@mysipserver.de DestId=43 MaxSessionTime=0 Counter=1-0 When cron normalizes the radius CDRs 2 min. later (or I renormalize from the web GUI) it grabs the correct profile for the correct customer: Jun 30 13:15:02 voip cdrtool[5305]: Increment=60 MinDuration=60 ConnectFee=0. CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5p Span=1 Duration=60 DestId=43 subscriber=0821723...@mysipserver.de Profile=euroflat Period=weekday Rate=euroflat Interval=0-24 Cost=0./60 Price=0. PriceIn=0.0181 Any ideas what can be going on there??? Thank you and Kind Regards, Jan Baumann ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool prepaid bebits correct customer with wrong pricing of another
Hi, Increasing the verbosity can not be done. You can only show the warnings you may get from php. This can be done by commenting out error reporting line in the global config. You can test the rating engine by connecting to it over telnet and the port you configured. This way you can see what rates/profile you get back when doing specific calls. The whole rating is in rating.php in the library folder. See class RatingEngine Best regards, Tijmen de Mes AG Projects Op 6/30/11 3:21 PM, Jan Baumann schreef: Hi, thank you for the quick answer. I at least think I did the mirgration of the mysql structures correctly. Everything else works as expected and with no sql errors. I am using latest php 5.3.6 and mysql 5.1.51, both compiled from source. Upgrade was performed due to problems with the ratingengine loosing the mysql connection and failing to reconnect once every day. That was a show-stopper for prepaid in the past and seems to be fixed now. Can you tell me where to find (and debug) the mysql query that selects the customer and profiles in the case of prepaid calls? Can I increase the logging verbosity? Thank you and Best Regards, Jan Am 30.06.11 15:06, schrieb Tijmen de Mes: Hi, We have never seen this before. Have you done al the migration steps required to go to 8.1.2? Also which php version are you using? Best regards, Tijmen de Mes AG Projects. Op 6/30/11 1:40 PM, Jan Baumann schreef: Good afternoon, I have updated to CDRTool 8.1.2, callcontrol 2.0.12 and mediaproxy 2.5.0 running together with an older opensips 1.5.3. Everything works perfectly for postpaid calls. I now have come across very strange behaviour when testing prepaid calls. After terminating a prepaid call I get the following syslog - all with the same callid and surely belonging together. Default is the name of the fallback billing profile for all customer accounts. The calling user has in fact assigned a dedicated rating plan euroflat with free calls to Austria. When user 0821723xxx now calls to Austria the prepaid system uses the rating profile of subscriber 08219987xyz(!) to calculate the pricing and debits 0821723xxx's prepaid account with the inappropriate default rate of the wrong other customer. The wrongly chosen 08219987xyz seems a random, but always the same choice, even for different prepaid callers. If I delete the 08219987xyz user the system chooses another wrong one and sticks with that. Immediately after prepaid call ends: First line wrong customer choice, second line correct caller's balance debited with wrong rate: Jun 30 13:12:24 voip cdrtool[4901]: Increment=60 MinDuration=60 ConnectFee=0. CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5p Span=1 Duration=60 DestId=43 subscriber=08219987...@mysipserver.de Profile=default Period=weekday Rate=default Interval=0-24 Cost=0.0250/60 Price=0.0250 PriceIn=0.0181 Jun 30 13:12:24 voip cdrtool[4901]: DebitBalance=0.0250 Duration=4 CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5pBillingParty=0821723...@mysipserver.de DestId=43 MaxSessionTime=0 Counter=1-0 When cron normalizes the radius CDRs 2 min. later (or I renormalize from the web GUI) it grabs the correct profile for the correct customer: Jun 30 13:15:02 voip cdrtool[5305]: Increment=60 MinDuration=60 ConnectFee=0. CallId=NPI2JDqYKnQCsLz.x3ELQVMsLvQ5wh5p Span=1 Duration=60 DestId=43 subscriber=0821723...@mysipserver.de Profile=euroflat Period=weekday Rate=euroflat Interval=0-24 Cost=0./60 Price=0. PriceIn=0.0181 Any ideas what can be going on there??? Thank you and Kind Regards, Jan Baumann ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - Database error's
Hi, It looks like there is something wrong with your database. What happens if you execute the active sessions query manually? Do you have an empty database, or are there valid destinations in ther (from the sample data)? Best regards, -- Tijmen de Mes AG Projects Op 6/6/11 6:37 PM, Duane Larson schreef: I am having some database errors with a new install of CDRTool. One error I keep seeing in my syslog is Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp#012from radacct201105 where (1=1) and Normalized = '0' and AcctStopTime not like '-00-00 00:00:00%' order by RadAcctId asc I don't see any issues with this log, but I don't know why it is trying to look for radacct201105. It was never created and the database doesn't exist since this month is 201106. Then I see another issue and this does cause issues with the CDRTool application. With this I am not able to log into the CDRTool and see the following error at the bottom of the login page MySQL error: 1036 (Table 'active_sessions' is read only) Session halted. When I look in the syslog I see the following error Database error: Invalid SQL: update active_sessions set val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtP nB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoO yAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nX SA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1d GgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', changed='20110606111425', count=count+1 where sid= '99eeb2a6426095d5708d0a5149196bae' and name='CDRc' If I stop cdrtool and try to restart it I am not able to restart CDRTool and see the following error in syslog Database error: Invalid SQL: delete from memcache where `key` = 'destinations_sip' or `key` = 'destinations' In order to get CDRTool to start up again I have to stop and restart MySQL database. Any ideas what could be wrong? This is the latest version of CDRTool and I am running it on Ubuntu Maverick. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - CDR Flow record
Hi, The flow is determined by the aNumber and BillingParty. The logic is the following: If the caller is local and aNumber is the same as the BillingPartyID the flow will be on-net or outgoing depending on the callee If the caller is local and aNumber is not the same as the BillingPartyID the flow will be on-net-diverted-on-net or on-net-diverted-off-net depending on the callee If the caller is not local and the BillingParty is local the flow will be diverted-on-net or diverted-off-net depending on the callee If the caller is not local and the callee is local the flow will be incoming If the caller is not local and the callee is not local is local the flow will be transit After the call is done ( not in progress any more) it will be normalized by the normalization process. This will rewrite the numbers based on the config settings. Hope this clarifies things a bit. Best regards, -- Tijmen de Mes AG Projects Op 6/2/11 10:23 PM, Duane Larson schreef: I think I don't have something configured correctly. When I do a search on the CDRs page my Flow info is not always correct. So I am not sure what all I am doing wrong. On my cdrtool global.inc config I have the following configured intAccessCode = 011, natAccessCode = 1, When an internal customer to internal customer call is in progress the call shows up as On-Net, yet when the call is over it shows up as outgoing. For the following fields I am sending this from OpenSIPS To (dialed URI): 19**33*9**8...@irock.com mailto:19**33*9**8...@irock.com Canonical URI: 19**33*9**8...@irock.com mailto:19**33*9**8...@irock.com Billing Party: 19**27*2**4...@coolbeans.com mailto:19**27*2**4...@coolbeans.com From: 19**27*2**4...@coolbeans.com mailto:19**27*2**4...@coolbeans.com You can see that I am prefixing the 1 to the US numbers. After the call is not in progress I see that the following changed To (dialed URI): 01119**33*9**8...@irock.com mailto:01119**33*9**8...@irock.com Canonical URI: 01119**33*9**8...@irock.com mailto:01119**33*9**8...@irock.com I also get a flow of diverted-off-net when a call comes from the PSTN to an internal customer and once again my To (dialed URI) and Canonical URI numbers change from having a 1 prefix to a 0111 when the call is over. I'm sure this is something simple. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool - Database error's
Hi, OK so there is nothing wrong with the queries. Is it possible you hit a maximum connections limit in mysql? And what is your max allowed packet size? Best regards, -- Tijmen de Mes AG Projects Op 6/7/11 4:07 PM, Duane Larson schreef: When I execute update active_sessions set val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', changed='20110606111425', count=count+1 where sid='99eeb2a6426095d5708d0a5149196bae' and name='CDRc' manually it is ok Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 This doesn't happen all the time. It appears that something happens after a while and then I start getting the MySQL error: 1036 (Table 'active_sessions' is read only) Session halted. errors. I will have to look into this more. If anyone has any ideas let me know. On Tue, Jun 7, 2011 at 8:10 AM, Tijmen de Mes tij...@ag-projects.com mailto:tij...@ag-projects.com wrote: Hi, It looks like there is something wrong with your database. What happens if you execute the active sessions query manually? Do you have an empty database, or are there valid destinations in ther (from the sample data)? Best regards, -- Tijmen de Mes AG Projects Op 6/6/11 6:37 PM, Duane Larson schreef: I am having some database errors with a new install of CDRTool. One error I keep seeing in my syslog is Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp#012from radacct201105 where (1=1) and Normalized = '0' and AcctStopTime not like '-00-00 00:00:00%' order by RadAcctId asc I don't see any issues with this log, but I don't know why it is trying to look for radacct201105. It was never created and the database doesn't exist since this month is 201106. Then I see another issue and this does cause issues with the CDRTool application. With this I am not able to log into the CDRTool and see the following error at the bottom of the login page MySQL error: 1036 (Table 'active_sessions' is read only) Session halted. When I look in the syslog I see the following error Database error: Invalid SQL: update active_sessions set val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtP nB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoO yAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nX SA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1d GgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', changed='20110606111425', count=count+1 where sid= '99eeb2a6426095d5708d0a5149196bae' and name='CDRc' If I stop cdrtool and try to restart it I am not able to restart CDRTool and see the following error in syslog Database error: Invalid SQL: delete from memcache where `key` = 'destinations_sip' or `key` = 'destinations' In order to get CDRTool to start up again I have to stop and restart MySQL database. Any ideas what could be wrong? This is the latest version of CDRTool and I am running it on Ubuntu Maverick. ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- -- *--*--*--*--*--* Duane *--*--*--*--*--* -- ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool install
Hi, No he did not. At least not to me. As far as I know, the patch is still not in freeradius. Tijmen de Mes AG Projects Op 5/31/11 7:22 PM, osiris123d schreef: Did ram ever respond to this question? -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-install-tp5855130p6423718.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Issue in displaying the CDRs in callsearch
Hi, So you see ... Number of records displayed, but no table below it with the calls? Which version of PHP are you using? Best regards, Tijmen de Mes AG Projects Op 5/2/11 11:02 AM, Tushar Jain schreef: Hi Friends, I am able to successfully install - opensips 1.6 freeradius CDRTool 8.0.19 but when I am trying search the CDRs in CDRTool all I get the no. of records, no detail is populated on the screen though when I export the result to file i can see all the cdr records on the browser. I have checked the opensips, apache, freeradius logs but there is no error in any of the log files. -- Regards Tushar Jain two roads diverged in a wood, and I - I took the one less traveled by, and that has made all the difference --Robert Frost ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Issue in displaying the CDRs in callsearch
Hi Tushar, I've never seen this error and could be related to a couple of things. To get more insight in what is causing this you could enable the error messages which are default disabled. To do this you need to comment $errorReporting=1 in the CDRTool. After this you should see errors (if there are errors) in syslog for the rating engine and in the apache error log for the webinterface. Best regards, Tijmen de Mes AG Projects Op 5/2/11 12:10 PM, Tushar Jain schreef: Hi Tijmen, I am using PHP 5.3.3 PHP 5.3.3-7+squeeze1 with Suhosin-Patch (cli) (built: Mar 18 2011 17:22:52) Copyright (c) 1997-2009 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH Regards Tushar On Mon, May 2, 2011 at 3:31 PM, Tijmen de Mes tij...@ag-projects.com mailto:tij...@ag-projects.com wrote: Hi, So you see ... Number of records displayed, but no table below it with the calls? Which version of PHP are you using? Best regards, Tijmen de Mes AG Projects Op 5/2/11 11:02 AM, Tushar Jain schreef: Hi Friends, I am able to successfully install - opensips 1.6 freeradius CDRTool 8.0.19 but when I am trying search the CDRs in CDRTool all I get the no. of records, no detail is populated on the screen though when I export the result to file i can see all the cdr records on the browser. I have checked the opensips, apache, freeradius logs but there is no error in any of the log files. -- Regards Tushar Jain two roads diverged in a wood, and I - I took the one less traveled by, and that has made all the difference --Robert Frost ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Regards Tushar Jain two roads diverged in a wood, and I - I took the one less traveled by, and that has made all the difference --Robert Frost ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Issue in displaying the CDRs in callsearch
Hi Tushar, The deprecation errors are harmless and CDRTool should work fine with php 5.3. You should fix the last error displayed: [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Fatal error: Call to undefined function geoip_record_by_name() in /var/www/CDRTool/library/cdr_generic.php on line 2365, referer: http://192.168.100.29/CDRTool/callsearch.phtml This could be the cause for the table not displaying. Please enable and install geoip for php. Best regards, Tijmen de Mes AG Projects Op 5/2/11 12:44 PM, Tushar Jain schreef: HI Tijmen, It seems to the issue with PHP version 5.3, should I downgrade the version? Regards Tushar On Mon, May 2, 2011 at 4:12 PM, Tushar Jain tusshar.j...@gmail.com mailto:tusshar.j...@gmail.com wrote: Thanks Tijmen, We did enable the logs, according to the logs some of the functions are depreciated. Can you put some more light on it as I dont have much knowledge of PHP. [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Function ereg() is deprecated in /var/www/CDRTool/phplib/ct_sql.inc on line 118, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Function ereg_replace() is deprecated in /var/www/CDRTool/phplib/ct_sql.inc on line 119, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Function split() is deprecated in /var/www/CDRTool/phplib/perm.inc on line 39, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Function split() is deprecated in /var/www/CDRTool/phplib/perm.inc on line 40, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/cdr_generic.php on line 1085, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/cdr_generic.php on line 1085, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/cdr_generic.php on line 1090, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/cdr_generic.php on line 2157, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/cdr_generic.php on line 2177, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/cdr_generic.php on line 2328, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/rating.php on line 6005, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/rating.php on line 7311, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/rating.php on line 7311, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/rating.php on line 7817, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Call-time pass-by-reference has been deprecated in /var/www/CDRTool/library/rating.php on line 7817, referer: http://192.168.100.29/CDRTool/callsearch.phtml [Mon May 02 10:38:07 2011] [error] [client 192.168.100.115] PHP Deprecated: Function split() is deprecated in /var/www/CDRTool/phplib/perm.inc on line 39, referer
Re: [OpenSIPS-Users] Cannot store Accounting Record into mysql Using Opensips 1.6.4 + CDRTool + Freeradius + mysql
Hi, You can enable sqltrace in freeradius to see what is wrong and try to execute the queries manually. Which version of freeradius are you using? Best regards, Tijmen de Mes AG Projects Op 3/24/11 11:01 AM, Simon Shum schreef: Hello, I have installed opensips 1.6.4 + mediaproxy + cdrtool + freeradius + mysql, and I have followed the install guide from http://cdrtool.ag-projects.com/wiki/Install. I am able to find accounting record in the freeradius server log file at /var/log/freeradius/radacct/, but when I trying to look for the accounting record in the mysql database. I found the radacct table in radius database is empty. I read the /var/log/freeradius/radius.log and found the following logs: Thu Mar 24 12:09:25 2011 : Error: [sql] Couldn't update SQL accounting ALIVE record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 Thu Mar 24 12:09:25 2011 : Error: rlm_sql_mysql: Cannot store result Thu Mar 24 12:09:25 2011 : Error: rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1' Thu Mar 24 12:09:35 2011 : Error: [sql] Couldn't update SQL accounting ALIVE record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 Thu Mar 24 12:09:35 2011 : Error: rlm_sql_mysql: Cannot store result Thu Mar 24 12:09:35 2011 : Error: rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1' Thu Mar 24 12:09:45 2011 : Error: [sql] Couldn't update SQL accounting ALIVE record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 Thu Mar 24 12:09:45 2011 : Error: rlm_sql_mysql: Cannot store result Thu Mar 24 12:09:45 2011 : Error: rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1' Thu Mar 24 12:11:25 2011 : Info: [sql] stop packet with zero session length. [user '301@192.168.11.212', nas '127.0.0.1'] Would anybody tell me is there something wrong with my config ? Thanks Regards, Simon ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool install
Hi We have a patched freeradius-xs 2.1.10 almost ready to go, but we are still testing this. I looked to find the failed patch, but I can not find it in the main repo of freeradius. Can you tell us a bit more Ram? Best regards, Tijmen de Mes AG Projects Op 2/8/11 2:29 PM, Jeff Pyle schreef: ram, Are you saying that the stock version of Freeradius has the FAILED patch already installed? If so, can you say at which version this started? I installed the freeradius-xs deb packages from AG Networks' repository. It worked, but it required a lot of tricky updates from the Debian testing branch. It would be fantastic if the regular Debian stable version handled this natively. - Jeff From: ram talk2...@gmail.com mailto:talk2...@gmail.com Reply-To: OpenSIPS users mailling list users@lists.opensips.org mailto:users@lists.opensips.org Date: Tue, 8 Feb 2011 06:29:12 -0500 To: OpenSIPS users mailling list users@lists.opensips.org mailto:users@lists.opensips.org Subject: Re: [OpenSIPS-Users] CDRTool install patch already added in to freeradius latest version On Tue, Dec 21, 2010 at 2:47 PM, rad bogdan bogdan_rad2...@yahoo.com mailto:bogdan_rad2...@yahoo.com wrote: Hi everyone, I've started configuring CDRTool 8.0.10, FreeRadius 2.1.10, CallControl 2.0.8 and OpenSIPS 1.6 but I've encountered some problems: all the servers have installed successfully (I can start them) but after I've followed the instructions from http://cdrtool.ag-projects.com/wiki/Install I've realized that they refer to older versions of FreeRadius and OpenSIPS. The documentation of FreeRadius for MySQL's configuration (http://wiki.freeradius.org/SQL_HOWTO) seems to be different than the one from CDRTool's page (the section that describes the installation of FreeRadius). The patch CDRTool/setup/radius/FreeRadius/freeradius.patch doesn't seem to fit on all files of the latest version of FreeRadius. Also, the settings for OpenSIPS seem to be for 1.4. Which versions of servers should I use, those from CDRTool's page or the latest ones ? Can I bypass FreeRadius and use only OpenSIPS for authentication ? Are CDRTool and Call Control built to work this way ? I'm not concerned about security and I'd prefer not to use FreeRadius in the beginning if possible. Thanks, Bogdan ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] CDRTool group by Sip Destination id Description empy
Hi, This one line is not the only thing changed in cdr_opensips.php. You should make sure you got the all the new files that are in the release. Did you also upgraded the database tables like instructed in the changelog and alter_mysql? From which version you upgraded? Tijmen de Mes AG Projects Op 1/20/11 2:00 PM, Adrià Vidal schreef: On Thu, Jan 20, 2011 at 1:38 PM, Tijmen de Mes tij...@ag-projects.com mailto:tij...@ag-projects.com wrote: Hi, I looks like something failed in your update and you' ve stil got an old version of cdr_opensips.php. This bug was fixed in 8.0.7. It should be: $description=$this-destinations[0][default][$mygroup]; Yes, you are right, edited now by hand, but getting Array as the result value -- -- Adrià Vidal ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] prepaid with call plan
Hi , You can use the call-control application for this. See http://callcontrol.ag-projects.com. Best Regards, Tijmen de Mes AG Projects Op 1/6/11 12:21 PM, Dani Popa schreef: Hi, I wonder, how can be implemented with opensips prepaid system with service plans with included minutes. Can someone to give me some hints ? Thanks, Dani Popa ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] need help on connection CDRTool to opensips
Hi, On Nov 25, 2010, at 10:06 AM, ha do wrote: and opensips.cfg with fifo config # - mi_fifo params - modparam(mi_fifo, fifo_name, /tmp/opensips_fifo) modparam(mi_fifo, fifo_mode, 0600) modparam(mi_fifo, fifo_group, 0) modparam(mi_fifo, fifo_group, root) modparam(mi_fifo, fifo_user, 0) modparam(mi_fifo, fifo_user, root) and the callcontrol config.ini [CallControl] group = root [OpenSIPS] socket_path = /tmp ;max_connections = 10 -- does it disconnect 10 calls in 1 time, if i need 100 terminated i need to increase to 100, right??? how to fix the issue Try using socket_path=/tmp/socket in config.ini. The socket path should match the mi_datagram ,socket_name in the opensips config. Tijmen de Mes AG Projects ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] need help on connection CDRTool to opensips
Hi,
You should verify by hand that you can connect to the database by
executing a mysql -h 192.168.1.39 -u opensips -psips opensips.
Maybe you forgot to remove the bind interfaces directive in the mysql
config.
Best regards,
Tijmen de Mes
AG Projects
On Nov 9, 2010, at 4:11 AM, ha do wrote:
Hi all
i installed opensips and mediaproxy in server 1, ip address :
192.168.1.39
and cdrtool and freeradius in server 2, ip address : 192.168.1.42
the opensips, mediaproxy, freeradius starting are fine
i use the link below as a guide
http://cdrtool.ag-projects.com/browser/doc/INSTALL.txt
the problem i got only with cdrtool
Nov 9 04:56:22 cdrtool cdrtool[3219]: Read 12291 PSTN destinations
from cache
in 0 seconds
Nov 9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect
as opensips
to 192.168.1.39 failed
Nov 9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:
(0) select *
from domain
Nov 9 04:56:22 cdrtool cdrtool[3219]: Error in connect(): pconnect
as opensips
to 192.168.1.39 failed
Nov 9 04:56:22 cdrtool cdrtool[3219]: Database DB_opensips error:
(0) select *
from trusted
Nov 9 04:56:22 cdrtool cdrtool[3219]: PSTN destinations cache size:
0.64 MB
Nov 9 04:56:22 cdrtool cdrtool[3219]: SIP destinations cache size:
0.00 MB
Nov 9 04:56:22 cdrtool cdrtool[3219]: Cached 12291 total, 12291
default, 0
gateway, 0 domain, 0 subscriber destinations
Nov 9 04:56:22 cdrtool cdrtool[3219]: Cached 0 SIP destinations
the cdrtool is fine with almost component except the connection to
opensips
the global.inc with define opensips server
class DB_opensips extends DB_Sql {
var $Host = 192.168.1.39;
var $Database = opensips;
var $User = opensips;
var $Password = sips;
var $Halt_On_Error = no;
}
and issue the command grant all on opensips.* to
opensips@'192.168.1.%'
identified by 'sips'; in opensips server
please help
Ha`
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] cdrtool install problem
Hi, I am unable to reproduce this,. I can install php5-geoip, geoip- database and cdrtool fine on Debian unstable. Which version of Debian are you using? Best regards, Tijmen de Mes AG Projects On Nov 2, 2010, at 4:03 PM, ha do wrote: Hi i try to install cdrtool in debian OS but i got stuck when install cdrtool cdrtool:/mnt# apt-get install php5-geoip Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libgeoip1 Suggested packages: geoip-bin The following packages will be REMOVED: geoip-database The following NEW packages will be installed: libgeoip1 php5-geoip 0 upgraded, 2 newly installed, 1 to remove and 0 not upgraded. Need to get 0B/660kB of archives. After this operation, 4403kB disk space will be freed. Do you want to continue [Y/n]? cdrtool requires php5-geoip + geoip-database but the php5-geoip dependent on libgeoip1. when i install libgeoip1 it remove geoip-database Please help Thank you Ha` ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] How callcontrol works for prepaid accounting
Hi Vishu, This is all explained in the documentation for the rating engine. (http://cdrtool.ag-projects.com/browser/doc/RATING.txt ) See section 3 called ' Determination of the costs' Best regards, -- Tijmen de Mes AG Projects On Sep 16, 2010, at 8:15 PM, vishu gaddi wrote: Thanks a ton Tijemen for reply. I have gone through it, but was lil confused with database tables. i mean in which table customers are defined including balances and how tariffs are defined for each customers. i want only one tariff for all my customers having their individuals balances . Thanks, Vishu On Thu, Sep 16, 2010 at 4:20 PM, Tijmen de Mes tij...@ag- projects.com wrote: Hi Vishu Callcontrol will connect to the CDRTool rating engine to get the balances and maximum session times. Customers and balances need to be defined in CDRTool. The API is described here http://download.ag-projects.com/CDRTool/doc/PREPAID.txt You should also take a look at the rating engine ( http://download.ag-projects.com/CDRTool/doc/RATING.txt) as the db scheme used by CDRTool is described there. Best regards, -- Tijmen de Mes AG Projects On Sep 15, 2010, at 9:56 PM, vishu gaddi wrote: Hi, I have installed Opensips, opensips-cp, Free Radius (accounting), CDRTool and is weoking fine. Recently i have installed CALL CONTROL application for prepaid accounting purpose. Can someone pls brief where and how to define the customers with their balances and how do they relate with their tariffs ? right now, i am using address table for IP authentication, but where to define balances and all.. pls brief Thanks in advance Vishu Gaddi ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] How callcontrol works for prepaid accounting
Hi Dimitri, Sure that is possible, for this please go to http://www.ag-projects.com/content/view/91/101/ . Best regards, On Sep 16, 2010, at 3:21 PM, DM wrote: Hi Tijmen, It is possible to submit a feature request regarding this? Thanks, Dimitri 2010/9/16 Tijmen de Mes tij...@ag-projects.com Hi Dimitri, Prepaid accounting is per u...@domain, not per IP or per whole domain. Best regards, -- Tijmen de Mes AG Projects On Sep 16, 2010, at 1:01 PM, DM wrote: Hi Tijmen, CDRTool and Callcontrol can be used for domain based prepaid accounting? Like if I have a wholesale customer, and I would like to apply prepaid based on the customer's IP Thanks, Dimitri 2010/9/16 Tijmen de Mes tij...@ag-projects.com Hi Vishu Callcontrol will connect to the CDRTool rating engine to get the balances and maximum session times. Customers and balances need to be defined in CDRTool. The API is described here http://download.ag-projects.com/CDRTool/doc/PREPAID.txt You should also take a look at the rating engine ( http://download.ag-projects.com/CDRTool/doc/RATING.txt) as the db scheme used by CDRTool is described there. Best regards, -- Tijmen de Mes AG Projects On Sep 15, 2010, at 9:56 PM, vishu gaddi wrote: Hi, I have installed Opensips, opensips-cp, Free Radius (accounting), CDRTool and is weoking fine. Recently i have installed CALL CONTROL application for prepaid accounting purpose. Can someone pls brief where and how to define the customers with their balances and how do they relate with their tariffs ? right now, i am using address table for IP authentication, but where to define balances and all.. pls brief Thanks in advance Vishu Gaddi ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] How callcontrol works for prepaid accounting
Hi Vishu Callcontrol will connect to the CDRTool rating engine to get the balances and maximum session times. Customers and balances need to be defined in CDRTool. The API is described here http://download.ag-projects.com/CDRTool/doc/PREPAID.txt You should also take a look at the rating engine ( http://download.ag-projects.com/CDRTool/doc/RATING.txt) as the db scheme used by CDRTool is described there. Best regards, -- Tijmen de Mes AG Projects On Sep 15, 2010, at 9:56 PM, vishu gaddi wrote: Hi, I have installed Opensips, opensips-cp, Free Radius (accounting), CDRTool and is weoking fine. Recently i have installed CALL CONTROL application for prepaid accounting purpose. Can someone pls brief where and how to define the customers with their balances and how do they relate with their tariffs ? right now, i am using address table for IP authentication, but where to define balances and all.. pls brief Thanks in advance Vishu Gaddi ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] How callcontrol works for prepaid accounting
Hi Dimitri, Prepaid accounting is per u...@domain, not per IP or per whole domain. Best regards, -- Tijmen de Mes AG Projects On Sep 16, 2010, at 1:01 PM, DM wrote: Hi Tijmen, CDRTool and Callcontrol can be used for domain based prepaid accounting? Like if I have a wholesale customer, and I would like to apply prepaid based on the customer's IP Thanks, Dimitri 2010/9/16 Tijmen de Mes tij...@ag-projects.com Hi Vishu Callcontrol will connect to the CDRTool rating engine to get the balances and maximum session times. Customers and balances need to be defined in CDRTool. The API is described here http://download.ag-projects.com/CDRTool/doc/PREPAID.txt You should also take a look at the rating engine ( http://download.ag-projects.com/CDRTool/doc/RATING.txt) as the db scheme used by CDRTool is described there. Best regards, -- Tijmen de Mes AG Projects On Sep 15, 2010, at 9:56 PM, vishu gaddi wrote: Hi, I have installed Opensips, opensips-cp, Free Radius (accounting), CDRTool and is weoking fine. Recently i have installed CALL CONTROL application for prepaid accounting purpose. Can someone pls brief where and how to define the customers with their balances and how do they relate with their tariffs ? right now, i am using address table for IP authentication, but where to define balances and all.. pls brief Thanks in advance Vishu Gaddi ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] unable to start mediaproxy
Hi Asim, The relay connects to the dispatcher using TLS. For testing you can use the sample files in the tls directory in the tar.gz. If you want to use in in production you'll have to generate your own files. Regards, Tijmen On 2 Feb 2009, at 16:23, Asim Riaz wrote: Hi List, I am getting below error when trying to start mediaproxy 2.3.2; fatal error: failed to create MediaProxy Relay: missing or unreadable file: tls/relay.crt the directory /etc/mediaproxy/tls is empty any idea ? Thanks, Asim ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
