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@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@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@lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users