On Tue, Mar 27, 2007 at 06:09:33PM +0800, Jayan Chirayath Kurian wrote: > (1) By enabling Telnet service on the DB server, through services.msc, > client was able to get connected to the DB server.
As someone else noted, you definitely do not want telnet running on the server. The use suggested by Stuart was to make sure you could connect to the postgres tcp port (5432). > (2) While giving telnet dspace.student.main.ntu.edu.sg 5432 from the > client, the connection was getting refused. The message displayed was > "Could not open connection to the host, on port 5432: connection failed" On the database server, try running lsof -i tcp:5432 This will let you know whether anything is listening on tcp port 5432. If it isn't, then postgres has been set up incorrectly. Check to see what arguments were passed to postgres at startup by running ps ax | grep post Which should show something like this: [EMAIL PROTECTED] ~ $ ps ax | grep postmaster 31529 ? S 0:20 /usr/bin/postmaster -i Note the -i flag which means my postmaster is listening for tcp connections. > (3) In the server, pg_hba was modified to include a single line that > gives the IP address/subnet of client. > > host all all 155.69.24.194 255.255.255.0 > trust That looks fine, but I wouldn't use 'trust' unless you're restricting access to that machine by some other means; 'md5' would be safer. > (4) In the server, postgresql.cfg file was modified to include > > tcpip_socket=true > > listen_addresses = '*' That looks fine. I'd check the scripts used to start postgres (usually in /etc/init.d/). Just make sure the -i flag is being passed at startup. What operating system is the database server running? Jim -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
