topic Re: Installation problem with MySQL in Alfresco Archive

Installation problem with MySQL

clark — Wed, 18 Mar 2009 02:43:02 GMT

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 w

Re: Installation problem with MySQL

mikeh — Wed, 18 Mar 2009 08:24:15 GMT

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

Re: Installation problem with MySQL

clark — Thu, 19 Mar 2009 03:45:42 GMT

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,