Data base

[linshad_k]

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, 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=jdbcostgresql://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 "DB'" is connected or not

[afaust]

Simply start the server and see if it will start up - there are errors when it cannot connect to the DB. Also, the log output will state to which database Alfresco is connecting.

[linshad_k]

Hi,

Can you Check the mentioned global properties file,let me know whether its correct or not