Talk:Phabricator/Help

Ask any questions about the Wikimedia Phabricator installation here.

Unused Phab account deleted; please re-register with a valid address

Hi,

I tried to connect to Phabricator by logging in with my Mediawiki account, then I failed on writting my email. I can't check my email for connecting, nor changing it from Phabricator.

How can we fix that?

I don't even understand why my account didn't link by itself, I have a global account since 2011.

@LD Hi, I deleted the unused account https://phabricator.wikimedia.org/p/LD/. Please register again. Thanks!

@AKlapper (WMF), thanks for fixing this issue. It's now working!

Have a good day!

Hi!

A user on phab.wmflabs.org has been closing tasks on some of our mockups. I thought maybe this was an honest mistake (it's a test env, so it's easy to assume it's just a place to mess around with whatever), so I reached out to them to ask them to stop and why and offered to help them with whatever they wanted to do. I also added a description to the project in question. After reverting their changes, however, they did it again. I've noticed this user is blocked on some wikis and has a disabled account on WMF production Phab, so I suspect their intent is simply malicious.

At the end of the day, I just want my mockups to be preserved (we're doing it in a test env to not overwhelm production). I think my best option is just to manually change access for each task. Is that accurate?

Thanks!

@MBinder (WMF), vandal-only accounts should be blocked.

Thanks, @Whatamidoing (WMF). I think I am wondering more specifically what to do for the test env, which is not monitored by pretty much anyone, nor anyone's real responsibility beyond (I think) whomever set it up.

Does that mean there is production data (mockups) in a non-production instance? If yes, could someone explain what "overwhelm" means exactly?

I wouldn't call it production "production data" exactly (I would show you but I had to change the policy for all of the projects and tasks to stop the vandalism). It's really just a simple backlog and Kanban board to illustrate, in an interactive way, how we might make those changes on production. It is populated with fake tasks. "Overwhelm" doesn't mean "break Phab" so much as "make 30 tickets that aren't actually work and make AKlapper pull his hair out while clogging real boards." :)

Have you asked for admin/blocking rights there? You might be able to solve the problem more directly.

In my understanding, the test instance exists to test whatever people want to test. That can include altering someone else's test data.

@AKlapper (WMF) that's fair! FWIW, at this point I have protected what data I think I need to, so my motivation for this post is moot. I have some conflicting personal values around the "vacuum" of a test environment, but practically it's no matter now. :)

I'm trying to get back into my wikitech account after ages, and I get the following error message:

You must verify your email address to log in. You should have a new email message from Phabricator with verification instructions in your inbox ([])

I had this wikitech account (Yuvipanda) before I was at WMF, so I'd like to get it back :D

@YuviPanda: Hej hej! :) https://phabricator.wikimedia.org/p/Yuvipanda/ is an active account (and linked to both LDAP and SUL accounts) and says "Email not verified", indeed. Querying the Phab DB, your email address ends with "@wikimedia.org" so it's likely invalid.

Can you manage to log into Phab by using your mediawiki.org SUL account instead (Not sure though, as Phab is linked to the SUL account called "Yuvipanda" but your account now seems to be "YuviPanda")?

Hi @AKlapper (WMF) :D

Yeah, I volunteered for SUL renaming when it first came out, so my SUL entry is kinda screwed up. When I try to login with SUL, it tells me it's going to create a new account. And when I try to do that, I get:

• Another user already has that username.
• Another user already has that email.

Even though this email is yuvipanda@gmail.com

@YuviPanda I think the underlying problem to first sort out here is your wikitech/LDAP account if you cannot log into wikitech. That would be the Cloud Services folks, presumably. :)

@AKlapper (WMF) I understood that Yuvi has access to Wikitech, but Phabricator still has the old email somewhere and is Yuvi can't do anything unless that old email (that he can't access) is verified, which is not possible.

Hmm, might be... As a Phab admin I cannot change the email address of a Phab account in the UI. This would require directly editing the DB. I don't have permissions to do that.

UPDATE phabricator_user.user_email SET address = "ThatNewAddress" WHERE userPHID = "PHID-USER-2nnm76h4ykalvvref2ye"; basically.

@MModell (WMF) Any better ideas? If not, who could do that?

(Plus I'm wondering if this needs an additional verification check, as the Phab account has some non-default permissions... what do I know.)

@AKlapper (WMF) @YuviPanda: I see both email addresses in phabricator and they are both associated with the same user PHID. I'm going to try switching which address is listed as 'primary' and maybe that will fix the issue.

@YuviPanda: Can you try logging in now that I've changed your primary address to the non-wmf one?

@YuviPanda ping - can you log in?

@MModell (WMF)@AKlapper (WMF) it works!!!!! THANK YOU :)

You're welcome! And welcome back! :)

Hello! I have some folks asking for a database they can query with SQL. I recall this was possible in the past for projects like Phlogiston. To whom can I direct said interested parties? :)

https://dumps.wikimedia.org/other/misc/

I realize the dump is in JSON format, hmm. https://phabricator.wikimedia.org/diffusion/PHTO/browse/wmf%252Fstable/wmfphablib/phabdb.py is the corresponding code creating and sanitizing it. I'm curious what the actual use case is though...

Thank you! I will forward these. As for use cases, I think the minimum is simply comfort with familiar tools, and beyond that I will defer to those folks interested (I have sent them this thread). :)

@MBinder (WMF) we can run one-off queries or set up static reports using SQL, we just can't give unlimited access because that could reveal sensitive information. I'd be willing to run queries manually if there is a pressing use-case.

I would like to see if a task matches criteria for more than one column (obviously on different boards, assuming columns on the same board are mutually exclusive). I tried doing that here: https://phabricator.wikimedia.org/maniphest/query/ElPvD_Yiivyc/#R

but it seems to either A) show me everything in both columns combined (rather than only tasks that match both columns), or B) show me something else entirely. I am thinking this is because I lack a way to say "and" rather than "or" (the latter accomplished, I think, via comma separation), or the query is simply breaking something.

Is there a way to query via Maniphest that says "show me tasks that exist in both of these columns"?

I've never seen the "Columns" field on Maniphest's Advanced Search form. How to get that displayed? :)

There seems to be no logical AND or OR for entries in the "Columns" field, indeed. No good idea (so far).

I wondered if explicitly adding the corresponding projects of those columns into the "Tags" field ("Ready for Development" on #iOS-app-v6.8.1-Manta-Ray-On-A-Tractor, "Bug Backlog" on #Wikipedia-iOS-App-Backlog), as the "Tags" field by default is a logical AND. But https://phabricator.wikimedia.org/maniphest/query/m_oBmrmGYCuz/#R does not work as expected either (some results are incorrect).

> I've never seen the "Columns" field on Maniphest's Advanced Search form. How to get that displayed? :)

I generated that via "View tasks as query" in the per-column menu (the non-intuitive pencil icon).

Thanks for taking a try with your query. It's curious how those results generate, given (as you said) that they are seemingly wrong.

Is there documentation somewhere for Maniphest syntax? Could I imply "and" via "+" or something, etc?

I guess the "Columns" field (which is not exposed by default) does not support multiple values at all and only parses the first value, but that's just my guess based on the results of the two queries above. Might be a question for upstream at https://discourse.phabricator-community.org/ .

For the records only, the corresponding SQL query for what is wanted here would be something like this (and currently shows 3 task results):

SELECT t.id FROM phabricator_maniphest.maniphest_task t INNER JOIN phabricator_project.project_columnposition cp INNER JOIN phabricator_project.project_column c WHERE c.phid = "PHID-PCOL-csnseb4iqcjdwssg7r7k" AND c.phid = cp.columnPHID AND t.phid = cp.objectPHID AND (t.status="open" OR t.status="stalled") AND t.id IN (SELECT t.id FROM phabricator_maniphest.maniphest_task t INNER JOIN phabricator_project.project_columnposition cp INNER JOIN phabricator_project.project_column c WHERE c.phid = "PHID-PCOL-qvpchgb7ecjhwhdeyuzv" AND c.phid = cp.columnPHID AND t.phid = cp.objectPHID AND (t.status="open" OR t.status="stalled")) ORDER BY t.id;

From looking at the code, it seems that the columns search field indeed supports multiple phid values and does an OR not AND on the columns. I don't see any way to do the intersection of two or more columns, only the union is possible.

Renamed

Hi there, could I please change my Phabricator username from laurendelench to ldelench_wmf?

Here's a link to my profile: https://phabricator.wikimedia.org/p/laurendelench/

Thank you!

@LDelench (WMF) Hej hej, yes. :) Done now.

Awesome, thank you @AKlapper (WMF)!

renamed

Hello. I want to change my phabricator username to NMW03. My profile is https://phabricator.wikimedia.org/p/Neriman2003/

Thanks in advance

Hi! Done now! :)

Thanks!

Deleted unused account so user can re-register with correct mail address

Hey, I accidentally created a Phabricator account with the wrong email address that I no longer have access to, I'd like to have that account deleted if possible. Thanks!

Done; please try again.

Deleted unused account so user can re-register with correct mail address

My email address is incorrect, so I request to delete my account, thank you.

Hi, no problem! Unused account deleted, please feel free to re-register.

Account deactivated instead.

Could Jseddon be renamed to Jseddoff? Many thanks

If you mean the Phabricator account, can you create a ticket in Phabricator from that account, tagging #phabricator?

Phab ticket not needed, we ask people to request on this very talk page and not in Phab tasks.

Looks like this moved to phab:T282928 now

@AKlapper (WMF) Upps, sorry for the bad advice then. All rename requests I saw so far were through Phabricator, so that's why I said so.