{"action":"closed","issue":{"url":"https://api.github.com/repos/processone/ejabberd/issues/537","labels_url":"https://api.github.com/repos/processone/ejabberd/issues/537/labels{/name}","comments_url":"https://api.github.com/repos/processone/ejabberd/issues/537/comments","events_url":"https://api.github.com/repos/processone/ejabberd/issues/537/events","html_url":"https://github.com/processone/ejabberd/issues/537","id":69539091,"number":537,"title":" auth_method: odbc got error - position 2: did not find expected key","user":{"login":"dongmai","id":3855966,"avatar_url":"https://avatars.githubusercontent.com/u/3855966?v=3","gravatar_id":"","url":"https://api.github.com/users/dongmai","html_url":"https://github.com/dongmai","followers_url":"https://api.github.com/users/dongmai/followers","following_url":"https://api.github.com/users/dongmai/following{/other_user}","gists_url":"https://api.github.com/users/dongmai/gists{/gist_id}","starred_url":"https://api.github.com/users/dongmai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dongmai/subscriptions","organizations_url":"https://api.github.com/users/dongmai/orgs","repos_url":"https://api.github.com/users/dongmai/repos","events_url":"https://api.github.com/users/dongmai/events{/privacy}","received_events_url":"https://api.github.com/users/dongmai/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/processone/ejabberd/labels/Component:Build","name":"Component:Build","color":"bfdadc"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2015-04-20T08:50:08Z","updated_at":"2015-04-20T18:19:35Z","closed_at":"2015-04-20T18:19:35Z","body":"Hi Ejabberd team,\r\nCurrently I am facing this problem when trying to config to use MySQL. My config file as bellow (just the mysql config)\r\n\r\nauth_method: odbc\r\nodbc_type: mysql\r\nodbc_server: \"localhost\"\r\nodbc_database: \"database\"\r\nodbc_username: \"username\"\r\nodbc_password: \"password\"\r\n\r\nAfter do some google searches I found out that I need to have to enable odbc module by the command line: ./configure --enable-odbc (it runs OK).\r\nBut when I try to restart ejabberd I still get this error: Syntax error on line 250 at position 2: did not find expected key. Line 250 is auth_method: odbc.\r\n\r\nCan anyone help to resolve this.\r\nThanks.\r\n"}}