1
|
Processing AccountController#login (for 192.168.0.2 at 2009-02-15 20:50:58) [GET]
|
2
|
Session ID: d8504bb5fc062cf3771025ac01f75d15
|
3
|
Parameters: {"action"=>"login", "controller"=>"account"}
|
4
|
[4;36;1mSetting Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
5
|
[4;35;1mSQL (0.000000)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
6
|
[4;36;1mAnonymousUser Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
7
|
[4;35;1mAnonymousUser Load (0.000000)[0m [0mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
8
|
[4;36;1mCACHE (0.000000)[0m [0;1mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
9
|
Rendering template within layouts/base
|
10
|
Rendering account/login
|
11
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1[0m
|
12
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1[0m
|
13
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1[0m
|
14
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
15
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
16
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
17
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1[0m
|
18
|
[4;36;1mProject Load (0.000000)[0m [0;1mSELECT `projects`.* FROM `projects` INNER JOIN members ON projects.id = members.project_id WHERE ((`members`.user_id = 4) AND ((projects.status=1))) [0m
|
19
|
Completed in 0.50000 (2 reqs/sec) | Rendering: 0.04600 (9%) | DB: 0.00000 (0%) | 200 OK [http://192.168.0.2/login]
|
20
|
|
21
|
|
22
|
Processing AccountController#login (for 192.168.0.2 at 2009-02-15 20:51:03) [POST]
|
23
|
Session ID: d8504bb5fc062cf3771025ac01f75d15
|
24
|
Parameters: {"back_url"=>"http%3A%2F%2F192.168.0.2%3A3000%2Faccount%2Fregister", "openid_url"=>"https://me.yahoo.com/a/XXXXXXXXXXXXXXX-", "action"=>"login", "username"=>"", "controller"=>"account", "password"=>"[FILTERED]", "login"=>"Connexion »"}
|
25
|
[4;35;1mSetting Columns (0.000000)[0m [0mSHOW FIELDS FROM `settings`[0m
|
26
|
[4;36;1mSQL (0.000000)[0m [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
27
|
[4;35;1mAnonymousUser Columns (0.000000)[0m [0mSHOW FIELDS FROM `users`[0m
|
28
|
[4;36;1mAnonymousUser Load (0.000000)[0m [0;1mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
29
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1[0m
|
30
|
WARNING: making https request to https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXX- without verifying server certificate; no CA path was specified.
|
31
|
WARNING: making https request to https://open.login.yahooapis.com/openid20/user_profile/xrds without verifying server certificate; no CA path was specified.
|
32
|
[4;36;1mOpenIdAuthentication::Association Columns (0.016000)[0m [0;1mSHOW FIELDS FROM `open_id_authentication_associations`[0m
|
33
|
[4;35;1mOpenIdAuthentication::Association Load (0.000000)[0m [0mSELECT * FROM `open_id_authentication_associations` WHERE (`open_id_authentication_associations`.`server_url` = 'https://open.login.yahooapis.com/openid/op/auth') [0m
|
34
|
Generated checkid_setup request to https://open.login.yahooapis.com/openid/op/auth with assocication hgKjjDkkWzB3Muwo02iHHGimW5CRB9crDkEaQh4Y.09V4h9NkBjfJebpkLEqL2Dsx6O1QekfoQaQb0XJBKg8lQxHUmEwdJ4H40bQEkCeg.GLOxl49I3GB.EV5GtBmQ--
|
35
|
Redirected to https://open.login.yahooapis.com/openid/op/auth?openid.assoc_handle=hgKjjDkkWzB3Muwo02iHHGimW5CRB9crDkEaQh4Y.09V4h9NkBjfJebpkLEqL2Dsx6O1QekfoQaQb0XJBKg8lQxHUmEwdJ4H40bQEkCeg.GLOxl49I3GB.EV5GtBmQ--&openid.ax.mode=fetch_request&openid.claimed_id=https%3A%2F%2Fme.yahoo.com%2Fa%2FXXXXXXXXXXXXXXXXXXXXXXXXXX-&openid.identity=https%3A%2F%2Fme.yahoo.com%2Fa%2FXXXXXXXXXXXXXXXXXXXXXXX-&openid.mode=checkid_setup&openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.ns.ax=http%3A%2F%2Fopenid.net%2Fsrv%2Fax%2F1.0&openid.ns.sreg=http%3A%2F%2Fopenid.net%2Fextensions%2Fsreg%2F1.1&openid.realm=http%3A%2F%2F192.168.0.2%3A3000%2F&openid.return_to=http%3A%2F%2F192.168.0.2%3A3000%2Flogin%3F_method%3Dpost%26open_id_complete%3D1&openid.sreg.required=nickname%2Cfullname%2Cemail
|
36
|
Completed in 1.86000 (0 reqs/sec) | DB: 0.01600 (0%) | 302 Found [http://192.168.0.2/login]
|
37
|
|
38
|
|
39
|
Processing AccountController#login (for 192.168.0.2 at 2009-02-15 20:51:10) [POST]
|
40
|
Session ID: d8504bb5fc062cf3771025ac01f75d15
|
41
|
Parameters: {"openid.mode"=>"id_res", "openid.return_to"=>"http://192.168.0.2:3000/login?_method=post&open_id_complete=1", "openid.claimed_id"=>"https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXXXXX-#f8646", "openid.sig"=>"+dGvke8brQOJ6jKv1XYdoXcI2/U=", "openid.ns"=>"http://specs.openid.net/auth/2.0", "openid.op_endpoint"=>"https://open.login.yahooapis.com/openid/op/auth", "action"=>"login", "_method"=>"post", "openid.response_nonce"=>"2009-02-15T19:45:58ZHe9p64bchOk8xo7Pm0oKqk0.x_E0hVI1Cg--", "controller"=>"account", "openid.pape.nist_auth_level"=>"0", "openid.identity"=>"https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXXX-", "open_id_complete"=>"1", "openid.pape.auth_policies"=>"none", "openid.assoc_handle"=>"hgKjjDkkWzB3Muwo02iHHGimW5CRB9crDkEaQh4Y.09V4h9NkBjfJebpkLEqL2Dsx6O1QekfoQaQb0XJBKg8lQxHUmEwdJ4H40bQEkCeg.GLOxl49I3GB.EV5GtBmQ--", "openid.signed"=>"assoc_handle,claimed_id,identity,mode,ns,ns.pape,op_endpoint,pape.auth_policies,pape.nist_auth_level,response_nonce,return_to,signed", "openid.realm"=>"http://192.168.0.2:3000/", "openid.ns.pape"=>"http://specs.openid.net/extensions/pape/1.0"}
|
42
|
[4;36;1mSetting Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
43
|
[4;35;1mSQL (0.000000)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
44
|
[4;36;1mAnonymousUser Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
45
|
[4;35;1mAnonymousUser Load (0.000000)[0m [0mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
46
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1[0m
|
47
|
[4;35;1mOpenIdAuthentication::Association Load (0.000000)[0m [0mSELECT * FROM `open_id_authentication_associations` WHERE (`open_id_authentication_associations`.`server_url` = 'https://open.login.yahooapis.com/openid/op/auth' AND `open_id_authentication_associations`.`handle` = 'hgKjjDkkWzB3Muwo02iHHGimW5CRB9crDkEaQh4Y.09V4h9NkBjfJebpkLEqL2Dsx6O1QekfoQaQb0XJBKg8lQxHUmEwdJ4H40bQEkCeg.GLOxl49I3GB.EV5GtBmQ--') [0m
|
48
|
[4;36;1mOpenIdAuthentication::Nonce Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `open_id_authentication_nonces`[0m
|
49
|
[4;35;1mOpenIdAuthentication::Nonce Load (0.000000)[0m [0mSELECT * FROM `open_id_authentication_nonces` WHERE (`open_id_authentication_nonces`.`timestamp` = 1234727158 AND `open_id_authentication_nonces`.`server_url` = 'https://open.login.yahooapis.com/openid/op/auth' AND `open_id_authentication_nonces`.`salt` = 'He9p64bchOk8xo7Pm0oKqk0.x_E0hVI1Cg--') LIMIT 1[0m
|
50
|
[4;36;1mSQL (0.000000)[0m [0;1mBEGIN[0m
|
51
|
[4;35;1mOpenIdAuthentication::Nonce Create (0.000000)[0m [0mINSERT INTO `open_id_authentication_nonces` (`timestamp`, `salt`, `server_url`) VALUES(1234727158, 'He9p64bchOk8xo7Pm0oKqk0.x_E0hVI1Cg--', 'https://open.login.yahooapis.com/openid/op/auth')[0m
|
52
|
[4;36;1mSQL (0.031000)[0m [0;1mCOMMIT[0m
|
53
|
[4;35;1mUser Columns (0.000000)[0m [0mSHOW FIELDS FROM `users`[0m
|
54
|
[4;36;1mUser Load (0.000000)[0m [0;1mSELECT * FROM `users` WHERE (`users`.`identity_url` = 'https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXXXX-') LIMIT 1[0m
|
55
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1[0m
|
56
|
[4;36;1mSQL (0.000000)[0m [0;1mBEGIN[0m
|
57
|
[4;35;1mCustomField Load (0.000000)[0m [0mSELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position[0m
|
58
|
[4;36;1mCustomField Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `custom_fields`[0m
|
59
|
[4;35;1mCustomValue Columns (0.000000)[0m [0mSHOW FIELDS FROM `custom_values`[0m
|
60
|
[4;36;1mUserCustomField Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `custom_fields`[0m
|
61
|
[4;35;1mSQL (0.000000)[0m [0mCOMMIT[0m
|
62
|
Rendering template within layouts/base
|
63
|
Rendering account/register
|
64
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
65
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
66
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
67
|
[4;35;1mProject Load (0.000000)[0m [0mSELECT `projects`.* FROM `projects` INNER JOIN members ON projects.id = members.project_id WHERE ((`members`.user_id = 4) AND ((projects.status=1))) [0m
|
68
|
Completed in 0.20300 (4 reqs/sec) | Rendering: 0.11000 (54%) | DB: 0.03100 (15%) | 200 OK [http://192.168.0.2/login?_method=post&open_id_complete=1&openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.mode=id_res&openid.return_to=http%3A%2F%2F192.168.0.2%3A3000%2Flogin%3F_method%3Dpost%26open_id_complete%3D1&openid.claimed_id=https%3A%2F%2Fme.yahoo.com%2Fa%2FXXXXXXXXXXXXXXXXXXXXXXXXXXX-%23f8646&openid.identity=https%3A%2F%2Fme.yahoo.com%2Fa%2FXXXXXXXXXXXXXXXXXXXXXXXX-&openid.assoc_handle=hgKjjDkkWzB3Muwo02iHHGimW5CRB9crDkEaQh4Y.09V4h9NkBjfJebpkLEqL2Dsx6O1QekfoQaQb0XJBKg8lQxHUmEwdJ4H40bQEkCeg.GLOxl49I3GB.EV5GtBmQ--&openid.realm=http%3A%2F%2F192.168.0.2%3A3000%2F&openid.response_nonce=2009-02-15T19%3A45%3A58ZHe9p64bchOk8xo7Pm0oKqk0.x_E0hVI1Cg--&openid.signed=assoc_handle%2Cclaimed_id%2Cidentity%2Cmode%2Cns%2Cns.pape%2Cop_endpoint%2Cpape.auth_policies%2Cpape.nist_auth_level%2Cresponse_nonce%2Creturn_to%2Csigned&openid.op_endpoint=https%3A%2F%2Fopen.login.yahooapis.com%2Fopenid%2Fop%2Fauth&openid.ns.pape=http%3A%2F%2Fspecs.openid.net%2Fextensions%2Fpape%2F1.0&openid.pape.auth_policies=none&openid.pape.nist_auth_level=0&openid.sig=%2BdGvke8brQOJ6jKv1XYdoXcI2%2FU%3D]
|
69
|
|
70
|
|
71
|
Processing AccountController#register (for 192.168.0.2 at 2009-02-15 20:51:39) [POST]
|
72
|
Session ID: d8504bb5fc062cf3771025ac01f75d15
|
73
|
Parameters: {"user"=>{"language"=>"", "mail"=>"jp@somenet.foo", "lastname"=>"Lang", "firstname"=>"Jp", "identity_url"=>"https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXXXXXXXXX-", "login"=>"mylogin"}, "commit"=>"Soumettre", "password_confirmation"=>"[FILTERED]", "action"=>"register", "controller"=>"account", "password"=>"[FILTERED]"}
|
74
|
[4;36;1mSetting Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
75
|
[4;35;1mSQL (0.000000)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
76
|
[4;36;1mAnonymousUser Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
77
|
[4;35;1mAnonymousUser Load (0.000000)[0m [0mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
78
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1[0m
|
79
|
[4;35;1mUser Columns (0.000000)[0m [0mSHOW FIELDS FROM `users`[0m
|
80
|
WARNING: Can't mass-assign these protected attributes: login
|
81
|
[4;36;1mSQL (0.000000)[0m [0;1mBEGIN[0m
|
82
|
[4;35;1mCustomField Load (0.000000)[0m [0mSELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position[0m
|
83
|
[4;36;1mCustomField Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `custom_fields`[0m
|
84
|
[4;35;1mCustomValue Columns (0.000000)[0m [0mSHOW FIELDS FROM `custom_values`[0m
|
85
|
[4;36;1mUserCustomField Columns (0.000000)[0m [0;1mSHOW FIELDS FROM `custom_fields`[0m
|
86
|
[4;35;1mSQL (0.000000)[0m [0mSELECT `mail` FROM `users` WHERE (LOWER(`users`.mail) = 'jp@somenet.foo') [0m
|
87
|
[4;36;1mSQL (0.000000)[0m [0;1mCOMMIT[0m
|
88
|
Rendering template within layouts/base
|
89
|
Rendering account/register
|
90
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1[0m
|
91
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
92
|
[4;35;1mSetting Load (0.000000)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
93
|
[4;36;1mSetting Load (0.000000)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
94
|
[4;35;1mProject Load (0.000000)[0m [0mSELECT `projects`.* FROM `projects` INNER JOIN members ON projects.id = members.project_id WHERE ((`members`.user_id = 4) AND ((projects.status=1))) [0m
|
95
|
Completed in 0.31300 (3 reqs/sec) | Rendering: 0.10900 (34%) | DB: 0.00000 (0%) | 200 OK [http://192.168.0.2/account/register]
|