I've got "Easy Simple Calendar" (http://www.easilysimplecalendar.com/) up and running under Mediawiki. The details of what I needed to do to get it working are here: http://www.easilysimplecalendar.com/forums/showthread.php?t=2765&highlig... ediawiki
Cheers,
al.
-----Original Message----- From: Mark Rakhmilevich [mailto:Mark.Rakhmilevich@chordiant.com] Sent: Tuesday, 25 January 2005 1:10 p.m. To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] Looking for a calendar plugin for Mediawiki
Does anyone know of a plugin or similar solution to maintain and update a calendar on MediaWiki page? I need something that displays one to three months at a time, allows for navigation to past and future months, and uses each unique date as a link to a date's page to let my group maintain some relevant info. I've seen a Calendar plugin mentioned for Twiki, but don't know if it would work on my MediaWiki site. Thanks for any ideas or pointers.
-- Mark
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Hi,
Last night I started getting a strange error from my MediaWiki installation --
Sorry! The wiki is experiencing some technical difficulties, and cannot contact the database server. User wolfandt_wiki has already more than 'max_user_connections' active connections"
The wiki has been running over a month and I've not had this problem before so I wondered if maybe my host had changed something, but they say they haven't --
Max user connections has not been changed. You will want to check your code to make sure that your mysql connections are being closed and not left open as thats the main cause for exceeding that limit of 100 connections.
To be honest I'm always a little suspicious when my host company says that nothing has changed, in the past that has turned out to be false, but other aps I host there, all of which also use MySQL, are and were running just fine and this morning MediaWiki appears to be running fine with no harm to the wiki itself.
Does anyone have any idea what might have caused that error message or how I might avoid it happening again?
Versions --
OS : FreeBSD 4.9-RELEASE-p11 MySQL : Ver 12.22 Distrib 4.0.16 PHP : 4.3.8 MediaWiki : 1.3.9
URL : http://wolfandturtle.net/Indigo/
Myria
I think you just increased your traffic to the point that there are more concurrent requests than MySQL connections.
Fixing it, however, could be problematic. Here's a few ideas: * Convince your host to allow you to use mysql_pconnect() in PHP, and modify the code to use it (and NOT close the connection). See http://www.php.net/manual/en/features.persistent-connections.php before trying this. * Modify the code and have it retry until it can connect. (Probably won't work) * Convince your host to raise the limit to accomadate this increase of traffic.
If these don't work, the only other thing I can think of is to throttle the number of requests (eg, waiting 15 seconds before doing any proccessing). But this should be avoided if possible.
On Tue, 25 Jan 2005 10:07:43 -0500, Myria myria@wolfandturtle.net wrote:
Hi,
Last night I started getting a strange error from my MediaWiki installation
Sorry! The wiki is experiencing some technical difficulties, and cannot contact the database server. User wolfandt_wiki has already more than 'max_user_connections' active connections"
The wiki has been running over a month and I've not had this problem before so I wondered if maybe my host had changed something, but they say they haven't --
Max user connections has not been changed. You will want to check your code to make sure that your mysql connections are being closed and not left open as thats the main cause for exceeding that limit of 100 connections.
To be honest I'm always a little suspicious when my host company says that nothing has changed, in the past that has turned out to be false, but other aps I host there, all of which also use MySQL, are and were running just fine and this morning MediaWiki appears to be running fine with no harm to the wiki itself.
Does anyone have any idea what might have caused that error message or how I might avoid it happening again?
Versions --
OS : FreeBSD 4.9-RELEASE-p11 MySQL : Ver 12.22 Distrib 4.0.16 PHP : 4.3.8 MediaWiki : 1.3.9
URL : http://wolfandturtle.net/Indigo/
Myria
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Jamie Bliss wrote: | I think you just increased your traffic to the point that there are | more concurrent requests than MySQL connections. | | Fixing it, however, could be problematic. Here's a few ideas: | * Convince your host to allow you to use mysql_pconnect() in PHP, and | modify the code to use it (and NOT close the connection). See | http://www.php.net/manual/en/features.persistent-connections.php | before trying this.
In my experience this actually is _more_ likely to lead to too-many-connection errors, because every Apache child process will end up with a connection open even if it's not running the wiki at the moment.
If several users on a shared host use persistent connections in their scripts, you could easily end up with _several_ connections open per process. With a default MaxClients of 150 on Apache, this is going to overwhelm a MySQL max_user_connections of 100 rather easily.
Using non-persistent connections, they will close when the wiki finishes, and so keepalives, images, style sheets, and other customers' web requests on that server will not be maintaining an unused connection open.
It's entirely possible that some other customer is at fault, opening a lot of connections which clog up the server. It's also possible that something's causing 100+ wiki requests to happen at once, such as really long stuck processes while a bunch of people try to load pages over and over.
- -- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org