ailto:[EMAIL PROTECTED] On Behalf Of Brice Levy
Sent: Thursday, February 19, 2004 10:06 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] StorageDB configuration
Hi again,
I finally found out why it did not work, and how to have it work.
It seems (on both systems I've t
Hi again,
I finally found out why it did not work, and how to have it work.
It seems (on both systems I've tried) that options files are read by mysql
client, but not by mysql server.
Hence, mysql --help reported the value I wanted to set, but mysql server
still used the default 1Mbyte value ...
Hi Brice,
On Thu, Feb 19, 2004 at 02:31:40PM +0100, Brice Levy wrote:
> > Try adding the following to you my.cnf
> >set-variable= max_allowed_packet=20M
>
> I've added the following lines to /etc/my.cnf
> [mysql]
> set-variable = max_allowed_packet=20M
>
> It seems to be ok for mysql :
> $ m
Hi Thomas,
> Try adding the following to you my.cnf
>set-variable= max_allowed_packet=20M
I've added the following lines to /etc/my.cnf
[mysql]
set-variable = max_allowed_packet=20M
It seems to be ok for mysql :
$ mysql --help | grep packet
max_allowed_packetcurrent value: 20970496
But
ser questions and discussions about OTRS.
>Subject: Re: [otrs] StorageDB configuration
>
>
>Hi Martin,
>
>> Normally /etc/my.cnf works (in my cases).
>I found out that /etc/my.cnf works, and the other ways too.
>What's more, the default on my system is 16Mbytes, which is
&
Hi Martin,
> Normally /etc/my.cnf works (in my cases).
I found out that /etc/my.cnf works, and the other ways too.
What's more, the default on my system is 16Mbytes, which is quote enough for
our needs :
--
$ mysql --help | grep packet
max_allowed_packetcurrent value: 16777216
--
Alas, I stil
Hi Brice,
On Wed, Feb 18, 2004 at 02:02:25PM +0100, Brice Levy wrote:
> Our OTRS system uses the default Kernel::System::Ticket::ArticleStorageDB
> (because apache does not run as otrs), and I would like to be able to store
> larger tickets than the default.
> OTRS doc says i have to use max_allo
Hi,
Our OTRS system uses the default Kernel::System::Ticket::ArticleStorageDB
(because apache does not run as otrs), and I would like to be able to store
larger tickets than the default.
OTRS doc says i have to use max_allowed_packet=8M in mysql configuration.
I have created (following MySQL doc)
