topic Re: Alfresco 4 Community and MySQL in Alfresco Archive

Alfresco 4 Community and MySQL

heden75 — Sun, 02 Oct 2011 19:45:35 GMT

Hi,I just set up the new Alfresco 4 Community edition but was surprised by the use of Postgres as the default database. I tried both the easy and advanced installation but couldn't change the database to mysql as there are no mysql scripts to populate the database. Any help would be much appreciated

Re: Alfresco 4 Community and MySQL

mrogers — Sun, 02 Oct 2011 19:58:31 GMT

Alfresco 4 community works fine with MySql however as you have seen its no longer an option in the installer. AFAIK the problem was we couldn't get a straight answer about whether we could distribute MySql in the installers.

Perhaps the easiest option is to install with the postgress database and then switch over the database settings to mysql. Or just do a manual install using the alfresco.war file.

Re: Alfresco 4 Community and MySQL

mikeh — Sun, 02 Oct 2011 20:02:36 GMT

Please see http://docs.alfresco.com/3.4/topic/com.alfresco.Enterprise_3_4_0.doc/tasks/mysql-config.html

Thanks,
Mike

Re: Alfresco 4 Community and MySQL

heden75 — Sun, 02 Oct 2011 20:35:52 GMT

Thanks for your explanation but the MySQL database once create does not get populated (neither tables nor data) and the software is not runnning then.

I had a look at the reference document - http://docs.alfresco.com/3.4/topic/com.alfresco.Enterprise_3_4_0.doc/tasks/mysql-config.html -that I used for the version 3.3 installation. Version 4.0 doesn't look to have the same file hierarchy and I actually don't see the advantage to move to the version 4 if we continue to use the version 3.4 scripts.

Arnaud.

Re: Alfresco 4 Community and MySQL

mrogers — Mon, 03 Oct 2011 06:57:28 GMT

If the database tables are "not populated". Then you have not connected to the database properly. Check your alfresco-global. properties. You will also need to delete the contents of alf data from your temporary install with Postgresql.

The quick and dirty way to upgrade is to just shutdown, backup, replace the alfresco and share war files and then restart.

Re: Alfresco 4 Community and MySQL

sjoerdjump — Tue, 15 Nov 2011 22:16:06 GMT

If the database tables are "not populated". Then you have not connected to the database properly. Check your alfresco-global. properties. You will also need to delete the contents of alf data from your temporary install with Postgresql.

The quick and dirty way to upgrade is to just shutdown, backup, replace the alfresco and share war files and then restart.

I will try this first. Having problems with 32 bit linux and alfresco 4.0
Can't seem to find the info i am looking for…

Re: Alfresco 4 Community and MySQL

cloudcontrol — Fri, 18 Nov 2011 08:48:18 GMT

same here- no joy on a CLEAN install of latest nightly build (11/18) - even after deleting the /alf_data/ contents for good measure. Installing from the .war file it does not automatically create the MySQL tables- here is my alfresco-global.properties DB section:

db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306
#

Has Alfresco drank the bitrock Kool-Aid and forgotten how to support those you install manually?

Re: Alfresco 4 Community and MySQL

mrogers — Fri, 18 Nov 2011 10:29:06 GMT

Have you created the empty database for alfresco to use?

create database alfresco DEFAULT CHARACTER SET utf8;
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;

Re: Alfresco 4 Community and MySQL

loftux — Fri, 18 Nov 2011 14:56:40 GMT

In repository.properties file the default db url is
db.url=jdbc:mysql:///${db.name}

That means that setting db.host and db.port has no effect.
You can change it to
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}
(the default one should still work if you are on localhost)

and make sure you grant permissions to the user connecting from the domain as mrogers mentioned.

Re: Alfresco 4 Community and MySQL

jpfi — Fri, 18 Nov 2011 16:33:17 GMT

hi,
you'll have to put the mysql-jdbc-driver in tomcat/lib ( mysql-connector-java-5.x.x-bin.jar) if you havn't done yet.
cheers, jan

Re: Alfresco 4 Community and MySQL

cloudcontrol — Fri, 18 Nov 2011 21:53:03 GMT

hi,
you'll have to put the mysql-jdbc-driver in tomcat/lib ( mysql-connector-java-5.x.x-bin.jar) if you havn't done yet.
cheers, jan

Thanks- when I symlinked to that connector I truncated the name- that must have been it- works fine now.

Re: Alfresco 4 Community and MySQL

lachmac — Wed, 23 Nov 2011 08:12:52 GMT

If the database tables are "not populated". Then you have not connected to the database properly. Check your alfresco-global. properties. You will also need to delete the contents of alf data from your temporary install with Postgresql.

The quick and dirty way to upgrade is to just shutdown, backup, replace the alfresco and share war files and then restart.

I tried the above (on a lab sever, for sure) and it deployed, reindexed etc - but it got stuck running patches. So I went through with a fresh install of 4.0.c on Debian 6, MySQL. Started, it deploys and works. So I shut it down and pointed the alfresco-global.properties to the database of 3.4.d-installation, and copied over the contentstore. I started and got stuck on the same patch -

08:41:47,614 INFO  [org.alfresco.repo.admin.patch.PatchExecuter]    Applying patch 'patch.db-V3.4-AVM-rename-dupes' (Ensures that the database upgrade script has been run.).
08:41:47,618 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.
08:41:47,631 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Failed to apply patch         === 
ID: patch.db-V3.4-AVM-rename-dupes
RESULT: 
10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.‍‍‍‍‍‍‍

Log file below

08:41:15,319 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
08:41:15,402 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
08:41:23,444 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
08:41:26,378 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
08:41:26,380 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
08:41:34,115 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
08:41:34,697 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
08:41:34,755 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No reference schema file, expected: class path resource [org/alfresco/util/schemacomp/reference/MySQLInnoDBDialect-Reference.xml]
08:41:35,044 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Search' subsystem, ID: [Search, managed, lucene]
08:41:35,384 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Search' subsystem, ID: [Search, managed, lucene] complete
08:41:36,551 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
08:41:36,728 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
08:41:36,729 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
08:41:37,048 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
08:41:37,052 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
08:41:37,723 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 84 transactions.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    10 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    20 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    30 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    40 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    50 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    60 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    70 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    80 % complete.
08:41:44,014 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    90 % complete.
08:41:46,465 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    100 % complete.
08:41:46,869 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
08:41:46,881 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 1 AVM Stores
08:41:46,881 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]     Rebuilding index for sitestore
08:41:46,930 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent]   Reindex   100% complete
08:41:46,930 INFO  [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores
08:41:47,117 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /srv/www/alfresco/alf_data
08:41:47,122 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
08:41:47,614 INFO  [org.alfresco.repo.admin.patch.PatchExecuter]    Applying patch 'patch.db-V3.4-AVM-rename-dupes' (Ensures that the database upgrade script has been run.).
08:41:47,618 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.
08:41:47,631 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Failed to apply patch         === 
ID: patch.db-V3.4-AVM-rename-dupes
RESULT: 
10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.
=====================================
08:41:47,633 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 10230001 Not all patches could be applied
   at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:111)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:120)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   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:546)
   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:1277)
   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:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   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:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
08:41:57,990 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
08:41:58,271 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
08:41:58,271 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
08:41:58,276 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
08:42:00,287 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 312 Web Scripts (+0 failed), 322 URLs
08:42:00,289 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
08:42:00,289 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
08:42:00,378 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2087.2498ms)
08:42:00,385 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
08:42:00,389 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Update 2011-11-23 I applied the patch, as outlined in JIRA https://issues.alfresco.com/jira/browse/ALF-11646. System starts, all indexing and patches went through. Thanks all for help and patience. You rock!

Re: Alfresco 4 Community and MySQL

mrogers — Wed, 23 Nov 2011 09:07:23 GMT

There was another thread about this yesterday. This needs to be raised in JIRA.