[ejabberd] ejabberd and MySQL

Alexander Drozdov dzal_mail at mtu-net.ru
Thu Jul 14 10:02:24 MSD 2005


Has anybody launched ejabberd with MySQL as a storage via ODBC?

I can't do it. I transformed the PostgreSQL database install script into
the MySQL one. The connections to MySQL via ODBC are established:
I used the libiodbc test program to check. When I started ejabberd it wrote
into ejabberd.log:

=INFO REPORT==== 2005-07-14 09:32:11 ===
The odbc application was not started. Has now been started as a 
temporary application.

MySQL connection from ejabberd was established (I checked it through
MySQL's SHOW PROCESSLIST). But it is all. SHOW PROCESSLIST shows idle time:
ejabberd has not sent anymore to MySQL.

When I trying to register on ejabberd (I use 6222 port instead 5222 now) 
it writes into
ejabberd.log:

=INFO REPORT==== 2005-07-14 09:51:05 ===
I(<0.203.0>:ejabberd_listener:90): (#Port<0.281>) Accepted connection 
{{10,10,10,10},56388} -> {{10,10,10,10},6222}

But registration was failed.

When I trying to connect to ejjaberd with some user and password (now 
via SSL and port 6223):

=INFO REPORT==== 2005-07-14 09:57:59 ===
I(<0.204.0>:ejabberd_listener:142): ({sslsocket,5,<0.7657.0>}) Accepted 
SSL connection {{10,10,10,10},63640} -> {{10,10,10,10},6223}

=INFO REPORT==== 2005-07-14 09:57:59 ===
I(<0.7658.0>:ejabberd_c2s:382): ({sslsocket,5,<0.7657.0>}) Failed legacy 
authentication for user at mydomain.com/imcom

Any ideas?



More information about the ejabberd mailing list