{"action":"created","issue":{"url":"https://api.github.com/repos/gogits/gogs/issues/2615","repository_url":"https://api.github.com/repos/gogits/gogs","labels_url":"https://api.github.com/repos/gogits/gogs/issues/2615/labels{/name}","comments_url":"https://api.github.com/repos/gogits/gogs/issues/2615/comments","events_url":"https://api.github.com/repos/gogits/gogs/issues/2615/events","html_url":"https://github.com/gogits/gogs/issues/2615","id":133373924,"number":2615,"title":"Cannot recognize MySQL password correctly when contains ';'","user":{"login":"IaBurton","id":4121211,"avatar_url":"https://avatars.githubusercontent.com/u/4121211?v=3","gravatar_id":"","url":"https://api.github.com/users/IaBurton","html_url":"https://github.com/IaBurton","followers_url":"https://api.github.com/users/IaBurton/followers","following_url":"https://api.github.com/users/IaBurton/following{/other_user}","gists_url":"https://api.github.com/users/IaBurton/gists{/gist_id}","starred_url":"https://api.github.com/users/IaBurton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IaBurton/subscriptions","organizations_url":"https://api.github.com/users/IaBurton/orgs","repos_url":"https://api.github.com/users/IaBurton/repos","events_url":"https://api.github.com/users/IaBurton/events{/privacy}","received_events_url":"https://api.github.com/users/IaBurton/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/gogits/gogs/labels/documentation","name":"documentation","color":"207de5"},{"url":"https://api.github.com/repos/gogits/gogs/labels/feedback%20needed","name":"feedback needed","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/gogits/gogs/milestones/9","html_url":"https://github.com/gogits/gogs/milestones/0.9.0","labels_url":"https://api.github.com/repos/gogits/gogs/milestones/9/labels","id":1226114,"number":9,"title":"0.9.0","description":"","creator":{"login":"Unknwon","id":2946214,"avatar_url":"https://avatars.githubusercontent.com/u/2946214?v=3","gravatar_id":"","url":"https://api.github.com/users/Unknwon","html_url":"https://github.com/Unknwon","followers_url":"https://api.github.com/users/Unknwon/followers","following_url":"https://api.github.com/users/Unknwon/following{/other_user}","gists_url":"https://api.github.com/users/Unknwon/gists{/gist_id}","starred_url":"https://api.github.com/users/Unknwon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Unknwon/subscriptions","organizations_url":"https://api.github.com/users/Unknwon/orgs","repos_url":"https://api.github.com/users/Unknwon/repos","events_url":"https://api.github.com/users/Unknwon/events{/privacy}","received_events_url":"https://api.github.com/users/Unknwon/received_events","type":"User","site_admin":false},"open_issues":36,"closed_issues":170,"state":"open","created_at":"2015-07-26T11:28:23Z","updated_at":"2016-02-13T02:00:09Z","due_on":null,"closed_at":null},"comments":37,"created_at":"2016-02-13T00:02:32Z","updated_at":"2016-02-13T05:08:26Z","closed_at":null,"body":"Hello,\r\n\r\nI seem to be running into an issue when trying to upgrade from Gogs version 0.7.22 to any newer version (I've tried 0.7.33, 0.8 and 0.8.25). The machine is a Centos 6 box with MySQL 5.1.69 and Git version 1.8.3.1\r\n\r\n```\r\n2016/02/12 15:28:09 [T] Custom path: /asc/array1/gogs/gogs/custom\r\n2016/02/12 15:28:09 [T] Log path: /asc/array1/gogs/gogs/log\r\n2016/02/12 15:28:09 [I] Gogs: Go Git Service 0.8.25.0129\r\n2016/02/12 15:28:09 [I] Log Mode: File(Info)\r\n2016/02/12 15:28:09 [I] Cache Service Enabled\r\n2016/02/12 15:28:09 [I] Session Service Enabled\r\n2016/02/12 15:28:09 [I] Git Version: 1.8.3.1\r\n2016/02/12 15:28:09 [...s/routers/install.go:70 GlobalInit()] [E] Fail to initialize ORM engine: migrate: sync: Error 1045: Access denied for user 'root'@'localhost' (using password: YES)\r\n```\r\n\r\nThe mysql password hasn't changed (and I can log into mysql with the password fine), but everytime I try to upgrade I get this access denied error. When reverting back to 0.7.22 (without changing anything in the app.ini) it works fine. Could something have changed between 0.7.22 and above for gogs or xorm that could be causing this?\r\n\r\nI took a look at issue #385 about old mysql passwords, and while our password didn't match that case I wen't ahead with the solution anyways and it didn't fix it.\r\n\r\nI also noticed this on the Troubleshooting page in the comments, not sure if its related, but there was no answer \r\n![gogs](https://cloud.githubusercontent.com/assets/4121211/13023718/593c3324-d1a0-11e5-9604-9a8505b0ae79.png)\r\n\r\nUnfortunately when I enabled general logging for our mysql server I still couldn't see any issue. Finally I decided to ditch mysql for sqlite (should have done this to begin with) using some tools to dump the mysql database into a sqlite3 one and point gogs at that instead\r\n\r\n```\r\n[database]\r\n;DB_TYPE = mysql\r\n;HOST = 127.0.0.1:3306\r\n;NAME = gogs\r\n;USER = root\r\n;PASSWD = **********\r\n;SSL_MODE = disable\r\nDB_TYPE = sqlite3\r\nPATH = data/gogs.db\r\n```\r\n\r\nbut when I do that I get this\r\n\r\n`2016/02/12 13:04:16 [T] Custom path: /asc/array1/gogs/gogs/custom\r\n2016/02/12 13:04:16 [T] Log path: /asc/array1/gogs/gogs/log\r\n2016/02/12 13:04:16 [I] Gogs: Go Git Service 0.8.25.0129\r\n2016/02/12 13:04:16 [I] Log Mode: File(Info)\r\n2016/02/12 13:04:16 [I] Cache Service Enabled\r\n2016/02/12 13:04:16 [I] Session Service Enabled\r\n2016/02/12 13:04:16 [I] Git Version: 1.8.3.1\r\n2016/02/12 13:04:16 [...s/routers/install.go:70 GlobalInit()] [E] Fail to initialize ORM engine: migrate: sync: duplicate column name: id`\r\n\r\nAnyways, hope we can figure this out, Gogs has been awesome so far and while I don't care so much about mysql vs sqlite3, it is important I can upgrade without losing my data :smile: thank you"},"comment":{"url":"https://api.github.com/repos/gogits/gogs/issues/comments/183589357","html_url":"https://github.com/gogits/gogs/issues/2615#issuecomment-183589357","issue_url":"https://api.github.com/repos/gogits/gogs/issues/2615","id":183589357,"user":{"login":"Unknwon","id":2946214,"avatar_url":"https://avatars.githubusercontent.com/u/2946214?v=3","gravatar_id":"","url":"https://api.github.com/users/Unknwon","html_url":"https://github.com/Unknwon","followers_url":"https://api.github.com/users/Unknwon/followers","following_url":"https://api.github.com/users/Unknwon/following{/other_user}","gists_url":"https://api.github.com/users/Unknwon/gists{/gist_id}","starred_url":"https://api.github.com/users/Unknwon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Unknwon/subscriptions","organizations_url":"https://api.github.com/users/Unknwon/orgs","repos_url":"https://api.github.com/users/Unknwon/repos","events_url":"https://api.github.com/users/Unknwon/events{/privacy}","received_events_url":"https://api.github.com/users/Unknwon/received_events","type":"User","site_admin":false},"created_at":"2016-02-13T05:08:26Z","updated_at":"2016-02-13T05:08:26Z","body":"@IaBurton thanks for your support along the way, hope upgrade is smooth except this password problem  :trollface:"}}