pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAccessing PgSql-Database from NT (ODBCD)
3+ messages / 3 participants
[nested] [flat]
* Accessing PgSql-Database from NT (ODBCD)
@ 1998-05-13 11:47 The Hermit Hacker <scrappy@hub.org>
1998-05-13 14:33 ` Re: [INTERFACES] Accessing PgSql-Database from NT (ODBCD) Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>
0 siblings, 1 reply; 3+ messages in thread
From: The Hermit Hacker @ 1998-05-13 11:47 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Oliver Stegle <olli2@fr.infra.net>
===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-interfaces@postgresql.org
===================================================================
Hello!
Last day I installed the Postgrest SQl-Database successful on my
LINUX-Server.
The Database runs fine, and all tests, which are included with the source
("/src/test") have possitive result.
The Access-List for the Postmaster has also been checked, that everybody in
the wan can access the SQl-Server via TCPIP
But it is still impossbile to get any connection from Windows NT to the
SQl-Server. the ODBC-Client returns: "Server 192.168.1.101 could not be
connected - No connection possible to port 5432"
I also checked, that the Postmaster Process is running on port 5432 and
localy on the mashine everything works fine(using psql)
What to do???
(how can I for instance with an second LINUX-Mashine check, that the
Postmaster is available from Remote??)
Thankyou in advance!
Oliver!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Accessing PgSql-Database from NT (ODBCD)
1998-05-13 11:47 Accessing PgSql-Database from NT (ODBCD) The Hermit Hacker <scrappy@hub.org>
@ 1998-05-13 14:33 ` Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>
0 siblings, 0 replies; 3+ messages in thread
From: Olaf Mittelstaedt @ 1998-05-13 14:33 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Oliver Stegle <olli2@fr.infra.net>
> The Database runs fine, and all tests, which are included with the source
> ("/src/test") have possitive result.
> The Access-List for the Postmaster has also been checked, that everybody in
> the wan can access the SQl-Server via TCPIP
> But it is still impossbile to get any connection from Windows NT to the
> SQl-Server. the ODBC-Client returns: "Server 192.168.1.101 could not be
> connected - No connection possible to port 5432"
> I also checked, that the Postmaster Process is running on port 5432 and
> localy on the mashine everything works fine(using psql)
Did you include the "-i" switch when starting the postmaster? It
enables TCP/IP connections since the postmaster only uses UNIX
domain sockets per default.
Try to open a telnet session from your NT workstation to the machine
hosting the PostgreSQL server, a least you should see something like:
frog# telnet frog 5432
Trying ?.?.?.?...
Connected to frog.
Escape character is '^]'.
EInvalid packet length
Connection closed by foreign host.
Regards,
Olaf
--
Olaf Mittelstaedt - IuK - mittelstaedt@fh-ulm.de
Fachhochschule Ulm Prittwitzstr. 10 89075 Ulm
Tel.: +49 (0)731-502-8220 Fax: -8270
Ash nazg durbatulûk, ash nazg gimbatul,
ash nazg thrakatulûk agh burzum-ishi krimpatul.
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: [INTERFACES] Accessing PgSql-Database from NT (ODBCD)
@ 1998-05-13 13:42 Peter Mount <peter@maidstone.gov.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Peter Mount @ 1998-05-13 13:42 UTC (permalink / raw)
To: 'The Hermit Hacker' <scrappy@hub.org>; pgsql-interfaces; +Cc: 'Oliver Stegle' <olli2@fr.infra.net>
I know you have said about the access list (aka pg_hba.conf), but did the
postmaster start with the -i flag? This enables TCP/IP.
--
Peter T Mount, peter@maidstone.gov.uk, peter@retep.org.uk
Please note that this is from my works email. If you reply, please cc my
home address.
-----Original Message-----
From: owner-pgsql-interfaces@hub.org
[mailto:owner-pgsql-interfaces@hub.org]On Behalf Of The Hermit Hacker
Sent: Wednesday, May 13, 1998 12:48 PM
To: pgsql-interfaces@postgreSQL.org
Cc: Oliver Stegle
Subject: [INTERFACES] Accessing PgSql-Database from NT (ODBCD)
===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-interfaces@postgresql.org
===================================================================
Hello!
Last day I installed the Postgrest SQl-Database successful on my
LINUX-Server.
The Database runs fine, and all tests, which are included with the source
("/src/test") have possitive result.
The Access-List for the Postmaster has also been checked, that everybody in
the wan can access the SQl-Server via TCPIP
But it is still impossbile to get any connection from Windows NT to the
SQl-Server. the ODBC-Client returns: "Server 192.168.1.101 could not be
connected - No connection possible to port 5432"
I also checked, that the Postmaster Process is running on port 5432 and
localy on the mashine everything works fine(using psql)
What to do???
(how can I for instance with an second LINUX-Mashine check, that the
Postmaster is available from Remote??)
Thankyou in advance!
Oliver!
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-05-13 14:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-05-13 11:47 Accessing PgSql-Database from NT (ODBCD) The Hermit Hacker <scrappy@hub.org>
1998-05-13 14:33 ` Olaf Mittelstaedt <mstaedt@va-sigi.va.fh-ulm.de>
1998-05-13 13:42 RE: [INTERFACES] Accessing PgSql-Database from NT (ODBCD) Peter Mount <peter@maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox