Brett,<div><br></div><div>since I am not a php programmer, was looking for some stored configuration setting instead of running the command at starting of each mysql session(place where I don't have access as a user). </div>
<div>If that is what is needed, then the CDRTool should do it when connecting to the mysql sessions (or at least this is what docs suggesting it).</div><div><br></div><div>Thx,</div><div>DanB<br><br><div class="gmail_quote">
On Thu, Jul 9, 2009 at 4:29 PM, Brett Nemeroff <span dir="ltr"><<a href="mailto:brett@nemeroff.com">brett@nemeroff.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I would think that those params would change it for libmysqlclient. Have you tried it?<div><div></div><div class="h5"><div><br><br><div class="gmail_quote">On Thu, Jul 9, 2009 at 3:12 AM, DanB <span dir="ltr"><<a href="mailto:danb@sms4sip.com" target="_blank">danb@sms4sip.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Brett,<div><br></div><div>Thanks for the link.</div><div><br></div><div>I see (found on google many links too) how to configure both mysql-server or mysql_cli_client's max_allowed_packet but for some reason I miss how to configure libmysqlclient one (the one php is using). Is this something that I miss from the link you have sent me?</div>
<div><br></div><div>Ta,</div><div>DanB<div><div></div><div><br><br><div class="gmail_quote">On Wed, Jul 8, 2009 at 7:37 PM, Brett Nemeroff <span dir="ltr"><<a href="mailto:brett@nemeroff.com" target="_blank">brett@nemeroff.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Quick google got me this:<div><a href="http://www.astahost.com/info.php/Max_allowed_packet-Mysql_t2725.html" target="_blank">http://www.astahost.com/info.php/Max_allowed_packet-Mysql_t2725.html</a></div><div><br></div><div>
<shrug> ??</div>
<div>-Brett</div><div><div></div><div><div><br><br><div class="gmail_quote">On Wed, Jul 8, 2009 at 11:34 AM, DanB <span dir="ltr"><<a href="mailto:danb@sms4sip.com" target="_blank">danb@sms4sip.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="gmail_quote">Adrian,<div><br></div><div>I spent quite a long time searching for a way to modify this setting, but could not find it anywhere.</div><div><br></div><div>One extra info I found was that it was not the amount of rows returned which generated the error but the information in one row, so I have managed as work-around to alter some information inside, and the error is now gone.</div>
<div><br></div><div>Regards,</div><div>DanB <div><div></div><div><div><div></div><div><br><br><div class="gmail_quote">On Tue, Jul 7, 2009 at 11:23 AM, 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="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Dan<div><br></div><div>I did not see this yet but it sounds like a PHP setting, you may want to check your php.ini.<div>
<br></div><div>Adrian</div><div><br></div><div><div><div><div></div><div><div>On Jul 6, 2009, at 12:49 PM, DanB wrote:</div><br></div></div><blockquote type="cite"><div><div></div><div>Hey Guys,<div>
<br></div><div>I have recently discovered a problem with one of my CDRTool installations. </div><div>I have about 2.2 mil destinations in cdrtool.destinations table and when trying to load them into cdrtool memory, the process fails with:</div>
<div>"<span style="font-family:Verdana">Got a packet bigger than 'max_allowed_packet' bytes (1153)".</span></div><div><font face="Verdana"><br></font></div> <div><font face="Verdana">Can u please advice how to increase this value?</font></div>
<div><font face="Verdana"><br></font></div><div><font face="Verdana">Ta,</font></div> <div><font face="Verdana">DanB</font></div></div></div> _______________________________________________<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></blockquote></div><br></div></div>
</div></div></div>
</div><br>
<br>_______________________________________________<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>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>