topic Re: Alfresco 2.0 mysql Error in Alfresco Archive

Alfresco 2.0 mysql Error

burner — Tue, 27 Feb 2007 16:31:16 GMT

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 one17:26:25,886 WARN [alfresco.util.OpenOfficeConnectionTester]

Re: Alfresco 2.0 mysql Error

melkor_kp — Wed, 28 Feb 2007 07:52:57 GMT

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.

Re: Alfresco 2.0 mysql Error

melkor_kp — Wed, 28 Feb 2007 08:30:28 GMT

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.

Re: Alfresco 2.0 mysql Error

burner — Wed, 28 Feb 2007 14:33:42 GMT

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?

Re: Alfresco 2.0 mysql Error

heckle — Wed, 28 Feb 2007 19:08:19 GMT

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.

Re: Alfresco 2.0 mysql Error

kevinr — Wed, 28 Feb 2007 21:52:58 GMT

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

Re: Alfresco 2.0 mysql Error

burner — Fri, 02 Mar 2007 12:18:29 GMT

Thank you i got it!