LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Networking (https://www.linuxquestions.org/questions/linux-networking-3/)
-   -   postgres client connection error (https://www.linuxquestions.org/questions/linux-networking-3/postgres-client-connection-error-559820/)

sailu_mvn 06-07-2007 01:50 AM

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

traene 06-08-2007 12:06 PM

Can you ping 192.168.0.132 from the client?

sailu_mvn 06-10-2007 11:03 PM

the problem is resolved. I was using the wrong user.
Thanks

korotania 06-20-2007 07:16 AM

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

traene 06-20-2007 12:12 PM

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.

korotania 06-21-2007 06:10 AM

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.