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