Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Whenever I try adding a new user like:

ejabberdctl register admin localhost default

It gives me the following error:

Problem 'error undef' occurred executing the command.
Stacktrace: [{ejabberd_odbc,escape,["admin"]},
         {ejabberd_auth_odbc,is_user_exists,2},
         {ejabberd_auth,'-is_user_exists/2-fun-0-',3},
         {lists,any,2},
         {ejabberd_auth,try_register,3},
         {ejabberd_admin,register,3},
         {ejabberd_ctl,call_command,3},
         {ejabberd_ctl,try_call_command,3}]

I have erlang with pg library, and set the following configurations on ejabberd:

{auth_method, odbc}.
{odbc_server, {pgsql, "localhost", "ejabberd", "root", "admin"}}.

I also created a database named ejabberd and migrated the pg.sql file. Do I need something else or am I doing something wrong?

share|improve this question

migrated from stackoverflow.com Feb 28 '11 at 15:52

This question came from our site for professional and enthusiast programmers.

    
have you checked postgres's logs? is root allowed to log in? –  JackPDouglas Feb 28 '11 at 15:21
    
yes it is, because I've been using postgres for other apps too. –  Marconi Feb 28 '11 at 23:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.