AnsweredAssumed Answered

hang on installation jboss-win2k-oracle

Question asked by peltuinum on Jan 13, 2008
I'm trying to install an Alfresco Communitity Ed. v 2.1.0 on a Win2K Server with an Oracle 9 DB.

I customized the files according to specifications and deployed the .war file to /default/deploy dir.
When launching JBoss , the startup hangs after these messages:
"…..
INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.integrity.IncompleteNodeTagger, method=onCreateChildAssociation] to association policy {http://www.alfresco.org}onCreateChildAssociation for service org.alfresco.repo.node.integrity.IncompleteNodeTagger@1176e5c
2008-01-13 13:23:18,946 INFO  [STDOUT] 13:23:18,946 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.integrity.IncompleteNodeTagger, method=onDeleteChildAssociation] to association policy {http://www.alfresco.org}onDeleteChildAssociation for service org.alfresco.repo.node.integrity.IncompleteNodeTagger@1176e5c
2008-01-13 13:23:18,946 INFO  [STDOUT] 13:23:18,946 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.integrity.IncompleteNodeTagger, method=onCreateAssociation] to association policy {http://www.alfresco.org}onCreateAssociation for service org.alfresco.repo.node.integrity.IncompleteNodeTagger@1176e5c
2008-01-13 13:23:18,946 INFO  [STDOUT] 13:23:18,946 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.node.integrity.IncompleteNodeTagger, method=onDeleteAssociation] to association policy {http://www.alfresco.org}onDeleteAssociation for service org.alfresco.repo.node.integrity.IncompleteNodeTagger@1176e5c
2008-01-13 13:23:19,008 INFO  [STDOUT] 13:23:19,008 INFO  [AbstractTriggerBean] Job ftsIndexerTrigger is active
2008-01-13 13:23:19,024 INFO  [STDOUT] 13:23:19,024 INFO  [AbstractTriggerBean] Job tempFileCleanerTrigger is active
2008-01-13 13:23:19,071 INFO  [STDOUT] 13:23:19,071 INFO  [AbstractTriggerBean] Job contentStoreCleanerTrigger is active
2008-01-13 13:23:19,086 INFO  [STDOUT] 13:23:19,086 INFO  [AbstractTriggerBean] Job indexBackupTrigger is active
2008-01-13 13:23:19,102 INFO  [STDOUT] 13:23:19,102 WARN  [AbstractTriggerBean] Job ehCacheTracerJob is not active
2008-01-13 13:23:19,117 INFO  [STDOUT] 13:23:19,117 INFO  [AbstractTriggerBean] Job avmOrphanReaperJob is active
2008-01-13 13:23:19,133 INFO  [STDOUT] 13:23:19,133 INFO  [AbstractTriggerBean] Job avmExpiredContentTrigger is active
2008-01-13 13:23:20,461 INFO  [STDOUT] 13:23:20,461 WARN  [OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
2008-01-13 13:23:21,664 INFO  [STDOUT] 13:23:21,664 WARN  [AbstractMappingMetadataExtracter] connection failed: socket,host=localhost,port=8100,tcpNoDelay=1: java.net.ConnectException: Connection refused: connect
2008-01-13 13:23:23,195 INFO  [STDOUT] 13:23:23,195 WARN  [OpenOfficeContentTransformer] connection failed: socket,host=localhost,port=8100,tcpNoDelay=1: java.net.ConnectException: Connection refused: connect
2008-01-13 13:23:23,680 INFO  [STDOUT] 13:23:23,680 INFO  [PolicyComponentImpl] Bound Java method[class=org.alfresco.repo.security.person.HomeFolderManager, method=onCreateNode] to policy {http://www.alfresco.org}onCreateNode for class {http://www.alfresco.org/model/content/1.0}person
2008-01-13 13:23:23,774 INFO  [STDOUT] 13:23:23,774 INFO  [workflow] Registered Workflow Component 'jbpm' (class org.alfresco.repo.workflow.jbpm.JBPMEngine)
2008-01-13 13:23:23,774 INFO  [STDOUT] 13:23:23,774 INFO  [workflow] Registered Task Component 'jbpm' (class org.alfresco.repo.workflow.jbpm.JBPMEngine)
2008-01-13 13:23:23,836 INFO  [STDOUT] 13:23:23,836 INFO  [DictionaryDAO] Loading model from alfresco/model/jcrModel.xml
2008-01-13 13:23:23,852 INFO  [STDOUT] 13:23:23,852 INFO  [DictionaryDAO] Registered model jcr:jcrmodel
2008-01-13 13:23:23,852 INFO  [STDOUT] 13:23:23,852 INFO  [DictionaryDAO] Registered namespace 'http://www.jcp.org/jcr/1.0' (prefix 'jcr')
2008-01-13 13:23:23,852 INFO  [STDOUT] 13:23:23,852 INFO  [DictionaryDAO] Registered namespace 'http://www.jcp.org/jcr/nt/1.0' (prefix 'nt')
2008-01-13 13:23:23,852 INFO  [STDOUT] 13:23:23,852 INFO  [DictionaryDAO] Registered namespace 'http://www.jcp.org/jcr/mix/1.0' (prefix 'mix')
2008-01-13 13:23:23,852 INFO  [STDOUT] 13:23:23,852 INFO  [DictionaryDAO] Registered namespace 'http://www.jcp.org/jcr/sv/1.0' (prefix 'sv')
2008-01-13 13:23:23,852 INFO  [STDOUT] 13:23:23,852 INFO  [DictionaryDAO] Registered namespace 'http://www.w3.org/XML/1998/namespace' (prefix 'xml')
2008-01-13 13:23:23,961 INFO  [STDOUT] 13:23:23,961 INFO  [RmiServiceExporter] Looking for RMI registry at port '50500'
2008-01-13 13:23:31,914 INFO  [STDOUT] 13:23:31,914 INFO  [RmiServiceExporter] Binding service 'avm' to RMI registry: RegistryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.10.30.69:50500](remote),objID:[0:0:0, 0]]]]
2008-01-13 13:23:31,961 INFO  [STDOUT] 13:23:31,961 INFO  [RmiServiceExporter] Looking for RMI registry at port '50500'
2008-01-13 13:23:31,977 INFO  [STDOUT] 13:23:31,977 INFO  [RmiServiceExporter] Binding service 'avmsync' to RMI registry: RegistryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.10.30.69:50500](remote),objID:[0:0:0, 0]]]]
2008-01-13 13:23:32,008 INFO  [STDOUT] 13:23:32,008 INFO  [RmiServiceExporter] Looking for RMI registry at port '50500'
2008-01-13 13:23:32,039 INFO  [STDOUT] 13:23:32,039 INFO  [RmiServiceExporter] Binding service 'attributes' to RMI registry: RegistryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.10.30.69:50500](remote),objID:[0:0:0, 0]]]]
2008-01-13 13:23:32,039 INFO  [STDOUT] 13:23:32,039 INFO  [RmiServiceExporter] Looking for RMI registry at port '50500'
2008-01-13 13:23:32,055 INFO  [STDOUT] 13:23:32,055 INFO  [RmiServiceExporter] Binding service 'authentication' to RMI registry: RegistryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.10.30.69:50500](remote),objID:[0:0:0, 0]]]]
2008-01-13 13:23:32,070 INFO  [STDOUT] 13:23:32,070 INFO  [RmiServiceExporter] Looking for RMI registry at port '50500'
2008-01-13 13:23:32,102 INFO  [STDOUT] 13:23:32,102 INFO  [RmiServiceExporter] Binding service 'repo' to RMI registry: RegistryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.10.30.69:50500](remote),objID:[0:0:0, 0]]]]
2008-01-13 13:23:32,117 INFO  [STDOUT] 13:23:32,117 INFO  [RmiServiceExporter] Looking for RMI registry at port '50500'
2008-01-13 13:23:32,133 INFO  [STDOUT] 13:23:32,133 INFO  [RmiServiceExporter] Binding service 'action' to RMI registry: RegistryImpl_Stub[UnicastRef [liveRef: [endpoint:[10.10.30.69:50500](remote),objID:[0:0:0, 0]]]]
2008-01-13 13:23:33,727 INFO  [STDOUT] 13:23:33,727 WARN  [ConfigurationFactory] No configuration found. Configuring ehcache from ehcache-failsafe.xml  found in the classpath: jar:file:/D:/jboss-4.0.5/server/default/./tmp/deploy/tmp11410alfresco-exp.war/WEB-INF/lib/ehcache-1.3.0.jar!/ehcache-failsafe.xml
2008-01-13 13:23:33,742 INFO  [STDOUT] 13:23:33,742 WARN  [CacheManager] Creating a new instance of CacheManager using the diskStorePath "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\" which is already used by an existing CacheManager.
The source of the configuration was classpath.
The diskStore path for this CacheManager will be set to C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\\ehcache_auto_created_1200227013742.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
2008-01-13 13:23:34,102 INFO  [STDOUT] 13:23:34,102 INFO  [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
2008-01-13 13:23:34,149 INFO  [STDOUT] 13:23:34,149 INFO  [SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.Oracle9Dialect.
2008-01-13 13:23:35,836 INFO  [STDOUT] 13:23:35,836 INFO  [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
2008-01-13 13:23:35,867 INFO  [STDOUT] 13:23:35,867 INFO  [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
2008-01-13 13:23:35,914 INFO  [STDOUT] 13:23:35,914 INFO  [SchemaExport] Running hbm2ddl schema export
2008-01-13 13:23:35,914 INFO  [STDOUT] 13:23:35,914 INFO  [SchemaExport] writing generated schema to file: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.Oracle9Dialect-11413.sql
2008-01-13 13:23:35,945 INFO  [STDOUT] 13:23:35,945 INFO  [SchemaExport] schema export complete
2008-01-13 13:23:35,977 INFO  [STDOUT] 13:23:35,977 INFO  [SchemaBootstrap] Executing database script C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.Oracle9Dialect-11413.sql (Generated).
2008-01-13 13:23:42,617 INFO  [STDOUT] 13:23:42,617 INFO  [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
2008-01-13 13:23:42,664 INFO  [STDOUT] 13:23:42,664 INFO  [SchemaBootstrap] Executing database script C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-11414.sql (Copied from classpath:alfresco/dbscripts/create/2.1/org.hibernate.dialect.Oracle9Dialect/AlfrescoPostCreate-2.1-FKIndexes.sql).
2008-01-13 13:23:43,414 INFO  [STDOUT] 13:23:43,414 INFO  [SchemaBootstrap] All executed statements written to file C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\Alfresco\AlfrescoSchemaUpdate-All_Statements"


************************************
After this, the java process keeps consuming CPU so I have to force it down . The DB user has been populated while the alf_data tree  is empty.

******************************
This is the 'custom-repository.properties' file:

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#
dir.root=D:\alfresco_repository\alf_data

#
# Sample database connection properties
#
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed.  After
# upgrading to a new version, this can be disabled.
#
db.schema.update=true

#
# HSQL connection
#
#db.driver=org.hsqldb.jdbcDriver
#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
#db.driver=org.gjt.mm.mysql.Driver
#db.url=jdbc:mysql://localhost/alfresco

#
# Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)
#
db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@10.10.30.xxx:xxxx:xxxx

#
# Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)
#
#db.driver=com.sybase.jdbc2.jdbc.SybDriver
#db.url=jdbc:sybase:Tds:localhost:2638/alfresco

#
# SQLServer connection (requires jdts-1.2.jar or equivalent - http://jtds.sourceforge.net/)
#
#db.driver=net.sourceforge.jtds.jdbc.Driver
#db.url=jdbc:jtds:sqlserver://localhost/alfresco

#
# SQLServer connection using Microsoft JDDB driver
#
#db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
#db.url=jdbc:sqlserver://localhost;DatabaseName=alfresco

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbc:postgresql://localhost:5432/alfresco

************************

this is the 'repository.properties'  file:

# Directory configuration
dir.root=d:\alfresco_repository\alf_data

dir.contentstore=${dir.root}/contentstore
dir.contentstore.deleted=${dir.root}/contentstore.deleted

dir.auditcontentstore=${dir.root}/audit.contentstore

# The location for lucene index files
dir.indexes=${dir.root}/lucene-indexes

# The location for lucene index locks
dir.indexes.lock=${dir.indexes}/locks

# The index recovery mode (NONE, VALIDATE, AUTO, FULL)
index.recovery.mode=VALIDATE

# Change the failure behaviour of the configuration checker
system.bootstrap.config_check.strict=true

#
# Properties to limit resources spent on individual searches
#
# The maximum time spent pruning results
system.acl.maxPermissionCheckTimeMillis=10000
# The maximum number of results to perform permission checks against
system.acl.maxPermissionChecks=1000

# #################### #
# Lucene configuration #
# #################### #
#
# Millisecond threshold for text transformations
# Slower transformers will force the text extraction to be asynchronous
#
lucene.maxAtomicTransformationTime=20
#
# The maximum number of clauses that are allowed in a lucene query
#
lucene.query.maxClauses=10000
#
# The size of the queue of nodes waiting for index
# Events are generated as nodes are changed, this is the maximum size of the queue used to coalesce event
# When this size is reached the lists of nodes will be indexed
#
# http://issues.alfresco.com/browse/AR-1280:  Setting this high is the workaround as of 1.4.3.
#
lucene.indexer.batchSize=1000000
#
# Lucene index min merge docs - the in memory size of the index
#
lucene.indexer.minMergeDocs=1000
#
# When lucene index files are merged together - it will try to keep this number of segments/files in
#
# When lucene index files are merged together - it will try to keep this number of segments/files in
#
lucene.indexer.mergeFactor=10
#
#
# Roughly the maximum number of nodes indexed in one file/segment
#
lucene.indexer.maxMergeDocs=100000
#
# The number of terms from a document that will be indexed
#
lucene.indexer.maxFieldLength=10000

lucene.write.lock.timeout=10000
lucene.commit.lock.timeout=100000
lucene.lock.poll.interval=100


# Database configuration
db.schema.update=true
db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@10.10.30.xxxx:xxxx1:xxx
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

# Email configuration
mail.host=
mail.port=25
mail.username=anonymous
mail.password=
# Set this value to UTF-8 or similar for encoding of email messages as required
mail.encoding=UTF-8
# Set this value to 7bit or similar for Asian encoding of email headers as required
mail.header=
mail.from.default=alfresco@alfresco.org

# System Configuration
system.store=system://system
system.descriptor.childname=sys:descriptor
system.descriptor.current.childname=sys:descriptor-current

# User config
alfresco_user_store.store=user://alfrescoUserStore
alfresco_user_store.system_container.childname=sys:system
alfresco_user_store.user_container.childname=sys:people
alfresco_user_store.authorities_container.childname=sys:authorities

# Spaces Archive Configuration
spaces.archive.store=archive://SpacesStore

# Spaces Configuration
spaces.store=workspace://SpacesStore
spaces.company_home.childname=app:company_home
spaces.guest_home.childname=app:guest_home
spaces.dictionary.childname=app:dictionary
spaces.templates.childname=app:space_templates
spaces.templates.content.childname=app:content_templates
spaces.templates.email.childname=app:email_templates
# Folders for storing people
system.system_container.childname=sys:system
system.people_container.childname=sys:people

# Folders for storing workflow related info
system.workflow_container.childname=sys:workflow

# Are user names case sensitive?
# ==============================
#
# NOTE: If you are using mysql you must have case sensitive collation
#
# You can do this when creating the alfresco database at the start
# CREATE DATABASE alfresco CHARACTER SET utf8 COLLATION utf8_bin;
# If you want to do this later this is a dump and load fix as it is done when the database, tables and columns are created.
#
# Must other databases are case sensitive by default.
#
user.name.caseSensitive=false

# AVM Specific properties.
avm.remote.idlestream.timeout=30000
                                                             
****************************************                                                               

Thanks in advance

Outcomes