How do I download Mysql database dump

kharkov_max — Sun, 14 Nov 2010 16:56:38 GMT

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 s

Re: How do I download Mysql database dump

loftux — Sun, 14 Nov 2010 17:12:21 GMT

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.

Re: How do I download Mysql database dump

kharkov_max — Sun, 14 Nov 2010 17:28:47 GMT

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 …..

Re: How do I download Mysql database dump

loftux — Sun, 14 Nov 2010 17:40:57 GMT

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.

Re: How do I download Mysql database dump

kharkov_max — Sun, 14 Nov 2010 18:05:16 GMT

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.

Re: How do I download Mysql database dump

loftux — Sun, 14 Nov 2010 18:20:49 GMT

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).

Re: How do I download Mysql database dump

kharkov_max — Mon, 15 Nov 2010 10:03:17 GMT

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
‍‍‍‍‍‍

Re: How do I download Mysql database dump

kharkov_max — Mon, 15 Nov 2010 11:55:35 GMT

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.

topic Re: How do I download Mysql database dump in Alfresco Archive

How do I download Mysql database dump

Re: How do I download Mysql database dump

Re: How do I download Mysql database dump

Re: How do I download Mysql database dump

Re: How do I download Mysql database dump

Re: How do I download Mysql database dump

Re: How do I download Mysql database dump

Re: How do I download Mysql database dump