Home

Ejabberd 2.0.0-rc1 & mysql

Submitted by mikasaari on Wed, 2008-02-06 13:11

Hi,

I am using EJabberd 2.0.0-rc1 source package compiled with --enable-odbc. After installation I have added rows "{auth_method, odbc}." and "{odbc_server, {mysql, "mysql.example.org", "ejabberd", "ejabberd", "password"}}." to ejabberd.cfg and also removed the "{auth_method, internal}." from the same file. Also I have downloaded the svn co http://svn.process-one.net/ejabberd-modules and compiled the mysql module which I moved to /var/lib/ejabberd/ebin directory.

Once executing the ejabberdctl start I get this error message:
Error in process <0.251.0> on node 'ejabberd@localhost' with exit value: {{badmatch,<<0 bytes>>},[{mysql_conn,greeting,2},{mysql_conn,mysql_init,5},{mysql_conn,init,7}]}

Any tips to solve this problem is appreciated.

Thanks zillion times,
-Mika

Same issue

Submitted by mteppo on Wed, 2008-02-06 14:43.

I'm experiencing the same issue.
I noticed that mysql had "banned" my ejabberd-server account and I needed to mysqladmin flush-hosts on my mysql-server.

After that the error which I'm getting on the ejabberd start says:
=ERROR REPORT==== 2008-02-06 16:31:38 ===
Error in process <0.233.0> on node 'ejabberd@localhost' with exit value: {badarg,[{ets,lookup,[crypto_server_table,port]},{crypto,control,2},{mysql_auth,password_new,2},{mysql_auth,do_new_auth,8},{mysql_conn,mysql_init,5},{mysql_conn,init,7}]}

Any ideas around?

Cheers,
// Marko

http://www.boogiesoftware.com

»

Works correctly, I use Debian unstable

Submitted by mfoss on Tue, 2008-02-12 12:51.

I tried using ejabberd 2.0.0-rc1 compiled from source package, mysql erlang library compiled from ejabberd-modules SVN, Erlang R11B-5 from Debian unstable, Mysql server 5.0.51 from Debian unstable, and database created as explained in Using ejabberd with MySQL native driver.

All seems to work correctly for me: I can start ejabberd, create an account with a Jabber client, and login to it. No error messages are shown in ejabberd.log or sasl.log, neither at start time or at login time.

Now I make mistakes on purpose, and I check what error messages are printed:

  • If I put the wrong SQL server host:
    {odbc_server, {mysql, "localhostaaaaaaaa", "ejabberd", "ejabberd", "password"}}.

    Then I see at startup:

    =ERROR REPORT==== 12-Feb-2008::13:44:20 ===
E(<0.267.0>:ejabberd_odbc:312) : MySQL connection failed: connect_failed
  • If I put the wrong database name:
    {odbc_server, {mysql, "localhost", "ejabberdaaaaaaa", "ejabberd", "password"}}.

    Then I see at startup:

    =ERROR REPORT==== 12-Feb-2008::13:46:17 ===
E(<0.277.0>:ejabberd_odbc:312) : MySQL connection failed: failed_changing_database
  • If I put the wrong database username in database:
    {odbc_server, {mysql, "localhost", "ejabberd", "ejabberdaaaaaa", "password"}}.

    Then I see at startup:

    =ERROR REPORT==== 12-Feb-2008::13:47:12 ===
E(<0.273.0>:ejabberd_odbc:312) : MySQL connection failed: login_failed

So I don't know how to reproduce your problem.

»

Ejabberd 2.0.1-6+lenny1 (debian) & mysql

Submitted by izrail on Sun, 2009-08-30 15:42.

Hi,

i know that this thread is sleeping for long but i have the same problem as described by mikasaari.

i installed the ejabberd debian package, put the mysql modules in /var/lib/ejabberd/ebin and changed the auth_method and odbc_server lines in my ejabberd.cfg. when i then start the server i get this message:

=ERROR REPORT==== 2009-08-30 17:27:27 ===
Error in process <0.258.0> on node 'ejabberd@arwen' with exit value: {{badmatch,<<0 bytes>>},[{mysql_conn,greeting,2},{mysql_conn,mysql_init,5},{mysql_conn,init,7}]}

the server seems to be running and listening on ports 5222, 5223, ... but when i try to create an account using ejabberdctl i always get:
User "bla@blubb.org" already registered at node ejabberd@arwen

Has anyone else had this problem so far? Any suggestions?

Thanks,
Sven.

»
Syndicate content

User login