[ejabberd] mysql connection failed

Kirill Ratkin kirill.v.ratkin at gmail.com
Mon May 20 18:55:29 MSK 2013


Hmmm...
Have no ideas ...

But ...

Did you build ejabberd with --odbc-enabled and
Is erlang mysql driver built & installed?


2013/5/20 Hannibal Ndlovu <hannibaln at gmail.com>

> I used the credentials i have in the .cfg file - i am able to connect -
> and i can see the correct database and have access to it - but ejabberd is
> still stating that the connection to mysql is timing out
>
>
> On 20 May 2013 13:23, Kirill Ratkin <kirill.v.ratkin at gmail.com> wrote:
>
>> What does happen if you try 'mysql -h DB-IP-Address -u user -p' from the
>> host where you run ejabberd?
>> For me this error appeared when my db-user didn't have access to
>> particular database from remote host where ejabberd works.
>>
>>
>> 2013/5/17 Hannibal Ndlovu <hannibaln at gmail.com>
>>
>>> Hello
>>> DB name, username and password in ejabberd.cfg are correct - it was
>>> working correctly and then it stopped and started giving that error
>>>
>>>
>>>
>>> On 17 May 2013 20:00, Ivan Osipov <ivanosipov at mail.ru> wrote:
>>>
>>>>  Hello.
>>>> DB name, username and password in ejabberd.cfg are correct? Maybe some
>>>> of this parameters was changed? Check this.
>>>>
>>>> 17.05.2013 21:31, Hannibal Ndlovu пишет:
>>>>
>>>> I have ejabberd ejabberd-2.1.11 installed on debian 6 it was working
>>>> fine and then all of a sudden i started seeing this in my ejabberd log. am
>>>> not sure how to fix it - my Mysql seems to be working as all other
>>>> databases can be connected to and accessed with no problem.
>>>>
>>>>  =ERROR REPORT==== 2013-05-17 19:29:49 ===
>>>> E(<0.211.0>:ejabberd_odbc:552) : mysql_conn: post_start timeout
>>>>
>>>>
>>>>  =INFO REPORT==== 2013-05-17 19:29:49 ===
>>>> I(<0.211.0>:ejabberd_odbc:226) : mysql connection failed:
>>>> ** Reason: "timed out"
>>>> ** Retry after: 30 seconds
>>>>
>>>>  =WARNING REPORT==== 2013-05-17 19:29:49 ===
>>>> W(<0.211.0>:ejabberd_odbc:291) : unexpected info in connecting:
>>>> {mysql_conn,
>>>>
>>>>  <0.626.0>,
>>>>                                                                  {error,
>>>>
>>>> connect_failed}}
>>>>
>>>>  =ERROR REPORT==== 2013-05-17 19:29:49 ===
>>>> E(<0.207.0>:ejabberd_odbc:552) : mysql_conn: post_start timeout
>>>>
>>>>
>>>>  =INFO REPORT==== 2013-05-17 19:29:49 ===
>>>> I(<0.207.0>:ejabberd_odbc:226) : mysql connection failed:
>>>> ** Reason: "timed out"
>>>> ** Retry after: 30 seconds
>>>>
>>>>  =ERROR REPORT==== 2013-05-17 19:29:49 ===
>>>> E(<0.213.0>:ejabberd_odbc:552) : mysql_conn: post_start timeout
>>>>
>>>>
>>>>  =WARNING REPORT==== 2013-05-17 19:29:49 ===
>>>> W(<0.207.0>:ejabberd_odbc:291) : unexpected info in connecting:
>>>> {mysql_conn,
>>>>
>>>>  <0.625.0>,
>>>>                                                                  {error,
>>>>
>>>> connect_failed}}
>>>>
>>>>  =INFO REPORT==== 2013-05-17 19:29:49 ===
>>>> I(<0.213.0>:ejabberd_odbc:226) : mysql connection failed:
>>>> ** Reason: "timed out"
>>>> ** Retry after: 30 seconds
>>>>
>>>>  =WARNING REPORT==== 2013-05-17 19:29:49 ===
>>>> W(<0.213.0>:ejabberd_odbc:291) : unexpected info in connecting:
>>>> {mysql_conn,
>>>>
>>>>  <0.629.0>,
>>>>                                                                  {error,
>>>>
>>>> connect_failed}}
>>>>
>>>>  =ERROR REPORT==== 2013-05-17 19:29:49 ===
>>>> E(<0.212.0>:ejabberd_odbc:552) : mysql_conn: post_start timeout
>>>>
>>>>
>>>>  =INFO REPORT==== 2013-05-17 19:29:49 ===
>>>> I(<0.212.0>:ejabberd_odbc:226) : mysql connection failed:
>>>> ** Reason: "timed out"
>>>> ** Retry after: 30 seconds
>>>>
>>>>  =WARNING REPORT==== 2013-05-17 19:29:49 ===
>>>> W(<0.212.0>:ejabberd_odbc:291) : unexpected info in connecting:
>>>> {mysql_conn,
>>>>
>>>>  <0.627.0>,
>>>>                                                                  {error,
>>>>
>>>> connect_failed}}
>>>>
>>>>  =ERROR REPORT==== 2013-05-17 19:29:49 ===
>>>> E(<0.209.0>:ejabberd_odbc:552) : mysql_conn: post_start timeout
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> ejabberd mailing listejabberd at jabber.ruhttp://lists.jabber.ru/mailman/listinfo/ejabberd
>>>>
>>>>
>>>> --
>>>> WBR,
>>>> Ivan Osipov
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>
>>
>
> _______________________________________________
> 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/20130520/88315e57/attachment-0001.html>


More information about the ejabberd mailing list