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

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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