I have been trying to create an MDX report against a MySQL database, but have not been successful.
So only for test if I was doing things good I create a back Up of sampledata from one machine (192.168.2.244) and recovery the data in another server my localhost in (127.0.0.1) and I can create an MDX report against sampledata in MySql in 192.168.2.244 and works but did not work at 127.0.0.1.

I have two MySqlServers one at 192.168.2.244 and the other at localhost (127.0.0.1) the sampledata db is the same in both servers and there are the same permisions.

ReportDesigner 1.6 build 348. (Under Kubuntu 7.10)
I created two JNDI connection for both datasource and tested connection - both works.

I checked the "Use Mondrian Cube Definition" box and specified my *.mondrian.xml file, then entered valid MDX. When I click OK, I get "Could not fetch data: Mondrian Error: Internal error: Error while creating SQL dialect" If I use the (127.0.0.1) connection.

If I use the remote MySqlServer 192.168.2.244 all things goes succesfull .. ...
What am I doing Wrong? Do I have to configure another file?? mondrian properties perhaps??