I have scoured the forums and googled till my fingers hurt, but cannot figure out how to get ejabberd (v2.0.5) to use MySQL DB on windows. The log files seem to indicate a successful connection to MySQL...
=INFO REPORT==== 2009-07-01 09:57:39 ===
D(<0.299.0>:ejabberd_odbc:347) : mysql_conn: greeting version "5.1.35-community-log" (protocol 10) salt "Quxz~,[g" caps 63487 serverchar
<<8,2,0,0,
0,0,0,0,
0,0,0,0,
0,0,0,0>> salt2 "s-#hc:46Rx'X"
=INFO REPORT==== 2009-07-01 09:57:39 ===
D(<0.293.0>:ejabberd_odbc:347) : mysql_auth send packet 1: <<7,162,0,0,64,66,
15,0,8,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,
101,106,97,98,98,
101,114,100,0,20,
102,237,166,119,
232,222,173,132,
180,237,223,30,
185,255,21,72,150,
0,214,109>>
...but then essentially ignores MySQL and merrily uses the Mnesia database.
I have followed such things as copying the mysql*.beam files to the ejabberd ebin folder, and swearing and pooring over the logs, but so far, the MySQL tables are silent.
I notice that in the linux installations there are some ./configure options to specify odbc operability, but I have not found anything similar for the Windows installation. I used the nice, friendly ejabberd-2.0.5-windows-installer.exe installer, and then changed the .cfg settings appropriately, or at least what seemed to be indicated in the users guide and confirmed for the most part from various postings on the topic here and elsewhere on the web. Needless to say, (or is it?) I restarted ejabberd each time after changing the settings.
So what's the trick to getting ejabberd to use MySQL on Windows?
Thanks for any help on this topic.
