Toolserver-l

toolserver-l@lists.wikimedia.org

1612 discussions

MySQL maintenance tonight
by River Tarnell 27 Aug '10

27 Aug '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I will be restarting all MySQL servers later tonight / tomorrow morning (UTC). For user databases (sql), there will be < 30 minutes downtime. For -rr replicated database, there will be no downtime except on s2/s5, where there will be < 30 minutes downtime. For -user replicated databases, there will be < 30 minutes downtime. - river. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (FreeBSD) iEYEARECAAYFAkx23+MACgkQIXd7fCuc5vIM8ACbBIfvnwizJb2NcfQ/fneyqWTe eHsAnRJPIKUimIY6wtf9w/VEj0rPKwBM =eulh -----END PGP SIGNATURE-----

1 1

MySQL & Ruby changes
by River Tarnell 26 Aug '10

26 Aug '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, We are about to make two changes to the Solaris login servers: * MySQL will be linked with libreadline instead of libeditline. The new MySQL will be more compatible with MySQL on Linux, but will not be able to read existing .mysql_history files previously created on Solaris. You may wish to remove your existing .mysql_history file. * The default Ruby (/usr/bin/ruby) will change from 1.9 to 1.8. Ruby 1.9 is still available it /usr/bin/ruby1.9. - river. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (FreeBSD) iEYEARECAAYFAkx2qYAACgkQIXd7fCuc5vJ6mACfSpusHWz/snPeNYvqzBfx7GwX 9iMAnjlcaOUKPxbVdIePhhmY/gP9jKJd =3Bsi -----END PGP SIGNATURE-----

2 2

New mailing list: newprojects
by Casey Brown 24 Aug '10

24 Aug '10

It seems that no one actually announced the creation of the "newprojects" mailing list yet! The mailing list[1] is an announcement-only list for new Wikimedia wikis[2]. The way it works is that the addwiki.php[3] script that sysadmins use to create the wikis automatically sends a mail to the list, so (provided there are no bugs with the script) subscribers will get an e-mail when every Wikimedia wiki is created. This list should be especially useful for people who need to know when new wikis are created so that they can update their tools or scripts. Of course, people who are just interested in knowing about new wikis are welcomed to subscribe too. :-) [1]https://lists.wikimedia.org/mailman/listinfo/newprojects [2]http://meta.wikimedia.org/wiki/Special:SiteMatrix [3]http://wikitech.wikimedia.org/view/Add_a_wiki -- Casey Brown Cbrown1023

3 4

Reboot of nightshade
by DaB. 21 Aug '10

21 Aug '10

Hello all, I will reboot nightshade tonight at 22 o'clock UTC, because of an kernel- update, The process will be visible at https://jira.toolserver.org/browse/MNT-753 and there will be messages for the user, which are login, before. Sinclery, DaB. -- Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

2 2

Demo of RC-Events over XMPP
by Daniel Kinzler 18 Aug '10

18 Aug '10

Hi all! For a long time I wanted a decent push interface for RC-Events. Parsing messages on IRC is unreliable, and polling the API sucks (and is also unreliable, see Bug 24782). So, I have written XMLRC <http://www.mediawiki.org/wiki/Extension:XMLRC> and set up a prototype on the Toolserver - have a look at <http://meta.wikimedia.org/wiki/Recentchanges_via_XMPP> for details. Basically, you point any Jabber client to the chat room <enwiki(a)conference.jabber.toolserver.org> to see the change events, like on IRC. However, if you use a client aware of the extra data attached to the messages, like <http://www.mediawiki.org/wiki/Extension:XMLRC/rcclient.py>, you will get all the information you can get from the API (in fact, you can get the exact same XML tag). Try it out and let me know what you think! -- daniel

1 0

Toolserver outage
by River Tarnell 17 Aug '10

17 Aug '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, There was an outage of the Toolserver from around 2200h, 17th August until around 0020h. The initial cause of the outage was a network issue at Wikimedia (who provide us with transit). The network outage caused a cascading failure of the two HA clusters (turnera/damiana and wolfsbane/ortelius), which prolonged the outage by about 20 minutes. The problem is now resolved and all services should be accessible again. Although the cluster outage did not significantly extend the outage (since cluster is quite good as recovering itself), it is nonetheless not something that should have happened, and we will be reviewing the cluster setup to prevent it happening in the future. - river.. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (FreeBSD) iEYEARECAAYFAkxrGiUACgkQIXd7fCuc5vLk5QCdGZPp2+5/kDUW3jq+NZ6HkVb0 hDsAn1GBCTY9n2v/idrjNXa08Zrnmol3 =D8KG -----END PGP SIGNATURE-----

1 0

Changes to 'sql' script
by River Tarnell 16 Aug '10

16 Aug '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, It is now possible to specify the server type (RR or user) when using the 'sql' script: $ sql -u enwiki_p # Connect to user database $ sql -r enwiki_p # Connect to RR database If you currently use 'sql' for scripting, you should update your scripts to specify one of these options. Currently, the default (if no option is specified) is to connect to the obsolete sql-sX alias. This might change in future. - river. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (FreeBSD) iEYEARECAAYFAkxpU08ACgkQIXd7fCuc5vKB1ACfYHHRSDMB9FWBbWUQvQNkNf1d 204An0Jcf8F1elf58gkNzOtDpbqDOJgR =+Q9g -----END PGP SIGNATURE-----

1 0

Iterating over all wikis
by Danny B. 15 Aug '10

15 Aug '10

Hello, performing of random same queries over the given set of wikis (typically random statistics) is apparently one of the very usual tasks done by toolserver users. I have started https://wiki.toolserver.org/view/Iterating_over_wikis where I would appreciate if you could share your code excerpts in random languages. (Feel free to add yours if it's missing.) I bet there are random ways how to do such task, good and bad, effective and ineffective, resource consuming or not, so one of the aims is to have the most effective algorithms on this task published there, so everyone can use them instantly. Thank you for cooperation. Kind regards Danny B.

2 1

Query time limiter
by River Tarnell 12 Aug '10

12 Aug '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've just added a new feature to the automated query killer which can be used to limit the execution time of queries. To use it, include the string LIMIT:<n> in your query. For example: SELECT /* LIMIT:60 */ * FROM ... would limit the query execution time to 60 seconds. This could be used in web tools to prevent excessively long page load times (where the user will gave given up by the time the query finishes), or as a sanity check on queries which usually finish quickly, but sometimes take too long. - river. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (FreeBSD) iEYEARECAAYFAkxj8k4ACgkQIXd7fCuc5vJQWwCfaVYnSWoxSmEd8HesFcfUikeH dLsAn3sgbrnXQwpeGoyys48fad+gbQKO =HE6k -----END PGP SIGNATURE-----

1 0

Exposing data about deleted revisions
by Mike.lifeguard 11 Aug '10

11 Aug '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I wanted to get an OK (or not) to return the page title, and timestamp for a given deleted revid. It might also be helpful to return the username. Some information on the tool is available at http://toolserver.org/~lifeguard/page/tools/get-deleted-data This is needed as a workaround for bug 23489 (No way to get the page title of a deleted revision by its rev_id: https://bugzilla.wikimedia.org/show_bug.cgi?id=23489). Specifically, the database of link additions maintained by COIBot has some data corrupted by mixing charsets which needs to be repaired. We need page titles for corrupted rows, and since we have only a revid, we cannot get it from MediaWiki at present. Thanks, - -Mike -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAkxcuSkACgkQst0AR/DaKHsSnQCgvBU/IZGsxZ5IoOr4GRanvAKP XooAoK3LQEDnK7hGvU0NTlfeGrLorYzK =LXpN -----END PGP SIGNATURE-----

9 12

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Toolserver-l