Re: [Cloud] Help with a MediaWiki instance on WMCloud - spammers

2021-04-22 Thread Alex Monk
The Wikimania wiki is part of the production cluster so gets privileged access to the production CentralAuth database. I'm not sure if the prod wikis can act as an identity provider for other sites to consume On Thu, 22 Apr 2021 at 19:27, Denny Vrandečić wrote: > I would love to do the same! Can

Re: [Cloud] Help with a MediaWiki instance on WMCloud - spammers

2021-04-21 Thread Alex Monk
Hi Denny, Have you seen https://www.mediawiki.org/wiki/Manual:Combating_spam or https://www.mediawiki.org/wiki/Manual:User_rights? You might be able to do something like `$wgGroupPermissions['*']['edit'] = false; $wgGroupPermissions['*']['createaccount'] = false;` On Wed, 21 Apr 2021 at 18:59, De

Re: [Cloud] Publishing out of a VPS node?

2021-04-18 Thread Alex Monk
You might try: sudo a2enmod mpm_prefork Failing that, what's the name of your instance and project? I can probably sort it out for you On Sun, 18 Apr 2021 at 13:30, Roy Smith wrote: > Hmmm, it turns out, this doesn't work. Apache fails to start with: > > AH00534: apache2: Configuration error:

Re: [Cloud] [Cloud-announce] [Toolforge] New Kubernetes cluster open for beta testers

2020-01-12 Thread Alex Monk
m, 12 de jan de 2020 20:14, Alex Monk escreveu: > >> I think I've seen that particular error that you see in stdout/stderr >> (via kubectl logs) before - on pods that in fact were working. >> >> Meanwhile, uwsgi.log says: >> >> Python version: 3.7.3 (defaul

Re: [Cloud] [Cloud-announce] [Toolforge] New Kubernetes cluster open for beta testers

2020-01-12 Thread Alex Monk
kubectl logs > countcounttest-6b58f5c547-785mr > open("/usr/lib/uwsgi/plugins/python_plugin.so"): No such file or directory > [core/utils.c line 3724] > !!! UNABLE to load uWSGI plugin: /usr/lib/uwsgi/plugins/python_plugin.so: > cannot open shared object file: No such f

Re: [Cloud] [Cloud-announce] [Toolforge] New Kubernetes cluster open for beta testers

2020-01-12 Thread Alex Monk
RESTARTS >> AGE >> countcounttest-6b58f5c547-mf4jx 0/1 ContainerCreating 0 >> 77s >> >> I will leave that running. If the container gets created I might also be >> able to reproduce the segfault. >> >> Best regards, >> >> Count Count >

Re: [Cloud] [Cloud-announce] [Toolforge] New Kubernetes cluster open for beta testers

2020-01-12 Thread Alex Monk
ContainerCreating 0 > 77s > > I will leave that running. If the container gets created I might also be > able to reproduce the segfault. > > Best regards, > > Count Count > > On Sun, Jan 12, 2020 at 10:20 PM Alex Monk wrote: > >> Hi Count Count, >

Re: [Cloud] [Cloud-announce] [Toolforge] New Kubernetes cluster open for beta testers

2020-01-12 Thread Alex Monk
Hi Count Count, I'm afraid you seem to have no pods on the new cluster to look at: # kubectl get -n tool-flaggedrevspromotioncheck pod No resources found. Alex On Sun, 12 Jan 2020 at 21:07, Count Count wrote: > Hi! > > I don't have much luck with a webservice based on the python3.7 image. It

Re: [Cloud] What's my URL?

2020-01-12 Thread Alex Monk
You mean, that you just get the path determined by the name of your tool on the server? The tool creation form on toolsadmin does say "The tool name is used as part of the URL for the tool's webservice." On Sun, 12 Jan 2020, 05:47 Roy Smith, wrote: > Never mind, I found it by trial-and-error.

Re: [Cloud] What's my URL?

2020-01-12 Thread Alex Monk
https://tools.wmflabs.org/spi-tools On Sun, 12 Jan 2020, 05:36 Roy Smith, wrote: > I've got a django-based tool that I was previously running in test mode > directly on the bastion hosts using runserver. Now I'm trying to move that > over the kubernetes for production. I've got things to the p

Re: [Cloud] Adding SSH key to wikitech?

2020-01-11 Thread Alex Monk
age before. Are there > other interfaces that might have also got them into LDAP? > > > > On Jan 11, 2020, at 10:19 AM, Alex Monk wrote: > > Looks like you already have those keys in LDAP: > $ ldapsearch -LLLx mail=r...@panix.com cn sshPublicKey -o ldif-wrap=no > dn: uid=

Re: [Cloud] Adding SSH key to wikitech?

2020-01-11 Thread Alex Monk
/UZRGfKI1TWzYrmY+YerZUZJF3o9VA0y3D9IE76OFg2BqQpcQh7KbSF0qemM7mFJWdSdMnEbo1AnrX7jxZ+mz0Cdh RoySmith/wikimedia I get the same error if I try to add a duplicate key. On Sat, 11 Jan 2020 at 14:54, Roy Smith wrote: > On Jan 11, 2020, at 6:34 AM, Alex Monk wrote: > > Wikitech writes it into L

Re: [Cloud] Adding SSH key to wikitech?

2020-01-11 Thread Alex Monk
(On the other hand if you just want to use Gerrit and not SSH into any Cloud VPS things, you can probably skip this step) On Sat, 11 Jan 2020, 11:34 Alex Monk, wrote: > Wikitech writes it into LDAP where it'll get read when you SSH into things. > > Please paste your public key

Re: [Cloud] Adding SSH key to wikitech?

2020-01-11 Thread Alex Monk
Wikitech writes it into LDAP where it'll get read when you SSH into things. Please paste your public key here so we can have a look. On Sat, 11 Jan 2020, 03:21 Roy Smith, wrote: > I'm working my way through the instructions at > https://www.mediawiki.org/wiki/Gerrit/Tutorial/tl;dr. I'm up to a

Re: [Cloud] [Cloud-announce] unexpected VM reboots

2019-12-29 Thread Alex Monk
he hostmask. > > Thanks, > RhinosF1 > > On Sat, 28 Dec 2019 at 12:18, David Richfield > wrote: > >> Thank you so much!! >> >> Alex Monk schrieb am Sa., 28. Dez. 2019, 13:16: >> >>> I doubt it's that as the tools project didn't loose a

Re: [Cloud] Umlaut issue

2019-12-29 Thread Alex Monk
IIRC horizon uses CN for login rather than UID, and https://tools.wmflabs.org/openstack-browser/user/dhun suggests the CN is Dirk Hünniger. dhun is just the UID. On Sun, 29 Dec 2019, 15:15 Platonides, wrote: > Your account is just dhun > > Instead of creating a new account, it would be much more

Re: [Cloud] [Cloud-announce] unexpected VM reboots

2019-12-28 Thread Alex Monk
I doubt it's that as the tools project didn't loose any exec instances in this issue that I'm aware of. Anyway I started that tool up krenair@tools-sgebastion-07:~$ sudo become parliamentdiagram tools.parliamentdiagram@tools-sgebastion-07:~$ webservice status Your webservice is not running tools.p

Re: [Cloud] Cassandra?

2019-12-07 Thread Alex Monk
This page appears to be about a production setup of Cassandra rather than something publicly accessible. I'm not aware of a publicly accessible one provided for Cloud VPS projects / Toolforge tools, sorry. On Fri, 6 Dec 2019, 20:47 Roy Smith, wrote: > Is there a publicly-accessable Cassandra ins

Re: [Cloud] Cassandra?

2019-12-07 Thread Alex Monk
Things in the tools project should probably not be talking internally to things in deployment-prep, especially sessionstore instances. deployment-prep instances are not intended to provide services to other labs projects. On Fri, 6 Dec 2019, 22:44 Daniel Zahn, wrote: > There is a "role::beta::ca

Re: [Cloud] /util/arch and /usrlbin//now missing?

2019-11-29 Thread Alex Monk
Looks like maybe the trick is to set the environment SGE_ROOT=/var/lib/gridengine Or, `qstat` instead of `qstatus`. On Fri, 29 Nov 2019 at 22:01, Roy Smith wrote: > When I run qstatus on tools-sgebastion-08, I get the following errors: > > > (env) utils $ qstatus > /usr/bin/qstatus: line 299: /u

Re: [Cloud] problems resolving external host

2019-06-14 Thread Alex Monk
I looked at `dig eutils.ncbi.nlm.nih.gov +trace` and at `strace -f dig eutils.ncbi.nlm.nih.gov +trace` - it looks to me like NIH's nameservers are not willing to serve labs? On Fri, 14 Jun 2019 at 05:59, Konrad Koehler via Cloud < cloud@lists.wikimedia.org> wrote: > The following tool has been r

Re: [Cloud] Another SQL optimization request

2019-06-05 Thread Alex Monk
It looks to me like the query attempts to count all logged-in non-bot page creations in certain namespaces, grouped by user, and each user also has their counts for the various different individual namespaces shown. On Wed, 5 Jun 2019 at 09:53, Jaime Crespo wrote: > > Finally, any advice on how

Re: [Cloud] Toolforge SQL performance issue with new comment table

2019-06-03 Thread Alex Monk
I believe John is trying to make the implication that the comment table was created purely for the sake of normalisation, but I believe it came out of the concerns around the size of the revision table: https://www.mediawiki.org/wiki/User:Brion_VIBBER/Compacting_the_revision_table_round_2 On Mon,

Re: [Cloud] Optimalizing a SQL query

2019-06-03 Thread Alex Monk
To use those indexes on title you also need to filter by log_namespace: MariaDB [commonswiki_p]> select count(*) from logging_logindex where log_type="thanks" and log_title="Martin_Urbanec" and log_namespace = 2; +--+ | count(*) | +--+ |6 | +--+ 1 row in set (0.03 se

Re: [Cloud] CloudVPS Trusty instances shutdown

2019-01-18 Thread Alex Monk
More affected projects: math: https://phabricator.wikimedia.org/T204509 osmit: https://phabricator.wikimedia.org/T204527 globaleducation: https://phabricator.wikimedia.org/T214160 (incorrect upgrade) wikidata-dev: https://phabricator.wikimedia.org/T214161 (incorrect upgrade) On Fri, 18 Jan 2019 at

Re: [Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread Alex Monk
Actually now that I think about it, it will probably include everyone who met the autopromotion criteria after that got deployed by editing, just with the wrong timestamps? On Tue, 30 Oct 2018 at 19:03, Alex Monk wrote: > Yeah. Don't rely on that too much though as it won&#

Re: [Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread Alex Monk
7:22, 30 October 2018 Kubaski (talk | contribs) was > automatically updated from (none) to extended confirmed user (thank) on > https://en.wikipedia.org/wiki/Special:Log/rights . > > Best, > Martin > > út 30. 10. 2018 v 13:53 odesílatel Alex Monk napsal: > >> Hi m

Re: [Cloud] Autopromoted groups aren't listed in user_groups table

2018-10-30 Thread Alex Monk
Hi max, I think the implicit groups don't get stored in the database by MediaWiki, they are determined at runtime. You might be able to go through https://www.mediawiki.org/w/api.php?action=help&modules=query%2Busers with usprop=implicitgroups and filter them yourself. Many thanks Alex On Tue, 3

Re: [Cloud] [Cloud-announce] Ubuntu deprecation plans

2018-09-29 Thread Alex Monk
Arturo wasn't around at the time but I've done some digging and found some of the original discussion along with a public summary on the predecessor of this list: https://lists.wikimedia.org/pipermail/labs-l/2015-February/003399.html On Sat, 29 Sep 2018 at 19:13, Pine W wrote: > Hi Arturo, > > O

Re: [Cloud] Python gives "invalid syntax" error only on labs

2018-08-19 Thread Alex Monk
What are the versions of Python involved? On Sun, 19 Aug 2018 at 21:34, Huji Lee wrote: > Hello, > > When I run this script[1] on my own machine it runs without any problem. > When I run it on Labs, I get an invalid syntax error, pasted below. Can you > please help me figure out why? > > Thanks!

Re: [Cloud] Request to add centralauth to the meta_p.wiki table

2018-02-08 Thread Alex Monk
Won't this break everything that assumes all `wiki` entries are wikis and try to start querying them? On 8 Feb 2018 17:00, "Bryan Davis" wrote: > Krinkle has filed a feature request in Phabricator about adding > information for the centralauth database to the meta_p.wiki table >

Re: [Cloud] Changing my shell preference

2017-12-31 Thread Alex Monk
I think there might just be some caching going on. I ran chsh.ldap on bastion.wmflabs.org and when I went to deployment-puppetmaster02.deployment-prep.eqiad.wmflabs, it executed the new shell. bastion still didn't. On 31 December 2017 at 16:31, Huji Lee wrote: > At login.tools.wmflabs.org the com

Re: [Cloud] Changing my shell preference

2017-12-31 Thread Alex Monk
Maybe our instances are not set to pull loginShell info from LDAP? On 31 Dec 2017 16:03, "Martin Urbanec" wrote: > Just the first one, second one stays to be /bin/bash. > > Martin > > ne 31. 12. 2017 v 16:47 odesílatel Alex Monk napsal: > >> getent passwd* &g

Re: [Cloud] Changing my shell preference

2017-12-31 Thread Alex Monk
getent passwd* On 31 Dec 2017 15:46, "Alex Monk" wrote: Does it change what's shown at `ldapsearch -x uid=yourusername loginShell` or `getent passed yourusername`? On 31 Dec 2017 15:41, "Martin Urbanec" wrote: > At dev.tools.wmflabs.org: command not found

Re: [Cloud] Changing my shell preference

2017-12-31 Thread Alex Monk
Does it change what's shown at `ldapsearch -x uid=yourusername loginShell` or `getent passed yourusername`? On 31 Dec 2017 15:41, "Martin Urbanec" wrote: > At dev.tools.wmflabs.org: command not found. At bastion.wmflabs.org the > command exists, ask for LDAP password but do nothing for both bast

Re: [Cloud] Database queries via PHP

2017-10-06 Thread Alex Monk
Maybe post your script so people can try to investigate? On 6 October 2017 at 19:42, Russell Blau wrote: > I'm trying to debug a PHP script that runs various queries against the > enwiki_p database on the new server (enwiki.analytics.db.svc.eqiad.wmflabs), > and I've run into a wall. To simplify

Re: [Cloud] revision.rev_text_id is always 0?

2017-10-02 Thread Alex Monk
On 2 October 2017 at 17:30, Roy Smith wrote: > I’m not seeing how to access the wikitext for a specific revision via the > API. I can get the HTML with /page/html/{title}/{revision}, but I don’t see > how to get the wikitext. Do I really need to get the HTML and then feed > that through /transfo

Re: [Cloud] revision.rev_text_id is always 0?

2017-09-30 Thread Alex Monk
“the API” you mean https://www.mediawiki.org/wiki/API:Main_page > ? > > > > On Oct 1, 2017, at 12:10 AM, Alex Monk wrote: > > The MediaWiki schema description is only valid for the underlying > database, you do not have access to that as a labs user - you just > have securi

Re: [Cloud] revision.rev_text_id is always 0?

2017-09-30 Thread Alex Monk
Sorry - that was supposed to be 'show databases' and 'show tables'. On 1 October 2017 at 05:26, Alex Monk wrote: > You mean, pages like MediaWiki has but modified for use in Labs? I > don't think there's MediaWiki-style documentation on that, I'd just

Re: [Cloud] revision.rev_text_id is always 0?

2017-09-30 Thread Alex Monk
ou, where you could find a database schema? > > Regards, Martin > > -- > Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet. > Am 01.10.2017, 06:10, Alex Monk schrieb: >> >> The MediaWiki schema description is only valid for the underlying >>

Re: [Cloud] revision.rev_text_id is always 0?

2017-09-30 Thread Alex Monk
The MediaWiki schema description is only valid for the underlying database, you do not have access to that as a labs user - you just have security-sanitised views. rev_text_ids are not useful to you as you cannot access revision texts via the DBs - you must go through the API. On 1 October 2017 at