It works ok for me, but ejabberdstores password in plain text, this way. Isn't there a way of enabling digest encryption for an external database?
Thanks,

Pedro 

I just noticed, that ejabberd seems to need a TCP socket. A MySQL 5 installation on Debian sarge has TCP (port 3306) disabled. It is configured to use the unix socket only. While this makes MySQL safe and works with the "mysql" command line client and phpmyadmin, it does not seem to work with ejabberd. My ejabberd finally started using the MySQL tables after I commented out "skip-networking" in /etc/mysql/my.cnf.

hw

Note that the schema as supplied assumes a MySQL installation 4.1 or later, with InnoDB.

For MySQL 4.0.18 I needed to remove each USING HASH qualifier, and change SERIAL on line 41 to INTEGER UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE (phew). 

To make it easier to adapt I would suggest removing all TYPE=InnoDB qualifiers (TYPE= is deprecated in favour of ENGINE= by the way) and put a single SET table_type=InnoDB at the top. This can then be commented out if necessary (assuming ejabberd is compatible with other table types...)

toby@smartgames.ca 

It looks like you can't connect using MySQL accounts that do not need a password. Adding a password to the MySQL account I'm using on my test server sorted out MySQL connection problems I was having. Plus, its a good idea from a security perspective as well

I have change ejabberd to use mysql and since then every time I try to register I get error

"The address cannot be register. The username is not avalibale."

Any ideas?

Do you have any solution, to store whole JID on users table, e.g. me@jabber-sample.com insted of just me?

 Thanks,

WS.

&pHi. I installed ejabberd1.1.3  on a Linux FC6 server . I want ejabberd use mysql instead of its defautl.  Mysql's version 5.0.27 . But when I start ejabberd it prompt me 'An error  occured' . I check the sasl.log and find

=SUPERVISOR REPORT==== 18-Jul-2007::14:06:51 ===
Supervisor: {local, 'ejabberd_odbc_sup_ns25586.ovh.net'}
 Context: start_error
 Reason: mysql_connection_failed
 Offender: [{pid,undefined},
 {name,1},
 {mfa,{ejabberd_odbc,start_link,["ns25586.ovh.net"]}},
 {restart_type,transient},
 {shutdown,brutal_kill},
 {child_type,worker}]

I tried on another Suse10.2 server with mysql5.0.26 and everything is ok. Does Erlang mysql driver support Mysql5.0.27 ? How can I make ejabberd work ? Thanks . Best regards.

Hello,

I have installed ejabber 1.1.2_2 from ports under FreeBSD 6.0, erlang version is r11b3. I configured authentication with AD and it works now. But when I want to store offline messages and some other info in MySQL database, I had done all things from this article - but ejabberd does not work with MySQL. There are no any errors, or any words about odbc or mysql in sasl.log.

What things need I look or try to?

Regards,

Andrew Parnasov 

Hello all,

I have install ejabberd 1.1.3 with MySQL 5, with MySQL all is ok, but with ejabberd I could not see the Users and the connecting Users. Moreover Mnesia has not got the off_line table.

The command tv:start(). don t work... 

And moreover the environment variable DISPLAY don t exist now ...

Have you an idea ??? 

Paul 

Hi,

is there a way to encrypt the passwords which are stored in the database?

I am using odbc to get to my mysql server and ejabberd1.1.4 installer 64bit

Thanks.

Florian

I've just tried this and it works great--will solve a number of problems for me.

That said, I'd like to know if there is anyway to make the odbc module authenticate against other tables (besides the external script).  Is it possible to use external authentication and still use odbc for roster, last, etc.?  

Finally, when I was setting all this up, I noticed what I think might be a bug.  I accidentally mistyped

 Thanks,

Todd 

We have an existing MySQL database table with usernames and encrypted passwords - how can make ejabberd work with it?

Just one question..this might be a real dumb one ...I have done the steps and restarted ejabberd..now authentication happens through the MySQL database. I assumed that I can not logon any more as admin to the web interface or messenger because the users do not exist in the newly created db.

So I opened phpmyadmin and entered admin and admin@myjaber.mydmonain.net each seperately as a user with password 123456 but it did not work any comments please ?

Just confirming here that when everything is working correctly, creating accounts should be no problem:

I was able to create an account manually via MySQL just by adding a row to the users table with a username and password.

I was also able to register a new account via my IM client, same way as usual.

If this isn't working, you are probably misconfigured. The gotcha that got me at first was the fact that in the ejabberd.cfg file the odbc_server line for the MSSQL server is uncommented by defaut; you of course have to comment that if you plan to use MySQL.

I too have a problem getting the mysql-options to run properly.

When trying to add the admin, I will get an error telling me that the User already exists:

>ejabberdctl register admin myhostname.com password
User "admin@myhostname.com" already registered at node ejabberd@server

I had a look at sasl.log and found:

=CRASH REPORT==== 21-Feb-2008::17:41:02 ===
  crasher:
    pid: <0.233.0>
    registered_name: []
    error_info: {{case_clause,{mysql,"localhost",
                                      "ejabberd",
                                      "ejabberd",
                                      "password"}},
                  [{ejabberd_odbc,init,1},
                   {gen_server,init_it,6},
                   {proc_lib,init_p,5}]}
    initial_call: {gen,init_it,
                      [gen_server,
                       <0.232.0>,
                       <0.232.0>,
                       ejabberd_odbc,
                       ["myhostname.com"],
                       []]}
    ancestors: ['ejabberd_odbc_sup_myhostname.com',<0.36.0>]
    messages: []
    links: [<0.232.0>]
    dictionary: []
    trap_exit: false
    status: running
    heap_size: 377
    stack_size: 21
    reductions: 103
  neighbours:

=SUPERVISOR REPORT==== 21-Feb-2008::17:41:02 ===
     Supervisor: {local,
                                              'ejabberd_odbc_sup_myhostname.com'}
     Context:    start_error
     Reason:     {{case_clause,{mysql,"localhost",
                                      "ejabberd",
                                      "ejabberd",
                                      "password"}},
                  [{ejabberd_odbc,init,1},
                   {gen_server,init_it,6},
                   {proc_lib,init_p,5}]}
     Offender:   [{pid,undefined},
                  {name,1},
                  {mfa,{ejabberd_odbc,start_link,["myhostname.com"]}},
                  {restart_type,transient},
                  {shutdown,brutal_kill},
                  {child_type,worker}]

Log in to my mysql-Server using the supplied username/password works, "ejabberctl registered-users" does not show any user being registered.

My ejabberd.cfg follows:

{acl, local, {user_regexp, ""}}.
{access, configure, [{allow, admin}]}.
{access, register, [{allow, all}]}.
{welcome_message,
 {"Welcome!",
  "Welcome to Debian Jabber Service.  "
  "For information about Jabber visit http://jabber.org"}}.
{registration_watchers, ["webmaster@myhostname.com"]}.
{access, announce, [{allow, admin}]}.
{access, c2s, [{deny, blocked},
               {allow, all}]}.
{shaper, normal, {maxrate, 1000}}.
{shaper, fast, {maxrate, 50000}}.
{access, c2s_shaper, [{none, admin},
                      {normal, all}]}.
{access, s2s_shaper, [{fast, all}]}.
{access, muc_admin, [{allow, admin}]}.
{access, muc, [{allow, all}]}.
{access, local, [{allow, local}]}.
{auth_method, odbc}.
{odbc_server, {mysql, "localhost", "ejabberd", "ejabberd", "password"}}.
{hosts, ["myhostname.com"]}.
{language, "en"}.
{listen,
 [{5222, ejabberd_c2s,     [{access, c2s},
                            starttls, {certfile, "/etc/ssl/certs/ejabberd.pem"},
                            {shaper, c2s_shaper}]},
  {5223, ejabberd_c2s,     [{access, c2s},
                            tls, {certfile, "/etc/ssl/certs/ejabberd.pem"},
                            {shaper, c2s_shaper}]},
  {5269, ejabberd_s2s_in,  [{shaper, s2s_shaper}]},
  {5280, ejabberd_http,    [http_poll, web_admin]}
 ]}.
{outgoing_s2s_port, 5269}.
{modules,
 [
  {mod_announce,   [{access, announce}]},
  {mod_register,   [{access, register}]},
  {mod_roster_odbc,     []},
  {mod_shared_roster, []},
  {mod_privacy,    []},
  {mod_configure,  []},
  {mod_configure2, []},
  {mod_disco,      [{extra_domains, ["users.jabber.org"]}]},
  {mod_stats,      []},
  {mod_vcard_odbc,      []},
  {mod_offline_odbc,    []},
  {mod_echo,       []},
  {mod_private,    []},
  {mod_irc,        []},
  {mod_muc,        [{access, muc},
                    {access_create, muc},
                    {access_admin, muc_admin}]},
  {mod_pubsub,     []},
  {mod_time,       []},
  {mod_last_odbc,       []},
  {mod_version,    []}
 ]}.

Does anyone hva an idea what could be wrong?

Best regards,

Tobias

we have configured module of ejabber in ejabbard.cfg file of ejabbard-1.1.4 as follows

[snip]

in last table of seconds field is changing in our mysql database. how ever in that same last table state field is not changing when ever we changed presence info of user.

can any one help on this

Thanks in advance.

Satya.