LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 06-07-2007, 02:50 AM   #1
sailu_mvn
Member
 
Registered: Sep 2004
Location: Hyderabad
Distribution: FEDORA,REDHAT,HOST
Posts: 440
Blog Entries: 1

Rep: Reputation: 30
Lightbulb 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
 
Old 06-08-2007, 01:06 PM   #2
traene
Member
 
Registered: Jan 2005
Distribution: Archlinux, Debian, Centos
Posts: 219

Rep: Reputation: 33
Can you ping 192.168.0.132 from the client?
 
Old 06-11-2007, 12:03 AM   #3
sailu_mvn
Member
 
Registered: Sep 2004
Location: Hyderabad
Distribution: FEDORA,REDHAT,HOST
Posts: 440
Blog Entries: 1

Original Poster
Rep: Reputation: 30
the problem is resolved. I was using the wrong user.
Thanks
 
Old 06-20-2007, 08:16 AM   #4
korotania
LQ Newbie
 
Registered: Nov 2005
Posts: 7

Rep: Reputation: 0
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
 
Old 06-20-2007, 01:12 PM   #5
traene
Member
 
Registered: Jan 2005
Distribution: Archlinux, Debian, Centos
Posts: 219

Rep: Reputation: 33
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.
 
Old 06-21-2007, 07:10 AM   #6
korotania
LQ Newbie
 
Registered: Nov 2005
Posts: 7

Rep: Reputation: 0
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]
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Postgres Database Connection anjani.78 Linux - Software 1 10-07-2005 03:06 AM
Connection reset Error with Dante-Client Demaron Linux - Networking 0 07-03-2005 09:12 AM
LDAP SERVER Client Connection on SUSE 9.2 - connection error jcarton Linux - Networking 3 03-19-2005 01:40 PM
LDAP SERVER - CLIENT CONNECTION on suse 9.2 - connection error nicolasdiogo Linux - Networking 4 03-01-2005 02:43 PM
LDAP SERVER - CLIENT CONNECTION on suse 9.2 - connection error nicolasdiogo SUSE / openSUSE 0 03-01-2005 06:43 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 03:41 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration