AnsweredAssumed Answered

Data base is not getting connected

Question asked by linshad.k on Jan 31, 2017

Hi team,

 

I would like to configure PostgreSQL  on remote server ,It has to be connected with alfresco community, Database Installation and configuration is completed on remote server,and  deleted some thing from global properties file,and done some changes

The following is my global properties file

###############################
## Common Alfresco Properties #
###############################
dir.root=C:/ALFRES~1/alf_data
alfresco.context=alfresco
alfresco.host=192.168.0.143
alfresco.port=8080
alfresco.protocol=http
share.context=share
share.host=192.168.0.143
share.port=8080
share.protocol=http
### database connection properties ###
   ### i deleted  default code from here,and  added  remote database URL  below

# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN
### FTP Server Configuration ###
ftp.port=21
### RMI registry port for JMX ###
alfresco.rmi.services.port=50500
### External executable locations ###
ooo.exe=C:/ALFRES~1/LIBREO~1/App/libreoffice/program/soffice.exe
ooo.enabled=true
ooo.port=8100
img.root=C:\\alfresco-community\\imagemagick
img.coders=${img.root}\\modules\\coders
img.config=${img.root}
img.gslib=${img.root}\\lib
img.exe=${img.root}\\convert.exe
jodconverter.enabled=false
jodconverter.officeHome=C:/ALFRES~1/LIBREO~1/App/libreoffice
jodconverter.portNumbers=8100
### Initial admin password ###
alfresco_user_store.adminpassword=579da618cfbfa85247acf1f800a280a4
### E-mail site invitation setting ###
notification.email.siteinvite=false
### License location ###
dir.license.external=C:/ALFRES~1
### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.host=localhost
solr.port.ssl=8443
### Allow extended ResultSet processing
security.anyDenyDenies=false
### Smart Folders Config Properties ###
smart.folders.enabled=false
### Remote JMX (Default: disabled) ###
alfresco.jmx.connector.enabled=false
db.url=jdbc:postgresql://192.168.0.130:5432/alfresco
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.host=192.168.0.130
db.pool.max=400
Kindly revert me ,with solution ,how i can get to know whether "BD'" is connected or not

Outcomes