Dear All,
I have instaled PostgresSQL 8.2 in windows xp system.That windows xp system have a static ip.I already update that static ip in pg_hba.config files after stop start postgresql service.Still i can't connect the postgressql database from outside.How to solve this problem.Pls adice me.Advance thanks
With Kindly Regards
Siva
5 9438 michaelb 534
Recognized Expert Contributor
One common problem with connecting to the server is a firewall.
If this is not the case here, then check the database log for error messages and post the contents of pg_hba.conf here.
I think there is no firrewal problem.Because i can connect the system from oustside through remote destop and PCAnwhere software.
I put the setting ip in pg_hba.onfig file like this
host all all 202.153.125.184 255.255.255.0 md5.Pls advice where is the problem.Advance thanks to u
Kindly Regards
Siva
Here mentioned pg_hba.conf files.Can you find for have problem in pg_hba.conf files
# PostgreSQL Client Authentication Configuration File
# =============== =============== =============== ======
#
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description. A short synopsis
# follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access. Records take one of these forms:
#
# local DATABASE USER METHOD [OPTION]
# host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
# hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION]
# hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain socket,
# "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an
# SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.
#
# DATABASE can be "all", "sameuser", "samerole", a database name, or
# a comma-separated list thereof.
#
# USER can be "all", a user name, a group name prefixed with "+", or
# a comma-separated list thereof. In both the DATABASE and USER fields
# you can also write a file name prefixed with "@" to include names from
# a separate file.
#
# CIDR-ADDRESS specifies the set of hosts the record matches.
# It is made up of an IP address and a CIDR mask that is an integer
# (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies
# the number of significant bits in the mask. Alternatively, you can write
# an IP address and netmask in separate columns to specify the set of hosts.
#
# METHOD can be "trust", "reject", "md5", "crypt", "password",
# "krb5", "ident", or "pam". Note that "password" sends passwords
# in clear text; "md5" is preferred since it sends encrypted passwords.
#
# OPTION is the ident map or the name of the PAM service, depending on METHOD.
#
# Database and user names containing spaces, commas, quotes and other special
# characters must be quoted. Quoting one of the keywords "all", "sameuser" or
# "samerole" makes the name lose its special character, and just match a
# database or username with that name.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect. You can use
# "pg_ctl reload" to do that.
# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL listen
# on a non-local interface via the listen_addresse s configuration parameter,
# or via the -i or -h command line switches.
#
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
local all all md5
host all all 202.153.125.187 255.255.255.0 md5
Advance Thanks to you.
Kindly Regards
Siva
Dear All,
Please reply my posting.Any body know about question.Still i am strugling i cannot connect the internet IP.Windows XP postgresSQL 8.1 server
KIndly Regards
Siva
michaelb 534
Recognized Expert Contributor
Siva, I can think of few things you need to look at.
You wrote:
I think there is no firewall problem. Because i can connect the system from
outside through remote desktop and PCAnywhere software.
Actually, this does not mean that you don't have a firewall problem.
Chances are remote desktop and PC Anywhere are allowed through the firewall, but the port used by Postgresql is blocked.
Look at the firewall logs, or temporarily disable firewall and test again.
Then, you have this entry in pg_hba.conf
host all all 202.153.125.187 255.255.255.0 md5
Please make sure that remote computer from which you attempt to connect has tcp address 202.153.125.187 .
You can also try to temporarily replace 202.153.125.187 255.255.255.0 with 0.0.0.0/0 to allow connections from any remote host.
Keep in mind that in order to pick up changes to configuration files you either need to restart Postgres or execute pg_ctl reload
You also need to verify that your database server is configured to listen to remote requests.
Remote TCP/IP connections will not be possible unless the server is started with an appropriate value for the listen_addresse s configuration parameter, since the default behavior is to listen for TCP/IP connections only on the local loopback address localhost.
Check on your server startup command line and postgresql.conf file and read this for more information.
Finally, you could probably make the whole debugging process much easier if you look at the database log. Failed connection attempts are typically logged there along with reason why they were rejected.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jerry Sacks |
last post by:
I Purchased Visual Studio .Net Enterprise Architect
I Have Installed it on my Window 2000 computer with a
FAT32 file system. Service Pack 4 installed. However in
installing IIS I have been unable manually configure FPSE.
The instructions are clear
To manually configure FrontPage Server Extension on
Windows 2000
1. On the Start menu, choose Settings, and then Control
|
by: Per Bergland |
last post by:
After many woes, I finally managed to get a stack dump of my System
Service (written in C#) that insists on crashing when launched at system
boot time (see below on how to get this dump - I couldn't find any info
on how to do this).
Here's the stack trace from cordbg:
Unhandled exception generated: (0x04719c94)
<System.Runtime.Remoting.RemotingException>
_className=<null>
_exceptionMethod=<null>
|
by: Ed Sutton |
last post by:
I use a mutex to disallow starting a second application instance. This
did not work in a release build until I made it static member of my
MainForm class.
In a debug build, first instance got ownership, second did not and
terminated. In a release build, the second instance *also* got
ownership. I "fixed" it by making the mutex a static member of my
MainForm class.
Did the garbage collector eat my mutex because it is not referenced
|
by: superseed |
last post by:
Hi,
I'm pretty new to C#, and I'm quite stuck on the following problem.
I would like to add to my application a Windows.Form (singleton) on
which I could display a message of one of the following type :
Exception, Error, Warning, Infos (with differents colors, etc).
I would like to use it like the Console.WriteLine("My Message"); on
everywhere in my application.
|
by: Davey |
last post by:
I have Visio for Visual Studio.NET Enterprise Architect 2003 and I am
designing a PostgresSQL database using it. Is it possible to generate and
manage a PostgresSQL database using Visio?
| |
by: Hal Vaughan |
last post by:
I have a problem with port forwarding and I have been working on it for over
2 weeks with no luck. I have found C programs that almost work and Java
programs that almost work, but nothing that does what I need. I've even
tried writing a port forwarder in Java and found problems that nobody seems
to have the answer to in forums. I need to make it work essentially the
same on both Windows and Linux.
There is one program, in C, that...
|
by: Mr Flibble |
last post by:
Hi all,
I've decided to use log4net for my logging/tracing.
In the example on the site it shows using main() to setup the root
logger and then using the LogManager within your classes to create more
loggers (subloggers). This is nice since I can use just one
configuration file to control the behaviour of all the loggers within my
app. This is great if I'm using a project that contains all my classes
but what happens if my class is in...
|
by: =?Utf-8?B?TWF0dA==?= |
last post by:
I'm having a problem with a static class constructor being called twice. I
have the static class MasterTaskList which uses a BackgroundWorker to execute
multiple methods on a separate thread. The static constructor calls a reset
function which creates a new instance of BackgroundWorker and attaches the
appropriate event handlers. There is also a static method ReportProgress for
the called methods to do just that.
What is happening is...
|
by: Mathieu Prevot |
last post by:
Hi,
I have the following error when I run configure:
checking size of wchar_t... configure: error: cannot compute sizeof (wchar_t)
what can I do ?
Mathieu
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |