topic Data base in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/data-base/m-p/4628#M2115 <HTML><HEAD></HEAD><BODY><P style="color: #727174; background-color: #ffffff; border: 0px;">Hi team,</P><P style="color: #727174; background-color: #ffffff; border: 0px;">&nbsp;</P><P style="color: #727174; background-color: #ffffff; border: 0px;">I would like to configure PostgreSQL &nbsp;on remote server ,It has to be connected with alfresco community, Database Installation and configuration is completed on remote server,and &nbsp;deleted some thing from global properties file, done some changes</P><P style="color: #727174; background-color: #ffffff; border: 0px;">The following is my global properties file</P><DIV style="color: #333333; background-color: #ffffff; border: 0px;">###############################<BR />## Common Alfresco Properties #<BR />###############################</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">dir.root=C:/ALFRES~1/alf_data</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">alfresco.context=alfresco<BR />alfresco.host=192.168.0.143<BR />alfresco.port=8080<BR />alfresco.protocol=http</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">share.context=share<BR />share.host=192.168.0.143<BR />share.port=8080<BR />share.protocol=http</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### database connection properties ###</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">&nbsp; &nbsp;### i deleted &nbsp;default code from here,and &nbsp;added &nbsp;remote database URL &nbsp;below</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"><BR /># The server mode. Set value here<BR /># UNKNOWN | TEST | BACKUP | PRODUCTION<BR />system.serverMode=UNKNOWN</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### FTP Server Configuration ###<BR />ftp.port=21</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### RMI registry port for JMX ###<BR />alfresco.rmi.services.port=50500</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### External executable locations ###<BR />ooo.exe=C:/ALFRES~1/LIBREO~1/App/libreoffice/program/soffice.exe<BR />ooo.enabled=true<BR />ooo.port=8100<BR />img.root=C:\\alfresco-community\\imagemagick<BR />img.coders=${img.root}\\modules\\coders<BR />img.config=${img.root}<BR />img.gslib=${img.root}\\lib<BR />img.exe=${img.root}\\convert.exe</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">jodconverter.enabled=false<BR />jodconverter.officeHome=C:/ALFRES~1/LIBREO~1/App/libreoffice<BR />jodconverter.portNumbers=8100</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### Initial admin password ###<BR />alfresco_user_store.adminpassword=579da618cfbfa85247acf1f800a280a4</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### E-mail site invitation setting ###<BR />notification.email.siteinvite=false</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### License location ###<BR />dir.license.external=C:/ALFRES~1</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### Solr indexing ###<BR /><A class="" href="http://index.subsystem.name/" rel="nofollow noopener noreferrer" style="color: #0186ba; border: 0px; font-weight: inherit; padding: 0px calc(12px + 0.35ex) 0px 0px;" target="_blank">index.subsystem.name</A>=solr4<BR />dir.keystore=${dir.root}/keystore<BR />solr.host=localhost<BR />solr.port.ssl=8443</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### Allow extended ResultSet processing<BR />security.anyDenyDenies=false</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### Smart Folders Config Properties ###<BR />smart.folders.enabled=false</DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;">### Remote JMX (Default: disabled) ###<BR /><EM style="border: 0px; font-weight: inherit;">alfresco.jmx.connector.enabled=false</EM><BR /><EM style="border: 0px; font-weight: inherit;">db.url=jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://<A class="" href="http://192.168.0.130:5432/alfresco" rel="nofollow noopener noreferrer" style="color: #0186ba; border: 0px; font-weight: inherit; padding: 0px calc(12px + 0.35ex) 0px 0px;" target="_blank">192.168.0.130:5432/alfresco</A></EM><BR /><EM style="border: 0px; font-weight: inherit;">db.driver=org.postgresql.Driver</EM><BR /><EM style="border: 0px; font-weight: inherit;">db.username=alfresco</EM><BR /><EM style="border: 0px; font-weight: inherit;">db.password=alfresco</EM><BR /><EM style="border: 0px; font-weight: inherit;"><A class="" href="http://db.name/" rel="nofollow noopener noreferrer" style="color: #0186ba; border: 0px; font-weight: inherit; padding: 0px calc(12px + 0.35ex) 0px 0px;" target="_blank">db.name</A>=alfresco</EM><BR /><EM style="border: 0px; font-weight: inherit;">db.host=192.168.0.130</EM><BR /><EM style="border: 0px; font-weight: inherit;">db.pool.max=400</EM></DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"> </DIV><DIV style="color: #333333; background-color: #ffffff; border: 0px;"><EM style="border: 0px; font-weight: inherit;">Kindly revert me ,with solution ,how i can get to know whether "DB'" is connected or not</EM></DIV></BODY></HTML> Wed, 01 Feb 2017 06:16:08 GMT linshad_k 2017-02-01T06:16:08Z Data base https://connect.hyland.com/t5/alfresco-forum/data-base/m-p/4628#M2115 Hi team,&nbsp;I would like to configure PostgreSQL &nbsp;on remote server ,It has to be connected with alfresco community, Database Installation and configuration is completed on remote server,and &nbsp;deleted some thing from global properties file, done some changesThe following is my global properties file##### Wed, 01 Feb 2017 06:16:08 GMT https://connect.hyland.com/t5/alfresco-forum/data-base/m-p/4628#M2115 linshad_k 2017-02-01T06:16:08Z Re: Data base https://connect.hyland.com/t5/alfresco-forum/data-base/m-p/4629#M2116 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 01 Feb 2017 11:36:10 GMT https://connect.hyland.com/t5/alfresco-forum/data-base/m-p/4629#M2116 afaust 2017-02-01T11:36:10Z Re: Data base https://connect.hyland.com/t5/alfresco-forum/data-base/m-p/4630#M2117 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can you Check the mentioned global properties file,let me know whether its correct or not</P></BODY></HTML> Wed, 01 Feb 2017 11:52:36 GMT https://connect.hyland.com/t5/alfresco-forum/data-base/m-p/4630#M2117 linshad_k 2017-02-01T11:52:36Z