From owner-freebsd-isp Mon Nov 20 4:29:22 2000 Delivered-To: freebsd-isp@freebsd.org Received: from hitline.ch (mail.pbe.ch [195.129.74.66]) by hub.freebsd.org (Postfix) with ESMTP id 8407C37B479 for ; Mon, 20 Nov 2000 04:29:17 -0800 (PST) Received: from [195.129.74.2] (HELO [10.10.14.36]) by hitline.ch (CommuniGate Pro SMTP 3.3.2) with ESMTP id 2771922 for freebsd-isp@freebsd.org; Mon, 20 Nov 2000 13:33:25 +0100 Mime-Version: 1.0 X-Sender: moshea%tronic-group.com@mail.com4u.ch Message-Id: Date: Mon, 20 Nov 2000 13:29:06 +0100 To: freebsd-isp@freebsd.org From: Michael O Shea Subject: apache+php+pgsql woes Content-Type: text/plain; charset="iso-8859-1" ; format="flowed" Content-Transfer-Encoding: quoted-printable Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hi folks, After many hours of hair pulling I am posting to this list for help. I have a Fresh Install of FreeBSD 4.1.1 upon which I installed and built apache1.3.14+php4.0.3pl1 I also have on another Identical FreeBSD box PostGres SQL server running for which I build my Kernel with options, options SYSVSHM #SYSV-style shared memory options SHMMAXPGS=3D320768 options SYSVMSG #SYSV-style message queues options SYSVSEM #SYSV-style semaphores options SHMSEG=3D256 options SEMMNI=3D256 options SEMMNS=3D512 options SEMMNU=3D256 options SEMMAP=3D256 I start postgres with the following flags, postmaster -i -S 65536 -o -F -N 128 -B 256024 I am trying to store my PHPSessions on Postgres and while it runs fine under small load as soon as it gets busy I get the following in the browser, Warning: Unable to connect to PostgreSQL server: connectDBStart() -- socket() failed: errno=3D55 No buffer space available in /mnt/htdocs/www.somedomain.ch/inc/sessionp.php on line 5 Unable to connect to SQL server Sessionp.php is a simple file that does the inserts,selects etc for the session. It is not the culprit as I can also reproduce the error by anyother php/sql file that does inserts. Has anyone come across this before ? Are the buffers for socket connections to postgres and is there any way to increse the value ? I tried connecting to postgres with and without persistant connections but that does not help. Any help would be much appreciated. Thanks in advance. -- Micheal O Shea ----------------------------------------------------- com-o-tronic ag Micheal O Shea, Systems Engineer Gewerbepark CH-5506 M=E4genwil E-Mail micheal@com4u.ch Voice: +41 62 887 3734 =46ax: +41 62 896 1133 Internet: http://www.com4u.ch http://www.ehitline.ch To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message