Обсуждение: Re: [pgsql-www] Wiki "editor" privileges request

On 12/27/2016 07:49 AM, Alvaro Herrera wrote:
> Dave Page wrote:
>> Sorry for the delay on this - many of us are (still) on vacation. What
>> is your username (not email)? Please make sure you've logged into the
>> wiki at least once as well, so we have an auto-created account to
>> promote.
>
> That's the actual account username ... and it turns out that MediaWiki
> does not like it at all.  I get a "403" when I visit the auth page.  I
> think Michael will have to create another account with a less unorthodox
> username.

Yeah, I tried various things to escape his username but could not find
anything that would work. I could swear that this happened before I I
found some workaround but I cannot remember what it was :-(


--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

* Joe Conway (mail@joeconway.com) wrote:
> On 12/27/2016 07:49 AM, Alvaro Herrera wrote:
> > Dave Page wrote:
> >> Sorry for the delay on this - many of us are (still) on vacation. What
> >> is your username (not email)? Please make sure you've logged into the
> >> wiki at least once as well, so we have an auto-created account to
> >> promote.
> >
> > That's the actual account username ... and it turns out that MediaWiki
> > does not like it at all.  I get a "403" when I visit the auth page.  I
> > think Michael will have to create another account with a less unorthodox
> > username.
>
> Yeah, I tried various things to escape his username but could not find
> anything that would work. I could swear that this happened before I I
> found some workaround but I cannot remember what it was :-(

I believe that if a space is in the username then you can address that
with %20 or something, but I couldn't figure out how to make it work for
an email address either.

There was a bit of a discussion regarding this on #pginfra too, as I
recall, and the unfortunate answer is that if you want to use the wiki,
you need to use a regular username and not an email address.   We had
complaints from people who weren't able to use their email address as
their username before and don't want to disable that either, and it does
work for the rest of the systems.

Thanks!

Stephen

On 12/27/2016 08:33 AM, Stephen Frost wrote:
> * Joe Conway (mail@joeconway.com) wrote:
>> Yeah, I tried various things to escape his username but could not find
>> anything that would work. I could swear that this happened before I I
>> found some workaround but I cannot remember what it was :-(
>
> I believe that if a space is in the username then you can address that
> with %20 or something, but I couldn't figure out how to make it work for
> an email address either.

That was one of the things I tried.

Michael, have you ever logged into the wiki at all with that username?
If not, please try.

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

Hello

> -----Original Message-----
> From: pgsql-www-owner@postgresql.org [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Michael Goldberg
> Sent: Dienstag, 27. Dezember 2016 20:17
> To: Joe Conway <mail@joeconway.com>
> Cc: Stephen Frost <sfrost@snowman.net>; Alvaro Herrera <alvherre@2ndquadrant.com>; Dave Page <dpage@pgadmin.org>;
> PostgreSQL WWW <pgsql-www@postgresql.org>
> Subject: Re: [pgsql-www] Wiki "editor" privileges request
>
> Hi Joe,
>
> I did login there. I'm right now logged in.
> The user was auto created from my community account.
>
> I tried to find a way to change the username but unfortunately didn't find such option.

There is no such option in a standard MW installation. But there is an extension:

https://www.mediawiki.org/wiki/Extension:Renameuser

However, this is not one thing that you can do yourself (install the extension and then change the user name). It
requiresaccess to the server hosting MW and bureaucrat privileges in the wiki itself. 
Maybe one of the admins could look into that. The extension is compatible with the MW version of the PG MW (1.19).

Regards
Charles

>
> Thank you,
> Michael
>
> On Tue, Dec 27, 2016 at 7:58 PM, Joe Conway <mail@joeconway.com <mailto:mail@joeconway.com> > wrote:
>
>
>     On 12/27/2016 08:33 AM, Stephen Frost wrote:
>     > * Joe Conway (mail@joeconway.com <mailto:mail@joeconway.com> ) wrote:
>     >> Yeah, I tried various things to escape his username but could not find
>     >> anything that would work. I could swear that this happened before I I
>     >> found some workaround but I cannot remember what it was :-(
>     >
>     > I believe that if a space is in the username then you can address that
>     > with %20 or something, but I couldn't figure out how to make it work for
>     > an email address either.
>
>     That was one of the things I tried.
>
>     Michael, have you ever logged into the wiki at all with that username?
>     If not, please try.
>
>
>     --
>     Crunchy Data - http://crunchydata.com
>     PostgreSQL Support for Secure Enterprises
>     Consulting, Training, & Open Source Development
>
>
>

Charles Clavadetscher wrote:
> Great – I love good news ;-)

Here's some bad news, sorry: the mediawiki user depends on the "Postgres
community account" username, which we do not support changing.  Probably
it's possible to implement that, though.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Hello Álvaro

> Here's some bad news, sorry: the mediawiki user depends on the "Postgres
> community account" username, which we do not support changing.  Probably
> it's possible to implement that, though.

I assume that in most cases there is no need for that. Much more the
contrary - users may change their mail address (e.g. change of company
or similar) but they seldom (although it may happen) change their name,
which often is the base for the user name of an online service, or a
well established nickname.

In that sense not so much a bad news and an implementation on the
community site only makes sense if the use case happen often.

Bye
Charles

-- 
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Treasurer
Motorenstrasse 18
CH – 8005 Zürich

http://www.swisspug.org

+---------------------------+
|     ____  ______  ___     |
|    /    )/      \/   \    |
|   (     / __    _\    )   |
|    \    (/ o)  ( o)   )   |
|     \_  (_  )   \ ) _/    |
|       \  /\_/    \)/      |
|        \/ <//|  |\\>      |
|             _|  |         |
|             \|_/          |
|                           |
|     Swiss PGDay 2017      |
| HSR Rapperswil 30.06.2017 |
|    http://www.pgday.ch    |
|                           |
+---------------------------+

Hello

> Not easily. It would certainly be *possible*, but you'd have to verify
> that every possible "downstream" consumer of it supports changing it and
> then actually implement it. This include both our own home-built systems
> (which would probably be "most doable" since they are off the same
> blueprints, but depending on exactly where else they store the username
> it could cause a lot of issues) and things like our redmine installation.
> 
> UPDATE:ing the primary key in a distributed system has non-trivial
> implications...

What is the issue with redmine?

Maybe it would help to include some information about allowed characters
for the community account name on

https://www.postgresql.org/account/signup/

Just to avoid, at least, problems that are caused by special characters
like "@" in a mail address, as was here the case. It can happen easier
that somebody gets to the idea to use their mail address instead of a
nickname, because many internet sites force them to do so.

Just an idea, although as I mentioned before, this does not really seem
to be an issue coming up every second day.

Bye
Charles