OpenEMR & MySQLCLUSTER

Day-to-Day Users
1

yacketta wrote on Friday, December 11, 2009:

Hello all!

I am attempting to setup OpenEMR here at SUNY Potsdam and having a fight with getting the OpenEMR DB to run in a MySQLCLUSTER.

Does anyone have any experience with getting OpenEMR up and running on a MySQLCLUSTER?

Each attempt to load the database.sql results it :
ERROR 1005 (HY000) at line 2: Can’t create table ‘openemr.form_ros’ (errno: 4318)

Regards,
Ronald J. Yacketta
System Engineer
SUNY Potsdam

2

bradymiller wrote on Saturday, December 12, 2009:

hi,

I think MySQLCLUSTER has more size constraints than MySQL. You could try to yank the form_ros entry from openemr/sql/database.sql . This wouldn’t break OpenEMR, just won’t allow you to use the ‘review of systems’ form. Also, there’s another ‘review of system’ in the database and I’m guessing you may need to remove that also (I’d see if you get the error first though).

-brady