Extension talk:ConfirmAccount

Jump to: navigation, search

About this board


By clicking "Add topic", you agree to our Terms of Use and agree to irrevocably release your text under the CC BY-SA 3.0 License and GFDL
Andreas Plank (talkcontribs)

Hi,

I'm running a 1.27.0-wmf.9 and Extension:ConfirmAccount origin/master from 2915-12-14 – I know it is a development wiki state that I try to run – but after creating an account I could not log in, it issued the message: «Das Passwort ist falsch. Bitte versuche es erneut.» (Password incorrect. Please try again). The password I used was that from e-mail. I only could log in after proceeding to Special:ResetPassword. Have I missed some LocalSettings to take care of? Note that on this Wiki setup I had to reset the new password saving method pbkdf2 because there are older Wikis that share the user table:

$wgPasswordDefault ='B'; /* old MD5 hashing on shared Wikifamily with pre MW1.24 and post MW 1.24+ Wikis */

But normally this changed setting should not disrupt the request account process, right?

Any hint or solution to get it working properly at the very first log in? Regards Andreas

Andreas Plank (talkcontribs)

After

  1. confirming the new user
  2. confirming e-Mail address
  3. checking the database table user where the new user name will be inserted by the confirm process of new users
SELECT `user_id` , `user_name` , UNHEX( HEX( `user_password` ) ) AS 'user_password' FROM `user` ORDER BY `user_id` DESC

… I see that there is no password set whatsoever when the new user is created.

A bug?

Andreas Plank (talkcontribs)

The cause is in the MW 1.27 core, extension:ConfirmAccount calls User::createNew …

foreach ( array( 'password', 'newpassword', 'newpass_time', 'password_expires' ) as $field ) {
  if ( isset( $params[$field] ) ) {
    wfDeprecated( __METHOD__ . " with param '$field'", '1.27' );
    unset( $params[$field] );
  }
}

… but all of those data values (password, newpassword etc.) are deleted in the process and hence no password comes into the database at the first place that the login can compare with. So I guess there is some other concept of creating a new user from the MW-core point of view that extension:ConfirmAccount is not synchronous with?

Is there any solution to this in planning?

Reply to "Unkown password after account creation"

ConfirmAccount not compatible with ConfirmEdit right now?

1
183.83.51.83 (talkcontribs)

I'm new to MediaWiki so maybe I'm missing something obvious - I just installed 1.26.2 with latest plugins for ConfirmEdit and ConfirmAccount and the "Request Account" page for ConfirmAccount started failing as soon as I setup ConfirmEdit with RecaptchaNoCaptcha following exact instructions for both extensions. This was the error message I got the on clicking "Request Account":

Catchable fatal error: Argument 1 passed to ReCaptchaNoCaptcha::getForm() must be an instance of OutputPage, none given, called in /home/<mydomain>/public_html/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php on line 231 and defined in /home/<mydomain>/public_html/wiki/extensions/ConfirmEdit/ReCaptchaNoCaptcha/ReCaptchaNoCaptcha.class.php on line 8

I managed to fix it by changing this line in RequestAccount_body.php

$form .= $captcha->getForm();

to

$form .= $captcha->getForm($this->getOutput());

This works, but I have absolutely no idea what I'm doing here frankly - I just made the parameters match by checking both files. Is this a known bug?

My thanks to all contributors for creating such a great piece of software in mediawiki and all these great extensions too!

Reply to "ConfirmAccount not compatible with ConfirmEdit right now?"

Could not create directory "mwstore://accountcreds-backend/accountcreds-public/w/wi/wik".

20
Daniel K. Schneider (talkcontribs)

MediaWiki 1.25beta (696dc35) Extension: code from GIT (both master and REL_25)

Hello,

  • I ran into this problem: Could not create directory "mwstore://accountcreds-backend/accountcreds-public/w/wi/wik"
  • Several persons reported this in older archieved messages, but my file permission are ok (i.e I can upload an image)
  • $wgFileStore to manually specify a directory will not work (has been removed since MW 1_24

Workaround (I find this truly freaky since the version appear to be the same, according to the "version" page in the wiki):

git checkout REL1_24

- cheers ! Daniel

Lajosb (talkcontribs)

I had this exact same problem, and your trick worked for me too.

But why?...

Nemo bis (talkcontribs)

It means the lastest code of the extension is not compatible with your MediaWiki.

Lajosb (talkcontribs)

Yes, of course that's what it means, but that's really very odd. Like Daniel, I'm using WM 1.25 and the extension version for WM 1.25 (i.e. the version intended for that MW version) isn't working, while an older version (namely that for MW 1.24) is. In other words, the "right" version doesn't work, while a "wrong" version does.

(By the way, I had this problem also with the WikiForum extension. In that case too the 1.25 version had a problem that was solved by downgrading to the 1.24 version.)

Nemo bis (talkcontribs)

There is no guarantee that extensions work with any version. The branches are just a time approximation.

Bawolff (talkcontribs)

Usually that type of error is caused by a permission issue. The extension defaults to $wgUploadDirectory . "/accountcreds" as the directory to use. Make sure that php can create that directory and any subdirectories (e.g. Let the php user [usually www-data] own that directory).

Well $wgFileSotre was removed, you can still set it in LocalSettings.php. The more proper way would be to adjust $wgConfirmAccountFSRepos

Wess (talkcontribs)

Facing the same problem too, downgrading the syst. I could not understand the solution described above. As I understand it tries to save those files at the server root directory. Right now my workaround was to comment out all the file saving issues...

In addition - right now the e-mails to the admin are sent only after email address confirmation. Is there's any possibility to send them at the time of registration?

38.89.3.44 (talkcontribs)
80.252.174.242 (talkcontribs)

Any solution to this? I don't get the comment "git checkout REL1_24"

117.203.118.130 (talkcontribs)

Hello. I am facing the same problem. This discussion does not make clear about how to resolve it. Please guide in a step by step manner.

Jschrempp (talkcontribs)

I have the same problem. I just applied the 1.24.3 patch to 1.24.2. The ConfirmAccount extension was working with 1.24.2.

193.33.2.101 (talkcontribs)

Do you have $wgUploadDirectory = true; in Local Settings?

Wmat (talkcontribs)

This is still a problem with MW 1.25.1 and REL1_25 of the extension.

Ken Roy (talkcontribs)

Download and install the ConfirmAccount extensions for MW 1.24.

I had to do a similar backlevel for the CategoryTree extension where I needed the MW 1.23 version for it to work with MW 1.25.3

Eburcat (talkcontribs)

With MW 1.26 this has become a real issue for us. Can't checkout REL1_25 or REL1_24 - it crashes the whole site, and can't confirm any new accounts now...

Edit: solved it by replacing in the file ConfirmAccount.config.php, this line:

$wgFileStore['accountcreds']['directory'] : $wgUploadDirectory . "/accountcreds",

with the line:

$wgFileStore['accountcreds']['directory'] : "{$IP}/images/accountcreds",

212.122.223.98 (talkcontribs)

Thats great... thanks a lot :)

Dvlink (talkcontribs)

Thank you Eburcat!!

Paladox (talkcontribs)

Patch uploaded at https://gerrit.wikimedia.org/r/#/c/258373/ for mediawiki 1.27 alpha.

74.76.112.55 (talkcontribs)

Patch worked for me... I manually made the edits found in the above link by looking at the diff. So far so good.

Paladox (talkcontribs)

Ok. Please try the new patch I just uploaded at https://gerrit.wikimedia.org/r/#/c/258373/ please.

Reply to "Could not create directory "mwstore://accountcreds-backend/accountcreds-public/w/wi/wik"."

Error running updater.php with Postgres backend

1
174.71.94.45 (talkcontribs)

I'm reporting a bug here that I encountered while using ConfirmAccount with the Postgres backend. Running the updater fails with this error:

Adding column 'account_requests.acr_agent'
A database query error has occurred.
Query: ALTER TABLE account_requests ADD acr_agent /snip/mediawiki/extensions/ConfirmAccount/backend/schema/postgres/patch-acr_agent.sql
Function: DatabaseBase::query
Error: 42601 ERROR:  syntax error at or near "/"
LINE 1: ...e::query  */ TABLE account_requests ADD acr_agent /snip...
                                                             ^

Reason: the third parameter to addPgField should be the type, not a patch file. Since the patch file in this case is very simple, it can be replaced with a series of addPgField calls. Otherwise, it would have to be applied with a different function (addTable, maybe, though that's not what's really happening).

Solution: Apply this patch to extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php:

diff --git a/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php b/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php
index 54e6d31..d07dc54 100755
--- a/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php
+++ b/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php
@@ -34,7 +34,10 @@ class ConfirmAccountUpdaterHooks {
                        $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_areas', "TEXT" ) );
                        $updater->addExtensionUpdate( array( 'addPgField', 'account_credentials', 'acd_areas', "TEXT" ) );
                        $updater->addExtensionUpdate( array( 'addIndex', 'account_requests', 'acr_email', "$base/patch-email-index.sql", true ) );
-                       $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_agent', "$base/patch-acr_agent.sql", true ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_xff', "TEXT" ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_agent', "TEXT" ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_credentials', 'acd_xff', "TEXT" ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_credentials', 'acd_agent', "TEXT" ) );
                }
                return true;
        }
Reply to "Error running updater.php with Postgres backend"
WmBliss (talkcontribs)

After the new user confirms their email, ConfirmAccount seems to be sending 2 duplicate pending account notifications. This was reported in 2011, but that installer did not get any solution responses.

Any ideas what I set up incorrectly?

Wmat (talkcontribs)

I can confirm this is still a problem with MW 1.25.1 and ConfirmAccount REL1_24. Note, running REL1_24 due to the 'Could not create directory: wmstore...." error above.

I am receiving 3 notices of pending accounts.

Reply to "Duplicate Email Notifications"
Paulijennings (talkcontribs)

I am trying to add this extension to an existing MediaWiki 1.25.2 installation. I have tried both 1_24 and 1_25 versions and see the same problem in both:

  • First I installed the 1_25 version (not the beta version), and on testing hit the same problem reported below (Could not create directory "mwstore://accountcreds-backend/accountcreds-public/w/wi/wiki"). After reading the information below, I decided to try the 1_24 install.
  • However, before getting to that installation I went back to the main page and happened to look at a page with images, and all images (everywhere on the site except the logo on the main page) were replaced with the text "Error creating thumbnail: File missing".
  • Having restored the database from the previous night's backup (all images present again), I then tried installing the 1_24 version.
  • I have not yet tested the account confirmation capability to know if it resolves the directory creation issue, but all the images are now non-functional in the site: again, replaced with "Error creating thumbnail: File missing".
  • I have checked (27 times) that the permissions on the images upload directory make this directory accessible (755), and that $wgEnableUploads = true; in LocalSettings.php.
  • The images are lost on running the update.php script. To check this, I ran update.php prior to installing the extensions - all images present - then installed the extension and then reran update.php and immediately checked the images - gone.

I have no workaround for this. Anyone have any idea what is going on?

Thanks | Paul

Reply to "Loss of images during instalation"

How can I add a new parameter to the Extension's Pages?

1
Dekel E (talkcontribs)

Hi,

I have to add a new parameter to the "request account" page.

How can I do that?

Reply to "How can I add a new parameter to the Extension's Pages?"

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

17
OlivierCompagne (talkcontribs)

I installed ConfirmAccount, all went well. I updated the database via the web.

I tested the account request, and I rejected my test account, and it worked. Today someone requested an account; I wanted to accept it, but when I submit, it gives me that error message: "A database query error has occurred. This may indicate a bug in the software." See screenshot of the error page: http://screencast.com/t/lPU4IyEXjX

Can anyone help? I don't know what to do to fix this issue. Thanks!

FYI my environment info: MediaWiki 1.23.2 PHP 5.3.28 (cgi-fcgi) MySQL 5.1.67-rel14.3-log

128.250.26.189 (talkcontribs)

I have the same exact version and issue

Donkey Kong Genius (talkcontribs)

I have this error as well. As far as I can see everything about the confirm account extension seems to work. If I confirm an account to approve it, then I get the same error on the wiki page. Any one understanding this issue and willing to help?

91.61.79.41 (talkcontribs)

Same for me. I have this error for a few days. I deleted all my tables in the db and all files on my space so I have a complete clean installation. But I still can't install mediawiki.

No my error changes from the one above to: Function: DatabaseBase::sourceFile( /home/webpages/lima-city/wod-berlin/html/maintenance/tables.sql ) Error: 1146 Table 'db_287222_1.user' doesn't exist (mysql.lima-city.de)

So what am I supposed to do now?!

CookipediaChef~mediawikiwiki (talkcontribs)

I have the same problem on a new installation, though I have copied tables from another database. I'm now wondering if that's where the problem lies?

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

  • MW 1.24.0
  • PHP 5.3.3 (apache2handler)
  • mySQL 5.1.73
  • Confirm account – (75bdde7) 20:50, 12 November 2014

This post was posted by CookipediaChef~mediawikiwiki, but signed as CookipediaChef.

Nemo bis (talkcontribs)

Copied tables? And did you run update.php then?

88.106.73.51 (talkcontribs)

I have exactly same problem after upgrade to MW 1.24. Reinstalled confirmaccount, and run update.php but it's not helping

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

Query: INSERT INTO `y5m_account_credentials` (acd_user_id,acd_real_name,acd_email,acd_email_authenticated,acd_bio,acd_notes,acd_urls,acd_ip,acd_xff,acd_agent,acd_filename,acd_storage_key,acd_areas,acd_registration,acd_accepted,acd_user,acd_comment,acd_id) VALUES ('682','Ričardas','ryckaxxl60@gmail.com','20141202143609',,,,'78.62.161.58',,'Mozilla/5.0 (Windodws NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36',NULL,'soft_escwiki-y5m_:acctrequest:ip:78.62.161.58',,'20141201022523','20141204123207','2',,NULL) Function: AccountConfirmSubmission::acceptRequest Error: 1054 Unknown column 'acd_xff' in 'field list' (localhost)

188.226.181.10 (talkcontribs)

Same: SELECT COUNT(*) FROM `account_requests` WHERE acr_type = '0' AND acr_deleted = '0' AND (acr_held IS NULL) LIMIT 1 1146 Table 'wiki.account_requests' doesn't exist (localhost)

Tymek1988 (talkcontribs)

So there is no way to fix it?

Aaron Schulz (talkcontribs)

ALTER TABLE /*_*/account_credentials ADD COLUMN acd_xff VARCHAR(255) NULL default ;

Grantbow (talkcontribs)

This did not fix my mediawiki 1.22.6 install.

159.50.16.166 (talkcontribs)

Same Problem. Read somewhere we can try to create these fields manually. Could someone give us the field definition ? (Type, attribute, Null, Default...) Thanks !

98.201.4.33 (talkcontribs)

I not only have that issue, but I'd get the same message when I clicked the Recent Changes link, until I commented out the extension.

75.175.9.66 (talkcontribs)

After upgrading from MW 1.19 to MW 1.23 and ConfirmAccount r115623 to REL1_23, I had to add the acd_xff and acd_agent fields, and I had to add them to account_requests, not account_credentials.

tl;dr: Run these in mysql, substituting your wiki's database name for wikidb:

USE wikidb;
ALTER TABLE mw_account_requests ADD acr_agent VARCHAR(255) NULL default '';''
ALTER TABLE mw_account_requests ADD acr_xff VARCHAR(255) NULL default '';''

There may be a better way to fix it. The underlying problem is that new fields added to ConfirmAccount across LTS version upgrades are not automatically added to the wiki database. Ideally, the extension would attempt to add necessary fields if they don't exist.

--

The error and backtrace:

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

Query:
INSERT INTO `mw_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,'Z','x@y.z','aowiefawe','20150712184313','Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum.','','','0','',NULL,'wikidb-mw_:acctrequest:ip:--.--.--.--','','--.--.--.--','','Mozilla/5.0 (X11; CrOS x86_64 6946.70.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.132 Safari/537.36','0','--','20150811184313')''
Function: UserAccountRequest::insertOn
Error: 1054 Unknown column 'acr_xff' in 'field list' (localhost)
Backtrace:

#0 /var/www/wiki/includes/db/Database.php(1123): DatabaseBase->reportQueryError('Unknown column ...', 1054, 'INSERT  INTO `m...', 'UserAccountRequ...', false)
#1 /var/www/wiki/includes/db/Database.php(1920): DatabaseBase->query('INSERT  INTO `m...', 'UserAccountRequ...')
#2 /var/www/wiki/extensions/ConfirmAccount/backend/UserAccountRequest.php(358): DatabaseBase->insert('account_request...', Array, 'UserAccountRequ...')
#3 /var/www/wiki/extensions/ConfirmAccount/business/AccountRequestSubmission.php(243): UserAccountRequest->insertOn()
#4 /var/www/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(315): AccountRequestSubmission->submit(Object(RequestContext))
#5 /var/www/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(80): RequestAccountPage->doSubmit()
#6 /var/www/wiki/includes/specialpage/SpecialPage.php(379): RequestAccountPage->execute(NULL)
#7 /var/www/wiki/includes/specialpage/SpecialPageFactory.php(503): SpecialPage->run(NULL)
#8 /var/www/wiki/includes/Wiki.php(285): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#9 /var/www/wiki/includes/Wiki.php(588): MediaWiki->performRequest()
#10 /var/www/wiki/includes/Wiki.php(447): MediaWiki->main()
#11 /var/www/wiki/index.php(46): MediaWiki->run()
#12 {main}

You can generate this message by adding these to the end of your wiki's LocalSettings.php file:

$wgShowSQLErrors = true;
$wgDebugDumpSql = true;
$wgShowDBErrorBacktrace = true;

--

Console I/O to fix it:

➜  ~  sudo mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1506962
Server version: 5.5.31-0ubuntu0.12.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use wikidb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE mw_account_requests ADD acr_agent VARCHAR(255) NULL default '';''
Query OK, 1 row affected (0.10 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE mw_account_requests ADD acr_xff VARCHAR(255) NULL default '';''
Query OK, 1 row affected (0.23 sec)
Records: 1  Duplicates: 0  Warnings: 0
75.175.9.66 (talkcontribs)

(To confirm, I did run update.php before any of the above steps. The update.php pass ''is not'' adding this extension's required fields after an upgrade.)

Mojorhino (talkcontribs)

I had this same error. I noticed it right after blocking several of what I thought were fictitious users.

After further review I figured out what was causing the error. Someone at my work created an account without updating any pages so I blocked them thinking they were also a fictitious user. Well, when I blocked them I also blocked their IP address & since we have a static IP at my work that caused me to unintentionally block myself which was ultimately causing in the error message. After unblocking the user with the same IP as mine my problems went away.

Paladox (talkcontribs)

Patch https://gerrit.wikimedia.org/r/#/c/237711 should fix this problem.

Reply to "A database query error has occurred. This may indicate a bug in the software."
81.14.47.251 (talkcontribs)

Hi! everyone,

I am using 1.23. My mediawiki files are under /wiki and I have symbolic links from my many wiki sites. All my sites are run under SQLight.

Until now, I was unable to use the ConfirmAccount extension I had loaded. Look at this site I saw that reloading another 1.23 version might help. I reloaded it today from the site. I get the request page and can fill the form.

However I get:

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

  • Query:
    SELECT COUNT(*) FROM account_requests WHERE acr_deleted = '0' AND (acr_held IS NULL) AND (acr_email_authenticated IS NOT NULL) LIMIT 1
  • Function: ConfirmAccount::getOpenEmailConfirmedCount
  • Error: 1 no such table: account_request

I would be glad someone explains me what I do wrong.

Best regards

Jefsey

Reply to "What did I do wrong?"
87.158.75.126 (talkcontribs)

Hi all,

with ConfirmAccount extension uploaded and local settings modified the web browser update script does not work :(

First step of update (verifying installed MediaWiki version) is not to be seen (blank page)

Is this a known problem or misconfiguration by myself? Any further informations necessary?

Regards,

Klaus

Reply to "Update script will not proceed"