{"action":"created","issue":{"url":"https://api.github.com/repos/theory/uri-db/issues/7","labels_url":"https://api.github.com/repos/theory/uri-db/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/theory/uri-db/issues/7/comments","events_url":"https://api.github.com/repos/theory/uri-db/issues/7/events","html_url":"https://github.com/theory/uri-db/issues/7","id":105417893,"number":7,"title":"Incorrect parsing of # sign","user":{"login":"rzane","id":2731572,"avatar_url":"https://avatars.githubusercontent.com/u/2731572?v=3","gravatar_id":"","url":"https://api.github.com/users/rzane","html_url":"https://github.com/rzane","followers_url":"https://api.github.com/users/rzane/followers","following_url":"https://api.github.com/users/rzane/following{/other_user}","gists_url":"https://api.github.com/users/rzane/gists{/gist_id}","starred_url":"https://api.github.com/users/rzane/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rzane/subscriptions","organizations_url":"https://api.github.com/users/rzane/orgs","repos_url":"https://api.github.com/users/rzane/repos","events_url":"https://api.github.com/users/rzane/events{/privacy}","received_events_url":"https://api.github.com/users/rzane/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-09-08T16:23:27Z","updated_at":"2015-09-08T16:27:17Z","closed_at":"2015-09-08T16:27:17Z","body":"I posted in the sqitch-users group regarding an issue I was facing. I believe the behavior I was encountering was caused by a bug in uri-db.\r\n\r\nTake this example script:\r\n```perl\r\n#!/usr/bin/perl\r\nuse URI::db;\r\nmy $uri = URI::db->new(shift);\r\nmy $format = \"Host: %s\\nDatabase: %s\\nUser: %s\\nPass: %s\\n\";\r\nprintf $format, $uri->host, $uri->dbname, $uri->user, $uri->password;\r\n```\r\n\r\nIt works:\r\n\r\n```\r\n$ ./uri.pl db:firebird://sysdba:masterkey@myhost.com//path/to/db.fdb\r\nHost: myhost.com\r\nDatabase: C:/path/to/database.fdb\r\nUser: sysdba\r\nPass: masterkey\r\n```\r\n\r\nNow, say, for example, that my password includes a pound sign:\r\n\r\n```\r\n$ ./uri.pl db:firebird://sysdba:maste#rkey@myhost.com//path/to/db.fdb\r\nHost: sysdba:maste\r\nDatabase:\r\nUser:\r\nPass:\r\n```\r\n\r\nUnless there is a way to escape the pound sign, this seems to be unexpected behavior."},"comment":{"url":"https://api.github.com/repos/theory/uri-db/issues/comments/138621779","html_url":"https://github.com/theory/uri-db/issues/7#issuecomment-138621779","issue_url":"https://api.github.com/repos/theory/uri-db/issues/7","id":138621779,"user":{"login":"theory","id":46604,"avatar_url":"https://avatars.githubusercontent.com/u/46604?v=3","gravatar_id":"","url":"https://api.github.com/users/theory","html_url":"https://github.com/theory","followers_url":"https://api.github.com/users/theory/followers","following_url":"https://api.github.com/users/theory/following{/other_user}","gists_url":"https://api.github.com/users/theory/gists{/gist_id}","starred_url":"https://api.github.com/users/theory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theory/subscriptions","organizations_url":"https://api.github.com/users/theory/orgs","repos_url":"https://api.github.com/users/theory/repos","events_url":"https://api.github.com/users/theory/events{/privacy}","received_events_url":"https://api.github.com/users/theory/received_events","type":"User","site_admin":false},"created_at":"2015-09-08T16:27:17Z","updated_at":"2015-09-08T16:27:17Z","body":"It's a URI. You'll need to URI-escape it.\r\n\r\n    > perl -MURI -E 'say URI->new(shift)->password' db:firebird://sysdba:mast%23key@myhost.com/c:\\\\path\\\\to\\\\database.fdb\r\n    mast#key\r\n"}}