Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:07 -0700 2011
- Processing by AuthController#access_token as */*
- Parameters: {"code"=>"a96819da99d601e69a7ab5650aa87f40", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
- Client Load (1.0ms) SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
- Completed 200 OK in 1072ms (Views: 628.2ms | ActiveRecord: 1.0ms)
- Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:09 -0700 2011
- Processing by AuthController#user as JSON
- Parameters: {"access_token"=>""}
- Completed in 15ms
- Started GET "/auth/josh_id/authorize?scope=read&client_id=rnapp123&type=web_server&authorize_url=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fjosh_id%2Fauthorize&access_token_url=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fjosh_id%2Faccess_token&redirect_uri=http%3A%2F%2Flocalhost%3A3001%2Fauth%2Fjosh_id%2Fcallback" for 127.0.0.1 at Sun Jun 05 07:36:09 -0700 2011
- Processing by AuthController#authorize as HTML
- Parameters: {"scope"=>"read", "type"=>"web_server", "client_id"=>"rnapp123", "access_token_url"=>"http://localhost:3000/auth/josh_id/access_token", "authorize_url"=>"http://localhost:3000/auth/josh_id/authorize", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
- SQL (8.2ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"users"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- User Load (0.6ms) SELECT "users".* FROM "users" WHERE ("users"."id" = 2) LIMIT 1
- SQL (5.1ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"users"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- AREL (8.6ms) DELETE FROM "access_grants" WHERE (created_at < '2011-06-02 14:36:10.031059')
- SQL (8.0ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"clients"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- SQL (2.4ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"clients"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- Client Load (1.1ms) SELECT "clients".* FROM "clients" WHERE ("clients"."app_id" = 'rnapp123') LIMIT 1
- SQL (1.5ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"access_grants"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- SQL (6.0ms) BEGIN
- SQL (2.0ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"access_grants"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- PK and serial sequence (3.4ms) SELECT attr.attname, seq.relname
- FROM pg_class seq,
- pg_attribute attr,
- pg_depend dep,
- pg_namespace name,
- pg_constraint cons
- WHERE seq.oid = dep.objid
- AND seq.relkind = 'S'
- AND attr.attrelid = dep.refobjid
- AND attr.attnum = dep.refobjsubid
- AND attr.attrelid = cons.conrelid
- AND attr.attnum = cons.conkey[1]
- AND cons.contype = 'p'
- AND dep.refobjid = '"access_grants"'::regclass
- SQL (4.0ms) INSERT INTO "access_grants" ("access_token_expires_at", "created_at", "refresh_token", "access_token", "client_id", "updated_at", "user_id", "code") VALUES (NULL, '2011-06-05 14:36:10.104168', '3ea7cf5d8c4e49e7955200e4f1c3fcec', '2382241e8c38df466f0913ee73ecd775', NULL, '2011-06-05 14:36:10.104168', 2, 'a559f79b441de39229979311a8c2c409') RETURNING "id"
- SQL (19.0ms) COMMIT
- Redirected to http://localhost:3001/auth/josh_id/callback?code=a559f79b441de39229979311a8c2c409&response_type=code
- Completed 302 Found in 235ms
- Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:10 -0700 2011
- Processing by AuthController#access_token as */*
- Parameters: {"code"=>"a559f79b441de39229979311a8c2c409", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
- Client Load (1.3ms) SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
- Completed 200 OK in 51ms (Views: 37.6ms | ActiveRecord: 1.3ms)
- Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:10 -0700 2011
- Processing by AuthController#user as JSON
- Parameters: {"access_token"=>""}
- Completed in 26ms
- Started GET "/auth/josh_id/authorize?scope=read&client_id=rnapp123&type=web_server&authorize_url=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fjosh_id%2Fauthorize&access_token_url=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fjosh_id%2Faccess_token&redirect_uri=http%3A%2F%2Flocalhost%3A3001%2Fauth%2Fjosh_id%2Fcallback" for 127.0.0.1 at Sun Jun 05 07:36:10 -0700 2011
- Processing by AuthController#authorize as HTML
- Parameters: {"scope"=>"read", "type"=>"web_server", "client_id"=>"rnapp123", "access_token_url"=>"http://localhost:3000/auth/josh_id/access_token", "authorize_url"=>"http://localhost:3000/auth/josh_id/authorize", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
- SQL (4.5ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"users"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- User Load (1.7ms) SELECT "users".* FROM "users" WHERE ("users"."id" = 2) LIMIT 1
- SQL (1.2ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"users"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- AREL (0.5ms) DELETE FROM "access_grants" WHERE (created_at < '2011-06-02 14:36:10.877558')
- SQL (5.7ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"clients"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- SQL (1.0ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"clients"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- Client Load (0.4ms) SELECT "clients".* FROM "clients" WHERE ("clients"."app_id" = 'rnapp123') LIMIT 1
- SQL (1.7ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"access_grants"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- SQL (8.2ms) BEGIN
- SQL (0.9ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"access_grants"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- PK and serial sequence (3.0ms) SELECT attr.attname, seq.relname
- FROM pg_class seq,
- pg_attribute attr,
- pg_depend dep,
- pg_namespace name,
- pg_constraint cons
- WHERE seq.oid = dep.objid
- AND seq.relkind = 'S'
- AND attr.attrelid = dep.refobjid
- AND attr.attnum = dep.refobjsubid
- AND attr.attrelid = cons.conrelid
- AND attr.attnum = cons.conkey[1]
- AND cons.contype = 'p'
- AND dep.refobjid = '"access_grants"'::regclass
- SQL (0.5ms) INSERT INTO "access_grants" ("code", "refresh_token", "access_token_expires_at", "updated_at", "created_at", "access_token", "user_id", "client_id") VALUES ('2cb194a2ebb3c4b22fd8a1eb107acc66', '60b351406682398ae32d62cf9f289d3d', NULL, '2011-06-05 14:36:10.926224', '2011-06-05 14:36:10.926224', '20d958ccc1b788ba408974ef1cc10eb8', 2, NULL) RETURNING "id"
- SQL (1.5ms) COMMIT
- Redirected to http://localhost:3001/auth/josh_id/callback?code=2cb194a2ebb3c4b22fd8a1eb107acc66&response_type=code
- Completed 302 Found in 134ms
- Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:12 -0700 2011
- Processing by AuthController#access_token as */*
- Parameters: {"code"=>"2cb194a2ebb3c4b22fd8a1eb107acc66", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
- Client Load (0.6ms) SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
- Completed 200 OK in 40ms (Views: 34.5ms | ActiveRecord: 0.6ms)
- Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:12 -0700 2011
- Processing by AuthController#user as JSON
- Parameters: {"access_token"=>""}
- Completed in 41ms
- Started GET "/auth/josh_id/authorize?scope=read&client_id=rnapp123&type=web_server&authorize_url=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fjosh_id%2Fauthorize&access_token_url=http%3A%2F%2Flocalhost%3A3000%2Fauth%2Fjosh_id%2Faccess_token&redirect_uri=http%3A%2F%2Flocalhost%3A3001%2Fauth%2Fjosh_id%2Fcallback" for 127.0.0.1 at Sun Jun 05 07:36:12 -0700 2011
- Processing by AuthController#authorize as HTML
- Parameters: {"scope"=>"read", "type"=>"web_server", "client_id"=>"rnapp123", "access_token_url"=>"http://localhost:3000/auth/josh_id/access_token", "authorize_url"=>"http://localhost:3000/auth/josh_id/authorize", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
- SQL (7.8ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"users"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- User Load (15.4ms) SELECT "users".* FROM "users" WHERE ("users"."id" = 2) LIMIT 1
- SQL (6.8ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"users"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- AREL (0.6ms) DELETE FROM "access_grants" WHERE (created_at < '2011-06-02 14:36:13.356461')
- SQL (0.9ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"clients"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- SQL (4.2ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"clients"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- Client Load (0.9ms) SELECT "clients".* FROM "clients" WHERE ("clients"."app_id" = 'rnapp123') LIMIT 1
- SQL (1.8ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"access_grants"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- SQL (0.6ms) BEGIN
- SQL (1.8ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
- FROM pg_attribute a LEFT JOIN pg_attrdef d
- ON a.attrelid = d.adrelid AND a.attnum = d.adnum
- WHERE a.attrelid = '"access_grants"'::regclass
- AND a.attnum > 0 AND NOT a.attisdropped
- ORDER BY a.attnum
- PK and serial sequence (10.0ms) SELECT attr.attname, seq.relname
- FROM pg_class seq,
- pg_attribute attr,
- pg_depend dep,
- pg_namespace name,
- pg_constraint cons
- WHERE seq.oid = dep.objid
- AND seq.relkind = 'S'
- AND attr.attrelid = dep.refobjid
- AND attr.attnum = dep.refobjsubid
- AND attr.attrelid = cons.conrelid
- AND attr.attnum = cons.conkey[1]
- AND cons.contype = 'p'
- AND dep.refobjid = '"access_grants"'::regclass
- SQL (4.8ms) INSERT INTO "access_grants" ("code", "access_token", "access_token_expires_at", "client_id", "updated_at", "created_at", "user_id", "refresh_token") VALUES ('e2a28de7845259faaeca5c733a8aaa07', '1f1a7520d0afb46bcd8daf53ce7b5bb3', NULL, NULL, '2011-06-05 14:36:13.568335', '2011-06-05 14:36:13.568335', 2, '33b01a15171126737acf261aac16c5ba') RETURNING "id"
- SQL (1.2ms) COMMIT
- Redirected to http://localhost:3001/auth/josh_id/callback?code=e2a28de7845259faaeca5c733a8aaa07&response_type=code
- Completed 302 Found in 636ms
- Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:13 -0700 2011
- Processing by AuthController#access_token as */*
- Parameters: {"code"=>"e2a28de7845259faaeca5c733a8aaa07", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
- Client Load (17.3ms) SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
- Completed 200 OK in 47ms (Views: 13.9ms | ActiveRecord: 17.3ms)
- Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:13 -0700 2011
- Processing by AuthController#user as JSON
- Parameters: {"access_token"=>""}
- Completed in 42ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement