UTF8 / MySQL wait timeout issue

Greetings,

I've just encountered a bug that manifests itself when if you're using
national symbols in JID/vcard-temp.

If and when MySQL connection times out (by default wait_timeout is
28800sec, 8 hours), jabberd14 doesn't execute the <onconnect>SET NAMES
utf8</onconnect> statement when it reconnects to MySQL when it finds out
the connection dropped on next query. If you have non-busy or as in my
case, development server that's idle at nights, this results in all XMPP
messages having ?????s instead of unicode characters next morning (8
hours sleep time, default wait_timeout, yay).

The onconnect query gets executed only on the initial connect when
jabberd14 is started, so currently to fix you need to either restart
jabberd14, or, set in mysql's my.cnf insanely large number, like this:

set-variable = wait_timeout=999999999


I think this should be easy to fix.

Thanks for your time,
Vahan

_______________________________________________
JAdmin mailing list
FAQ: http://www.jabber.org/discussion-lists/jadmin-faq
Forum: http://www.jabberforum.org/forumdisplay.php?f=19
Info: http://mail.jabber.org/mailman/listinfo/jadmin
Unsubscribe: [email protected]
_______________________________________________