New subject: [OpenSER-Users] OPenser+mediaproxy

17 Jun 2008

Iñaki,

     Is this the same thing that's happening to me?

  * Fixed vulnerability related to missing BYE and MediaProxy
    radius Update action (reported by Inaki Baz Castil)
    You  must reload the sql stored procedures from
    setup/radius/OpenSER/radius_accounting.proc or
    update Freeradius with setup/radius/OpenSER/sql.conf
    when not using the stored procedures

I've been looking at the queries cdrtool and mediaproxy executeon mysql and
although mediaproxy SUCCESFULLY detects a lost call and UPDATES the
AcctStopTime, cdrtools doesn't updates the record info because MediaInfo is
NOT NULL...

this is the query cdrtool execs to get the cdrs to rate:

select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from radacct where
(1=1)  and  Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00' 
and
(ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '')

MediaInfo (after update from mediaproxy) is NOT null... the rest of the
fields are ok.

thanks

David

On Mon, Jun 16, 2008 at 10:00 PM, David Villasmil <
david.villasmil.work(a)gmail.com&gt; wrote:

...
  I believe so, if not, who could update the
AcctStopTime? I shutdown my UAC
 by hand, so no BYE was sent.

 this is my config:

 [Dispatcher]
 start = yes
 socket = /var/run/mediaproxy/proxydispatcher.sock
 group = openser
 defaultProxy = /var/run/mediaproxy/mediaproxy.sock

 [MediaProxy]
 start = yes
 socket = /var/run/mediaproxy/mediaproxy.sock
 group = openser
 listen = 192.168.1.9
 ;IP-Address of your host (not localhost, not 127.0.0.1)
 allow = 192.168.1.19
 ;IP-Address of your host (not localhost, not 127.0.0.1)
 ;if empty (undefined), takes the first entry of /etc/hosts
 proxyIP = 1.2.3.4
 portRange = 35000:65000

 TOS = 0xb8
 idleTimeout = 20
 holdTimeout = 300
 forceClose = 900

 [Accounting]
 dbaccounting = on

 [Database]
 user = openser
 password = mypass
 host = 192.168.1.19
 database = radius
 table = radacct

 do you see anything strange?

 thanks a lot

 On Mon, Jun 16, 2008 at 9:56 PM, Iñaki Baz Castillo &lt;ibc(a)aliax.net&gt; wrote:

  El Lunes, 16 de Junio de 2008, David Villasmil
escribió:
  I've configure openser and mediaproxy con
pass all rtps via  mediaproxy....
  I've found this error that is a bit weird:

 some calls are not rated, Calls that do not get the BYE, although they  are
  updated on the radacct table with its
corresponding AcctStopTime, they  are
  NOT rated, and on the cdr page are showing as
"in progress" which is not
 true by any means!

 Has anyone encountered this? 
 Have you configured MediaProxy to update radacct table?

 --
 Iñaki Baz Castillo

 _______________________________________________
 Users mailing list
 Users(a)lists.openser.org
 http://lists.openser.org/cgi-bin/mailman/listinfo/users

Re: [OpenSER-Users] OPenser+mediaproxy