Installation problem with MySQL

[clark]

Hi folks,

We are developing one project for our customer using Alfresco as CMS tools.

In the process, we fixed many Alfresco issues existing in labs version, but met with a big one in integrating with MySQL.

As you all know, default value of flag "lower_case_table_names" in MySQL windows version is 1 which means ignore table names case sensitive, while in MySQL Linux version is 0.

But is Alfresco source code, exactly in all hbm & db scripts in 4 jar files which deal with "JBPM_*" tables, "JBPM_*" were in UPPERCASE (maybe some place were in lowercase).

Which means if Alfresco run in Linux with the default case sensitive flag in MySQL, instance could not run well.

Our solution is resetting MySQL flag from 0 to 1, which also solved the problem.


But to our customer, they would not like to change this flag because there are other application against same MySQL instance.

We could not provide other solution, besides modifying all related source code in JAR files which seams impossible….


So,  could anyone provide some suggestion for us in similar case?

Meanwhile, you can raise any question about issues both in installation & WCM.
We would try to help you to fix some issues we solved.

Thanks.

[mikeh]

In the process, we fixed many Alfresco issues existing in labs version

Anything you'd care to contribute back? Even if you raise the issues in JIRA with suggested fixes, this helps everyone - not just us.

Which means if Alfresco run in Linux with the default case sensitive flag in MySQL, instance could not run well.

Our solution is resetting MySQL flag from 0 to 1, which also solved the problem.

Alfresco runs just fine on Linux, as there are many customers who have been using it for long periods. What specific problems did you hit? Were you trying to share databases between Windows and Linux for example?

Thanks,
Mike

[clark]

Anything you'd care to contribute back? Even if you raise the issues in JIRA with suggested fixes, this helps everyone - not just us.

Got it. I'd be Glad to do it.

Alfresco runs just fine on Linux, as there are many customers who have been using it for long periods. What specific problems did you hit? Were you trying to share databases between Windows and Linux for example?

Thank you for your reply indeed.

I'm afraid you got some misunderstanding according to my poor English

Let's me express the question clearly.


When MySQL(4.1)'s flag "lower_case_table_names" keep default value "0" which means database name case sensitive, Alfresco can not start/work.

Exception message was related with "JBPM_*" tables.

After resetting this flag to "1" which means MySQL ignore database name sensitive, alfresco could run well.

User would not meet with such problem in windows because the default value of this MySQL flag is "1" in windows version MySQL, while "0" in Linux one.


As a result Alfresco could run againt MySQL well as long as this flag was reset to "1", no matter in windows or linux.

This is cleared as you mentioned.


Now the question is : How to run Alfresco again MySQL with this flag as "0"?


After my researching, the root cause of this issue is that mostly codes which deal with "JBPM_*" tables in some JAR files & DB scripts were in different case format (90% were uppercase), while other "avm_*", "alf_*" were in lowercase.

For example: please take a look at "Membership.hbm.xml" files in "jbpm-identity-3.2.2.jar"

The table names were in uppercase "JBPM_ID_MEMBERSHIP"

There must be some confliction betwwen codes & uppercase table names due to  DB case sensitive feature

By now, hope each one could understand it…..



Of course, we can "fix" it by resetting MySQL's flag.

But in my case, our customer do not want to do so because there are some existing application which were also again same MYsql instance.



Could you please give some suggestin?

Each reply of you would be appreciated


Many thanks!

Thanks,