ejabberd - Comments for "Ejabberd 2.0.0-rc1 & mysql"

Ejabberd 2.0.1-6+lenny1 (debian) & mysql

izrail — Sun, 30 Aug 2009 15:42:56 +0000

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.

Works correctly, I use Debian unstable

mfoss — Tue, 12 Feb 2008 12:51:40 +0000

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.

Same issue

mteppo — Wed, 06 Feb 2008 14:43:24 +0000

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

ejabberd - Comments for "Ejabberd 2.0.0-rc1 &amp; mysql"

Ejabberd 2.0.1-6+lenny1 (debian) & mysql

Works correctly, I use Debian unstable

Same issue

ejabberd - Comments for "Ejabberd 2.0.0-rc1 & mysql"