Skip to content

Instantly share code, notes, and snippets.

@donpdonp
Created November 3, 2010 19:56
Show Gist options
  • Save donpdonp/661610 to your computer and use it in GitHub Desktop.
Save donpdonp/661610 to your computer and use it in GitHub Desktop.
## Development laptop sqlite, correct server_url & secret
INSERT INTO "open_id_associations" ("server_url", ...
VALUES('http://www.myopenid.com/server', '
>> Association
=> Association(id: integer, server_url: binary, handle: string, secret: binary, issued: integer, lifetime: integer, assoc_type: string)
>> Association.last
=> #<Association id: 30,
server_url: "http://www.myopenid.com/server",
handle: "{HMAC-SHA1}{4cd1bdfa}{5iWn2Q==}", secret: "\224��䞈�5�\273d\215\224\377т#\217\001", issued: 1288814075, lifetime: 1209600, assoc_type: "HMAC-SHA1">
## Production postgresql with same code and same server_url stores an incorrect server_url
>> Association
=> Association(id: integer, server_url: binary, handle: string, secret: binary, issued: integer, lifetime: integer, assoc_type: string)
INSERT INTO "open_id_associations" ("server_url", ...
VALUES(E'\\x687474703a2f2f7777772e6d796f70656e69642e636f6d2f736572766572',
>> Association.last
=> #<Association id: 659,
server_url: "\\x687474703a2f2f7777772e6d796f70656e69642e636f6d2f7...",
handle: "{HMAC-SHA1}{4cd1be09}{ZgTIGQ==}", secret: "\\x3b9a95b5318ac21441af825d315538c8f59c6f7c", issued: 1288814089, lifetime: 1209600, assoc_type: "HMAC-SHA1">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment