Alfresco custom installation on jboss using Postgres

[vikram mishra]

hi every one .. I'll really appreciate if some one can teach me or suggest me how to install ALFRESCO 3.4 on (windows xp)jboss 5.1/6 using postgress 9.1 step by step using alfresco enterprise zip file.
When i did it as given on the official documentation as under.
1.put alfresco-global.properties in conf folder of jboss..-- following are the values

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

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

#
# Sample database connection properties
#
db.username=ARIS
#db.password=alfresco

#
# External locations
#-------------
#ooo.exe=soffice
#ooo.enabled=false
#jodconverter.officeHome=./OpenOffice.org
#jodconverter.portNumbers=8101
#jodconverter.enabled=true
#img.root=./ImageMagick
#swf.exe=./bin/pdf2swf

#
# 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

#
# MySQL connection
#
#db.driver=org.gjt.mm.mysql.Driver
#db.url=jdbc:mysql://localhost/alfresco?useUnicode=yes&characterEncoding=UTF-8

#
# Oracle connection
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbc:oracle:thin:@localhost:1521:alfresco

#
# SQLServer connection
# Requires jTDS driver version 1.2.5 and SNAPSHOT isolation mode
# Enable TCP protocol on fixed port 1433
# Prepare the database with:
# ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON; 
#
#db.driver=net.sourceforge.jtds.jdbc.Driver
#db.url=jdbc:jtds:sqlserver://localhost:1433/alfresco
#db.txn.isolation=4096

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

#
# Index Recovery Mode
#-------------
#index.recovery.mode=AUTO

#
# Outbound Email Configuration
#-------------
#mail.host=
#mail.port=25
#mail.username=anonymous
#mail.password=
#mail.encoding=UTF-8
#mail.from.default=[e-mail]
#mail.smtp.auth=false

#
# Alfresco Email Service and Email Server
#-------------

# Enable/Disable the inbound email service.  The service could be used by processes other than
# the Email Server (e.g. direct RMI access) so this flag is independent of the Email Service.
#-------------
#email.inbound.enabled=true

# Email Server properties 
#-------------
#email.server.enabled=true
#email.server.port=25
#email.server.domain=alfresco.com
#email.inbound.unknownUser=anonymous

# A comma separated list of email REGEX patterns of allowed senders.
# If there are any values in the list then all sender email addresses
# must match. For example:
#   .*\@alfresco\.com, .*\@alfresco\.org
# Allow anyone:
#-------------
#email.server.allowed.senders=.*

#
# The default authentication chain
# To configure external authentication subsystems see:
# http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems
#-------------
#authentication.chain=alfrescoNtlm1:alfrescoNtlm

#
# URL Generation Parameters (The ${localname} token is replaced by the local server name)
#-------------
alfresco.context=alfresco
alfresco.host=${localname}
alfresco.port=8080
alfresco.protocol=http
#
share.context=share
share.host=${localname}
share.port=8080
share.protocol=http

#imap.server.enabled=true
#imap.server.port=143
#imap.server.host=localhost

# The RMI registry host and port is defined in the alfresco-shared.properties file
#
# To make your RMI services available from other machines you will need to change 
# alfresco.rmi.services.host from "localhost".
# alfresco.rmi.services.port=50500
# alfresco.rmi.services.host=localhost
#
# RMI service ports for the individual services.
# These seven services are available remotely.
#
# Assign individual ports for each service for best performance 
# or run several services on the same port. You can even run everything on 50500 if needed.
#
# Select 0 to use a random unused port.
# 
#avm.rmi.service.port=50501
#avmsync.rmi.service.port=50502
#attribute.rmi.service.port=50503
#authentication.rmi.service.port=50504
#repo.rmi.service.port=50505
#action.rmi.service.port=50506
#wcm-deployment-receiver.rmi.service.port=50507
#monitor.rmi.service.port=50508
#######################################################

step 2. copied postgres jdbc driver in lib folder.(I've already started server and checked connecting to it using java)
step 3. copied alfresco.war and share.war in server/default/deploy folder

[Ulf Dittmer]

You didn't say what -if any- problems you encountered, but "put alfresco-global.properties in conf folder of jboss" sounds odd. That file needs to be in the classpath, and "conf" does not sound like it would be in the classpath. (It's possible it might be, though - I don't know much about JBoss.)

It looks like the DB password is commented out; you may need to fix that.

[Jaikiran Pai]

Ulf Dittmer wrote:That file needs to be in the classpath, and "conf" does not sound like it would be in the classpath. (It's possible it might be, though - I don't know much about JBoss.)

Up until JBoss AS6, JBOSS_HOME/server/<servername>/conf folder is made available in the classpath of all applications on that server. It's usually used to place .properties files and such, but really those properties files belong to the application itself.

[Jaikiran Pai]

Vikram, what issues are you running into after following those steps?

[vikram mishra]

right now there are multiple exceptions i solved a few

I took following steps

1. instead of postgress i used MYSQL 5.1(commented the postgres info and used mysql instead)
2. put alfresco-global.properties in server/conf/alfresco/ (this resolved the failed to find configuration file error)



right now facing "unable to find resource " some dialect problem though i am using mysql.


so can you tell me how to eradicate this error???

[Jaikiran Pai]

vikram mishra wrote:

right now facing "unable to find resource " some dialect problem though i am using mysql.

so can you tell me how to eradicate this error???

You'll have to provide more details including relevant exception stacktraces for us to understand what's wrong.