AnsweredAssumed Answered

Alfresco community 4.2.c - issues using MySQL 5.6.10.1 database

Question asked by scott.dalzell on Mar 5, 2013
Latest reply on Mar 6, 2013 by scott.dalzell
I am new to alfresco and I have been scouring these forums for the last few weeks looking for a solution for this problem so any help would be greatly appreciated

I am trying to install alfresco community 4.2.c on Windows 7 and have it connect to an existing standalone MySQL 5.6 database (i.e. not a bundled MySQL like in 3.4). However when I do this I get the following error in the log stating that it cannot locate the repository

“WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Not Found”

My installation steps were as follows

1/ Install MySSQL using mysql-installer-community-5.6.10.1.msi
        -   Full install

2/ Add environment Variables
        – Path (C:\Program files\mySQL\MySqlServer 5.6\Bin)

3/ Open Cmd.exe and log into MySQL
        >   Mysql –u root –p

4/ Create Alfresco database
        >   Create database alfresco;

5/ Create user
        >   Create user ‘alfresco’@’localhost’ identified by ‘alfresco’

6/ Grant permissions
        >Grant all privileges on *.* to ‘alfresco’@’localhost’
        >With grant option;

7/ Install Alfresco community 4.2.c (install Settings below)
        >Install all components except the Postgresql
        >Folder – C:\alfresco

Database Config
        >URL      - jdbc:mysql://localhost:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8
        >JDBC Driver   - org.gjt.mm.mysql.Driver
        >DB name    - alfresco
        >DB user   - alfresco
        >Password   - *******

8/ Updating properties
        >open C:\Alfresco40a\tomcat\shared\classes\ alfresco-global.properties.sample
        >check Dir.root=c:\alfresco\alf_data
        >uncomment url and Driver sections (updating to suit)

9/ Rename alfresco-global.properties.sample to alfresco-global.properties
        >alfresco-global.properties.sample to alfresco-global.properties

10/ Apply MySQL Connector
        >Copy Connector J 5.1.23.Jar to [Dir.root]\tomcat\lib

11/ restore contents and contents.delete
        > Move contents and contents.delete from backup location to c:/alfresco/alf_data

12/ Add full recovery to global properties
        > index.recovery.mode=full

13/ start alfresco service

14/ run alfresco

15/ Remove full recovery to global properties
        > index.recovery.mode=Auto

16/ Restart alfresco service


Thank you in advance for any help

Outcomes