AnsweredAssumed Answered

Install into Existing JBoss - MySql on port 63306

Question asked by arnieaustin on May 31, 2006
Latest reply on Jul 2, 2006 by kevinr
I have a working JBoss AS (4.0.4ga) & Portal (2.2.1) setup. The instructions say to just copy the .war to the /deploy folder and I should be good to go (yes, I have a database ready to go). But that won't work as my MySQL server is listening on a non-standard port. So, I extracted the war file to the /deploy/alfresco.war folder and edited the /WEB-INF/classes/alfresco/repository.properties file thusly:

# Database configuration

db.driver=org.gjt.mm.mysql.Driver
db.name=alfresco
db.url=jdbc:mysql://localhost:63306/${db.name}
db.username=alfresco
db.password=alfresco

I also moved the myfaces*.jar files from inside the war to the /default/lib folder and removed the ones from the tomcat.war.

That didn't work. So then I tried this:

db.url=jdbc:mysql://localhost:63306/alfresco

Alfresco does seem to start and it creates 14 tables (applied_patch .. version_count) but now the portal doesn't respond at all. I modified my server.xml file so I can get to http://localhost/portal/index.html but now it never responds. Neither does /alfresco either. The server log is now huge, I give only the last few lines…
——————————————-
16:16:38,953 INFO  [STDOUT] 16:16:38,953 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.inte
grity.IntegrityChecker, method=onDeleteNode] to policy {http://www.alfresco.org}onDeleteNode for service org.alfresco.re
po.node.integrity.IntegrityChecker@c08964
16:16:38,953 INFO  [STDOUT] 16:16:38,953 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.inte
grity.IntegrityChecker, method=onAddAspect] to policy {http://www.alfresco.org}onAddAspect for service org.alfresco.repo
.node.integrity.IntegrityChecker@c08964
16:16:38,953 INFO  [STDOUT] 16:16:38,953 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.inte
grity.IntegrityChecker, method=onRemoveAspect] to policy {http://www.alfresco.org}onRemoveAspect for service org.alfresc
o.repo.node.integrity.IntegrityChecker@c08964
16:16:38,953 INFO  [STDOUT] 16:16:38,953 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.inte
grity.IntegrityChecker, method=onCreateChildAssociation] to association policy {http://www.alfresco.org}onCreateChildAss
ociation for service org.alfresco.repo.node.integrity.IntegrityChecker@c08964
16:16:38,953 INFO  [STDOUT] 16:16:38,953 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.inte
grity.IntegrityChecker, method=onDeleteChildAssociation] to association policy {http://www.alfresco.org}onDeleteChildAss
ociation for service org.alfresco.repo.node.integrity.IntegrityChecker@c08964
16:16:38,953 INFO  [STDOUT] 16:16:38,953 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.inte
grity.IntegrityChecker, method=onCreateAssociation] to association policy {http://www.alfresco.org}onCreateAssociation f
or service org.alfresco.repo.node.integrity.IntegrityChecker@c08964
16:16:38,953 INFO  [STDOUT] 16:16:38,953 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.inte
grity.IntegrityChecker, method=onDeleteAssociation] to association policy {http://www.alfresco.org}onDeleteAssociation f
or service org.alfresco.repo.node.integrity.IntegrityChecker@c08964
16:16:39,593 INFO  [STDOUT] 16:16:39,593 INFO  [RAMJobStore] RAMJobStore initialized.
16:16:39,593 INFO  [STDOUT] 16:16:39,593 INFO  [StdSchedulerFactory] Quartz scheduler 'QuartzScheduler' initialized from
an externally provided properties instance.
16:16:39,593 INFO  [STDOUT] 16:16:39,593 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.4.5
16:16:39,593 INFO  [STDOUT] 16:16:39,593 INFO  [SchedulerFactoryBean] Starting Quartz scheduler now
16:16:39,593 INFO  [STDOUT] 16:16:39,593 INFO  [QuartzScheduler] Scheduler QuartzScheduler_$_NON_CLUSTERED started.
16:16:39,781 ERROR [STDERR] May 31, 2006 4:16:39 PM net.sf.joott.uno.UnoConnection connect
INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…
16:16:41,328 ERROR [STDERR] May 31, 2006 4:16:41 PM net.sf.joott.uno.UnoConnection connect
SEVERE: connection failed: com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused: connect
16:16:41,406 ERROR [STDERR] May 31, 2006 4:16:41 PM net.sf.joott.uno.UnoConnection connect
INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…
16:16:42,343 ERROR [STDERR] May 31, 2006 4:16:42 PM net.sf.joott.uno.UnoConnection connect
SEVERE: connection failed: com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused: connect

Outcomes