Guest User

Untitled

a guest
Jun 5th, 2011
160
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