hi! Jim
we have Dspace 1.4.1 on Windows 2003 standard edition R2 with tomcat 6.0 and
postgresql 8.1
(1) i will disable the telnet serive on the server. But disabling telnet
service even disconnects telnet IPaddress. (without 5432 port)
(2) in windows, is there any specific directory where i need to run "lsof -i
tcp:5432"
(3) For windows environment how shall i execute "ps ax | grep post"
(4)For windows under "data" folder which file i need to check that starts
progresql and the -i flag.
Thanks for your reply.
Regards,
Jayan
________________________________
From: James Rutherford [mailto:[EMAIL PROTECTED]
Sent: Tue 3/27/2007 6:30 PM
To: Jayan Chirayath Kurian
Cc: Michael Judd; [email protected]; Stuart Lewis [sdl]
Subject: Re: [Dspace-tech] 2 Tier Dspace Implementation
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
