[OpenSER-Users] OPenser+mediaproxy

[David Villasmil]

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 at gmail.com> 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 <ibc at aliax.net> 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 at lists.openser.org
>> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080617/47a63e68/attachment.htm