Extension talk:ConfirmAccount/2017

• Archive 1
• Archive 2
• Archive 3

Make "Real name" allowed, but optional?

Is it possible to allow Real Name, but not make it compulsory? 61.69.192.236 (talk) 04:27, 7 January 2017 (UTC)

As far as I know, RealName is not required. Tinss (talk) 23:58, 1 February 2017 (UTC)

Error 500 on Special:ConfirmAccounts Only

This is the only page with the error. 68.53.246.183 (talk) 07:50, 27 January 2017 (UTC)

This is the error: PHP Fatal error: Call to undefined method ConfirmAccountsPage::getLinkRenderer() in /home/user/public_html/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/ConfirmAccount_body.php on line 211 68.53.246.183 (talk) 23:25, 27 January 2017 (UTC)

Did you apply php $IP/maintenance/update.php? Spas.Z.Spasov (talk) 07:13, 30 January 2017 (UTC)

yes i run update.php but Special:ConfirmAccounts still show error 500 page Jlkzer (talk) 07:06, 14 June 2017 (UTC)

What version of MediaWiki did this happen on? I get an Error 500 on the ConfirmAccounts page as well. I'm using MW 1.27.1. MikeDarling (talk) 03:35, 19 October 2017 (UTC)

I have the same issue. With version 1.23.

Anyone has a fix? 2001:A61:3462:FC00:E55D:3630:AE1A:A354 (talk) 15:41, 12 June 2018 (UTC)

MWException on Special:ConfirmAccounts

Trying to confirm an account request I get stuck on an MWException (the wiki is in German but the exception appears in English too). It seems to be an error in the HTML form of real name (case?). Anyway, it doesn't matter if real name is enabled or disabled. I tried to fix that error for hours but I didn't find a solution anywhere so I hope to get help here. My code (MediaWiki as well as extensions) comes from the Wikimedia git repo (Rel 1.28).

Here is the error:

[0a0b20a113c1e8b11fa05393] /wiki/index.php?title=Spezial:Benutzerkonto_anlegen&AccountRequestId=5&wpName=Mxmstrmn&returnto=Spezial%3ABenutzerkonto_best%C3%A4tigen%2Fauthors&reason=Heureka   MWException from line 461 of /var/www/html/wiki/includes/htmlform/HTMLForm.php: Descriptor with no class for realname: Array

(

[default] => 

[readonly] => 1

[validation-callback] => Closure Object

(

[static] => Array

(

[accReq] => UserAccountRequest Object

(

[id:protected] => 5

[name:protected] => Mxmstrmn

[realName:protected] =>

...

)

...

Backtrace:

#0 /var/www/html/wiki/includes/htmlform/HTMLForm.php(481): HTMLForm::getClassFromDescriptor(string, array)

#1 /var/www/html/wiki/includes/htmlform/VFormHTMLForm.php(48): HTMLForm::loadInputFromParameters(string, array, VFormHTMLForm)

#2 /var/www/html/wiki/includes/htmlform/HTMLForm.php(336): VFormHTMLForm::loadInputFromParameters(string, array, VFormHTMLForm)

#3 /var/www/html/wiki/includes/libs/ObjectFactory.php(147): HTMLForm->__construct(array, RequestContext)

#4 /var/www/html/wiki/includes/htmlform/HTMLForm.php(281): ObjectFactory::constructClassInstance(string, array)

#5 /var/www/html/wiki/includes/specialpage/LoginSignupSpecialPage.php(663): HTMLForm::factory(string, array, RequestContext)

#6 /var/www/html/wiki/includes/specialpage/AuthManagerSpecialPage.php(402): LoginSignupSpecialPage->getAuthForm(array, string)

#7 /var/www/html/wiki/includes/specialpage/LoginSignupSpecialPage.php(305): AuthManagerSpecialPage->trySubmit()

#8 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522): LoginSignupSpecialPage->execute(NULL)

#9 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(NULL)

#10 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title, RequestContext)

#11 /var/www/html/wiki/includes/MediaWiki.php(851): MediaWiki->performRequest()

#12 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()

#13 /var/www/html/wiki/index.php(43): MediaWiki->run()

#14 {main}

Julius Bittner (talk) 19:32, 19 March 2017 (UTC)

I also have this problem on REL1_29 with the default configuration indicated on the documentation:

$wgMakeUserPageFromBio = '''false''';
$wgAutoWelcomeNewUsers = '''false''';
$wgConfirmAccountRequestFormItems = '''array'''(
'UserName'        => '''array'''( 'enabled' => '''true''' ),
'RealName'        => '''array'''( 'enabled' => '''false''' ),
'Biography'       => '''array'''( 'enabled' => '''false''', 'minWords' => 50 ),
'AreasOfInterest' => '''array'''( 'enabled' => '''false''' ),
'CV'              => '''array'''( 'enabled' => '''false''' ),
'Notes'           => '''array'''( 'enabled' => '''true''' ),
'Links'           => '''array'''( 'enabled' => '''false''' ),
'TermsOfService'  => '''array'''( 'enabled' => '''false''' ),
);

Linedwell (talk) 16:21, 8 March 2019 (UTC)

How to edit the request account page user prompts?

I have a very small wiki for a specific group. As part of the request account process, I require them to provide me with verifiable information proving they are in the group or otherwise has a specific interest. Also helps with spam. In a previous version of ConfirmAccount I could just edit the text RequestAccountPage.i18n.php file to change the prompts and get the user to add the information I need into the biography field.

When I upgraded to Mediawiki 1.28, I also had to reinstall ConfirmAccount. In the most recent version of ConfirmAccount, the file that I edited previously doesn't seem to exist and I can't figure out where the plain text prompt strings are stored.

Can somebody point me in the right direction? Rsoandrew (talk) 15:52, 26 March 2017 (UTC)

Edit i18n/requestaccount/<lang>.json .

Better yet, just edit MediaWiki:<name of the message in lowercase> to override it.

s Aaron (talk) 20:46, 1 December 2017 (UTC)

CalNation (talkcontribs)

Everytime I fill and click the request account button the page loads for a while before it goes blank. Log:

2017-10-18 01:40:16 fbc2b63702c5 wikidb: [71e6cc371daeb32c40983f62] /Special:RequestAccount Wikimedia\Rdbms\DBQueryError from line 1075 of /var/www/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 42.0.4.247 (talk) 11:55, 25 June 2018 (UTC)

Avoiding initial email address confirmation

I've got ConfirmAccount working on a mediawiki instance (1.28.1) and I notice that there's an email address confirmation step that takes place *before* the account is approved. I'm wondering if that can be removed?

I think the email might easily be missed by the user trying to create their account, and there is an email to the address when the admin confirms the account that seems to serve the same purpose, i.e. they are being informed of their account approval and being asked to reset their password.

As it stands users have to receive two email and click through on them both before and after being confirmed by an admin. I'm wondering if there's some way to remove the first email since the second one would seem to be a sufficient check ... Tansaku (talk) 14:39, 1 May 2017 (UTC)

I think this is a good suggestion/request. coyotegirl (talk) 03:23, 15 July 2017 (UTC)

Agreed: the first email address confirmation seems unnecessary and premature — the request may not even be granted.

It seems best simply to have the user submit a request, then (if approved) get a single email telling them they're in and giving instructions on how to proceed. Huwmanbeing (talk) 09:06, 14 October 2017 (UTC)

Having the email confirmed first discourages spam requests and makes it easier for admins to know how serious the request or whether they control an email from a certain domain (e.g. osu.edu or dmv.ca.gov). Aaron (talk) 20:43, 1 December 2017 (UTC)

Having the email confirmed first results in accounts created with "stolen" emails potentially be flagged as spam by the real email owner. This is something that has happened to us to the point that gmail banned us because too many of their users reported our confirmation mails for spambot accounts as spam. 80.154.14.50 (talk) 14:12, 2 August 2023 (UTC)

Adding requesting users email address

How can I get the requesting users email address added to the email sent to the person(s) who will be approving the account? 138.162.128.54 (talk) 15:41, 16 May 2017 (UTC)

Limiting the email to a domain

Is there a way to limit the requesting users email to a particular domain, ie just .mil, or just .edu? 138.162.128.54 (talk) 15:42, 16 May 2017 (UTC)

You can possibly edit MediaWiki:common.js to run of Special:RequestAccount pages (using the mwconfig->get( 'PageName' ) JS variable). It could check the field onChange and show an error and disable the submit button. Requests that make it through anyway (e.g. JS disable) could simply be rejected. Aaron (talk) 20:33, 1 December 2017 (UTC)

PHP Fatal error: Uncaught DBUnexpectedError: Database::close: Got COMMIT while atomic sections AccountRequestSubmission::submit are still open

The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.

---

On a new MediWiki 1.28.2 install running on Debian Stretch (Apache 2.4.25-3, mod_php 7.0.19 and MariaDB 10.1.23-9) with the following Extension:ConfirmAccount configuration:

require_once "$IP/extensions/ConfirmAccount/ConfirmAccount.php";
$wgConfirmAccountRequestFormItems = array(
        'UserName'        => array( 'enabled' => true ),
        'RealName'        => array( 'enabled' => true ),
        'Biography'       => array( 'enabled' => true, 'minWords' => 10 ),
        'AreasOfInterest' => array( 'enabled' => true ),
        'CV'              => array( 'enabled' => false ),
        'Notes'           => array( 'enabled' => false ),
        'Links'           => array( 'enabled' => true ),
        'TermsOfService'  => array( 'enabled' => true ),
);

When you request an account an error like this is generated for the user requesting an account:

Database error

A database query error has occurred. This may indicate a bug in the software.

[ff83f4da27ff532eecb2267e] 2017-06-20 19:35:14: Fatal exception of type "DBQueryError"

And the following error is generated in the Apache error log:

[Tue Jun 20 19:35:14.269289 2017] [:error] [pid 8564] [client XX.XX.XX.XX:54177] PHP Fatal error:  Uncaught DBUnexpectedError: Database::close: Got COMMIT while atomic sections AccountRequestSubmission::submit are still open. in /home/badge/sites/default/w/includes/libs/rdbms/database/Database.php:2756\nStack trace:\n#0 /home/badge/sites/default/w/includes/libs/rdbms/database/Database.php(708): Database->commit('Database::close', 'flush')\n#1 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(976): Database->close()\n#2 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1377): LoadBalancer->{closure}(Object(DatabaseMysqli))\n#3 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(977): LoadBalancer->forEachOpenConnection(Object(Closure))\n#4 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(968): LoadBalancer->closeAll()\n#5 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1556): LoadBalancer->disable()\n#6 [internal function]: LoadBalancer->__destruct()\n#7 {main}\n  thrown in /home/badge/sites/default/w/includes/libs/rdbms/database/Database.php on line 2756, referer: https://badge.wiki/wiki/Special:RequestAccount

Does anyone have any suggestions how to further debug or even solve this issue? ChrisC~mediawikiwiki (talk) 19:42, 20 June 2017 (UTC)

So sorry I missed the need to run the update.php script in the install instructions to generate the database tables needed — after running that the plugin works without an issue. ChrisC~mediawikiwiki (talk) 16:30, 21 June 2017 (UTC)

The discussion above is closed. Please do not modify it. No further edits should be made to this discussion.

Custom CSS for Request Account Page?

It seems it is not possible to write custom css for the Request Account page because no html element on this page has an ID or a class name. I am creating my own skin and I want to be able to change the width of inputs, background color, etc. but I don't want to pollute those components' styles for the entire site.

For example I want the input's background color to be gray on the Request Account page but green on any other page. So how can access just the Request Account page's html elements in my stylesheet.

Thanks so much. Jakeschroeder (talk) 23:44, 30 July 2017 (UTC)

You can edit MediaWiki:common.css or use the Gadget extension to make a CSS module enabled for all users. Aaron (talk) 20:31, 1 December 2017 (UTC)

Aaron, @Aaron Schulz

What identifiers can I use in Mediawiki:Common.css to style the elements in the request account page? Is there a list for this somewhere?

Thank you so much, and I really appriciate the ConfirmAccount extention :)) 51.174.7.28 (talk) 10:25, 15 May 2020 (UTC)

Unable to connect DataBase

I uploaded my developed (in local server, using XAMPP) wiki site to linux web server using cPanel.

I have done following steps: 1) Create DB with user access 2) Import DB from old DB (using SQL format) 3) Upload MediaFile using file manager. 4) configure the "localsettings.php" file as given bellow...

But having the problem of "database connetion"

My site is here: databankbd.com/dbwiki

Error:

A database query error has occurred. This may indicate a bug in the software.

• Query: SELECT lc_value FROM `databank_bddb1l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1
• Function: LCStoreDB::get
• Error: 1146 Table 'databank_bddb1.databank_bddb1l10n_cache' doesn't exist (localhost) Obayda1757 (talk) 05:33, 13 August 2017 (UTC)

Hook to add "request account" to personal urls is not working

I added the code from the "Enhancements" section to my LocalSettings.php:

$wgHooks['PersonalUrls'][] = 'onPersonalUrls';

function onPersonalUrls( array &$personal_urls, Title $title, SkinTemplate $skin ) {

// Add a link to Special:RequestAccount if a link exists for login

if ( isset( $personal_urls['login'] ) || isset( $personal_urls['anonlogin'] ) ) {

$personal_urls['createaccount'] = array(

'text' => wfMessage( 'requestaccount' )->text(),

'href' => SpecialPage::getTitleFor( 'RequestAccount' )->getFullURL()

);

}

return true;

}

But I still do not see a link for "Request Account" in the upper right of my pages when the user is not logged in. I also made sure that the text "Request account" was added to MediaWiki:Requestaccount. I resaved the page to be sure.

I also have $wgGroupPermissions set to false for * createaccount

Is there something I am missing here? I am trying to make a private wiki where users can request accounts. 70.190.141.70 (talk) 01:45, 28 September 2017 (UTC)

Remove pending request?

I'm running a wiki at work, and we're using the ConfirmAccount extension. One of my coworkers made a typo in his email address when making his request. The request was rejected, but he's unable to create another account with the same username (Management has requested a particular username scheme) because that rejected request is still sitting in the queue. Is there any way to delete that request so he can re-request with the correct email address? Loansindi (talk) 19:00, 4 October 2017 (UTC)

You can vastly lower $wgRejectedAccountMaxAge to avoid this kind of problem. Otherwise he can use a different name and then you can use the RenameUser extension to correct it. Aaron (talk) 20:30, 1 December 2017 (UTC)

Works with MW1.29?

Everytime I fill and click the request account button the page loads for a while before it goes blank. Log:

2017-10-18 01:40:16 fbc2b63702c5 wikidb: [71e6cc371daeb32c40983f62] /Special:RequestAccount   Wikimedia\Rdbms\DBQueryError from line 1075 of /var/www/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 

 Query: INSERT  INTO `account_requests` (acr_id,acr_name,acr_email,acr_real_name,acr_registration,acr_bio,acr_notes,acr_urls,acr_type,acr_areas,acr_filename,acr_storage_key,acr_comment,acr_ip,acr_xff,acr_agent,acr_deleted,acr_email_token,acr_email_token_expires) VALUES (NULL,'Wawa','wawa@gmail.com','','20171018013815','','na','','0','',NULL,'wikidb:acctrequest:ip:209.58.135.67','','209.58.135.67','','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36','0','cdf2692dd4d49a49037dae473e6b92d3','20171117013815')

 Function: UserAccountRequest::insertOn

 Error: 1205 Lock wait timeout exceeded; try restarting transaction (percona)

 #0 /var/www/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

 #1 /var/www/includes/libs/rdbms/database/Database.php(1515): Wikimedia\Rdbms\Database->query(string, string)

 #2 /var/www/extensions/ConfirmAccount/backend/UserAccountRequest.php(358): Wikimedia\Rdbms\Database->insert(string, array, string)

 #3 /var/www/extensions/ConfirmAccount/business/AccountRequestSubmission.php(245): UserAccountRequest->insertOn()

 #4 /var/www/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(344): AccountRequestSubmission->submit(RequestContext)

 #5 /var/www/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(84): RequestAccountPage->doSubmit()

 #6 /var/www/includes/specialpage/SpecialPage.php(522): RequestAccountPage->execute(NULL)

 #7 /var/www/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL)

 #8 /var/www/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext)

 #9 /var/www/includes/MediaWiki.php(862): MediaWiki->performRequest()

 #10 /var/www/includes/MediaWiki.php(523): MediaWiki->main()

 #11 /var/www/index.php(43): MediaWiki->run()

 #12 {main}

Database schema updater was run more than once with no difference in results. CalNation (talk) 03:49, 18 October 2017 (UTC)

Locking usually just indicates contention. I can't reproduce this on PostgreSQL, which also has similar row-level locking. It might be interference by another extension. You can use SHOW ENGINE INNODB STATUS to see the last deadlock. You might need to adjust innodb_lock_wait_timeout and turn on innodb_deadlock_detect (see https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-detection.html ). Aaron (talk) 20:27, 1 December 2017 (UTC)

I did enable innodb_print_all_deadlocks. innodb_lock_wait_timeout was already at 120 innodb_deadlock_detect was enabled. Please see the SHOW ENGINE INNODB STATUS output here https://pastebin.com/m9KUwHBf. After multiple failed attempts: https://pastebin.com/cRvB8bEa CalNation (talk) 03:07, 4 December 2017 (UTC)

Many repeating notification emails to admin

Whenever someone requests an account on my wiki, I get notified of the account request via email, which is good. However, I get notified up to 7 times. Could this be caused by the extension, or is this likely a mail setup issue? Wmat (talk) 13:00, 15 December 2017 (UTC)

Still an issue with REL1_31. I get 7 email when an account is requested. Wmat (talk) 12:33, 4 September 2018 (UTC)

I get the same issue, but with only 2 e-mails (same for all bureaucrats) Reboulip (talk) 14:01, 29 November 2018 (UTC)

I tried the following fix, and it worked for my case: set the following properties in LocalSettings.php:

$wgConfirmAccountContact = ''; # to make sure this variable is set

$wgGroupPermissions['*']['confirmaccount-notify'] = false; # withdraw all notifications

$wgGroupPermissions['bureaucrat']['confirmaccount-notify'] = true; # enable notification to bureaucrats

However, I'm not sure why this worked... Reboulip (talk) 16:08, 30 November 2018 (UTC)

(I actually still get double notifications sometimes) Reboulip (talk) 14:41, 31 January 2019 (UTC)

Wiki 1.34.2

The administrator and the user will receive a confirmation email with the confirmation link. Ulrich C. Thiess (talk) 08:33, 18 July 2020 (UTC)

So I can't ConfirmAccount if I can't update?

If I update, doesn't that mean to the latest version? But I can't because at least the last time I checked the host didn't have the latest php. But part of your instructions for installing this extension is that I "run the update script". 173.19.66.153 (talk) 05:28, 20 December 2017 (UTC)