17 Jun
2008
17 Jun
'08
9:10 a.m.
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> 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(a)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(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users