Monday, August 25, 2014

How to install and configure Postgresql in Centosyum install postgresql postgresql-serverchkconfig postgresql onservice postgresql initdbservice postgresql startNow Postgresql has been installed in your box.From Windows client i need to connect with this postgresql server. For that i download and install pgAdminIII http://www.pgadmin.org/download/Before getting connect, we have to allow remote clients to get connection in the serverLogin to the postgresql boxsu - postgresvi /var/lib/pgsql/data/postgresql.confChange the line "listen_address='localhost'" to listen_address='*'Uncomment port 5432 max_connections=100Also we have to mention the client IP to allow/trust in postgresql servervi /var/lib/pgsql/data/pg_hba.conf host all all 192.168.1.0/24 md5host all all 192.168.3.0/24 md5

Restart the service.Now i can connect to postgresql server from the windows client using the pgAdmin tool

Thursday, August 14, 2014

I need to change the default port of alfresco (http://ip:8080/share) to listen on port 80(http://ip/share)My alfresco verion is 3.4 community editionOS is windows 2008 R2We need to edit two configuration files for listening alfresco from port 8080 to 80.1. tomcat/shared/classes/alfresco/web-extension/share-config-custom.xml Change all ports from 8080 to the desired port Save file2. tomcat/conf/server.xml Find the line having ajp Change the connector port from 8080 to 80 Save fileRestart alfresco service.Try to access http://ip/shareLogin with your credentials.