[ejabberd] mysql connection failed

Hannibal Ndlovu hannibaln at gmail.com
Mon May 20 18:28:18 MSK 2013


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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20130520/51b5af45/attachment-0001.html>


More information about the ejabberd mailing list