Hi Adrian,<br><br>I don't have UserQuotaClass in my global.inc, but SELECTs are executed according to syslog:<br><br>Feb 2 15:55:02 cdr cdrtool[25649]: ConnectFee=0.0000 CallId=<a href="mailto:c2a5537d-1641aef4@192.168.1.113" target="_blank">c2a5537d-1641aef4@192.168.1.113</a> Span=1 Duration=60 DestId=790433 default Profile=500 Period=w<br>
eekday Rate=default Interval=0-24 Cost=2.2400/60 Price=2.2400 Price in=1.6000<br>Feb
2 15:55:02 cdr cdrtool[25649]: Database error: Invalid SQL: select
quota from subscriber where username = 'XXXXXX' and domain = YYYYYYY' <br>
Feb 2 15:55:02 cdr cdrtool[25649]: 67<br><br>I
want to disable quota because of performance concerns (my DB already is
under heavy load with opensips and legacy applications) and a bit of
paranoid thoughts about functionality I'm not fully understand and need.<div><div class="Wj3C7c"><span id="q_11f3886a2131bfb2_1" class="WQ9l9c"></span><br><div class="gmail_quote">On Sun, Feb 1, 2009 at 4:37 PM, Adrian Georgescu <span dir="ltr"><<a href="mailto:ag@ag-projects.com" target="_blank">ag@ag-projects.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Hi Ikar,<div><br></div><div>If your data source does not have
UserQuotaClass defined, the scripts that check the quota are not
performing any actions. This exclude the SELECT in the
opensips.subscriber table so you do not need to add a quota column
either.<div>
<br></div><div>Internally the cdrtool.quota_usage MySQL table is always
updated during the the CDR normalization but this does not require any
changes in OpenSIPS tables.</div><div><br></div><div>For my understanding, what do you want to gain by disabling these internal UPDATEs?</div>
<div><br></div><div>Regards,</div><div>Adrian</div><div><div><br></div><div><div><div><div><div>On Feb 1, 2009, at 1:21 PM, happy.neko wrote:</div><br></div></div><blockquote type="cite"><div><div>
</div><div>Hi,<br><br>I want to disable CDRTool's quota functionality
completely including SELECTs with quota column from subscriber table,
UPDATEs during cdrs normalization etc.<br>How can I do this?<br clear="all">
</div></div><font color="#888888"><br>-- <br>Best regards,<br> Ikar</font> _______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></div></div></div></blockquote></div><br></div>
</div><font color="#888888">-- <br>
<font color="#888888">Best regards,<br> Ikar</font>
</font>