AnsweredAssumed Answered

Migation labs community 3.0 vers 3.3g

Question asked by nelsou on Jul 15, 2010
Latest reply on Jul 16, 2010 by nelsou
Serveur Mac OS X leopard

Bonjour,

Suite à des problèmes d'instabilités de la version 3.0 notamment avec le Share. Je désire migrer vers le 3.3.

Étapes réalisées :

- Shutdown de l'ancienne version d'alfresco (3.0)
- Sauvegarde de la base Mysql
- intallation du package : Alfresco-Community-3.3g-MacOSXInstall.tar.gz dans un nouveau répertoire sans installation de la BD
- configuration des parametres Mysql.
- creation d'une nouvelle database Mysql Alfresco
- puis exécution d'alfresco

Après une première exécution de alfresco.sh j'ai des erreurs dans alfresco.log
J'ai recherché dans les différents posts des sujets sur ce type d'erreurs mais rien trouvé pour l'instant.
Je ne suis pas vraiment familier avec les erreurs JAVA, ainsi que le célèbre erreur 404 lors de l'affichage d'une page.

Si vous avez des éléments qui puissent me faire avancer je vous en remercie.

Cordialement,

Nelson

'Alfresco_new/extras/databases/mysql/db_setup.sql'

create database alfresco_labs default character set utf8 collate utf8_bin;
grant all on alfresco_labs.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco_labs.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

'tomcat/shared/classes/alfresco-global.properties'
###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#————-
dir.root=/Users/admin/Alfresco_new/alf_data

#
# Sample database connection properties
#————-
db.name=alfresco_labs
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306

#
# External locations
#————-
ooo.exe=/Users/admin/Alfresco_new/OpenOffice.org.app/Contents/MacOS/soffice
ooo.user=/Users/admin/Alfresco_new/alf_data/oouser
jodconverter.officeHome=/Users/admin/Alfresco_new/OpenOffice.org.app/Contents
jodconverter.portNumbers=8101
#ooo.enabled=false
#jodconverter.enabled=true
img.root=/Users/admin/Alfresco_new/ImageMagick
swf.exe=/Users/admin/Alfresco_new/bin/pdf2swf

#
# Initial admin password
#————-
alfresco_user_store.adminpassword=cf2eb099e1c149dcac49da8dde9e2222

#
# MySQL connection
#————-
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}



'alfresco.log'
17:59:31,518 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
17:59:31,521 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
17:59:31,522 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/Users/admin/Alfresco_new/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/test/alfresco-global.properties]
17:59:31,522 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/Users/admin/Alfresco_new/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/tests/alfresco-global.properties]
17:59:31,522 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/Users/admin/Alfresco_new/tomcat/shared/classes/alfresco-global.properties]
17:59:31,562 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
17:59:34,154 WARN  [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)

Outcomes