[MediaWiki-l] Which Apache MPM for MW-SMW?

2015-11-08 Thread Peter Presland
Increasing site traffic has escalated both our cpu and memory issues such that I am constantly tweeking 'bad-bot' and other defences against multiple concurrent connections, from single IP's, IP ranges and in total, using both mod_security and fail2ban/firewalld rules. The problem has prompted 2

Re: [MediaWiki-l] Which Apache MPM for MW-SMW?

2015-11-08 Thread David Gerard
On 8 November 2015 at 10:43, Peter Presland wrote: > Among other things I am considering moving to the Apache event-MPM using > php-fpm and mod_proxy_fcgi because it is claimed to half (or better) > process memory usage and provide major cpu-related speed improvements >

Re: [MediaWiki-l] Which Apache MPM for MW-SMW?

2015-11-08 Thread Jonathan Aquilina
When I have worked with php based websites. I try to avoid apache prefork as that tends to be resource hungry. Look into apache event or worker with php-fpm. You will notice a major difference and things will be quicker. Prefork works on a single thread to process requests. Where as event and

[MediaWiki-l] [Cargo] Error: table "Book" not found (books/authors example)

2015-11-08 Thread Ed
Hello everyone, My name is Ed. This is my first post to the mail list. I hope I'm doing it right. I installed wikimedia, cargo and semantic forms all from git. I attempted to recreate the books/authors example and I run into trouble. Can you help? This is what I did: 1) Created the Book

Re: [MediaWiki-l] [Cargo] Error: table "Book" not found (books/authors example)

2015-11-08 Thread Ed
Hi Yaron, Thank you! Issue 1, as you suggested, seemed to have been a combination of upper/lower case and perhaps singular/plural across both templates for B/book(s) and A/author(s). The solution was to standardize in first letter uppercase and singular all over the place and it now works.

Re: [MediaWiki-l] [Cargo] Error: table "Book" not found (books/authors example)

2015-11-08 Thread Yaron Koren
Hi Ed, For issue #1: your templates are actually somewhat different from what's in the examples, but I tried out your "Book" template just now, and it worked for me. However, your "Author" template seems to contain an error: it queries a table called "Book", instead of "book" (notice the casing