[Toolserver-l] Extracting basic revision data
Hello, I would ask for allowance to run a request that can be resource consuming if not properly scaled: SELECT page.page_title as title, rev_user_text as user, rev_timestamp as timestamp, rev_len as len FROM revision JOIN page ON page.page_id = rev_page WHERE rev_id > 0 AND rev_id < [...] AND rev_deleted = 0; This is intended to extract basic data about all publicly visible revisions from 1 to [...]. Info about each revision would be a 4-tuple title/user name/time/length. I need this data to start generating a timeline of editing of srwiki, so it is intended to be run only once for each revision. If this is generally allowed to do, my question is how large chunks of data can I take at once, and how long should be waited between two takes? M ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] Monthly pageviews
Op 15 nov 2010, om 19:22 heeft Magnus Manske het volgende geschreven: > Hi, > > I know there are lots'o'files for daily (hourly?) pageview stats on > the toolserver. Where are these text files actually ? -- Krinkle ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] Domain for a project
Paul Selitskas wrote: > Is it able to give a project its own domain one day while the project will > still >be a Toolserver project with proper TS attribution/promotion? There's no >Wikipedia >DB replica in Belarus, so downloading dumps would not be the best approach in >my planned project. :) Looks like you are taking the wrong approach. What is your planned project? What are you trying to solve? ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
[Toolserver-l] Domain for a project
Is it able to give a project its own domain one day while the project will still be a Toolserver project with proper TS attribution/promotion? There's no Wikipedia DB replica in Belarus, so downloading dumps would not be the best approach in my planned project. :) -- - С уважением, Павел Селіцкас/Paul Selitskas, skype: p.selitskas Wizardist @ Wikimedia projects ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
[Toolserver-l] Reboot of nightshade tonight
Hello all, I will reboot nightshade tonight at 0:20 UTC, because of a kernel-update (Critical maintenance). Please see [[MNT-901]] for details. Sincerly, DaB. -- Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885 signature.asc Description: This is a digitally signed message part. ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] FYI: Changing of interwiki-bots-account-approval
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 11/28/2010 12:08 PM, masti wrote: > > any reason behind? > > masti pywikipedia is bloated and interwiki.py doubly-so -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.14 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBCAAGBQJM8pr8AAoJEL+AqFCTAyc2JxoH/3ywqXbm6SUjnIfKTAIVHo+9 NmG0FaE8FCmO4yv8S/Rzui9JjqNlqvdwh/3t58JZtQ3LvfeUNyUKu5dB4IMvR1hk Svd1l5hshNm2af3xiKLc50T0XwovJpmgshXs3Qo7Fi90PgzVkV3LHR8hIEjcy4GF 7gwkDgfKGJ93ijYKumNJMO09XryHlVf2fElE5ZjgR/48rvt0AyVgWuY+g6b9FAjI 8pHJsl5QXwpJCXS9ljLXRAHzet/Mk50B0PNKWntVqkA5KchO2YMRE0qxJuWREuZm 2i7qO7Q1H0R/s7hIaiUGzMDCZ4z6a9mlWl6dhNmv+jtJJIxhsvUnt1n8QfA9rlw= =+gQz -END PGP SIGNATURE- ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] FYI: Changing of interwiki-bots-account-approval
On 11/28/2010 06:03 PM, DaB. wrote: > Hello all, > > with the beginning of the next year (2011) I will not longer accept new > interwiki-bot-accounts, if: > -The homewiki of the bot has at least one active interwiki-bot, which runs on > the toolserver, OR > -The homewiki has less then 1000 articles. any reason behind? masti ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
[Toolserver-l] FYI: Changing of interwiki-bots-account-approval
Hello all, with the beginning of the next year (2011) I will not longer accept new interwiki-bot-accounts, if: -The homewiki of the bot has at least one active interwiki-bot, which runs on the toolserver, OR -The homewiki has less then 1000 articles. (There can be exceptions if there is a good reason of course) The homewiki is that wiki where the bot starts and where the account-requester got his/her bot approved (see [1]). If the account-requester requested the account only for the interwiki-bot, the request will be rejected; if he/she requested the account also for other things, only the interwiki-bot will be denied of course and the rest of the request will be handled the normal way. For interwiki-bots which runs already on the toolserver, there is no change at the moment. When you find a free minute: Please add your bot to [2] and check if there are inactive bots listed for your wiki. The goal of this change is to limit the number of interwiki-bots on the toolserver (and improve our documentary a bit). Sincerly, DaB. [1] https://wiki.toolserver.org/view/Account_approval_process, Request process, Point 4. [2] https://wiki.toolserver.org/view/Wikimedia_bots -- Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885 signature.asc Description: This is a digitally signed message part. ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] alternative way to get wikipedia dump while server is down
Bryan Tong Minh wrote: > On Fri, Nov 26, 2010 at 6:43 PM, Platonides wrote: >> >> Also, as discussed with Ariel, I will gladly mirror such dumps at wm-es >> web space. >> > You do have a toolserver account right? I think it would be a good > idea if you could copy the dumps from the TS to your web space. I don't. But I can request one if needed. ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] Changes to software libraries in /opt/ts
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mauro Girotto: > 2010/11/14 River Tarnell : > I'm trying to switch from CC to gcc. My app uses mysqlpp library. Does > /opt/ts/lib contain the libraries of Sun Studio? If I compile with -L > /opt/ts/lib -lmysqlpp I've a linking error: > Undefined symbol > mysqlpp::Row::at(unsigned int) const > mysqlpp::UseQueryResult::fetch_row() > mysqlpp::Query::error() const > mysqlpp::Connection::query(char const*) > ... You're right, we neglected to provide a GCC version of mysqlpp. I will install one during the ts-specs update and you will be able to link with that instead. - river. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (FreeBSD) iEYEARECAAYFAkzyZSQACgkQIXd7fCuc5vLg2ACfeKwHQTAP1WN6uNshP+iSpTN0 fzoAn3dmj3dJQKgTJM0PlWnaMvnXFjsO =Y3w3 -END PGP SIGNATURE- ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] Problem with matplolib / pylab
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robin Krahl: > ImportError: ld.so.1: python: fatal: relocation error: file > /opt/ts/python/2.6/lib/python2.6/site-packages/matplotlib/_path.so: > symbol > __1cDstdMbasic_string4Ccn0ALchar_traits4Cc__n0AJallocator4Cc___J__nullref_: > referenced symbol not found This should be fixed now. - river. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (FreeBSD) iEYEARECAAYFAkzyS98ACgkQIXd7fCuc5vLFwQCeL0y+WqdPz1uAjfzuyn+0J6Ox qdcAnijpm4C1u8YLmWRcx0s4ANYttt2h =4HrO -END PGP SIGNATURE- ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette