The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

This may not be an issue with Sympa, but a limit on the POST size in your web server, or possibly a timeout issue on the execution.

 

If using Apache, take a look at the LimitRequestBody setting, which can be set to a maximum of 2GB in most cases (possibly more if you’re using Apache 2.6 and 64bit OS?).  Also, set Timeout to be sufficiently high.

 

Since Sympa uses mod_fcgid, there are several settings to put there.  Try this construct:

 

<IfModule mod_fcgid.c>

    IPCCommTimeout 900

    BusyTimeout 900

    MaxRequestLen 102400000

</IfModule>

 

This will also tune for the request body size, and the upload itmeout.

 

Finally, consider if the way you are updating the membership is really appropriate.  Maybe you can automate this by either directly inserting the members into the database, or by using an external datasource so that Sympa instead pulls the membership (using HTTP or a database query) from its source?  Or, place the list of members into a local file (using FTP , SCP or similar) so that Sympa can use the file external datasource to read it.

 

Steve

 

Steve Shipway

address@concealed

(GNU Terry Pratchett)

 

From: address@concealed [mailto:address@concealed] On Behalf Of Tomaschewski-Walser Doris (ID SDL)
Sent: Tuesday, 21 April 2015 8:05 p.m.
To: address@concealed
Subject: [sympa-users] Multiple add time limit of 5 minutes?

 

We have a list with constantly changing members. When adding 17'000 members with the "multiple add" function, there are no problems. When adding 21'000, the server responds with "Internal Server Error"

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, address@concealed and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

In the log it says "Premature end of script headers: wwsympa.fcgi".
Apparently 5 minutes is not enough to enter all 21'000 new Review members. 

How can we avoid these problems? Do we have to put a higher the sql_fetch_timeout?

Best regards

Doris Tomaschewski

ETH Zürich, Switzerland

Attachment: smime.p7s
Description: S/MIME cryptographic signature