PerlDancer / PerlDancer/Dancer2-Plugin-Auth-Extensible

Implementing password resets

Open
#75 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Perl
Stars
10
Forks
21
PR merge metrics
No merged PRs in 30d

Description

Hi team,
I have (what I think is) a working DPAE setup - it worked with simple passwords and I am now trying to get it to work with DB passwords. When using password reset,
"Password reset
Enter your username to obtain an email to reset your password

Username: ... [Submit]" and clicking 'Submit', I get "A password reset request has been sent. Please check your email."

However, there is no email and I get
"DBD::mysql::db do failed: Unknown column 'pw_reset_code' in 'field list' at /Library/Perl/5.18/Dancer/Plugin/Database/Core/Handle.pm line 310." (to STDERR)
and no further information in Dancer2 logfile or STDERR.

Are there more diagnostics I should be seeing or ...?
I can see pw_reset_code mentioned in the PM but I'm not sure how it translates to a select query in Dancer2::Plugin::Auth::Extensible::Provider::Database (which is how I assume the above error is arising)

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with Dancer2::Plugin::Auth::Extensible::Provider::Database and the password-reset flow described in the report; reproduce the MySQL error and inspect how pw_reset_code is selected. Check the available diagnostics and database schema, then verify the fix with a reset request that completes without the unknown-column error.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, perl
Domain
authentication, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.