Data base

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
linshad_k
Member II

Data base

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=jdbcSmiley Tongueostgresql://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
2 Replies
afaust
Master

Re: Data base

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
Member II

Re: Data base

Hi,

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