Return-Path: Delivered-To: apmail-httpd-dev-archive@www.apache.org Received: (qmail 763 invoked from network); 1 Jan 2009 16:50:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Jan 2009 16:50:58 -0000 Received: (qmail 27856 invoked by uid 500); 1 Jan 2009 16:50:56 -0000 Delivered-To: apmail-httpd-dev-archive@httpd.apache.org Received: (qmail 27796 invoked by uid 500); 1 Jan 2009 16:50:56 -0000 Mailing-List: contact dev-help@httpd.apache.org; run by ezmlm Precedence: bulk Reply-To: dev@httpd.apache.org list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list dev@httpd.apache.org Received: (qmail 27787 invoked by uid 99); 1 Jan 2009 16:50:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jan 2009 08:50:56 -0800 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [206.190.39.61] (HELO web53712.mail.re2.yahoo.com) (206.190.39.61) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 01 Jan 2009 16:50:49 +0000 Received: (qmail 13799 invoked by uid 60001); 1 Jan 2009 16:50:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID; b=Nl9M9NXHCXFMzQtREWfhnfbIBLHEXXmk1gkkyL9cTgeS9lwnnzJG7WgOczsFB/jpheTDP76No+8MZMXsw0vfnbKyc1tIpS1IaXTNfOYlYA0I80JjhRUMLMwJZsSOPkqV1FxVoK9/8CSc1TDjKOh/uC9FXr1aXcXuHg1SV1xtBU4=; X-YMail-OSG: br.O4jsVM1lmfBTrYmvwTcaME29WKjs14U_drlCuDs9QIr3Bp6P3m2Yd7eHWitVV0YWxtxrRHkqOZxOO_9krFRWqKn6Kf9yGVJ.HL3pmr0irmHhzL6M6rnMoDcwOWrLeMUU8DX76y5qjz8JhzIkvsJcdy5WLxB2jrzDIsOtuICC.ILlpxV_EjzhgtBPBlWwv89fiLhb7FC_XjlhyXS1A3k.zeVOSiuF_Is66C2mu3Kapxf31kJD4whQ- Received: from [24.61.13.194] by web53712.mail.re2.yahoo.com via HTTP; Thu, 01 Jan 2009 08:50:27 PST X-Mailer: YahooMailWebService/0.7.260.1 Date: Thu, 1 Jan 2009 08:50:27 -0800 (PST) From: Matthew Rushton Reply-To: mrushton7@yahoo.com Subject: mod_dbd issues To: dev@httpd.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-576740124-1230828627=:12646" Message-ID: <694530.12646.qm@web53712.mail.re2.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org --0-576740124-1230828627=:12646 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi, =A0 I'm trying to use mod_dbd for a Linux module with a Postgres backend an= d am running into a bunch of issues. It seems easy enough but all my querie= s are failing becasue I'm not getting back a valid db handle either. Here's= my httpd.conf: LoadModule dbd_module modules/mod_dbd.so DBDriver pgsql DBDParams "hostaddr=3D192.168.1.2 dbname=3D******* user=3D******* connect_t= imeout=3D2" DBDMin 5 DBDKeep 20 DBDMax 50 DBDExptime 120 and in my module code: =A0=A0=A0=A0=A0=A0=A0 //connect to database =A0=A0=A0=A0=A0=A0=A0 dbd =3D ap_dbd_acquire(r); =A0=A0=A0=A0=A0=A0=A0 //I get back a non-null dbd value =A0=A0=A0=A0=A0=A0=A0 PGconn *conn =3D apr_dbd_native_handle(dbd->driver,db= d); =A0=A0=A0=A0=A0=A0=A0 ...do stuff... When I connect with the native Postgres function things work just fine. I'v= e tried this on CentOS 5 and FC9 with the same behavior. On CentOS 5 I'm ge= tting these errors as well when trying to restart (this is not with my modu= le even loaded, simply just by loading mod_dbd): *** glibc detected *** /usr/sbin/httpd: corrupted double-linked list: 0x08e= cb7a8 *** [Thu Jan 01 11:11:41 2009] [warn] child process 25480 still did not exit, s= ending a SIGTERM At a bit of a loss, with the exception of recompining apache with debug I'm= not really sure how to tackle the issue, perhaps it's a simple issue someo= ne may know right away. Thanks. -Matt =0A=0A=0A --0-576740124-1230828627=:12646 Content-Type: text/html; charset=us-ascii
Hi,
  I'm trying to use mod_dbd for a Linux module with a Postgres backend and am running into a bunch of issues. It seems easy enough but all my queries are failing becasue I'm not getting back a valid db handle either. Here's my httpd.conf:

LoadModule dbd_module modules/mod_dbd.so
DBDriver pgsql
DBDParams "hostaddr=192.168.1.2 dbname=******* user=******* connect_timeout=2"
DBDMin 5
DBDKeep 20
DBDMax 50
DBDExptime 120

and in my module code:

        //connect to database
        dbd = ap_dbd_acquire(r);
        //I get back a non-null dbd value
        PGconn *conn = apr_dbd_native_handle(dbd->driver,dbd);
        ...do stuff...

When I connect with the native Postgres function things work just fine. I've tried this on CentOS 5 and FC9 with the same behavior. On CentOS 5 I'm getting these errors as well when trying to restart (this is not with my module even loaded, simply just by loading mod_dbd):

*** glibc detected *** /usr/sbin/httpd: corrupted double-linked list: 0x08ecb7a8 ***
[Thu Jan 01 11:11:41 2009] [warn] child process 25480 still did not exit, sending a SIGTERM

At a bit of a loss, with the exception of recompining apache with debug I'm not really sure how to tackle the issue, perhaps it's a simple issue someone may know right away. Thanks.
-Matt



--0-576740124-1230828627=:12646--