cancel
Showing results for 
Search instead for 
Did you mean: 

How do I download Mysql database dump

kharkov_max
Champ in-the-making
Champ in-the-making
From site http://process.alfresco.com/ccdl/?file=release/community/build-3262/alfresco-community-3.4.b.zip uploaded file.
Through Tomkat6 unpacked war.
In Mysql 5.5.7 and created a user database alfresco.
Now try to find the file db_setup.sql, for what would get a base in Mysql server.
File not …
So it should be?

I set the system alfresco3.4b freebsd8.1.
Version 3.3g on Freebsd8.1 works fine.
7 REPLIES 7

loftux
Star Contributor
Star Contributor
You can create that file yourself
create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
Then run
mysql -u root -p < db_setup.sql

Tables etc in the database is created when Alfresco starts for the first time.

kharkov_max
Champ in-the-making
Champ in-the-making
Thank you for having responded.

I know how to base load))))

Where to get file db_setup.sql?
As I downloaded the archive, I have not found …..

loftux
Star Contributor
Star Contributor
But I just told, create that file (db_setup.sql) with the content in that is in the CODE markup. That is all that is in that file.
The rest is done by alfresco.war when it starts up.

kharkov_max
Champ in-the-making
Champ in-the-making
Hmm.
Database I made and the user is also given.

Reboot alfresco.war result not given.

Tried, through your Sql query - does not work either.
Database after the deployment of war yet.

loftux
Star Contributor
Star Contributor
http://wiki.alfresco.com/wiki/Install_Tomcat6
You probably need to change the config for Tomcat so that it picks up alfresco-global.properties (I assume you have updated this file so that db connection properties are correct).

kharkov_max
Champ in-the-making
Champ in-the-making
I copied the Mysql connector from the archive in the Tomcat / lib.
And properly configured alfresco-global.properties
For all database connection Mysql should work.
In the log I see this:

11:36:12,235 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'SearchService' while setting bean property 'searchService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'SearchService' defined in class path resource [alfresco/public-services-context.xml]: Cannot resolve reference to bean 'searchService' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'searchService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'indexerAndSearcherFactory' while setting bean property 'indexerAndSearcherFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'admLuceneIndexerAndSearcherFactory' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'admLuceneIndexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'contentService' while setting bean property 'contentService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentService' defined in class path resource [alfresco/content-services-context.xml]: Cannot resolve reference to bean 'nodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'nodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mlPropertyInterceptor' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'multilingualContentService' while setting bean property 'multilingualContentService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'multilingualContentService' defined in class path resource [alfresco/model-specific-services-context.xml]: Cannot resolve reference to bean 'fileFolderService' while setting bean property 'fileFolderService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'fileFolderService' defined in class path resource [alfresco/model-specific-services-context.xml]: Cannot resolve reference to bean 'copyService' while setting bean property 'copyService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'copyService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'NodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'NodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'AuditMethodInterceptor' defined in class path resource [alfresco/public-services-context.xml]: Cannot resolve reference to bean 'auditComponent' while setting bean property 'auditComponent'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'auditComponent' defined in class path resource [alfresco/audit-services-context.xml]: Cannot resolve reference to bean 'Audit' while setting bean property 'auditModelRegistry'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'Audit' defined in class path resource [alfresco/bootstrap-context.xml]: Invocation of init method failed; nested exception is org.alfresco.repo.audit.model.AuditModelException: 10150001 Failed to load audit model: file:/usr/local/apache-tomcat-6.0/webapps/alfresco/WEB-INF/classes/alfresco/audit/alfresco-audit-cmis.xml
…………….
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'SearchService' defined in class path resource [alfresco/public-services-context.xml]: Cannot resolve reference to bean 'searchService' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'searchService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'indexerAndSearcherFactory' while setting bean property 'indexerAndSearcherFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'admLuceneIndexerAndSearcherFactory' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'admLuceneIndexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'contentService' while setting bean property 'contentService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentService' defined in class path resource [alfresco/content-services-context.xml]: Cannot resolve reference to bean 'nodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'nodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mlPropertyInterceptor' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'multilingualContentService' while setting bean property 'multilingualContentService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'multilingualContentService' defined in class path resource [alfresco/model-specific-services-context.xml]: Cannot resolve reference to bean 'fileFolderService' while setting bean property 'fileFolderService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'fileFolderService' defined in class path resource [alfresco/model-specific-services-context.xml]: Cannot resolve reference to bean 'copyService' while setting bean property 'copyService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'copyService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'NodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'NodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'AuditMethodInterceptor' defined in class path resource [alfresco/public-services-context.xml]: Cannot resolve reference to bean 'auditComponent' while setting bean property 'auditComponent'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'auditComponent' defined in class path resource [alfresco/audit-services-context.xml]: Cannot resolve reference to bean 'Audit' while setting bean property 'auditModelRegistry'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'Audit' defined in class path resource [alfresco/bootstrap-context.xml]: Invocation of init method failed; nested exception is org.alfresco.repo.audit.model.AuditModelException: 10150001 Failed to load audit model: file:/usr/local/apache-tomcat-6.0/webapps/alfresco/WEB-INF/classes/alfresco/audit/alfresco-audit-cmis.xml

kharkov_max
Champ in-the-making
Champ in-the-making
My question is removed …
I was able to solve the problem of installation.

Carefully reviewing the log, I found the problem "needs 2.1 API"
On the advice of http://wiki.alfresco.com/wiki/Alfresco_Labs_3b_Release_Notes copied the file and it worked.

Thank you all.