Re: [rt-users] Cannot sent files of 1MB or larger via REST reqs

2013-03-29 Thread Thomas Sibley 
On 03/29/2013 01:18 PM, Hugo Escobar wrote:
 Hi,
 
 I've been using the REST api for some time to communicate RT with a custom
 made web app.
 
 I'm having problems sending files when their size approach 1MB.
 
 The following lines show up in apache's error logs when i attempt to
 upload big files:
 
 [Fri Mar 29 16:07:08 2013] [warn] [client 192.168.1.106] mod_fcgid:
 error reading data, FastCGI server closed connection
 [Fri Mar 29 16:07:08 2013] [error] [client 192.168.1.106] Premature end
 of script headers: rt-server.fcgi
 
 For smaller sizes it works perfectly, even with multiple files.

Read the warning about mod_fcgid here:
http://bestpractical.com/rt/docs/latest/web_deployment.html#mod_fcgid

1MB isn't the large or small default, but perhaps something else set
FcgidMaxRequestLen recently and you need to increase it.

Re: [rt-users] Cannot sent files of 1MB or larger via REST reqs

2013-03-29 Thread Hugo Escobar 
Thank you Thomas. It seems to be going in the right direction. Just to let
you know, the message disappeared
since I Added FcgidMaxRequestLen to apache conf. The problem seems to be in
the db side,

[Fri Mar 29 20:30:23 2013] [warning]: DBD::mysql::rtuser execute failed:
MySQL server has gone away at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
[Fri Mar 29 20:30:23 2013] [warning]: RT::Handle=HASH(0x6e23eb8) couldn't
execute the query 'INSERT INTO Attachments (Subject, ContentType, Filename,
Headers, MessageId, Creator, Parent, Created, ContentEncoding, Content,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.

DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x6e23eb8)',
'INSERT INTO Attachments (Subject, ContentType, Filename, Head...', '',
'application/octet-stream', 'some-1mb-file.pdf', 'Content-Type:
application/octet-stream; name=some-...', '', 127, 1645, ...) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 350



On Fri, Mar 29, 2013 at 4:24 PM, Thomas Sibley t...@bestpractical.comwrote:

 On 03/29/2013 01:18 PM, Hugo Escobar wrote:
  Hi,
 
  I've been using the REST api for some time to communicate RT with a
 custom
  made web app.
 
  I'm having problems sending files when their size approach 1MB.
 
  The following lines show up in apache's error logs when i attempt to
  upload big files:
 
  [Fri Mar 29 16:07:08 2013] [warn] [client 192.168.1.106] mod_fcgid:
  error reading data, FastCGI server closed connection
  [Fri Mar 29 16:07:08 2013] [error] [client 192.168.1.106] Premature end
  of script headers: rt-server.fcgi
 
  For smaller sizes it works perfectly, even with multiple files.

 Read the warning about mod_fcgid here:
 http://bestpractical.com/rt/docs/latest/web_deployment.html#mod_fcgid

 1MB isn't the large or small default, but perhaps something else set
 FcgidMaxRequestLen recently and you need to increase it.




-- 
Hugo Escobar


[image: AFS_logo.png]

Follow us on Facebook and Linked-In

[image: 
facebook-24x24.png]http://www.facebook.com/pages/Miami-FL/ASSOCIATION-FINANCIAL/64952991864
 [image: linkedin-24x24.png] http://www.linkedin.com/companies/1006276
AFS_logo.pngfacebook-24x24.pnglinkedin-24x24.png

Re: [rt-users] Cannot sent files of 1MB or larger via REST reqs

2013-03-29 Thread Thomas Sibley 
On 03/29/2013 01:36 PM, Hugo Escobar wrote:
 Thank you Thomas. It seems to be going in the right direction. Just to
 let you know, the message disappeared
 since I Added FcgidMaxRequestLen to apache conf. The problem seems to be
 in the db side,

Check your MySQL max_allowed_packet value.