Thread: No connection to Server
Name: Dennis Hübner
Email: huebner@te-systems.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 huebner@te-systems.de
Visit also our website: www.xcapi.de
Dennis, > Operation system: Windows XP Professional=20 > Short description: No connection to Server=20 > - 'could not send SSL negotiation packet: The system cannot find the path > specified'=20 > - 'server closed the connection unexpectedly. This probably means the ser= ver > terminated abnormally'=20 > - 'error while processing sql-command'=20 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=20 HArald --=20 GHUM Harald Massa Harald Armin Massa Reinsburgstra=DFe 202b 70197 Stuttgart 0173/9409607