{"action":"created","issue":{"url":"https://api.github.com/repos/mattermost/platform/issues/1541","labels_url":"https://api.github.com/repos/mattermost/platform/issues/1541/labels{/name}","comments_url":"https://api.github.com/repos/mattermost/platform/issues/1541/comments","events_url":"https://api.github.com/repos/mattermost/platform/issues/1541/events","html_url":"https://github.com/mattermost/platform/issues/1541","id":119328168,"number":1541,"title":"Can't use special character in password in the DataSource property","user":{"login":"renannprado","id":2359543,"avatar_url":"https://avatars.githubusercontent.com/u/2359543?v=3","gravatar_id":"","url":"https://api.github.com/users/renannprado","html_url":"https://github.com/renannprado","followers_url":"https://api.github.com/users/renannprado/followers","following_url":"https://api.github.com/users/renannprado/following{/other_user}","gists_url":"https://api.github.com/users/renannprado/gists{/gist_id}","starred_url":"https://api.github.com/users/renannprado/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renannprado/subscriptions","organizations_url":"https://api.github.com/users/renannprado/orgs","repos_url":"https://api.github.com/users/renannprado/repos","events_url":"https://api.github.com/users/renannprado/events{/privacy}","received_events_url":"https://api.github.com/users/renannprado/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-11-29T01:11:46Z","updated_at":"2016-01-26T04:50:50Z","closed_at":null,"body":"I tried the below string (password was a bit different)    \r\n\r\n    \"DataSource\": \"postgres://mmuser:*$fh3@#@127.0.0.1:5432/mattermost?sslmode=disable&connect_timeout=10\",\r\n\r\nIt only started to work when I changed to a password containing only letters and numbers\r\nI know that the @ character is used to tell ip/port and so on. But after some research, I couldn't find a way to escape the password so it could contain pretty much anything.\r\nI wonder if it is a limitation of the connection string parser API or mattermost itself.\r\n\r\nError log:\r\n\r\n```\r\n[11/28/15 19:55:06] [CRIT] Failed to ping db err:dial tcp: unknown port tcp/'*\r\npanic: Failed to open sql connection dial tcp: unknown port tcp/'*\r\n\r\ngoroutine 1 [running]:\r\ngithub.com/mattermost/platform/store.setupConnection(0xb89090, 0x6, 0xc20800bcd8, 0x8, 0xc208052120, 0x59, 0xa, 0xa, 0x0, 0x1)\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/store/sql_store.go:178 +0x581\r\ngithub.com/mattermost/platform/store.NewSqlStore(0x0, 0x0)\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/store/sql_store.go:59 +0x109\r\ngithub.com/mattermost/platform/api.NewServer()\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/api/server.go:33 +0x15a\r\nmain.main()\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/mattermost.go:55 +0x4d8\r\n\r\ngoroutine 8 [select]:\r\ncode.google.com/p/log4go.func·002()\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/Godeps/_workspace/src/code.google.com/p/log4go/filelog.go:84 +0xa53\r\ncreated by code.google.com/p/log4go.NewFileLogWriter\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/Godeps/_workspace/src/code.google.com/p/log4go/filelog.go:116 +0x3da\r\n\r\ngoroutine 6 [syscall]:\r\nos/signal.loop()\r\n\t/usr/local/go/src/os/signal/signal_unix.go:21 +0x1f\r\ncreated by os/signal.init·1\r\n\t/usr/local/go/src/os/signal/signal_unix.go:27 +0x35\r\n\r\ngoroutine 7 [chan receive]:\r\ncode.google.com/p/log4go.ConsoleLogWriter.run(0xc208052240, 0x7f0fdc26a030, 0xc20802a008)\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/Godeps/_workspace/src/code.google.com/p/log4go/termlog.go:27 +0x7a\r\ncreated by code.google.com/p/log4go.NewConsoleLogWriter\r\n\t/home/travis/gopath/src/github.com/mattermost/platform/Godeps/_workspace/src/code.google.com/p/log4go/termlog.go:19 +0x6b\r\n\r\ngoroutine 9 [chan receive]:\r\ndatabase/sql.(*DB).connectionOpener(0xc20803b5e0)\r\n\t/usr/local/go/src/database/sql/sql.go:589 +0x4c\r\ncreated by database/sql.Open\r\n\t/usr/local/go/src/database/sql/sql.go:452 +0x31c\r\n\r\ngoroutine 17 [syscall, locked to thread]:\r\nruntime.goexit()\r\n\t/usr/local/go/src/runtime/asm_amd64.s:2232 +0x1\r\n```"},"comment":{"url":"https://api.github.com/repos/mattermost/platform/issues/comments/174823962","html_url":"https://github.com/mattermost/platform/issues/1541#issuecomment-174823962","issue_url":"https://api.github.com/repos/mattermost/platform/issues/1541","id":174823962,"user":{"login":"renannprado","id":2359543,"avatar_url":"https://avatars.githubusercontent.com/u/2359543?v=3","gravatar_id":"","url":"https://api.github.com/users/renannprado","html_url":"https://github.com/renannprado","followers_url":"https://api.github.com/users/renannprado/followers","following_url":"https://api.github.com/users/renannprado/following{/other_user}","gists_url":"https://api.github.com/users/renannprado/gists{/gist_id}","starred_url":"https://api.github.com/users/renannprado/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renannprado/subscriptions","organizations_url":"https://api.github.com/users/renannprado/orgs","repos_url":"https://api.github.com/users/renannprado/repos","events_url":"https://api.github.com/users/renannprado/events{/privacy}","received_events_url":"https://api.github.com/users/renannprado/received_events","type":"User","site_admin":false},"created_at":"2016-01-26T04:50:49Z","updated_at":"2016-01-26T04:50:49Z","body":"Newer versions of go-sql-driver/mysql don't have this issue. I've just tried with mattermost 1.4 and it worked. You can close this."}}