Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Enterprise Platforms
- Alfresco
- Alfresco Archive
- Re: Migrating from windows to Ubuntu
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Migrating from windows to Ubuntu
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2010 05:59 AM
Since I have problems with CIFS on windows, I'm in the process of migrating Alfresco 3.2r2 to Ubuntu (CIFS worked like that during a test). I started with a working Ubuntu setup running alfresco 3.2 (not r2).
Next I created a new mysql database "alfresco2" and imported the mysqldump from the windows database, gave user alfresco all privileges, and changed the db.name in alfresco-global.properties.
Then I copied the alfresco.war file from windows to the webapps dir, renamed the original war, deleted the alfresco directory, and restarted tomcat6.
What amazes me is that I get "Can't create table 'alfresco2.#sql-7fc_74'".
1. Why in the world would the schema updater run? The WAR en database are in sync.
2. Why can't the table be created, user alfresco has all privileges on the database alfresco2?
Next I created a new mysql database "alfresco2" and imported the mysqldump from the windows database, gave user alfresco all privileges, and changed the db.name in alfresco-global.properties.
Then I copied the alfresco.war file from windows to the webapps dir, renamed the original war, deleted the alfresco directory, and restarted tomcat6.
What amazes me is that I get "Can't create table 'alfresco2.#sql-7fc_74'".
1. Why in the world would the schema updater run? The WAR en database are in sync.
2. Why can't the table be created, user alfresco has all privileges on the database alfresco2?
Labels:
- Labels:
-
Archive
7 REPLIES 7
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2010 06:57 AM
You can't migrate backwards (3.2r2 back to older version 3.2).
I suggest you migrate to exactly the same version of alfresco. Take the WAR file from your source and use it for your target.
Edit - is that what you did?
What did you "rename the existing WAR to" Did it still have the extension .war if so you will still have the "old" alfresco causing chaos?
The update should not run if the version is the same. That it tried to do so indicates that the version is not correct.
There should be more information in the stack trace from mysql. I suspect some sort of permission error or an error restoring your database.
I suggest you migrate to exactly the same version of alfresco. Take the WAR file from your source and use it for your target.
Edit - is that what you did?
What did you "rename the existing WAR to" Did it still have the extension .war if so you will still have the "old" alfresco causing chaos?
The update should not run if the version is the same. That it tried to do so indicates that the version is not correct.
There should be more information in the stack trace from mysql. I suspect some sort of permission error or an error restoring your database.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2010 07:11 AM
You can't migrate backwards (3.2r2 back to older version 3.2).
I suggest you migrate to exactly the same version of alfresco. Take the WAR file from your source and use it for your target.
I have an Alfresco that runs 3.2 and I am copying the 3.2r2 WAR into it. The database also is 3.2 but I exported the 3.2r2 and imported it. So for all means and purposes the Ubuntu 3.2 version is then running 3.2r2, but it still is trying to update the schema.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2010 07:24 AM
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: 06060000 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1386)
at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1258)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)
Caused by: java.sql.SQLException: Can't create table 'alfresco2.#sql-7fc_83' (errno: 121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1092)
at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1046)
at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:744)
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1258)
… 39 more
Jul 6, 2010 7:21:56 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Jul 6, 2010 7:21:56 AM org.apache.catalina.core.ApplicationContext log
INFO: Shutting down Log4J
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2010 10:34 AM
Ok. This is really really strange. I did a complete new install; Ubuntu 10 and Alfresco 3.3. Works. Then I imported the mysql 3.2r2 database and restarted Alfresco: same error!
org.alfresco.error.AlfrescoRuntimeException: 06060000 Schema auto-update failed
Caused by: java.sql.SQLException: Can't create table 'alfresco.#sql-138e_36' (errno: 121)
How can this be? This is Alfresco 3.3!
org.alfresco.error.AlfrescoRuntimeException: 06060000 Schema auto-update failed
Caused by: java.sql.SQLException: Can't create table 'alfresco.#sql-138e_36' (errno: 121)
How can this be? This is Alfresco 3.3!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2010 11:13 AM
Making the mysqldump from Ubuntu instead of Windows does not make a difference.
I'm running out of options.
I'm running out of options.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2010 08:09 AM
Ok. It seems that this may be caused by the fact that Alfresco's installation on windows has the JBMP_* table filenames in lowercase and on Linux these filenames are uppercase.
On windows show tables gives:
On Ubunut show tables gives:
This means that Alfresco create the tables with different case on each OS?
On windows show tables gives:
+——————————–+
| Tables_in_alfresco |
+——————————–+
| alf_access_control_entry |
| alf_access_control_list |
| alf_ace_context |
| alf_acl_change_set |
| alf_acl_member |
| alf_activity_feed |
| alf_activity_feed_control |
| alf_activity_post |
| alf_applied_patch |
| alf_attributes |
| alf_audit_app |
| alf_audit_config |
| alf_audit_date |
| alf_audit_entry |
| alf_audit_fact |
| alf_audit_model |
| alf_audit_source |
| alf_authority |
| alf_authority_alias |
| alf_child_assoc |
| alf_content_clean |
| alf_content_data |
| alf_content_url |
| alf_encoding |
| alf_global_attributes |
| alf_list_attribute_entries |
| alf_locale |
| alf_lock |
| alf_lock_resource |
| alf_map_attribute_entries |
| alf_mimetype |
| alf_namespace |
| alf_node |
| alf_node_aspects |
| alf_node_assoc |
| alf_node_properties |
| alf_permission |
| alf_prop_class |
| alf_prop_date_value |
| alf_prop_double_value |
| alf_prop_link |
| alf_prop_root |
| alf_prop_serializable_value |
| alf_prop_string_value |
| alf_prop_unique_ctx |
| alf_prop_value |
| alf_qname |
| alf_server |
| alf_store |
| alf_transaction |
| alf_usage_delta |
| alf_version_count |
| avm_aspects |
| avm_child_entries |
| avm_history_links |
| avm_merge_links |
| avm_node_properties |
| avm_nodes |
| avm_store_properties |
| avm_stores |
| avm_version_layered_node_entry |
| avm_version_roots |
| jbpm_action |
| jbpm_bytearray |
| jbpm_byteblock |
| jbpm_comment |
| jbpm_decisionconditions |
| jbpm_delegation |
| jbpm_event |
| jbpm_exceptionhandler |
| jbpm_job |
| jbpm_log |
| jbpm_moduledefinition |
| jbpm_moduleinstance |
| jbpm_node |
| jbpm_pooledactor |
| jbpm_processdefinition |
| jbpm_processinstance |
| jbpm_runtimeaction |
| jbpm_swimlane |
| jbpm_swimlaneinstance |
| jbpm_task |
| jbpm_taskactorpool |
| jbpm_taskcontroller |
| jbpm_taskinstance |
| jbpm_token |
| jbpm_tokenvariablemap |
| jbpm_transition |
| jbpm_variableaccess |
| jbpm_variableinstance |
+——————————–+On Ubunut show tables gives:
+——————————–+
| Tables_in_alfresco |
+——————————–+
| JBPM_ACTION |
| JBPM_BYTEARRAY |
| JBPM_BYTEBLOCK |
| JBPM_COMMENT |
| JBPM_DECISIONCONDITIONS |
| JBPM_DELEGATION |
| JBPM_EVENT |
| JBPM_EXCEPTIONHANDLER |
| JBPM_JOB |
| JBPM_LOG |
| JBPM_MODULEDEFINITION |
| JBPM_MODULEINSTANCE |
| JBPM_NODE |
| JBPM_POOLEDACTOR |
| JBPM_PROCESSDEFINITION |
| JBPM_PROCESSINSTANCE |
| JBPM_RUNTIMEACTION |
| JBPM_SWIMLANE |
| JBPM_SWIMLANEINSTANCE |
| JBPM_TASK |
| JBPM_TASKACTORPOOL |
| JBPM_TASKCONTROLLER |
| JBPM_TASKINSTANCE |
| JBPM_TOKEN |
| JBPM_TOKENVARIABLEMAP |
| JBPM_TRANSITION |
| JBPM_VARIABLEACCESS |
| JBPM_VARIABLEINSTANCE |
| alf_access_control_entry |
| alf_access_control_list |
| alf_ace_context |
| alf_acl_change_set |
| alf_acl_member |
| alf_activity_feed |
| alf_activity_feed_control |
| alf_activity_post |
| alf_applied_patch |
| alf_attributes |
| alf_audit_app |
| alf_audit_config |
| alf_audit_date |
| alf_audit_entry |
| alf_audit_fact |
| alf_audit_model |
| alf_audit_source |
| alf_authority |
| alf_authority_alias |
| alf_child_assoc |
| alf_content_clean |
| alf_content_data |
| alf_content_url |
| alf_encoding |
| alf_global_attributes |
| alf_list_attribute_entries |
| alf_locale |
| alf_lock |
| alf_lock_resource |
| alf_map_attribute_entries |
| alf_mimetype |
| alf_namespace |
| alf_node |
| alf_node_aspects |
| alf_node_assoc |
| alf_node_properties |
| alf_permission |
| alf_prop_class |
| alf_prop_date_value |
| alf_prop_double_value |
| alf_prop_link |
| alf_prop_root |
| alf_prop_serializable_value |
| alf_prop_string_value |
| alf_prop_unique_ctx |
| alf_prop_value |
| alf_qname |
| alf_server |
| alf_store |
| alf_transaction |
| alf_usage_delta |
| alf_version_count |
| avm_aspects |
| avm_child_entries |
| avm_history_links |
| avm_merge_links |
| avm_node_properties |
| avm_nodes |
| avm_store_properties |
| avm_stores |
| avm_version_layered_node_entry |
| avm_version_roots |
+——————————–+
This means that Alfresco create the tables with different case on each OS?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2010 08:42 AM
To be more exact; the Alfresco community edition windows installation has not configured mysql so that easy migration to Linux is possible.
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
I have 'sed"ed all JBPM tables in the dump from lowercase to uppercase and then it worked.
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
I have 'sed"ed all JBPM tables in the dump from lowercase to uppercase and then it worked.
cat $1 |
sed "s/\`jbpm_action\`/\`JBPM_ACTION\`/g" |
sed "s/\`jbpm_bytearray\`/\`JBPM_BYTEARRAY\`/g" |
sed "s/\`jbpm_byteblock\`/\`JBPM_BYTEBLOCK\`/g" |
sed "s/\`jbpm_comment\`/\`JBPM_COMMENT\`/g" |
sed "s/\`jbpm_decisionconditions\`/\`JBPM_DECISIONCONDITIONS\`/g" |
sed "s/\`jbpm_delegation\`/\`JBPM_DELEGATION\`/g" |
sed "s/\`jbpm_event\`/\`JBPM_EVENT\`/g" |
sed "s/\`jbpm_exceptionhandler\`/\`JBPM_EXCEPTIONHANDLER\`/g" |
sed "s/\`jbpm_job\`/\`JBPM_JOB\`/g" |
sed "s/\`jbpm_log\`/\`JBPM_LOG\`/g" |
sed "s/\`jbpm_moduledefinition\`/\`JBPM_MODULEDEFINITION\`/g" |
sed "s/\`jbpm_moduleinstance\`/\`JBPM_MODULEINSTANCE\`/g" |
sed "s/\`jbpm_node\`/\`JBPM_NODE\`/g" |
sed "s/\`jbpm_pooledactor\`/\`JBPM_POOLEDACTOR\`/g" |
sed "s/\`jbpm_processdefinition\`/\`JBPM_PROCESSDEFINITION\`/g" |
sed "s/\`jbpm_processinstance\`/\`JBPM_PROCESSINSTANCE\`/g" |
sed "s/\`jbpm_runtimeaction\`/\`JBPM_RUNTIMEACTION\`/g" |
sed "s/\`jbpm_swimlane\`/\`JBPM_SWIMLANE\`/g" |
sed "s/\`jbpm_swimlaneinstance\`/\`JBPM_SWIMLANEINSTANCE\`/g" |
sed "s/\`jbpm_task\`/\`JBPM_TASK\`/g" |
sed "s/\`jbpm_taskactorpool\`/\`JBPM_TASKACTORPOOL\`/g" |
sed "s/\`jbpm_taskcontroller\`/\`JBPM_TASKCONTROLLER\`/g" |
sed "s/\`jbpm_taskinstance\`/\`JBPM_TASKINSTANCE\`/g" |
sed "s/\`jbpm_token\`/\`JBPM_TOKEN\`/g" |
sed "s/\`jbpm_tokenvariablemap\`/\`JBPM_TOKENVARIABLEMAP\`/g" |
sed "s/\`jbpm_transition\`/\`JBPM_TRANSITION\`/g" |
sed "s/\`jbpm_variableaccess\`/\`JBPM_VARIABLEACCESS\`/g" |
sed "s/\`jbpm_variableinstance\`/\`JBPM_VARIABLEINSTANCE\`/g" |
cat
Related Content
- Configuring Amazon S3 Bucket for Data Storage in Alfresco Community Edition 7.2.2 in Alfresco Forum
- Using Bulk Import with Alfresco 23.x in Alfresco Forum
- Alfresco Installation using WSL and Ubuntu in Alfresco Forum
- Alfresco Community v4.0 (2012), Ubuntu 12.04, Mysql 5.5 in Alfresco Forum
- AOS + Kerberos SSO: Login popup appears in Alfresco Forum
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
