Alfresco 2.0 mysql Error

[burner]

Hello i followed the instructins to install the war file.

I use Tomcat 5.5.20 and mysql 4.1.12.

After doing everything i got this error:

17:26:22,714 WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
17:26:25,886 WARN  [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
17:26:29,245 INFO  [domain.schema.SchemaBootstrap] Generating unmodified schema creation script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-46567.sql
17:26:29,339 INFO  [domain.schema.SchemaBootstrap] Executing database script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-46567.sql
17:26:55,685 INFO  [domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/2.0/${db.script.dialect}/AlfrescoPostCreate-2.0-FKIndexes.sql
17:27:40,723 WARN  [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
17:27:45,927 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to read zip file due to Cp437
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:83)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:227)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:430)
   … 33 more
Caused by: java.util.zip.ZipException: Cp437
   at org.apache.tools.zip.ZipFile.getString(ZipFile.java:454)
   at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:298)
   at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:142)
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:79)
   … 35 more
17:27:45,942 ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to read zip file due to Cp437
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:83)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:227)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:430)
   … 33 more
Caused by: java.util.zip.ZipException: Cp437
   at org.apache.tools.zip.ZipFile.getString(ZipFile.java:454)
   at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:298)
   at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:142)
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:79)
   … 35 more
17:27:45,942 ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to read zip file due to Cp437
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:83)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:227)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:430)
   … 33 more
Caused by: java.util.zip.ZipException: Cp437
   at org.apache.tools.zip.ZipFile.getString(ZipFile.java:454)
   at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:298)
   at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:142)
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:79)
   … 35 more

Can someone help me?

[melkor_kp]

I am using Ubuntu (Concretely XUbuntu), I installed mysql from the ubuntu
repositories, I installed the java virtual machine 1.5 revision 11 and I get
exactly the same error.

I installed alfresco from AlfrescoCommunity-2.0-Linux-x86-Install

I deleted the files explained in the directory, I removed all the directories in
Alf_data and I created the database tables. This process worked properly
for the version 1.4.AlfrescoCommunity-2.0-Linux-x86-Install


Does anybody know what is happening.

[melkor_kp]

Ok, It is working for me.
What you should do is the following:

Install the java jdk 1.5 (in my case version 11)
Add the java to the variable $PATH 
Define the variable JAVA_HOME pointing to the java machine directory
Delete the directory content of /opt/Alfresco/alf_data/
Delete the files custom-db-and-data-context.xml
                            custom-db-connection.properties
                            custom-hibernate-dialect.properties
This files are stored in /opt/Alfresco/tomcat/shared/classes/alfresco/extension
mysql -u root -p < /opt/Alfresco/extras/databases/mysql/db_remove.sql
mysql -u root -p < /opt/Alfresco/extras/databases/mysql/db_setup.sql
Then ensure is not tomcat running with /etc/init.d/tomcat5 stop
And ensure that it is not any instance of alfresco runnig with
ps -aux | grep java. With killall java you can stop any instance running.‍‍‍‍‍‍‍‍‍‍‍‍‍

Following this instructions it worked to me in a Ubuntu distro. I hope this
would be useful for you.

[burner]

Hi thanx dor the reply.Thats what i thought too, that its because i took JAva 11 update but why?

I removed the update to have it runn.

But i still have some warnings:

15:26:42,465 WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
15:27:00,512 WARN  [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
15:27:05,106 INFO  [domain.schema.SchemaBootstrap] Generating unmodified schema creation script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-34335.sql
15:27:05,231 INFO  [domain.schema.SchemaBootstrap] Executing database script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-34335.sql
15:27:31,778 INFO  [domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/2.0/${db.script.dialect}/AlfrescoPostCreate-2.0-FKIndexes.sql
15:28:11,090 WARN  [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
15:29:59,465 INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: c:\alf_data
15:29:59,512 INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
15:29:59,715 INFO  [repo.module.ModuleServiceImpl] Found 0 module(s).
15:30:01,137 INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_10-b03; maximum heap size 63,313MB
15:30:01,137 WARN  [service.descriptor.DescriptorService] Alfresco JVM - WARNING - maximum heap size 63,313MB is less than recommended 512MB
15:30:01,137 INFO  [service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 2.0.0 (build-185) schema 38 - Installed version 2.0.0 (build-185) schema 38

The synchronization with the indexes sounds bad!How can i get it right and how can i make the heapsize bigger?

[heckle]

If you do not have any data on this system (i.e. this system is NOT already in production) try deleting the alf_data directory and delete the alfresco database in mysql. Recreate the alfresco database and try to startup tomcat again.

[kevinr]

how can i make the heapsize bigger?

Edit the values JAVA_OPTS to something like this:
-Xms256m -Xmx512m
in your catalina.bat/catalina.sh files as appropriate.

Thanks,

Kevin

[burner]

Thank you i got it!