3.4.e Installation - MySQL is missing

[piski]

Hi all,

I try to install the new 3.4.e to test Activiti preview and his abilities.

I begin the installation and I'm very surprised it don't propose me MySQL database !
I can only choose PostGRESQL  :cry:  … so :

1) Is this a choice to give up MySQL (and for future releases too) or is this an installation packaging mistake ?

2) If this is a mistake, how to overrid the issue ?

3) How upgrade our Alfresco 3.4.b with MySQL to Alfresco 3.4.e with POSTGRESQL ?

Thanks for your replies !

[kjameson]

Steve;

Thanks for your input … I was beginning to think that I was the only one who could
see this migration thing coming … 3.4.e is wonderful … seems more stable … works …
but uses postgresql … I have no problem with that … but how do I get my data over there?

I'm no MYSQL or POSTGRESQL expert … but I took a look at the structures of the two
dat bases … both are 4113 if I remember correctly, bu the structures look totally different
to me … I was hoping theat the engineers at Alfresco could shed some light on this subject …

I'm just moving forward with 3.4.d - MYSQL - Ubuntu 10.4 … I also looked at 3.5 nightly
build … same story … Enterprise 3.4.1 … same story … surely someone had a plan to
cover migration before they committed to default to POSTGRESQL.

Again, thanks for your input …

Regards,

kjameson

[mikeh]

I don't understand why you guys are stressing about migrating the database. If MySQL works for you, then stick with it. We're only using PostgreSQL for *new* installs.

Mike

[piski]

Hi all,

So I'm trying to reinstall Alfresco 3.4.e without Postgresql.

I'm in trouble with :

a) I have to fill some cases during the installation about MySQL drivers … so I take a look on my 3.4.b alfresco-global.properties -> OK

b) I have downloaded and installed MySQL (I was not able to find a compatiblity "scheme") in a separate folder, because it's no longer embedded within Alfresco. According to the wiki (is this up to date ?), I have to run the script \Alfresco\extras\databases\mysql\db_setup.sql … but I don't find the folder "extras" !!!

The transition is a little "rough" for MySQL users, so could you give us the main steps to install a freshly release (not migrate) ?

Thanks !

[mrogers]

Here's the setup script….
You may like to change "alfresco" as appropriate….

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;

[stevericker]

Mike,

Oh, it's because for better or worse, we've always used the installer (or before that the bundled) versions to upgrade.  For example when we moved from 3.3 to 3.4, we just dumped the database, copied over alf_data, renamed the backup lucene index to be the lucene index, imported the database (after dropping the alfresco database and recreating it), and fired it up (with index.recover.mode at FULL).  It's always worked (for about 4 upgrades now) without a hitch.  It's been real handy because we've been experimenting with virtualization (Zen and now KVM) and have been trying various tweaks to the guest and host OS.  In doing so, we must've reinstalled the application a dozen or so times. 

I guess we could just install each of the components manually and not use the bundle, but we've probably just been lazy and have not taken the time to do this and get comfortable with it.  In particular, it's real nice that the database is set up automatically (driver, port, user, database, etc.), open office is there, and all the alfresco-global.properties have been pre-configured. 

I think most of all, we're planning to use Alfresco for a long time to come.  So if Oracle is getting squirrely with MySQL and its open source status, we completely understand the need and desire to move to PostgreSQL for the bundled version.  I guess we're just thinking then that it'll not get easier to work with Oracle/MySQL and we might as well bite the bullet and migrate? 

That's our thinking anyway.

[piski]

I've created the database and run the scripts that you gave to me.

Now, I start my Tomcat but the database remains empty, the database isn't populated with tables !

If I log in from server (or client with HeidiSQL), the connection is OK but the database is empty … the log below didn't show any action to populate the database. If I open Share, it's ok (so the war is well deployed) but the database being empty, the SSO doesn't work.

My alfresco-global.properties :

…
### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.url=jdbc:mysql://localhost:3306/${db.name}?useUnicode=true&characterEncoding=utf8
…
‍‍‍‍‍‍‍‍‍‍

Here is my stdout (partial, the WARN loops endless) :

10:28:54,107  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 309 Web Scripts (+0 failed), 319 URLs
10:28:54,107  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
10:28:54,107  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
10:28:55,091  INFO  [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2728.5442ms)
10:28:55,123  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
10:28:55,169  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
10:28:55,373  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
10:28:55,373  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
10:28:55,560  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
10:28:55,576  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
10:28:55,966  INFO  [site.servlet.SSOAuthenticationFilter] NTLMAuthenticationFilter initialised.
WARN : org.apache.myfaces.shared_impl.util.LocaleUtils - Locale name in faces-config.xml null or empty, setting locale to default locale : fr_FR
WARN : org.springframework.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'baseUrl' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.net.URI)]: [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.lang.String) throws java.net.URISyntaxException]
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Introuvable
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Introuvable
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Introuvable
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Introuvable
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Introuvable
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Introuvable
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Introuvable
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And my stderr :

17 mai 2011 12:06:56 org.apache.catalina.core.StandardService start
INFO: Démarrage du service Catalina
17 mai 2011 12:06:56 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
17 mai 2011 12:06:56 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Déploiement du descripteur de configuration alfresco.xml
17 mai 2011 12:06:56 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Déploiement du descripteur de configuration host-manager.xml
17 mai 2011 12:06:56 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Déploiement du descripteur de configuration manager.xml
17 mai 2011 12:06:56 org.apache.catalina.startup.HostConfig deployWAR
INFO: Déploiement de l'archive awe.war de l'application web
17 mai 2011 12:06:57 org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
17 mai 2011 12:06:57 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring Surf Dispatcher Servlet'
17 mai 2011 12:07:01 org.apache.catalina.startup.HostConfig deployWAR
INFO: Déploiement de l'archive share.war de l'application web
17 mai 2011 12:07:02 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
17 mai 2011 12:07:10 org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
17 mai 2011 12:07:10 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring Surf Dispatcher Servlet'
17 mai 2011 12:07:10 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Déploiement du répertoire ROOT de l'application web
17 mai 2011 12:07:10 org.apache.coyote.http11.Http11AprProtocol start
INFO: Démarrage de Coyote HTTP/1.1 sur http-8080
17 mai 2011 12:07:10 org.apache.coyote.http11.Http11AprProtocol start
INFO: Démarrage de Coyote HTTP/1.1 sur http-80
17 mai 2011 12:07:10 org.apache.coyote.ajp.AjpAprProtocol start
INFO: Starting Coyote AJP/1.3 on ajp-8009
17 mai 2011 12:07:10 org.apache.catalina.startup.Catalina start
INFO: Server startup in 14483 ms
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

How can I test simply the JDBC connection to MySQL (it seems to be a connection issue ?)

Thanks for your help, I'm really stuck !

[grouptechnology]

For 3.4d to 3.4e   Shutdown,  Bbackup - just in case.
Replace the alfresco.war and share.war files with the new version.  
Restart.

I am running Alfresco 3.4.d on Ubuntu 10.10. I have replaced the .war files as you mention and restarted but when I click on 'Alfresco Info' it shows I am still on 3.4.d.

I have reloaded the 'Alfresco' and 'Share' applications using the Tomcat manager. Anything else I am missing?

Thanks!

[img]http://www.lebreck.com/Alfresco34d.JPG[/img]

[mrogers]

I've never seen that screen before  :mrgreen:    Does that agree with what's printed in the alfresco.log?

Occasionally tomcat can fail to deploy a new war, especially if dates of the war file are older than the deployed content.   Try shutting down.   Delete tomcat/webapps/alfresco and tomcat's temp files which will be something like tomcat/work/alfresco (or whatever the path is).

[grouptechnology]

I've never seen that screen before  :mrgreen:    Does that agree with what's printed in the alfresco.log?

Occasionally tomcat can fail to deploy a new war, especially if dates of the war file are older than the deployed content.   Try shutting down.   Delete tomcat/webapps/alfresco and tomcat's temp files which will be something like tomcat/work/alfresco (or whatever the path is).

Thanks for the quick response. I'm going to try that now.

[grouptechnology]

I've never seen that screen before  :mrgreen:    Does that agree with what's printed in the alfresco.log?

Occasionally tomcat can fail to deploy a new war, especially if dates of the war file are older than the deployed content.   Try shutting down.   Delete tomcat/webapps/alfresco and tomcat's temp files which will be something like tomcat/work/alfresco (or whatever the path is).

You were right on! Here's what I did for anyone else trying to upgrade to 3.4.e on Linux 32-bit systems.

1. Stopped Alfresco
2. Removed alfresco.war, share.war, /alfresco and /share from tomcat/webapps directory
3. Deleted all files in tomcat/work/Catalina/localhost
4. Deleted all files in tomcat/temp
5. Copied 3.4.e alfresco.war and share.war into tomcat/webapps directory
6. Started Alfresco

Thanks!

[img]http://www.lebreck.com/Alfresco34e.JPG[/img]