error using odbc

Installed ejabberd from this installer https://www.process-one.net/downloads/downloads-action.php?file=/ejabber....

Execute .run file and everything works fine.
Then I need to use postgres db. So I opened ejabberd.yml and change auth_mode in:

auth_method: ODBC

Imported db from pg.sql.

Added these lines:

##
## PostgreSQL server:
##
odbc_type: pgsql
odbc_server: "localhost"
odbc_database: "ejabberd"
odbc_username: "postgres"
odbc_password: "mydbpassword"
#If you want to specify the port:
odbc_port: 5432

Starting I get this error:

2015-11-30 10:40:19.519 [error] <0.37.0> CRASH REPORT Process <0.37.0> with 0 neighbours exited with reason: {undefined_macro,'ODBC'} in application_master:init/4 line 133
2015-11-30 10:40:19.519 [info] <0.7.0> Application ejabberd exited with reason: {undefined_macro,'ODBC'}

Here is the crash.log:

2015-11-30 11:39:36 =CRASH REPORT====
  crasher:
    initial call: application_master:init/4
    pid: <0.37.0>
    registered_name: []
    exception exit: {{bad_return,{{ejabberd_app,start,[normal,[]]},{'EXIT',{undefined_macro,'ODBC'}}}},[{application_master,init,4,[{file,"application_master.erl"},{line,133}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,237}]}]}
    ancestors: [<0.36.0>]
    messages: []
    links: [<0.36.0>,<0.38.0>,<0.7.0>]
    dictionary: []
    trap_exit: true
    status: running
    heap_size: 376
    stack_size: 27
    reductions: 151
  neighbours:

Maybe I should recompile, but I cannot find configure file.

Resolved using odbc (instead

Resolved using odbc (instead of ODBC)

auth_method: odbc
Syndicate content