{"action":"created","issue":{"url":"https://api.github.com/repos/processone/ejabberd/issues/546","labels_url":"https://api.github.com/repos/processone/ejabberd/issues/546/labels{/name}","comments_url":"https://api.github.com/repos/processone/ejabberd/issues/546/comments","events_url":"https://api.github.com/repos/processone/ejabberd/issues/546/events","html_url":"https://github.com/processone/ejabberd/issues/546","id":70859334,"number":546,"title":"unable to connect ejabberd to postgresql","user":{"login":"seraphjiang","id":550437,"avatar_url":"https://avatars.githubusercontent.com/u/550437?v=3","gravatar_id":"","url":"https://api.github.com/users/seraphjiang","html_url":"https://github.com/seraphjiang","followers_url":"https://api.github.com/users/seraphjiang/followers","following_url":"https://api.github.com/users/seraphjiang/following{/other_user}","gists_url":"https://api.github.com/users/seraphjiang/gists{/gist_id}","starred_url":"https://api.github.com/users/seraphjiang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/seraphjiang/subscriptions","organizations_url":"https://api.github.com/users/seraphjiang/orgs","repos_url":"https://api.github.com/users/seraphjiang/repos","events_url":"https://api.github.com/users/seraphjiang/events{/privacy}","received_events_url":"https://api.github.com/users/seraphjiang/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-25T05:48:24Z","updated_at":"2015-04-25T05:50:26Z","closed_at":null,"body":"\r\n\r\nbelow is error\r\n```\r\n05:43:57.195 [error] The authentication module ejabberd_auth_odbc returned an error\r\nwhen checking user <<\"admin1\">> in server <<\"xjt.cloudapp.net\">>\r\nError message: {aborted,{no_exists,[sql_pool,<<\"xjt.cloudapp.net\">>]}}\r\n05:44:08.801 [debug] Executing command ejabberd_admin:register with Args=[<<\"admindd\">>,<<\"xjt.cloudapp.net\">>,<<\"123456\">>]\r\n05:44:08.801 [error] The authentication module ejabberd_auth_odbc returned an error\r\nwhen checking user <<\"admindd\">> in server <<\"xjt.cloudapp.net\">>\r\nError message: {aborted,{no_exists,[sql_pool,<<\"xjt.cloudapp.net\">>]}}\r\n```\r\n\r\nmy config:\r\n```\r\nauth_method: odbc\r\n\r\n##\r\nPostgreSQL server:\r\n##\r\n odbc_type: pgsql\r\n odbc_server: \"localhost\"\r\n odbc_database: \"ejabberd\"\r\n odbc_username: \"xxxx\"\r\n odbc_password: \"xxxxx\"\r\n##\r\n\r\n\r\nmodules:\r\n  mod_adhoc: {}\r\n  ## mod_admin_extra: {}\r\n  mod_announce: # recommends mod_adhoc\r\n    access: announce\r\n  mod_blocking: {} # requires mod_privacy\r\n  mod_caps: {}\r\n  mod_carboncopy: {}\r\n  mod_client_state:\r\n    drop_chat_states: true\r\n    queue_presence: false\r\n  mod_configure: {} # requires mod_adhoc\r\n  mod_disco: {}\r\n  ## mod_echo: {}\r\n  mod_irc: {}\r\n  mod_http_bind: {}\r\n  ## mod_http_fileserver:\r\n  ##   docroot: \"/var/www\"\r\n  ##   accesslog: \"/var/log/ejabberd/access.log\"\r\n  mod_last:\r\n    db_type: odbc\r\n  mod_muc:\r\n    ## host: \"conference.@HOST@\"\r\n    access: muc\r\n    access_create: muc_create\r\n    access_persistent: muc_create\r\n    access_admin: muc_admin\r\n  ## mod_muc_log: {}\r\n  ## mod_multicast: {}\r\n  mod_offline:\r\n    access_max_user_messages: max_user_offline_messages\r\n    db_type: odbc\r\n  mod_ping: {}\r\n  ## mod_pres_counter:\r\n  ##   count: 5\r\n  ##   interval: 60\r\n  mod_privacy: {}\r\n  mod_private: {}\r\n  ## mod_proxy65: {}\r\n  mod_pubsub:\r\n    access_createnode: pubsub_createnode\r\n    ## reduces resource comsumption, but XEP incompliant\r\n    ignore_pep_from_offline: true\r\n    ## XEP compliant, but increases resource comsumption\r\n    ## ignore_pep_from_offline: false\r\n    last_item_cache: false\r\n    plugins:\r\n\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/processone/ejabberd/issues/comments/96135090","html_url":"https://github.com/processone/ejabberd/issues/546#issuecomment-96135090","issue_url":"https://api.github.com/repos/processone/ejabberd/issues/546","id":96135090,"user":{"login":"seraphjiang","id":550437,"avatar_url":"https://avatars.githubusercontent.com/u/550437?v=3","gravatar_id":"","url":"https://api.github.com/users/seraphjiang","html_url":"https://github.com/seraphjiang","followers_url":"https://api.github.com/users/seraphjiang/followers","following_url":"https://api.github.com/users/seraphjiang/following{/other_user}","gists_url":"https://api.github.com/users/seraphjiang/gists{/gist_id}","starred_url":"https://api.github.com/users/seraphjiang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/seraphjiang/subscriptions","organizations_url":"https://api.github.com/users/seraphjiang/orgs","repos_url":"https://api.github.com/users/seraphjiang/repos","events_url":"https://api.github.com/users/seraphjiang/events{/privacy}","received_events_url":"https://api.github.com/users/seraphjiang/received_events","type":"User","site_admin":false},"created_at":"2015-04-25T05:50:26Z","updated_at":"2015-04-25T05:50:26Z","body":"i keep get error when i use different user name, it is said this user is registered, however user table is empty and it is impossible there is existing user. \r\n\r\nejabberdctl register admindd123 xjt.cloudapp.net dddd\r\nUser admindd123@xjt.cloudapp.net already registered at node ejabberd@localhost\r\n"}}