SHARE
TWEET

Untitled

a guest Jun 5th, 2011 111 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:07 -0700 2011
  2.   Processing by AuthController#access_token as */*
  3.   Parameters: {"code"=>"a96819da99d601e69a7ab5650aa87f40", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
  4.   Client Load (1.0ms)  SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
  5. Completed 200 OK in 1072ms (Views: 628.2ms | ActiveRecord: 1.0ms)
  6.  
  7.  
  8. Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:09 -0700 2011
  9.   Processing by AuthController#user as JSON
  10.   Parameters: {"access_token"=>""}
  11. Completed   in 15ms
  12.  
  13.  
  14. 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
  15.   Processing by AuthController#authorize as HTML
  16.   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"}
  17.   SQL (8.2ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  18.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  19.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  20.  WHERE a.attrelid = '"users"'::regclass
  21.  AND a.attnum > 0 AND NOT a.attisdropped
  22.  ORDER BY a.attnum
  23.   User Load (0.6ms)  SELECT "users".* FROM "users" WHERE ("users"."id" = 2) LIMIT 1
  24.   SQL (5.1ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  25.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  26.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  27.  WHERE a.attrelid = '"users"'::regclass
  28.  AND a.attnum > 0 AND NOT a.attisdropped
  29.  ORDER BY a.attnum
  30.   AREL (8.6ms)  DELETE FROM "access_grants" WHERE (created_at < '2011-06-02 14:36:10.031059')
  31.   SQL (8.0ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  32.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  33.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  34.  WHERE a.attrelid = '"clients"'::regclass
  35.  AND a.attnum > 0 AND NOT a.attisdropped
  36.  ORDER BY a.attnum
  37.   SQL (2.4ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  38.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  39.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  40.  WHERE a.attrelid = '"clients"'::regclass
  41.  AND a.attnum > 0 AND NOT a.attisdropped
  42.  ORDER BY a.attnum
  43.  
  44.   Client Load (1.1ms)  SELECT "clients".* FROM "clients" WHERE ("clients"."app_id" = 'rnapp123') LIMIT 1
  45.   SQL (1.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  46.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  47.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  48.  WHERE a.attrelid = '"access_grants"'::regclass
  49.  AND a.attnum > 0 AND NOT a.attisdropped
  50.  ORDER BY a.attnum
  51.  
  52.   SQL (6.0ms)  BEGIN
  53.   SQL (2.0ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  54.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  55.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  56.  WHERE a.attrelid = '"access_grants"'::regclass
  57.  AND a.attnum > 0 AND NOT a.attisdropped
  58.  ORDER BY a.attnum
  59.  
  60.   PK and serial sequence (3.4ms)   SELECT attr.attname, seq.relname
  61.  FROM pg_class seq,
  62.  pg_attribute attr,
  63.  pg_depend dep,
  64.  pg_namespace name,
  65.  pg_constraint cons
  66.  WHERE seq.oid = dep.objid
  67.  AND seq.relkind = 'S'
  68.  AND attr.attrelid = dep.refobjid
  69.  AND attr.attnum = dep.refobjsubid
  70.  AND attr.attrelid = cons.conrelid
  71.  AND attr.attnum = cons.conkey[1]
  72.  AND cons.contype = 'p'
  73.  AND dep.refobjid = '"access_grants"'::regclass
  74.   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"
  75.   SQL (19.0ms)  COMMIT
  76. Redirected to http://localhost:3001/auth/josh_id/callback?code=a559f79b441de39229979311a8c2c409&response_type=code
  77. Completed 302 Found in 235ms
  78.  
  79.  
  80. Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:10 -0700 2011
  81.   Processing by AuthController#access_token as */*
  82.   Parameters: {"code"=>"a559f79b441de39229979311a8c2c409", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
  83.   Client Load (1.3ms)  SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
  84. Completed 200 OK in 51ms (Views: 37.6ms | ActiveRecord: 1.3ms)
  85.  
  86.  
  87. Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:10 -0700 2011
  88.   Processing by AuthController#user as JSON
  89.   Parameters: {"access_token"=>""}
  90. Completed   in 26ms
  91.  
  92.  
  93. 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
  94.   Processing by AuthController#authorize as HTML
  95.   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"}
  96.   SQL (4.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  97.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  98.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  99.  WHERE a.attrelid = '"users"'::regclass
  100.  AND a.attnum > 0 AND NOT a.attisdropped
  101.  ORDER BY a.attnum
  102.   User Load (1.7ms)  SELECT "users".* FROM "users" WHERE ("users"."id" = 2) LIMIT 1
  103.   SQL (1.2ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  104.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  105.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  106.  WHERE a.attrelid = '"users"'::regclass
  107.  AND a.attnum > 0 AND NOT a.attisdropped
  108.  ORDER BY a.attnum
  109.   AREL (0.5ms)  DELETE FROM "access_grants" WHERE (created_at < '2011-06-02 14:36:10.877558')
  110.   SQL (5.7ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  111.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  112.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  113.  WHERE a.attrelid = '"clients"'::regclass
  114.  AND a.attnum > 0 AND NOT a.attisdropped
  115.  ORDER BY a.attnum
  116.   SQL (1.0ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  117.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  118.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  119.  WHERE a.attrelid = '"clients"'::regclass
  120.  AND a.attnum > 0 AND NOT a.attisdropped
  121.  ORDER BY a.attnum
  122.  
  123.   Client Load (0.4ms)  SELECT "clients".* FROM "clients" WHERE ("clients"."app_id" = 'rnapp123') LIMIT 1
  124.   SQL (1.7ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  125.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  126.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  127.  WHERE a.attrelid = '"access_grants"'::regclass
  128.  AND a.attnum > 0 AND NOT a.attisdropped
  129.  ORDER BY a.attnum
  130.  
  131.   SQL (8.2ms)  BEGIN
  132.   SQL (0.9ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  133.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  134.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  135.  WHERE a.attrelid = '"access_grants"'::regclass
  136.  AND a.attnum > 0 AND NOT a.attisdropped
  137.  ORDER BY a.attnum
  138.  
  139.   PK and serial sequence (3.0ms)   SELECT attr.attname, seq.relname
  140.  FROM pg_class seq,
  141.  pg_attribute attr,
  142.  pg_depend dep,
  143.  pg_namespace name,
  144.  pg_constraint cons
  145.  WHERE seq.oid = dep.objid
  146.  AND seq.relkind = 'S'
  147.  AND attr.attrelid = dep.refobjid
  148.  AND attr.attnum = dep.refobjsubid
  149.  AND attr.attrelid = cons.conrelid
  150.  AND attr.attnum = cons.conkey[1]
  151.  AND cons.contype = 'p'
  152.  AND dep.refobjid = '"access_grants"'::regclass
  153.   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"
  154.   SQL (1.5ms)  COMMIT
  155. Redirected to http://localhost:3001/auth/josh_id/callback?code=2cb194a2ebb3c4b22fd8a1eb107acc66&response_type=code
  156. Completed 302 Found in 134ms
  157.  
  158.  
  159. Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:12 -0700 2011
  160.   Processing by AuthController#access_token as */*
  161.   Parameters: {"code"=>"2cb194a2ebb3c4b22fd8a1eb107acc66", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
  162.   Client Load (0.6ms)  SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
  163. Completed 200 OK in 40ms (Views: 34.5ms | ActiveRecord: 0.6ms)
  164.  
  165.  
  166. Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:12 -0700 2011
  167.   Processing by AuthController#user as JSON
  168.   Parameters: {"access_token"=>""}
  169. Completed   in 41ms
  170.  
  171.  
  172. 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
  173.   Processing by AuthController#authorize as HTML
  174.   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"}
  175.   SQL (7.8ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  176.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  177.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  178.  WHERE a.attrelid = '"users"'::regclass
  179.  AND a.attnum > 0 AND NOT a.attisdropped
  180.  ORDER BY a.attnum
  181.   User Load (15.4ms)  SELECT "users".* FROM "users" WHERE ("users"."id" = 2) LIMIT 1
  182.   SQL (6.8ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  183.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  184.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  185.  WHERE a.attrelid = '"users"'::regclass
  186.  AND a.attnum > 0 AND NOT a.attisdropped
  187.  ORDER BY a.attnum
  188.   AREL (0.6ms)  DELETE FROM "access_grants" WHERE (created_at < '2011-06-02 14:36:13.356461')
  189.   SQL (0.9ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  190.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  191.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  192.  WHERE a.attrelid = '"clients"'::regclass
  193.  AND a.attnum > 0 AND NOT a.attisdropped
  194.  ORDER BY a.attnum
  195.   SQL (4.2ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  196.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  197.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  198.  WHERE a.attrelid = '"clients"'::regclass
  199.  AND a.attnum > 0 AND NOT a.attisdropped
  200.  ORDER BY a.attnum
  201.  
  202.   Client Load (0.9ms)  SELECT "clients".* FROM "clients" WHERE ("clients"."app_id" = 'rnapp123') LIMIT 1
  203.   SQL (1.8ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  204.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  205.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  206.  WHERE a.attrelid = '"access_grants"'::regclass
  207.  AND a.attnum > 0 AND NOT a.attisdropped
  208.  ORDER BY a.attnum
  209.  
  210.   SQL (0.6ms)  BEGIN
  211.   SQL (1.8ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
  212.  FROM pg_attribute a LEFT JOIN pg_attrdef d
  213.  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
  214.  WHERE a.attrelid = '"access_grants"'::regclass
  215.  AND a.attnum > 0 AND NOT a.attisdropped
  216.  ORDER BY a.attnum
  217.  
  218.   PK and serial sequence (10.0ms)   SELECT attr.attname, seq.relname
  219.  FROM pg_class seq,
  220.  pg_attribute attr,
  221.  pg_depend dep,
  222.  pg_namespace name,
  223.  pg_constraint cons
  224.  WHERE seq.oid = dep.objid
  225.  AND seq.relkind = 'S'
  226.  AND attr.attrelid = dep.refobjid
  227.  AND attr.attnum = dep.refobjsubid
  228.  AND attr.attrelid = cons.conrelid
  229.  AND attr.attnum = cons.conkey[1]
  230.  AND cons.contype = 'p'
  231.  AND dep.refobjid = '"access_grants"'::regclass
  232.   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"
  233.   SQL (1.2ms)  COMMIT
  234. Redirected to http://localhost:3001/auth/josh_id/callback?code=e2a28de7845259faaeca5c733a8aaa07&response_type=code
  235. Completed 302 Found in 636ms
  236.  
  237.  
  238. Started POST "/auth/josh_id/access_token" for 127.0.0.1 at Sun Jun 05 07:36:13 -0700 2011
  239.   Processing by AuthController#access_token as */*
  240.   Parameters: {"code"=>"e2a28de7845259faaeca5c733a8aaa07", "client_id"=>"rnapp123", "client_secret"=>"sussi", "type"=>"web_server", "redirect_uri"=>"http://localhost:3001/auth/josh_id/callback"}
  241.   Client Load (17.3ms)  SELECT "clients".* FROM "clients" WHERE (app_id = 'rnapp123' AND app_secret = 'sussi') LIMIT 1
  242. Completed 200 OK in 47ms (Views: 13.9ms | ActiveRecord: 17.3ms)
  243.  
  244.  
  245. Started GET "/auth/josh_id/user.json?access_token=" for 127.0.0.1 at Sun Jun 05 07:36:13 -0700 2011
  246.   Processing by AuthController#user as JSON
  247.   Parameters: {"access_token"=>""}
  248. Completed   in 42ms
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top