[ejabberd] cannot connect to mysql

Zohair Raza engineerzuhairraza at gmail.com
Fri Dec 14 17:48:49 MSK 2012


There is a trunk for ejabberd modules which contains all modules including
mysql

you can checkout using svn referring to this manual

http://www.ejabberd.im/ejabberd-modules

Readme is included in each of these modules

Good luck :)


Regards,
Zohair Raza


On Fri, Dec 14, 2012 at 4:40 PM, Michael Holm <hollo at hollo.dk> wrote:

> Hi,
>
> Thanks for the quick reply.. i did some search for ejabberd mysql.. and i
> cannot really see what you are refering to, but thats propperly because of
> the lack of the ejabberd-mysql module, which i cannot find anywhere, or im
> not sure which one you mean..:
>
> i get the mysql erlang support, or does ejabberd have anything?
>
> im using centos/redhat at the time, and does not seems to be possible to
> do that from the binary files.. but then i just have to compile it if thats
> what it takes.
>
> hope you can help me, do you know if redhat has something, or can you
> refer to something about the mysql module on ejabberd?
>
> Best regards,
> Michael Holm
>
>
>
> On Fri, Dec 14, 2012 at 1:16 PM, Zohair Raza <engineerzuhairraza at gmail.com
> > wrote:
>
>> have you installed ejabberd mysql module?
>>
>>
>> Regards,
>> Zohair Raza
>>
>>
>>
>>
>> On Fri, Dec 14, 2012 at 4:02 PM, Michael Holm <hollo at hollo.dk> wrote:
>>
>>> Hi,
>>>
>>> Problem:
>>>
>>> I cannot connect to mysql with the odbc_server and mod_roster_odbc..
>>>
>>> Details:
>>>
>>> I have tried to put following lines in the config:
>>>
>>> {odbc_server, {mysql, "localhost", 3306, "test", "root", ""}}.
>>>
>>>   %%{mod_roster,   []},
>>>   {mod_roster_odbc,   [{versioning, true}, {store_current_id, true}]},
>>>
>>> Yet, im still not able to connect to mysql.. here i what i do.. i tail
>>> my mysql general log which output everything that i going on on the mysql
>>> server.. and no attempts to connect from ejabberd when i login as a new
>>> user, i expect to get a connection to find the roster for a given user.
>>>
>>> When i try to connect commandline with the same credentials i get:
>>>
>>> [root at talk1 ejabberd]# mysql -u root -h localhost -P 3306
>>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>>> Your MySQL connection id is 13
>>> Server version: 5.1.66 Source distribution
>>>
>>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights
>>> reserved.
>>>
>>> Oracle is a registered trademark of Oracle Corporation and/or its
>>> affiliates. Other names may be trademarks of their respective
>>> owners.
>>>
>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>> statement.
>>>
>>> mysql>
>>>
>>> nothing is wrong here.. so what am i doing wrong? hope someone can help
>>> me out, and make a ejabberd connect to mysql..
>>>
>>> Software:
>>>
>>> CentOS 6.0
>>> ejabberd: 2.1.11
>>> mysql: 5.1.66
>>>
>>> Best regards,
>>> Michael Holm
>>>
>>>
>>> _______________________________________________
>>> ejabberd mailing list
>>> ejabberd at jabber.ru
>>> http://lists.jabber.ru/mailman/listinfo/ejabberd
>>>
>>>
>>
>> _______________________________________________
>> ejabberd mailing list
>> ejabberd at jabber.ru
>> http://lists.jabber.ru/mailman/listinfo/ejabberd
>>
>>
>
> _______________________________________________
> ejabberd mailing list
> ejabberd at jabber.ru
> http://lists.jabber.ru/mailman/listinfo/ejabberd
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20121214/e3553559/attachment-0001.html>


More information about the ejabberd mailing list