<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Calibri">Hi Daniel - <br>
<br>
Thanks for your reply.<br>
<br>
That variable is already set at 128m on our systems, both in
templates and in "running config"; and anyway, if you reduce it,
say to 1m, you get an nginx server error to the browser "413
Request Entity Too Large", not the error message within the
sipwise web UI that I'm seeing.<br>
<br>
So I did a whole load of hunting, and found it is actually in
/usr/share/perl5/NGCP/Panel/Form/BillingFeeUpload.pm<br>
line 16ish:<br>
has_field 'upload_fees' => (<br>
type => 'Upload',<br>
max_size => '200000000',<br>
);<br>
<br>
I modified that x10 to 20000000, did service ngcp-panel restart <br>
<br>
Now it works, with much larger files!<br>
<br>
<br>
Cheers<br>
<br>
Gavin<br>
<br>
<br>
</font>
<div class="moz-cite-prefix">On 02/07/2015 12:31, Daniel Grotti
wrote:<br>
</div>
<blockquote cite="mid:55952108.20904@sipwise.com" type="cite">
<pre wrap="">Hi Gavin,
try to increase:
client_max_body_size 128m;
in /etc/ngcp-config/templates/etc/nginx/ngcp-panel_params.tt2.
--
Daniel Grotti
VoIP Engineer
Sipwise GmbH
Europaring F15 | 2345 Brunn am Gebirge, Austria | <a class="moz-txt-link-abbreviated" href="http://www.sipwise.com">www.sipwise.com</a>
On 07/01/2015 01:02 PM, Gavin Sweet wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi George - Thanks!
If it were a simple single table, yes.
But there are joins out to multiple tables, for fees history, zones,
zones history etc - these are handled by the api.
Gavin
On 01/07/2015 11:47, George Mason wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On 01/07/15 11:43, Gavin Sweet wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Anyone help me on this?
(yes, splitting files is possible but its not really a solution)
Thanks,
Gavin
On 30/06/2015 14:44, Gavin Sweet wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi -
I am getting an error trying to upload a new billing fees csv file,
file size greater than 200K.
Is there a way to increase this file size limit? I have a file now at
nearly 5Mb, all are valid strings with different fees.
Cheers
Gavin
</pre>
</blockquote>
</blockquote>
<pre wrap="">If you can get the CSV into the right format for the table, you could
import straight in, avoiding the web interface altogether:
<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/3635166/how-to-import-csv-file-to-mysql-table">https://stackoverflow.com/questions/3635166/how-to-import-csv-file-to-mysql-table</a>
I have done this on other systems when faced with the same issue with
good success.
_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>