Iñaki,<br><br> Is this the same thing that's happening to me?<br><br><pre> * Fixed vulnerability related to missing BYE and MediaProxy<br> radius Update action (reported by Inaki Baz Castil)<br> You must reload the sql stored procedures from<br>
setup/radius/OpenSER/radius_accounting.proc or<br> update Freeradius with setup/radius/OpenSER/sql.conf<br> when not using the stored procedures</pre><br>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...<br>
<br>this is the query cdrtool execs to get the cdrs to rate:<br><br>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 != '')<br>
<br><br>MediaInfo (after update from mediaproxy) is NOT null... the rest of the fields are ok.<br><br><br>thanks<br><br>David<br><br><div class="gmail_quote">On Mon, Jun 16, 2008 at 10:00 PM, David Villasmil <<a href="mailto:david.villasmil.work@gmail.com">david.villasmil.work@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I believe so, if not, who could update the AcctStopTime? I shutdown my UAC by hand, so no BYE was sent.<br>
<br>this is my config:<br><br>[Dispatcher]<br>start = yes<br>socket = /var/run/mediaproxy/proxydispatcher.sock<br>group = openser<br>
defaultProxy = /var/run/mediaproxy/mediaproxy.sock<br><br>[MediaProxy]<br>start = yes<br>socket = /var/run/mediaproxy/mediaproxy.sock<br>group = openser<br>listen = <a href="http://192.168.1.9" target="_blank">192.168.1.9</a><br>
;IP-Address of your host (not localhost, not <a href="http://127.0.0.1" target="_blank">127.0.0.1</a>)<br>
allow = <a href="http://192.168.1.19" target="_blank">192.168.1.19</a><br>;IP-Address of your host (not localhost, not <a href="http://127.0.0.1" target="_blank">127.0.0.1</a>)<br>;if empty (undefined), takes the first entry of /etc/hosts<br>
proxyIP = <a href="http://1.2.3.4" target="_blank">1.2.3.4</a><br>
portRange = 35000:65000<br><br>TOS = 0xb8<br>idleTimeout = 20<br>holdTimeout = 300<br>forceClose = 900<br><br>[Accounting]<br>dbaccounting = on<br><br>[Database]<br>user = openser<br>password = mypass<br>host = <a href="http://192.168.1.19" target="_blank">192.168.1.19</a><br>
database = radius<br>table = radacct<br><br>do you see anything strange?<br><br>thanks a lot<div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">On Mon, Jun 16, 2008 at 9:56 PM, Iñaki Baz Castillo <<a href="mailto:ibc@aliax.net" target="_blank">ibc@aliax.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">El Lunes, 16 de Junio de 2008, David Villasmil escribió:<br>
<div><div></div><div>> I've configure openser and mediaproxy con pass all rtps via mediaproxy....<br>
> I've found this error that is a bit weird:<br>
><br>
> some calls are not rated, Calls that do not get the BYE, although they are<br>
> updated on the radacct table with its corresponding AcctStopTime, they are<br>
> NOT rated, and on the cdr page are showing as "in progress" which is not<br>
> true by any means!<br>
><br>
> Has anyone encountered this?<br>
<br>
</div></div>Have you configured MediaProxy to update radacct table?<br>
<font color="#888888"><br>
<br>
<br>
--<br>
Iñaki Baz Castillo<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.openser.org" target="_blank">Users@lists.openser.org</a><br>
<a href="http://lists.openser.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser.org/cgi-bin/mailman/listinfo/users</a><br>
</font></blockquote></div><br>
</div></div></blockquote></div><br>