No connection to Server

Name: Dennis Hübner
Email: huebner(at)te-systems(dot)de
<mailto:huebner(at)te-systems(dot)de>
PostgreSQL version: 8.0
Operation system: Windows XP Professional
Short description: No connection to Server


Hi there,

I have trouble with newer versions of postgresql.

On every version of postgresql the only thing I changed at the
'postgresql.conf' is 'max_connections = 500'.
Otherwise I used default installation.

I'm using a telephony-system with 30 lines and I generate calls to this
system.

Now the system looks into the postgres-database if the calling number is
present and after that receives the calls.

With every older postgres-version up to 8.0.0-rc3 (this is the last working
version) everything is all right.

The database-system checks for the user and gives back the results.
This works on all 30 lines parallel.

On newer versions (higher than rc3) the connections were refused or could
not be established by the server.

Every time I get one of these error messages:

- 'could not send SSL negotiation packet: The system cannot find the path
specified'

- 'server closed the connection unexpectedly. This probably means the server
terminated abnormally'

- 'error while processing sql-command'


I hope you can help me.


Kind regards,

Dennis Hübner

************************************************
TE-SYSTEMS GmbH - competence in e-communications
Max-von-Laue-Weg 19 fon +49 5361 895-120
38448 Wolfsburg fax +49 5361 895-999
http://www.te-systems.de <http://www.te-systems.de/>
huebner(at)te-systems(dot)de <mailto:huebner(at)te-systems(dot)de>

Visit also our website: www.xcapi.de <http://www.xcapi.de/>

Dennis,

> Operation system: Windows XP Professional
> Short description: No connection to Server
> - 'could not send SSL negotiation packet: The system cannot find the path
> specified'
> - 'server closed the connection unexpectedly. This probably means the server
> terminated abnormally'
> - 'error while processing sql-command'

That WAS a well known bug up to rc2 / rc3. I had it on at least 4
different machines. Magnus produced a fix with another calling
convention, which went in into rc4 and up.

Within the FAQ of the installer there is a section:

3.1) PostgreSQL and/or the installer crashes at startup, fails to
start or hangs on start

By far most common reasons for this are antivirus and firewalls. If
you have any firewall software installed on your machine, try either
disabling it or uninstalling it. If you have any antivirus software
installed, you must disable it for the directories that are to be used
by PostgreSQL. If that still does not help, it may be required to
completely uninstall the software from the machine.

Specific issues have been reported with the nod32 antivirus product.
If you are using this product, add "postmaster.exe" to the list of
excluded processes (available under advanced options). This has been
reported to fix the problem.

Specific issues have also been reported with McAfee and Panda
anti-virus software and NetLimiter network monitoring software. While
some people do have PostgreSQL working with these software packages,
there is no specific or even recommend solutions that have not worked
in some cases, so the issues would appear to be installation specific,
sometimes even requiring uninstallation.

------------
the spefic error occured with some antivir software, with the id-stick
of X-Check Age Verfication and with some specifig VOIP software
distributed by telecom (which part ever)

Problem is with LSP (Layered service providers) grabbing the
Winsock-Conneciton in an "not documented" way.

So there you can start your search,

good luck

HArald

--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607