Alfresco 3.4e Community Installation with MySQL

[hanscrg]

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\alfresco\extension\ directory. "

But where are that two files mentioned above? I can not find them in tomcat\shared\classes\alfresco\extension\. Is there any way to configure 3.4e to use MySQL?

Your help is appreciated.

[tapan_d_thakkar]

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

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

[hanscrg]

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.

[plaw013]

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