Re: [Cloud] Changing my shell preference

[Bryan Davis]

On Sun, Dec 31, 2017 at 10:02 AM, Alex Monk  wrote:
> 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.

We run nscd () on every host in
Cloud VPS to cache NSS lookup data. The cache time for passwd data is
set to 3600 seconds (1 hour).

Bryan
-- 
Bryan Davis  Wikimedia Foundation
[[m:User:BDavis_(WMF)]] Manager, Cloud Services  Boise, ID USA
irc: bd808v:415.839.6885 x6855

___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

Re: [Cloud] Help with a query

[Bryan Davis]

On Sat, Dec 30, 2017 at 8:55 PM, Huji Lee  wrote:
> What is the proper strategy for temporary (physical or in-memory) tables on
> Toolforge?

Allowing temp tables on the new Wiki Replica servers was investigated
in . The resulting decision
was that `CREATE TEMPORARY TABLE...` can cause too many issues with
replication to be allowed at this time.

For this particular query, I think you could simulate having a
temporary table by "joining" in your application by selecting counts
of revision_userindex table rows using batches of (log_user,
log_timestamp) values. It would depend on the size of the inner query
dataset whether you are better off trying to cache all of the results
in your application memory or instead using two database connections
and only reading in a "reasonable" number of results at a time (e.g.
1000).

Bryan
-- 
Bryan Davis  Wikimedia Foundation
[[m:User:BDavis_(WMF)]] Manager, Cloud Services  Boise, ID USA
irc: bd808v:415.839.6885 x6855

___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

Re: [Cloud] Changing my shell preference

[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 command chsh.ldap does not exist either.
>
> On Sun, Dec 31, 2017 at 10:41 AM, 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 bastion and
>> dev.tools.wmflabs.org.
>>
>> Martin
>>
>> ne 31. 12. 2017 v 16:35 odesílatel Chad Horohoe 
>> napsal:
>>>
>>> It can be set in LDAP. Does `chsh.ldap` work for you? It'll prompt for
>>> your LDAP password, I believe.
>>>
>>> -Chad
>>>
>>>
>>> On Sun, Dec 31, 2017 at 3:42 AM Martin Urbanec
>>>  wrote:

 Hello,

 your password on tools is your Wikitech password. Anyway, what you tried
 won't work because it works with /etc/passwd and tools authorize you using
 LDAP. The only one think that comes to my mind is to add /usr/bin/zsh to 
 the
 .bashrc file (and probably delete the rest of its content as it won't be
 needed). But this is a hack, maybe there is some LDAP field that can be 
 used
 for the same. I have no way how I can examine the LDAP thing because I'm 
 not
 an admin :).

 Martin

 ne 31. 12. 2017 v 5:00 odesílatel Huji Lee  napsal:
>
> Is there a way to change my preferred shell on the Clouds to zsh? When
> I try   chsh -s `which zsh`  it asks for a password, which I don't have of
> course.
>
> Thanks,
> Huji
> ___
> Wikimedia Cloud Services mailing list
> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/cloud

 ___
 Wikimedia Cloud Services mailing list
 Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
 https://lists.wikimedia.org/mailman/listinfo/cloud
>>>
>>> ___
>>> Wikimedia Cloud Services mailing list
>>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
>>> https://lists.wikimedia.org/mailman/listinfo/cloud
>>
>>
>> ___
>> Wikimedia Cloud Services mailing list
>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
>> https://lists.wikimedia.org/mailman/listinfo/cloud
>
>
>
> ___
> Wikimedia Cloud Services mailing list
> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/cloud

___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

Re: [Cloud] Changing my shell preference

[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 bastion and
> dev.tools.wmflabs.org.
>
> Martin
>
> ne 31. 12. 2017 v 16:35 odesílatel Chad Horohoe 
> napsal:
>
>> It can be set in LDAP. Does `chsh.ldap` work for you? It'll prompt for
>> your LDAP password, I believe.
>>
>> -Chad
>>
>>
>> On Sun, Dec 31, 2017 at 3:42 AM Martin Urbanec <
>> martin.urba...@wikimedia.cz> wrote:
>>
>>> Hello,
>>>
>>> your password on tools is your Wikitech password. Anyway, what you tried
>>> won't work because it works with /etc/passwd and tools authorize you
>>> using LDAP. The only one think that comes to my mind is to add
>>> /usr/bin/zsh to the .bashrc file (and probably delete the rest of its
>>> content as it won't be needed). But this is a hack, maybe there is some
>>> LDAP field that can be used for the same. I have no way how I can examine
>>> the LDAP thing because I'm not an admin :).
>>>
>>> Martin
>>>
>>> ne 31. 12. 2017 v 5:00 odesílatel Huji Lee  napsal:
>>>
 Is there a way to change my preferred shell on the Clouds to zsh? When
 I try   chsh -s `which zsh`  it asks for a password, which I don't
 have of course.

 Thanks,
 Huji
 ___
 Wikimedia Cloud Services mailing list
 Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
 https://lists.wikimedia.org/mailman/listinfo/cloud
>>>
>>> ___
>>> Wikimedia Cloud Services mailing list
>>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
>>> https://lists.wikimedia.org/mailman/listinfo/cloud
>>
>> ___
>> Wikimedia Cloud Services mailing list
>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
>> https://lists.wikimedia.org/mailman/listinfo/cloud
>
>
> ___
> Wikimedia Cloud Services mailing list
> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/cloud
>
___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

Re: [Cloud] Changing my shell preference

[Martin Urbanec]

At dev.tools.wmflabs.org: command not found. At bastion.wmflabs.org the
command exists, ask for LDAP password but do nothing for both bastion and
dev.tools.wmflabs.org.

Martin

ne 31. 12. 2017 v 16:35 odesílatel Chad Horohoe 
napsal:

> It can be set in LDAP. Does `chsh.ldap` work for you? It'll prompt for
> your LDAP password, I believe.
>
> -Chad
>
>
> On Sun, Dec 31, 2017 at 3:42 AM Martin Urbanec <
> martin.urba...@wikimedia.cz> wrote:
>
>> Hello,
>>
>> your password on tools is your Wikitech password. Anyway, what you tried
>> won't work because it works with /etc/passwd and tools authorize you
>> using LDAP. The only one think that comes to my mind is to add
>> /usr/bin/zsh to the .bashrc file (and probably delete the rest of its
>> content as it won't be needed). But this is a hack, maybe there is some
>> LDAP field that can be used for the same. I have no way how I can examine
>> the LDAP thing because I'm not an admin :).
>>
>> Martin
>>
>> ne 31. 12. 2017 v 5:00 odesílatel Huji Lee  napsal:
>>
>>> Is there a way to change my preferred shell on the Clouds to zsh? When I
>>> try   chsh -s `which zsh`  it asks for a password, which I don't have
>>> of course.
>>>
>>> Thanks,
>>> Huji
>>> ___
>>> Wikimedia Cloud Services mailing list
>>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
>>> https://lists.wikimedia.org/mailman/listinfo/cloud
>>
>> ___
>> Wikimedia Cloud Services mailing list
>> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
>> https://lists.wikimedia.org/mailman/listinfo/cloud
>
> ___
> Wikimedia Cloud Services mailing list
> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/cloud
___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

Re: [Cloud] Changing my shell preference

[Martin Urbanec]

Hello,

your password on tools is your Wikitech password. Anyway, what you tried
won't work because it works with /etc/passwd and tools authorize you using
LDAP. The only one think that comes to my mind is to add /usr/bin/zsh to
the .bashrc file (and probably delete the rest of its content as it won't
be needed). But this is a hack, maybe there is some LDAP field that can be
used for the same. I have no way how I can examine the LDAP thing because
I'm not an admin :).

Martin

ne 31. 12. 2017 v 5:00 odesílatel Huji Lee  napsal:

> Is there a way to change my preferred shell on the Clouds to zsh? When I
> try   chsh -s `which zsh`  it asks for a password, which I don't have of
> course.
>
> Thanks,
> Huji
> ___
> Wikimedia Cloud Services mailing list
> Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/cloud
___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud