postgres client connection error
Hi,
I am using pgadmin to connect to postgresql server configured on a local machine. The Client and the Server are in the same Network. When I try to access the postgresql server, I get the following error -------------------------------------------------------------------- Unable to connect to postgresql server.No route to host, Is the server running on host 192.168.0.132 and accepting TCP/IP connections on port 5432? --------------------------------------------------------------------- I checked the port on which postgresql is listening by the command. nmap -sT -O localhost ---------------------------------- PORT STATE SERVICE 21/tcp open ftp 22/tcp open ssh 25/tcp open smtp 80/tcp open http 111/tcp open rpcbind 443/tcp open https 631/tcp open ipp 751/tcp open kerberos_master 3306/tcp open mysql 5432/tcp open postgres ---------------------------------- it tells me that postgresql is listening on port 5432. I checked the status of the postgersql server. Its running. Why is this problem caused? Please advice. Thanks |
Can you ping 192.168.0.132 from the client?
|
the problem is resolved. I was using the wrong user.
Thanks |
when i'm doing :-
nmap -sT -O 192.168.1.110 i can't see 5432 & 3306 port open. why & what to do? Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2007-06-20 17:40 IST Interesting ports on 192.168.1.110: Not shown: 1667 closed ports PORT STATE SERVICE 22/tcp open ssh 80/tcp open http 111/tcp open rpcbind 443/tcp open https 631/tcp open ipp 726/tcp open unknown 754/tcp open krb_prop 844/tcp open unknown 2049/tcp open nfs 5900/tcp open vnc 6000/tcp open X11 8009/tcp open ajp13 8080/tcp open http-proxy No exact OS matches for host (If you know what OS is running on it, see http://www.insecure.org/cgi-bin/nmap-submit.cgi). TCP/IP fingerprint: SInfo(V=4.11%P=i686-redhat-linux-gnu%D=6/20%Tm=46791924%O=22%C=1) TSeq(Class=RI%gcd=1%SI=31494E%IPID=Z) TSeq(Class=RI%gcd=1%SI=314B64%IPID=Z) TSeq(Class=RI%gcd=1%SI=314B78%IPID=Z) T1(Resp=Y%DF=Y%W=8000%ACK=S++%Flags=AS%Ops=MNNTNW) T2(Resp=N) T3(Resp=Y%DF=Y%W=8000%ACK=S++%Flags=AS%Ops=MNNTNW) T4(Resp=Y%DF=Y%W=0%ACK=O%Flags=R%Ops=) T5(Resp=Y%DF=Y%W=0%ACK=S++%Flags=AR%Ops=) T6(Resp=Y%DF=Y%W=0%ACK=O%Flags=R%Ops=) T7(Resp=Y%DF=Y%W=0%ACK=S++%Flags=AR%Ops=) PU(Resp=Y%DF=N%TOS=C0%IPLEN=164%RIPTL=148%RID=E%RIPCK=E K=E%ULEN=134%DAT=E) Nmap finished: 1 IP address (1 host up) scanned in 12.321 seconds |
Your mysql and postgres processes are not running. Try something like
/etc/init.d/mysql start /etc/init.d/postmaster start As of postgres, i think you need to do something like createdb first. You may start a new thread. |
Traene
this is all in fedora core 6. in last post you gave me 2 options to try but nothing happened. now when i'm restarting mysql. /sbin/service mysqld restart -u root Stopping MySQL: [FAILED] Initializing MySQL database: Neither host 'localhost' nor 'localhost' could be looked up with /usr/bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option [FAILED] |
All times are GMT -5. The time now is 02:14 AM. |