topic Re: Alfresco 3.4e Community Installation with MySQL in Alfresco Archive

Alfresco 3.4e Community Installation with MySQL

hanscrg — Wed, 24 Aug 2011 03:41:07 GMT

Have tried install 3.4e and then configure the database to use mysql. The online document talking about "… you must modify values in both custom-repository.properties and custom-hibernate-dialect.properties, located within the extension folder. To configure MySQL: Browse to the tomcat\shared\classes

Re: Alfresco 3.4e Community Installation with MySQL

tapan_d_thakkar — Wed, 24 Aug 2011 06:41:04 GMT

Hi in newer version, they have removed custom-repository.properties.

now to configure DB properties use alfresco-global.properties in "installationDir\tomcat\shared\classes"

Re: Alfresco 3.4e Community Installation with MySQL

hanscrg — Thu, 25 Aug 2011 16:48:23 GMT

I did not see any configuration in alfresco-global.properties related to those in custom-hibernate-dialect.properties. Also startup alfresco, it will check mysql/scripts directory to see if there is ctl.sh script, where is that script file in alfresco 3.4.e?

Is there any docuemnt talking about configuration mysql working with Alfresco 3.4.e?

Thanks in advance.

Re: Alfresco 3.4e Community Installation with MySQL

plaw013 — Fri, 28 Oct 2011 00:30:15 GMT

Hi,

I had this same problem when installing to a Linux distro (SLES). To resolve the issue I used the following procedure:
1) On existing MySQL instance create a new database called 'alfresco', create a new user (I also called it 'alfresco') and grant all privileges
2) Run default install binary and select advanced method
3) Amend the database properties as required (user, password and database)
4) Accept remaining default options and proceed with the install
5) Once installed open a terminal window and cd to the Alfresco installation location
6) Start the alfresco services if not already running using alfresco.sh start
7) Check the alfresco.log for progress. It does take a little bit of time to build the tables, etc

In your case I suggest the key is step 1 of the above process. Without this the database is not created or populated leading to all sorts of errors including not being able to login to the site.

Hope this helps - good luck…

Regards Peter