AnsweredAssumed Answered

Alfresco and Mysql

Question asked by nezha on Mar 11, 2014
Latest reply on Mar 11, 2014 by nezha
hi;
i followed this procedure
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

but when i tried to log in my Alfresco i got this error:
Le serveur distant est indisponible ou vos informations d'identification n'ont pas été reconnues.
i think the problme is how to migrate database from alfresco to mysql please someone can helpe???

Outcomes