Can not open ticket with attachment on 4.0.5

Hi people.

I finished migrate my old RT to new 4.0.5.
I see that i can´t open a ticket if this ticket have an attachment. But, i
can attach a file to an existente ticket.

Could you help me?

Thanks.
Kindest regards.

Un saludo.
Juanjo Corral

I finished migrate my old RT to new 4.0.5.

From which version on what DB?

Best regards, Ruslan.

I think i know what are the problem.

Mysql are using all the ram memory, when this happend doesn´t accept
attachment (per email or per uploading to ticket).

Other thing, On Chrome when i upload a attachment i get a 500 internal
server error. With IE or Firefox doesn´t occur.

Sorry :frowning:

From 3.6.5 to 4.0.5 on mysql.

I finished migrate my old RT to new 4.0.5.

From which version on what DB?


Best regards, Ruslan.


Un saludo.
Juanjo Corral


Un saludo.
Juanjo Corral

Un saludo.
Juanjo Corral

The internal errors occur if i use other language than english. I thin that
i open new cuestion about it.2012/5/9 Juanjo juanjillo@gmail.com

2012/5/9 Juanjo juanjillo@gmail.com

I think i know what are the problem.

Mysql are using all the ram memory, when this happend doesn´t accept
attachment (per email or per uploading to ticket).

Other thing, On Chrome when i upload a attachment i get a 500 internal
server error. With IE or Firefox doesn´t occur.

2012/5/9 Juanjo juanjillo@gmail.com

Sorry :frowning:

From 3.6.5 to 4.0.5 on mysql.

2012/5/8 Ruslan Zakirov ruz@bestpractical.com

On Tue, May 8, 2012 at 7:21 PM, Juanjo juanjillo@gmail.com wrote:

I finished migrate my old RT to new 4.0.5.

From which version on what DB?


Best regards, Ruslan.


Un saludo.
Juanjo Corral


Un saludo.
Juanjo Corral


Un saludo.
Juanjo Corral

Un saludo.
Juanjo Corral

Yes.

But i have some extra info.
In the time i can´t open ticket with attachment, the mysql is at 90% (or
more) of ram memory. I change my my.cnf to make mysql less ram hungry.

But it donesn´t he problem, not works fine. I can´t upload if the file is
up than 100kb. I get an 500 internal server error. If the file is 24k works
fine for uopload, if is miore than 100k i cant upload it.2012/5/9 Ruslan Zakirov ruz@bestpractical.com

On Wed, May 9, 2012 at 10:52 AM, Juanjo juanjillo@gmail.com wrote:

Sorry :frowning:

From 3.6.5 to 4.0.5 on mysql.

Have you followed UPGRADING.mysql instructions?

2012/5/8 Ruslan Zakirov ruz@bestpractical.com

On Tue, May 8, 2012 at 7:21 PM, Juanjo juanjillo@gmail.com wrote:

I finished migrate my old RT to new 4.0.5.

From which version on what DB?


Best regards, Ruslan.


Un saludo.
Juanjo Corral


Best regards, Ruslan.

Un saludo.
Juanjo Corral

:frowning: Sorry for my obstination and impatience.

I checked the apache log. If you use fastcgi, the upload limit are around
100k. You need to edit the vitualhost definition for RT with this.

    <IfModule mod_fcgid.c>
       # 20MB should be enough
       MaxRequestLen 20000000
    </IfModule>

It permit upload files at least 20MB.

Sorry for the all the emails sent without making standart tests.
Kindest Regards.2012/5/9 Juanjo juanjillo@gmail.com

Yes.

But i have some extra info.
In the time i can´t open ticket with attachment, the mysql is at 90% (or
more) of ram memory. I change my my.cnf to make mysql less ram hungry.

But it donesn´t he problem, not works fine. I can´t upload if the file is
up than 100kb. I get an 500 internal server error. If the file is 24k works
fine for uopload, if is miore than 100k i cant upload it.

2012/5/9 Ruslan Zakirov ruz@bestpractical.com

On Wed, May 9, 2012 at 10:52 AM, Juanjo juanjillo@gmail.com wrote:

Sorry :frowning:

From 3.6.5 to 4.0.5 on mysql.

Have you followed UPGRADING.mysql instructions?

2012/5/8 Ruslan Zakirov ruz@bestpractical.com

On Tue, May 8, 2012 at 7:21 PM, Juanjo juanjillo@gmail.com wrote:

I finished migrate my old RT to new 4.0.5.

From which version on what DB?


Best regards, Ruslan.


Un saludo.
Juanjo Corral


Best regards, Ruslan.


Un saludo.
Juanjo Corral

Un saludo.
Juanjo Corral

:frowning: Sorry for my obstination and impatience.

I checked the apache log. If you use fastcgi, the upload limit are around
100k. You need to edit the vitualhost definition for RT with this.

    <IfModule mod_fcgid.c>
       # 20MB should be enough
       MaxRequestLen 20000000
    </IfModule>

It permit upload files at least 20MB.

Sorry for the all the emails sent without making standart tests.
Kindest Regards.

mysql also has max_packet_size (spelling may be wrong).

Yes.

But i have some extra info.
In the time i can´t open ticket with attachment, the mysql is at 90% (or
more) of ram memory. I change my my.cnf to make mysql less ram hungry.

But it donesn´t he problem, not works fine. I can´t upload if the file is
up than 100kb. I get an 500 internal server error. If the file is 24k works
fine for uopload, if is miore than 100k i cant upload it.

Sorry :frowning:

From 3.6.5 to 4.0.5 on mysql.

Have you followed UPGRADING.mysql instructions?

I finished migrate my old RT to new 4.0.5.

From which version on what DB?


Best regards, Ruslan.


Un saludo.
Juanjo Corral


Best regards, Ruslan.


Un saludo.
Juanjo Corral


Un saludo.
Juanjo Corral

Best regards, Ruslan.

Yes, this parameter is OK (at 15MB, per default). But the fastcgi parameter
by default is only 100k.2012/5/9 Ruslan Zakirov ruz@bestpractical.com

mysql also has max_packet_size (spelling may be wrong).

Un saludo.
Juanjo Corral

Yes, this parameter is OK (at 15MB, per default). But the fastcgi parameter by default is only
100k.

Yep, this is why I added

which will be in the docs for the next RT release.

-kevin> 2012/5/9 Ruslan Zakirov <[1]ruz@bestpractical.com>

 mysql also has max_packet_size (spelling may be wrong).

Ok,. Thanks.2012/5/9 Kevin Falcone falcone@bestpractical.com

On Wed, May 09, 2012 at 01:50:00PM +0200, Juanjo wrote:

Yes, this parameter is OK (at 15MB, per default). But the fastcgi
parameter by default is only
100k.

Yep, this is why I added

Warn about the FcgidMaxRequestLen change in mod_fcgid 2.3.6 · bestpractical/rt@89c6750 · GitHub
which will be in the docs for the next RT release.

-kevin

2012/5/9 Ruslan Zakirov <[1]ruz@bestpractical.com>

 mysql also has max_packet_size (spelling may be wrong).

Un saludo.
Juanjo Corral