[OpenSIPS-Users] CDRTool - increasing max_allowed_packet

[DanB]

Brett,
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).
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).

Thx,
DanB

On Thu, Jul 9, 2009 at 4:29 PM, Brett Nemeroff <brett at nemeroff.com> wrote:

> I would think that those params would change it for libmysqlclient. Have
> you tried it?
>
>
> On Thu, Jul 9, 2009 at 3:12 AM, DanB <danb at sms4sip.com> wrote:
>
>> Hi Brett,
>> Thanks for the link.
>>
>> 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?
>>
>> Ta,
>> DanB
>>
>>
>> On Wed, Jul 8, 2009 at 7:37 PM, Brett Nemeroff <brett at nemeroff.com>wrote:
>>
>>> Quick google got me this:
>>> http://www.astahost.com/info.php/Max_allowed_packet-Mysql_t2725.html
>>>
>>> <shrug> ??
>>> -Brett
>>>
>>>
>>> On Wed, Jul 8, 2009 at 11:34 AM, DanB <danb at sms4sip.com> wrote:
>>>
>>>> Adrian,
>>>> I spent quite a long time searching for a way to modify this setting,
>>>> but could not find it anywhere.
>>>>
>>>> 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.
>>>>
>>>> Regards,
>>>> DanB
>>>>
>>>>
>>>> On Tue, Jul 7, 2009 at 11:23 AM, Adrian Georgescu <ag at ag-projects.com>wrote:
>>>>
>>>>> Dan
>>>>> I did not see this yet but it sounds like a PHP setting, you may want
>>>>> to check your php.ini.
>>>>> Adrian
>>>>>
>>>>> On Jul 6, 2009, at 12:49 PM, DanB wrote:
>>>>>
>>>>> Hey Guys,
>>>>> I have recently discovered a problem with one of my CDRTool
>>>>> installations.
>>>>> I have about 2.2 mil destinations in cdrtool.destinations table and
>>>>> when trying to load them into cdrtool memory, the process fails with:
>>>>> "Got a packet bigger than 'max_allowed_packet' bytes (1153)".
>>>>>
>>>>> Can u please advice how to increase this value?
>>>>>
>>>>> Ta,
>>>>> DanB
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090710/6c589c20/attachment.htm