Finally got around to revisiting this. I did a fresh update from HEAD and installed. I entered
mailto:admin@stratamatters.com as email and Brad as username on the install.
Following Lars' requests:
Yes it prompts for email - enter email address and password and get 'unknown username'. Still asking for email - if you enter the username it comes up 'unknown email'
sql query results:
users table
user_id authority_id username screen_name priv_name priv_email
0 guest 0 5
405 9 Brad 0 5
parties table
party_id email url
0
-2
-4
394
405 mailto:admin@stratamatters.com
Looking at the log, I can see that it's querying the users table but has the username all lowercase i.e. select user_id from users where username='brad' and authority_id=9
I tried that query in psql and came up 0 rows returned - if I change username to 'Brad', I get the user_id 405 returned.
I guess next step for me is to dig into auth::authenticate and what-not. Guess there's no better time than the present to get my feet wet looking at tcl code...
In the meantime, you can see this bug live at 24.87.20.202:8888 - I'll leave the install up for today.
Lars, if I can't figure out anything with auth procs, would it help if I let you ssh into my server and poke around?