[rt-users] Cannot sent files of 1MB or larger via REST reqs
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. I understand this issue might have been caused in the web app (not RT) but i just wanted to know if someone could shed some light here. Are there any size (or otherwise) limits that i could change in RT's (or apache) side? Any help will be highly appreciated -- 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 linkedin-24x24.pngAFS_logo.pngfacebook-24x24.png
Re: [rt-users] Cannot sent files of 1MB or larger via REST reqs
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
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
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.