ejabberd - Comments for "Both ODBC(MySQL) and anonymous authentication "

You are right. I've

badlop — Mon, 28 Dec 2015 20:47:34 +0000

You are right. I've investigated a little further the problem, and reported it here:
https://github.com/processone/ejabberd/issues/886

For now, the only solution is to copy an old ejabberd_config.erl to new ejabberd, like this:
https://raw.githubusercontent.com/processone/ejabberd/76104cd117126a2ac8...

In case you wonder, the correct config is (4), or more simply:

auth_method: 
  -  odbc
  -  anonymous
anonymous_protocol: both
allow_multiple_connections: true

I also tested with following

jpro — Sat, 26 Dec 2015 14:51:47 +0000

I also tested with following ejabbed versions: 15.04, .06, .07, .09, .10, .11.
.04 and .06 are OK for both login (odbc:mysql and anonymous), but .07, .09, .10, .11 are only anonymous login available.

Then I tested several

jpro — Sat, 26 Dec 2015 14:00:46 +0000

Then I tested several settings with several versions of ejabberd.
With ejabberd15.04, I succeeded login both users in mysql db and anonymous users with following setting in ejabbed.yml:
---------------------------------------
auth_method: odbc

host_config:
"mydomain.example.com":
auth_method:
- odbc
- anonymous
anonymous_protocol: both
allow_multiple_connections: true
---------------------------------------

However, for ejabberd15.11 with same setting, I could not succeeded login with users in mysql db. (anonymous login was succeeded.)

I am very happy if someone can advise me.