I have a strange error after installing ejabberd. After I start it ejabberd works correctly and I can authorize users using MySQL. But every day when I come at work I can't login before run
su ejabberd -c 'ejabberdctl ejabberd@host reload '
After that I can login ok.
In log file I see the following:
=INFO REPORT==== 2006-08-17 07:39:38 ===
I(<0.13288.0>:ejabberd_listener:90): (#Port<0.9336>) Accepted connection {{172,18,64,112},1085} -> {{172,18,67,136},5222}
=INFO REPORT==== 2006-08-17 07:39:38 ===
I(<0.13986.0>:ejabberd_c2s:417): (#Port<0.9336>) Failed legacy authentication for user@host/home
I use ejabberd 1.1.1, unixODBC-2.2.11
mysql-connector-odbc-unixodbc-mysql51-3.51.12
It seems as if ejabberd
It seems as if ejabberd loses the connection to MySQL after some time of inactivity (during the night). When you restart ejabberd, since it establishes again the connection, everything works again.
Maybe you find more information about that problem (and possible solutions) on the mailing list archives and/or the chatroom logs.
Yes, you are right. I've
Yes, you are right. I've increased interactive-timeout, wait-timeout and everything is ok. Maybe it will be a problem later with a lot of inactve connections to mysqld - we'll see. But it's really a good question - why ejabberd doesn't monitor the state of connection and doesn't recover it? Or I'm not right and it's not ejabberd fault?