{"action":"created","issue":{"url":"https://api.github.com/repos/processone/ejabberd/issues/796","labels_url":"https://api.github.com/repos/processone/ejabberd/issues/796/labels{/name}","comments_url":"https://api.github.com/repos/processone/ejabberd/issues/796/comments","events_url":"https://api.github.com/repos/processone/ejabberd/issues/796/events","html_url":"https://github.com/processone/ejabberd/issues/796","id":113741683,"number":796,"title":"ejabberd odbc error in module ejabberd_auth_odbc","user":{"login":"harshsuri","id":5026685,"avatar_url":"https://avatars.githubusercontent.com/u/5026685?v=3","gravatar_id":"","url":"https://api.github.com/users/harshsuri","html_url":"https://github.com/harshsuri","followers_url":"https://api.github.com/users/harshsuri/followers","following_url":"https://api.github.com/users/harshsuri/following{/other_user}","gists_url":"https://api.github.com/users/harshsuri/gists{/gist_id}","starred_url":"https://api.github.com/users/harshsuri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harshsuri/subscriptions","organizations_url":"https://api.github.com/users/harshsuri/orgs","repos_url":"https://api.github.com/users/harshsuri/repos","events_url":"https://api.github.com/users/harshsuri/events{/privacy}","received_events_url":"https://api.github.com/users/harshsuri/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-10-28T04:36:27Z","updated_at":"2015-10-28T13:38:49Z","closed_at":null,"body":"I have the following configuration\r\n* Ubuntu 14.04 *(OS)*\r\n* erl/otp 18.1\r\n* ejabberd 15.09.48\r\n* UnixODBC 2.3.4 *(ODBC)*\r\n* FreeTDS 0.95 *(driver)*\r\n* Azure SQL *(backend)*\r\n\r\nSituation: \r\n1. `osql` test works fine\r\n2. odbc connection and queries run fine in the `erl` shell\r\n3. odbc connection and queries run fine in the `ejabberdctl live` mode\r\n\r\nBut for a running server, I get the following error if I try to connect any user from a client:\r\n\r\n```ejabberd_auth:is_user_exists:316 The authentication module ejabberd_auth_odbc returned an error\r\nwhen checking user <<\"xxxxx\">> in server <<\"xmpp.xxxx.xxx\">>\r\nError message: {aborted,{no_exists,[sql_pool,<<\"xmpp.xxxx.xxx\">>]}}```\r\n\r\nAny ideas?  What am I doing wrong or is it a bug somewhere?\r\n\r\nI configured the ejabberd using `./configure --enable-odbc`"},"comment":{"url":"https://api.github.com/repos/processone/ejabberd/issues/comments/151847086","html_url":"https://github.com/processone/ejabberd/issues/796#issuecomment-151847086","issue_url":"https://api.github.com/repos/processone/ejabberd/issues/796","id":151847086,"user":{"login":"harshsuri","id":5026685,"avatar_url":"https://avatars.githubusercontent.com/u/5026685?v=3","gravatar_id":"","url":"https://api.github.com/users/harshsuri","html_url":"https://github.com/harshsuri","followers_url":"https://api.github.com/users/harshsuri/followers","following_url":"https://api.github.com/users/harshsuri/following{/other_user}","gists_url":"https://api.github.com/users/harshsuri/gists{/gist_id}","starred_url":"https://api.github.com/users/harshsuri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harshsuri/subscriptions","organizations_url":"https://api.github.com/users/harshsuri/orgs","repos_url":"https://api.github.com/users/harshsuri/repos","events_url":"https://api.github.com/users/harshsuri/events{/privacy}","received_events_url":"https://api.github.com/users/harshsuri/received_events","type":"User","site_admin":false},"created_at":"2015-10-28T13:38:49Z","updated_at":"2015-10-28T13:38:49Z","body":"No,  that is just a placeholder.  The configuration  works perfectly if I test is using osql, or even  via the erl shell using the odbc commands.  Further, if I start the ejabberd server  in  live mode, I enter the shell and connect to the server and run queries.  I receive the data.  The only issue is when I keep the server on for a few hours and it disconnect and do not re-connect.  I have  tired using various inputs for keepalive parameter but nothing seems to work.  After a few hours, the ejabberd server  will not be  able to  connect to the sql sever in the backend.  I tried many ways and after struggling for a week or so, I figured let me post a question. "}}