topic Re: 3.4.e Installation - MySQL is missing in Alfresco Archive

3.4.e Installation - MySQL is missing

piski — Mon, 09 May 2011 10:25:34 GMT

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 installatio

Re: 3.4.e Installation - MySQL is missing

mrogers — Mon, 09 May 2011 10:27:51 GMT

You will need to do a "manual" install to use MySql.

Given that you already have it that's just a trivial change to your alfresco-global.properties.

Re: 3.4.e Installation - MySQL is missing

piski — Tue, 10 May 2011 07:04:59 GMT

Hello,

Thanks for your reply.

Will it be the case for future releases, Postgresql by default ?

Re: 3.4.e Installation - MySQL is missing

mrogers — Tue, 10 May 2011 08:19:27 GMT

Yes. We can't distribute mysql for legal reasons.

Re: 3.4.e Installation - MySQL is missing

piski — Tue, 10 May 2011 08:39:28 GMT

So it will make sense to migrate to Postgresql to simplify next upgrades then !

According to you, Postgresql is more fast / reliable than MySQL, at least for Alfresco solution ?

Re: 3.4.e Installation - MySQL is missing

mrogers — Tue, 10 May 2011 09:32:56 GMT

No. There is no need to migrate from one to the other. I suggest you keep running with what you are already familiar with.

Re: 3.4.e Installation - MySQL is missing

kjameson — Fri, 13 May 2011 15:12:15 GMT

I am running Ubuntu 10.4 server … Alfresco 3.4.d … MYSQL …
I too was shocked to see the latest Alfresco with no MYSQL … I
could get no info as to why? I agree that it would make sense
to migrate to POSTGRESQL … problem is I hate to re-type all
data … so … Is there an "Alfresco approved" method / procedure
to migrate old data to POSTGRESQL … I attempted a manual
install of MYSQL over 3.4.e … swapping out WAR files … and there
is no MYSQL … the installers make such a nice clean install … everything
is in one place … the manual install would have POSTGRESQL in the
/opt/Alfresco-3.4.e area & MYSQLin the Ubuntu area … a bit confusing
and "hacked up" … I spent hours doing manual installs … never got it to run.
I too would really like to move toward where ALFRESCO is apparently
moving … POSTGRESQL …Any info will be greatly appreciated!

KMJ

Re: 3.4.e Installation - MySQL is missing

mrogers — Fri, 13 May 2011 15:34:49 GMT

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

Re: 3.4.e Installation - MySQL is missing

kjameson — Fri, 13 May 2011 20:48:52 GMT

What about AWE.WAR / WCMQS.WAR ???
The above procedure works … if you are only using alfresco / share wars …
I couldn't get it to work if system has all 4 wars …

Apparently the switch is due to legal issues … re: MYSQL …
but nobody wants to share … does Alfresco have a plan to migrate
from MYSQL to POSTGRESQL …??? If so … how??
I'd prefer to make that kind of a move … before I have a million documents …
I'm (sort of) content with 3.4.d … but 3.4.e is definitely more stable …
(I have no need for Activiti) the old work flow seems OK (for my use)

Thanks again … KMJ

Re: 3.4.e Installation - MySQL is missing

stevericker — Mon, 16 May 2011 03:22:28 GMT

Just to add to the conversation, for what it's worth, I've been digging into what a migration/conversion from MySQL to PostgreSQL would take. It is not trivial, and there does not seem to be any automated way of doing it. The alfresco schema should be fairly generic (ANSI compliant?) but here were some notes from someone that did this:

http://issues.alfresco.com/jira/browse/ALF-7896

I agree that the installer makes life so much easier. Unfortunately, we've got lots of data already, so it seems like we're faced with the migration from MySQL to Postgres at some point? It seems like simply replacing the .war files won't be enough for major upgrades?

What we've been doing as upgrades came out was a dump and restore for the database while copying over alf_data all into a freshly installed (recently via the installer) version. If we want to keep doing it this way, again, the migration seems inevitable.

Because of this, could someone share any experiences they've had with such a migration? Or, alternatively, does anyone know of any Alfresco nuances in terms of its compliance with SQL "standards?" Thanks.

Re: 3.4.e Installation - MySQL is missing

kjameson — Mon, 16 May 2011 04:06:26 GMT

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

Re: 3.4.e Installation - MySQL is missing

mikeh — Mon, 16 May 2011 07:27:11 GMT

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

Re: 3.4.e Installation - MySQL is missing

piski — Mon, 16 May 2011 12:31:29 GMT

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 !

Re: 3.4.e Installation - MySQL is missing

mrogers — Mon, 16 May 2011 13:39:29 GMT

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;

Re: 3.4.e Installation - MySQL is missing

stevericker — Mon, 16 May 2011 13:55:50 GMT

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.

Re: 3.4.e Installation - MySQL is missing

piski — Mon, 16 May 2011 14:40:51 GMT

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 !

Re: 3.4.e Installation - MySQL is missing

grouptechnology — Thu, 09 Jun 2011 17:29:37 GMT

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]

Re: 3.4.e Installation - MySQL is missing

mrogers — Thu, 09 Jun 2011 18:06:50 GMT

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).

Re: 3.4.e Installation - MySQL is missing

grouptechnology — Thu, 09 Jun 2011 18:12:16 GMT

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.

Re: 3.4.e Installation - MySQL is missing

grouptechnology — Thu, 09 Jun 2011 19:23:00 GMT

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]