<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Happy,<div><br></div><div>I have disabled all these queries in the trunk version. If you do not want to wait for the next release you can download it from darcs.<div><br></div><div>I hope you are now as your name implies :-)</div><div><br></div><div>Adrian</div><div><br><div><br><div><div>On Feb 2, 2009, at 10:18 PM, happy.neko wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">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> _______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br></div></div></div></body></html>