Je viens d'installer alfresco sur une debian sarge,...

[unknown-user]

Bonjour,

Je viens d'installer alfresco sur une debian sarge, mais en me servant d'un serveur mysql distant.

Après quelques recherches sur les forums anglais, j'ai fait ceci :
cd /opt/alfresco/jboss/server/default/conf/alfresco/extension
cp custom-db-connection.properties.sample en custom-db-connection.properties
vi custom-db-connection.properties

db.url=jdbc:mysql://nom_de_serveur/alfresco

J'ai également copié ce fichier dans /opt/alfresco/jboss/server/default/conf

La connexion fonctionne bien en ligne de commande mais en démarrant alfresco, j'obtiens des logs avec le message suivant :

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:107)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:113)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:728)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1258)
        at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2621)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:107)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:113)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:728)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1258)
        at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)

Ai je oublié de faire quelque chose ?
Merci d'avance

[mikael]

Quelques précisions :

Java installé : 1.5.0_07
Alfresco 1.3.0
Mysql 4.1

Voici le début des logs :

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1 doBody
10:12:48,419 INFO  [Server] Starting JBoss (MX MicroKernel)…
10:12:48,420 INFO  [Server] Release ID: JBoss [Zion] 4.0.3SP1 (build: CVSTag=JBoss_4_0_3_SP1 date=200510231054)
10:12:48,424 INFO  [Server] Home Dir: /opt/alfresco/jboss
10:12:48,424 INFO  [Server] Home URL: file:/opt/alfresco/jboss/
10:12:48,426 INFO  [Server] Patch URL: null
10:12:48,427 INFO  [Server] Server Name: default
10:12:48,428 INFO  [Server] Server Home Dir: /opt/alfresco/jboss/server/default
10:12:48,430 INFO  [Server] Server Home URL: file:/opt/alfresco/jboss/server/default/
10:12:48,431 INFO  [Server] Server Temp Dir: /opt/alfresco/jboss/server/default/tmp
10:12:48,501 INFO  [Server] Root Deployment Filename: jboss-service.xml
10:12:49,101 INFO  [ServerInfo] Java version: 1.5.0_07,Sun Microsystems Inc.
10:12:49,101 INFO  [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.5.0_07-b03,Sun Microsystems Inc.
10:12:49,101 INFO  [ServerInfo] OS-System: Linux 2.6.12.6-xenU,i386
10:12:50,539 INFO  [Server] Core system initialized
10:12:56,310 INFO  [WebService] Using RMI server codebase: http://alfresco.mydomain:8083/
10:12:56,439 INFO  [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
10:13:16,816 INFO  [Embedded] Catalina naming disabled
10:13:19,222 INFO  [Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
10:13:19,225 INFO  [Catalina] Initialization processed in 2331 ms
10:13:19,232 INFO  [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5
10:13:19,282 INFO  [StandardHost] XML validation disabled
10:13:19,423 INFO  [Catalina] Server startup in 198 ms
10:13:20,141 INFO  [WebappLoader] Dual registration of jndi stream handler: factory already defined
10:13:24,210 ERROR [LocaleUtils] Locale name null or empty, ignoring
10:13:25,368 INFO  [ContextConfig] Missing application web.xml, using defaults only StandardEngine[jboss.web].StandardHost[localhost].StandardContext[/portal-samples]
10:13:46,624 INFO  [JCRCMS] Starting JCR CMS.
10:13:46,642 INFO  [RepositoryUtil] Repository 'repotest' Name Not Found
10:13:50,331 WARN  [Configurator] No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/opt/alfresco/jboss/server/default/tmp/deploy/tmp38229ehcache.jar!/ehcache-failsafe.xml
10:13:50,409 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.security.store.SecurityPolicy]; using defaults.
10:13:50,740 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.security.store.HbmSecurityConstraint]; using defaults.
10:13:50,957 WARN  [EhCacheProvider] Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
10:13:50,962 WARN  [EhCacheProvider] Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
10:13:54,399 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl]; using defaults.
10:13:54,549 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl]; using defaults.
10:13:54,590 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl]; using defaults.
10:13:54,738 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl]; using defaults.
10:13:54,813 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl]; using defaults.
10:13:54,836 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.dynamic]; using defaults.
10:13:54,842 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl.users]; using defaults.
10:13:54,844 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl.content]; using defaults.
10:13:54,845 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl.strings]; using defaults.
10:13:54,847 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl.prefMap]; using defaults.
10:13:54,849 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.roles]; using defaults.
10:13:55,128 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl]; using defaults.
10:13:55,179 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl]; using defaults.
10:13:55,332 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl.preferencesMap]; using defaults.
10:13:55,334 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl.strings]; using defaults.
10:13:55,373 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl]; using defaults.
10:13:55,763 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode]; using defaults.
10:13:56,711 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.windowStates]; using defaults.
10:13:56,715 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl.declaredProperties]; using defaults.
10:13:56,718 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode.children]; using defaults.
10:13:56,721 WARN  [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.modes]; using defaults.
10:13:58,012 INFO  [LayoutDeployment] create new layout(s), found in :  portal
10:13:58,085 INFO  [LayoutDeployment] done creating new layout(s), found in :  portal
10:13:58,086 INFO  [ThemeDeployment] create new theme(s), found in :  portal
10:13:58,131 INFO  [ThemeDeployment] done creating new theme(s), found in :  portal

[mikael]

Bon, c'est résolu.

Mon problème venait du fait que je n'avais modifié QUE le fichier custom-db-connection.properties

Il fallait également retirer l'extension sample des fichiers suivants :
custom-db-and-data-context.xml.sample
custom-hibernate-dialect.properties.sample
custom-data-location.properties.sample

En fait, tout était indiqué ici : http://wiki.alfresco.com/wiki/Repository_Configuration

Mikael

[michaelh]

C'est une bonne journée, tout se résout "tout seul" si j'ose dire