connection troubles

Started by Julia Anne Casealmost 28 years ago9 messages
#1Julia Anne Case
julie@hub.org

In doing some work with the PostgreSQL ODBC driver today I noticed that I
was unable to connect to any of my database (how long has this been a
problem, I'm not sure). I then tried to use psql to connect from outside
the local machine. and I get the following errors on the server...
ConnStartup: No Postgres username specified in startup packet.
and the psql errors out with
-- couldn't recieve un/salt packet: errno=61

With the odbc driver after I send the login info I wait for a
response and finally get a character value 205 back...

I am afraid I've done something really silly but can't find out
where I went wrong.

Julie

--
[ Julia Anne Case ] [ Ships are safe inside the harbor, ]
[Programmer at large] [ but is that what ships are really for. ]
[ Admining Linux ] [ To thine own self be true. ]
[ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]

#2Julia Anne Case
julie@hub.org
In reply to: Julia Anne Case (#1)
Re: [HACKERS] connection troubles

Quoting Julia Anne Case (julie@hub.org):

With the odbc driver after I send the login info I wait for a
response and finally get a character value 205 back...

I've also found if I kill my debuging process during the wait for
response from the server it often crashes the server...

Julie

BTW, this is using 6.2.1

--
[ Julia Anne Case ] [ Ships are safe inside the harbor, ]
[Programmer at large] [ but is that what ships are really for. ]
[ Admining Linux ] [ To thine own self be true. ]
[ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]

#3The Hermit Hacker
scrappy@hub.org
In reply to: Julia Anne Case (#2)
Re: [HACKERS] connection troubles

On Wed, 4 Feb 1998, Julia Anne Case wrote:

Quoting Julia Anne Case (julie@hub.org):

With the odbc driver after I send the login info I wait for a
response and finally get a character value 205 back...

I've also found if I kill my debuging process during the wait for
response from the server it often crashes the server...

Julie

BTW, this is using 6.2.1

Julie...

Will PostODBC be v6.3 tested in the next little while? I know
there have been *alot* of changes to v6.3 as far as authentication is
concerned, which might prove a problem once we release...

#4Julia Anne Case
julie@hub.org
In reply to: The Hermit Hacker (#3)
Re: [HACKERS] connection troubles

Quoting The Hermit Hacker (scrappy@hub.org):

Julie...

Will PostODBC be v6.3 tested in the next little while? I know
there have been *alot* of changes to v6.3 as far as authentication is
concerned, which might prove a problem once we release...

I just brought down the latest snapshot to my Sparc/Linux
machine... I'll let you know how it works out... Could take a little
while to compile it's just a IPX laptop...

Julie

--
[ Julia Anne Case ] [ Ships are safe inside the harbor, ]
[Programmer at large] [ but is that what ships are really for. ]
[ Admining Linux ] [ To thine own self be true. ]
[ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]

#5The Hermit Hacker
scrappy@hub.org
In reply to: Julia Anne Case (#4)
Re: [HACKERS] connection troubles

On Wed, 4 Feb 1998, Julia Anne Case wrote:

Quoting The Hermit Hacker (scrappy@hub.org):

Julie...

Will PostODBC be v6.3 tested in the next little while? I know
there have been *alot* of changes to v6.3 as far as authentication is
concerned, which might prove a problem once we release...

I just brought down the latest snapshot to my Sparc/Linux
machine... I'll let you know how it works out... Could take a little
while to compile it's just a IPX laptop...

I don't have any knowledge of ODBC, but would it help if I setup
and maintained a (reasonably) current server that you can connect remotely
too for testing? I'll do periodic recompile/installs of it so that it
stays up to date? I'd like to see the ODBC as rock solid as possible
before the 1st, in accordance with v6.3 specs, and if it means doing this,
its a cheap price to pay :)

Peter...would this help any with the JDBC stuff too, or are you
okay with that one?

#6Meskes, Michael
meskes@topsystem.de
In reply to: The Hermit Hacker (#5)
RE: [HACKERS] connection troubles

Could we please add the ODBC driver to the source tree? I think it would
look much better if we distribute a 'complete' system.

Michael

--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10

Show quoted text

-----Original Message-----
From: The Hermit Hacker [SMTP:scrappy@hub.org]
Sent: Wednesday, February 04, 1998 7:59 PM
To: Julia Anne Case
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] connection troubles

On Wed, 4 Feb 1998, Julia Anne Case wrote:

Quoting The Hermit Hacker (scrappy@hub.org):

Julie...

Will PostODBC be v6.3 tested in the next little while? I know
there have been *alot* of changes to v6.3 as far as authentication

is

concerned, which might prove a problem once we release...

I just brought down the latest snapshot to my Sparc/Linux
machine... I'll let you know how it works out... Could take a

little

while to compile it's just a IPX laptop...

I don't have any knowledge of ODBC, but would it help if I setup
and maintained a (reasonably) current server that you can connect
remotely
too for testing? I'll do periodic recompile/installs of it so that it
stays up to date? I'd like to see the ODBC as rock solid as possible
before the 1st, in accordance with v6.3 specs, and if it means doing
this,
its a cheap price to pay :)

Peter...would this help any with the JDBC stuff too, or are you
okay with that one?

#7Meskes, Michael
meskes@topsystem.de
In reply to: Meskes, Michael (#6)
RE: [HACKERS] connection troubles

Oops. .-)

Michael

--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10

Show quoted text

-----Original Message-----
From: The Hermit Hacker [SMTP:scrappy@hub.org]
Sent: Thursday, February 05, 1998 12:55 PM
To: Meskes, Michael
Cc: Julia Anne Case; pgsql-hackers@postgreSQL.org
Subject: RE: [HACKERS] connection troubles

On Thu, 5 Feb 1998, Meskes, Michael wrote:

Could we please add the ODBC driver to the source tree? I think it

would

look much better if we distribute a 'complete' system.

src/interfaces/odbc ... been there for a couple of weeks now :)
Julie has direct access to the source repository, and, like Peter,
sort of
has to review any patches applied to it...

Michael

--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr.

20

meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10

-----Original Message-----
From: The Hermit Hacker [SMTP:scrappy@hub.org]
Sent: Wednesday, February 04, 1998 7:59 PM
To: Julia Anne Case
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] connection troubles

On Wed, 4 Feb 1998, Julia Anne Case wrote:

Quoting The Hermit Hacker (scrappy@hub.org):

Julie...

Will PostODBC be v6.3 tested in the next little while?

I know

there have been *alot* of changes to v6.3 as far as

authentication

is

concerned, which might prove a problem once we release...

I just brought down the latest snapshot to my

Sparc/Linux

machine... I'll let you know how it works out... Could take a

little

while to compile it's just a IPX laptop...

I don't have any knowledge of ODBC, but would it help if I setup
and maintained a (reasonably) current server that you can connect
remotely
too for testing? I'll do periodic recompile/installs of it so

that it

stays up to date? I'd like to see the ODBC as rock solid as

possible

before the 1st, in accordance with v6.3 specs, and if it means

doing

this,
its a cheap price to pay :)

Peter...would this help any with the JDBC stuff too, or are you
okay with that one?

#8The Hermit Hacker
scrappy@hub.org
In reply to: Meskes, Michael (#6)
RE: [HACKERS] connection troubles

On Thu, 5 Feb 1998, Meskes, Michael wrote:

Could we please add the ODBC driver to the source tree? I think it would
look much better if we distribute a 'complete' system.

src/interfaces/odbc ... been there for a couple of weeks now :)
Julie has direct access to the source repository, and, like Peter, sort of
has to review any patches applied to it...

Show quoted text

Michael

--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10

-----Original Message-----
From: The Hermit Hacker [SMTP:scrappy@hub.org]
Sent: Wednesday, February 04, 1998 7:59 PM
To: Julia Anne Case
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] connection troubles

On Wed, 4 Feb 1998, Julia Anne Case wrote:

Quoting The Hermit Hacker (scrappy@hub.org):

Julie...

Will PostODBC be v6.3 tested in the next little while? I know
there have been *alot* of changes to v6.3 as far as authentication

is

concerned, which might prove a problem once we release...

I just brought down the latest snapshot to my Sparc/Linux
machine... I'll let you know how it works out... Could take a

little

while to compile it's just a IPX laptop...

I don't have any knowledge of ODBC, but would it help if I setup
and maintained a (reasonably) current server that you can connect
remotely
too for testing? I'll do periodic recompile/installs of it so that it
stays up to date? I'd like to see the ODBC as rock solid as possible
before the 1st, in accordance with v6.3 specs, and if it means doing
this,
its a cheap price to pay :)

Peter...would this help any with the JDBC stuff too, or are you
okay with that one?

#9Peter T Mount
psqlhack@maidast.demon.co.uk
In reply to: The Hermit Hacker (#5)
Re: [HACKERS] connection troubles

On Wed, 4 Feb 1998, The Hermit Hacker wrote:

On Wed, 4 Feb 1998, Julia Anne Case wrote:
I don't have any knowledge of ODBC, but would it help if I setup
and maintained a (reasonably) current server that you can connect remotely
too for testing? I'll do periodic recompile/installs of it so that it
stays up to date? I'd like to see the ODBC as rock solid as possible
before the 1st, in accordance with v6.3 specs, and if it means doing this,
its a cheap price to pay :)

Peter...would this help any with the JDBC stuff too, or are you
okay with that one?

I'm ok here, as I keep the backend relatively up to date. It may be
useful to have one though, as it would allow us to test over a long
distance, and could highlight any problems that don't show up locally.

--
Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk