[ejabberd] mysql connection failed

Kirill Ratkin kirill.v.ratkin at gmail.com
Mon May 20 15:23:00 MSK 2013


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


More information about the ejabberd mailing list