Minimum version of MySQL

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

flyboy
Posts: 24
Joined: Tue Aug 22, 2006 6:50 pm
Location: Atlanta, Georgia U.S.A.

Minimum version of MySQL

Post by flyboy » Tue Aug 22, 2006 6:55 pm

What is the minimum version of MySQL for OpenEMM? The docs say 4.0, but I have 4.0.21 and I can't use the SQL script to create the database because it doesn't support:

collate utf8_unicode_ci
DEFAULT CHARSET=latin1
on update CURRENT_TIMESTAMP

and probably more stuff, but I gave up at this point because the last of the 3 above items probably breaks functionality.

Thanks,
Sam

minichip
Posts: 9
Joined: Wed Aug 09, 2006 2:57 pm
Location: Ffm, Germany

Post by minichip » Tue Aug 22, 2006 10:18 pm

Hi Sam,

I had the same problem on debian. During isntallation I ran into trouble importing the sql file. I solved the problem trough upgrading the mysql version from 4.0.24 to 4.1.11a.
Since it tried it on a spare machine the upgrade was no problem for me.

best regards

flyboy
Posts: 24
Joined: Tue Aug 22, 2006 6:50 pm
Location: Atlanta, Georgia U.S.A.

Post by flyboy » Wed Aug 23, 2006 12:08 am

Unfortunately, I’m on a system that has other stuff running on it. This sets me back a week or two because now I have to go find and set up another piece of hardware before I can even test the openEMM. :-(

Too bad, because I need it now and it looks like a pretty decent tool from the documentation.

If the developers are reading this they might consider updating the documentation about the prerequsites to say 4.1 is a requirement instead of 4.0. I vaguely remember 4.0 being an orphaned version of 4.x—more like 3.x than 4.1. Maybe it would save someone else the wasted effort of going through more than half the setup before figuring out they can't install the product because of their database version.

maschoff
Site Admin
Posts: 2225
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

MySQL version

Post by maschoff » Wed Aug 23, 2006 7:36 am

flyboy, thanks, I will put a note on the requirement page.
OpenEMM Maintainer

flyboy
Posts: 24
Joined: Tue Aug 22, 2006 6:50 pm
Location: Atlanta, Georgia U.S.A.

Post by flyboy » Wed Aug 23, 2006 12:58 pm

Thanks Master. FYI I'm not complaining--I'm just trying to help out other folks.

Post Reply