Processing AccountController#login (for 192.168.0.2 at 2009-02-15 20:50:58) [GET] Session ID: d8504bb5fc062cf3771025ac01f75d15 Parameters: {"action"=>"login", "controller"=>"account"} Setting Columns (0.000000) SHOW FIELDS FROM `settings` SQL (0.000000) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`  AnonymousUser Columns (0.000000) SHOW FIELDS FROM `users` AnonymousUser Load (0.000000) SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1 CACHE (0.000000) SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1 Rendering template within layouts/base Rendering account/login Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1 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)))  Completed in 0.50000 (2 reqs/sec) | Rendering: 0.04600 (9%) | DB: 0.00000 (0%) | 200 OK [http://192.168.0.2/login] Processing AccountController#login (for 192.168.0.2 at 2009-02-15 20:51:03) [POST] Session ID: d8504bb5fc062cf3771025ac01f75d15 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 ยป"} Setting Columns (0.000000) SHOW FIELDS FROM `settings` SQL (0.000000) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`  AnonymousUser Columns (0.000000) SHOW FIELDS FROM `users` AnonymousUser Load (0.000000) SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1 WARNING: making https request to https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXX- without verifying server certificate; no CA path was specified. WARNING: making https request to https://open.login.yahooapis.com/openid20/user_profile/xrds without verifying server certificate; no CA path was specified. OpenIdAuthentication::Association Columns (0.016000) SHOW FIELDS FROM `open_id_authentication_associations` 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')  Generated checkid_setup request to https://open.login.yahooapis.com/openid/op/auth with assocication hgKjjDkkWzB3Muwo02iHHGimW5CRB9crDkEaQh4Y.09V4h9NkBjfJebpkLEqL2Dsx6O1QekfoQaQb0XJBKg8lQxHUmEwdJ4H40bQEkCeg.GLOxl49I3GB.EV5GtBmQ-- 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 Completed in 1.86000 (0 reqs/sec) | DB: 0.01600 (0%) | 302 Found [http://192.168.0.2/login] Processing AccountController#login (for 192.168.0.2 at 2009-02-15 20:51:10) [POST] Session ID: d8504bb5fc062cf3771025ac01f75d15 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"} Setting Columns (0.000000) SHOW FIELDS FROM `settings` SQL (0.000000) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`  AnonymousUser Columns (0.000000) SHOW FIELDS FROM `users` AnonymousUser Load (0.000000) SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1 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--')  OpenIdAuthentication::Nonce Columns (0.000000) SHOW FIELDS FROM `open_id_authentication_nonces` 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 SQL (0.000000) BEGIN 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') SQL (0.031000) COMMIT User Columns (0.000000) SHOW FIELDS FROM `users` User Load (0.000000) SELECT * FROM `users` WHERE (`users`.`identity_url` = 'https://me.yahoo.com/a/XXXXXXXXXXXXXXXXXXXXXX-') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1 SQL (0.000000) BEGIN CustomField Load (0.000000) SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position CustomField Columns (0.000000) SHOW FIELDS FROM `custom_fields` CustomValue Columns (0.000000) SHOW FIELDS FROM `custom_values` UserCustomField Columns (0.000000) SHOW FIELDS FROM `custom_fields` SQL (0.000000) COMMIT Rendering template within layouts/base Rendering account/register Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1 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)))  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] Processing AccountController#register (for 192.168.0.2 at 2009-02-15 20:51:39) [POST] Session ID: d8504bb5fc062cf3771025ac01f75d15 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]"} Setting Columns (0.000000) SHOW FIELDS FROM `settings` SQL (0.000000) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`  AnonymousUser Columns (0.000000) SHOW FIELDS FROM `users` AnonymousUser Load (0.000000) SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1 User Columns (0.000000) SHOW FIELDS FROM `users` WARNING: Can't mass-assign these protected attributes: login SQL (0.000000) BEGIN CustomField Load (0.000000) SELECT * FROM `custom_fields` WHERE (type = 'UserCustomField') ORDER BY position CustomField Columns (0.000000) SHOW FIELDS FROM `custom_fields` CustomValue Columns (0.000000) SHOW FIELDS FROM `custom_values` UserCustomField Columns (0.000000) SHOW FIELDS FROM `custom_fields` SQL (0.000000) SELECT `mail` FROM `users` WHERE (LOWER(`users`.mail) = 'jp@somenet.foo')  SQL (0.000000) COMMIT Rendering template within layouts/base Rendering account/register Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'openid') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1 Setting Load (0.000000) SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1 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)))  Completed in 0.31300 (3 reqs/sec) | Rendering: 0.10900 (34%) | DB: 0.00000 (0%) | 200 OK [http://192.168.0.2/account/register]