{"action":"opened","issue":{"url":"https://api.github.com/repos/processone/ejabberd/issues/480","labels_url":"https://api.github.com/repos/processone/ejabberd/issues/480/labels{/name}","comments_url":"https://api.github.com/repos/processone/ejabberd/issues/480/comments","events_url":"https://api.github.com/repos/processone/ejabberd/issues/480/events","html_url":"https://github.com/processone/ejabberd/issues/480","id":62675145,"number":480,"title":" Can't register user after changing the auth_method to odbc ejabberd 15.02","user":{"login":"azimsai","id":1025036,"avatar_url":"https://avatars.githubusercontent.com/u/1025036?v=3","gravatar_id":"","url":"https://api.github.com/users/azimsai","html_url":"https://github.com/azimsai","followers_url":"https://api.github.com/users/azimsai/followers","following_url":"https://api.github.com/users/azimsai/following{/other_user}","gists_url":"https://api.github.com/users/azimsai/gists{/gist_id}","starred_url":"https://api.github.com/users/azimsai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/azimsai/subscriptions","organizations_url":"https://api.github.com/users/azimsai/orgs","repos_url":"https://api.github.com/users/azimsai/repos","events_url":"https://api.github.com/users/azimsai/events{/privacy}","received_events_url":"https://api.github.com/users/azimsai/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-03-18T11:59:34Z","updated_at":"2015-03-18T11:59:34Z","closed_at":null,"body":"I had installed ejabberd 15.02 on ubuntu 14.04.After changing to mysql i tried to register a user using ejabberdctl its showing an error \"Can't register user admin@localhost at node ejabberd@localhost: not_allowed\" . If the auth_method is internal registration is working properly.\r\n\r\nError log\r\n```2015-03-18 16:49:42.729 [info] <0.38.0>@ejabberd_app:start:71 ejabberd 15.02.78 is started in the node ejabberd@localhost\r\n2015-03-18 16:49:42.730 [info] <0.7.0> Application ejabberd started on node ejabberd@localhost\r\n2015-03-18 16:50:27.648 [debug] <0.606.0>@ejabberd_commands:execute_command2:319 Executing command ejabberd_admin:register with Args=[<<\"admin\">>,<<\"192.168.0.35\">>,<<\"admin\">>]\r\n2015-03-18 16:53:49.540 [debug] <0.610.0>@ejabberd_commands:execute_command2:319 Executing command ejabberd_admin:register with Args=[<<\"admin\">>,<<\"localhost\">>,<<\"admin\">>]```\r\n\r\nIn ejabberd.yml \r\n\r\n``` \r\n## MySQL server:\r\n  -\r\n   auth_method: odbc\r\n   odbc_type: mysql\r\n   odbc_server: \"127.0.0.1\"\r\n   odbc_database: \"ejabberd\"\r\n   odbc_username: \"root\"\r\n   odbc_password: \"root\"\r\n\r\n\r\n\r\n###   ACCESS RULES\r\naccess:\r\n  max_user_sessions: \r\n    all: 10\r\n  max_user_offline_messages: \r\n    admin: 5000\r\n    all: 100\r\n  local: \r\n    local: allow\r\n  c2s: \r\n    blocked: deny\r\n    all: allow \r\n  c2s_shaper: \r\n    admin: none\r\n    all: normal \r\n  s2s_shaper: \r\n    all: fast\r\n  announce: \r\n    admin: allow \r\n  configure: \r\n admin: allow\r\n    muc_admin: \r\n    admin: allow \r\n  muc_create: \r\n    local: allow \r\n  muc: \r\n    all: allow\r\n    admin: allow\r\n  pubsub_createnode: \r\n    local: allow\r\n  register: \r\n    all: allow\r\n###   MODULES\r\nmodules: \r\n  mod_adhoc: []\r\n  mod_announce: # recommends mod_adhoc\r\n    access: announce\r\n  mod_caps: []\r\n  mod_carboncopy: []\r\n  mod_configure: [] \r\n  mod_disco: []  \r\n  mod_http_bind: []  \r\n  mod_last: [{db_type: odbc}]\r\n  mod_muc:\r\n    db_type: odbc  \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_offline:\r\n    db_type: odbc \r\n    access_max_user_messages: max_user_offline_messages\r\n  mod_privacy: [{db_type: odbc}]\r\n  mod_private: [{db_type: odbc}]  \r\n  mod_pubsub:\r\n    db_type: odbc \r\n    access_createnode: pubsub_createnode   \r\n    ignore_pep_from_offline: true   \r\n    last_item_cache: false\r\n    plugins: \r\n      - \"flat\"\r\n      - \"hometree\"\r\n - \"pep\" \r\n  mod_register:     \r\n    welcome_message: \r\n      subject: \"Welcome!\"\r\n body: |-\r\n        Hi.\r\n        Welcome to this XMPP server. \r\n    ip_access: trusted_network \r\n access: register\r\n  mod_roster: []\r\n  mod_shared_roster: []\r\n  mod_vcard: [{db_type: odbc}]\r\n  mod_version: []\r\n\r\n\r\n\r\n```\r\n\r\n\r\n\r\n\r\n\r\n"}}