Alfresco community 4.2.c - issues using MySQL 5.6.10.1 database

[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

[dranakan]

Hello,

You need to restore the database with your backup dump.

Sample (to run in a console) :

mysql -ualfresco -pPASSWORD alfresco < D:\backup_dump\Export_data_base_Alfresco.sql‍

http://wiki.alfresco.com/wiki/Backup_and_Restore#Restore_Procedure

Before the point 11, try to run Alfresco to check your installation. After that, you can continue with the restore.

[scott_dalzell]

That worked a storm.

i had restored the sql database before but it was always after the i had restored the contents into the alf_data (dont know if that would have effected it).

i also updated the properties file to include lucene indexs

thank you again

[scott_dalzell]

My final Procedure that worked was 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)
        > uncomment db username and password (updating to suit)
        > Insert index type index.subsystem.name=lucene (if using lucene indexs)

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 mysql database in CMD
        > mysql –u alfresco –p PASSWORD alfresco <D:\backup_dump\Export_data_base_Alfresco.sql

12/ restore contents, contents.delete and lucene indexes to alf_data folder

13/ Add full recovery to global properties

14/ start alfresco service

15/ run alfresco