Project

General

Profile

Defect #2757 » development.log

Jean-Philippe Lang, 2009-02-15 20:52

 
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
  Setting Columns (0.000000)   SHOW FIELDS FROM `settings`
5
  SQL (0.000000)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
6
  AnonymousUser Columns (0.000000)   SHOW FIELDS FROM `users`
7
  AnonymousUser Load (0.000000)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
8
  CACHE (0.000000)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
9
Rendering template within layouts/base
10
Rendering account/login
11
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1
12
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1
13
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1
14
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
15
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
16
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
17
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1
18
  Project Load (0.000000)   SELECT `projects`.* FROM `projects` INNER JOIN members ON projects.id = members.project_id WHERE ((`members`.user_id = 4) AND ((projects.status=1))) 
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
  Setting Columns (0.000000)   SHOW FIELDS FROM `settings`
26
  SQL (0.000000)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
27
  AnonymousUser Columns (0.000000)   SHOW FIELDS FROM `users`
28
  AnonymousUser Load (0.000000)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
29
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1
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
  OpenIdAuthentication::Association Columns (0.016000)   SHOW FIELDS FROM `open_id_authentication_associations`
33
  OpenIdAuthentication::Association Load (0.000000)   SELECT * FROM `open_id_authentication_associations` WHERE (`open_id_authentication_associations`.`server_url` = 'https://open.login.yahooapis.com/openid/op/auth') 
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
  Setting Columns (0.000000)   SHOW FIELDS FROM `settings`
43
  SQL (0.000000)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
44
  AnonymousUser Columns (0.000000)   SHOW FIELDS FROM `users`
45
  AnonymousUser Load (0.000000)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
46
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1
47
  OpenIdAuthentication::Association Load (0.000000)   SELECT * 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--') 
48
  OpenIdAuthentication::Nonce Columns (0.000000)   SHOW FIELDS FROM `open_id_authentication_nonces`
49
  OpenIdAuthentication::Nonce Load (0.000000)   SELECT * 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
50
  SQL (0.000000)   BEGIN
51
  OpenIdAuthentication::Nonce Create (0.000000)   INSERT INTO `open_id_authentication_nonces` (`timestamp`, `salt`, `server_url`) VALUES(1234727158, 'He9p64bchOk8xo7Pm0oKqk0.x_E0hVI1Cg--', 'https://open.login.yahooapis.com/openid/op/auth')
52
  SQL (0.031000)   COMMIT
53
  User Columns (0.000000)   SHOW FIELDS FROM `users`
54
  User Load (0.000000)   SELECT * FROM `users` WHERE (`users`.`identity_url` = 'https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXXXX-') LIMIT 1
55
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1
56
  SQL (0.000000)   BEGIN
57
  CustomField Load (0.000000)   SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position
58
  CustomField Columns (0.000000)   SHOW FIELDS FROM `custom_fields`
59
  CustomValue Columns (0.000000)   SHOW FIELDS FROM `custom_values`
60
  UserCustomField Columns (0.000000)   SHOW FIELDS FROM `custom_fields`
61
  SQL (0.000000)   COMMIT
62
Rendering template within layouts/base
63
Rendering account/register
64
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
65
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
66
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
67
  Project Load (0.000000)   SELECT `projects`.* FROM `projects` INNER JOIN members ON projects.id = members.project_id WHERE ((`members`.user_id = 4) AND ((projects.status=1))) 
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
  Setting Columns (0.000000)   SHOW FIELDS FROM `settings`
75
  SQL (0.000000)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
76
  AnonymousUser Columns (0.000000)   SHOW FIELDS FROM `users`
77
  AnonymousUser Load (0.000000)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
78
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1
79
  User Columns (0.000000)   SHOW FIELDS FROM `users`
80
WARNING: Can't mass-assign these protected attributes: login
81
  SQL (0.000000)   BEGIN
82
  CustomField Load (0.000000)   SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position
83
  CustomField Columns (0.000000)   SHOW FIELDS FROM `custom_fields`
84
  CustomValue Columns (0.000000)   SHOW FIELDS FROM `custom_values`
85
  UserCustomField Columns (0.000000)   SHOW FIELDS FROM `custom_fields`
86
  SQL (0.000000)   SELECT `mail` FROM `users` WHERE (LOWER(`users`.mail) = 'jp@somenet.foo') 
87
  SQL (0.000000)   COMMIT
88
Rendering template within layouts/base
89
Rendering account/register
90
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1
91
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
92
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
93
  Setting Load (0.000000)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
94
  Project Load (0.000000)   SELECT `projects`.* FROM `projects` INNER JOIN members ON projects.id = members.project_id WHERE ((`members`.user_id = 4) AND ((projects.status=1))) 
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]
(1-1/2)