Return-Path: Delivered-To: apmail-httpd-users-archive@www.apache.org Received: (qmail 12359 invoked from network); 6 Feb 2009 18:22:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Feb 2009 18:22:25 -0000 Received: (qmail 5651 invoked by uid 500); 6 Feb 2009 18:22:13 -0000 Delivered-To: apmail-httpd-users-archive@httpd.apache.org Received: (qmail 5635 invoked by uid 500); 6 Feb 2009 18:22:13 -0000 Mailing-List: contact users-help@httpd.apache.org; run by ezmlm Precedence: bulk Reply-To: users@httpd.apache.org list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list users@httpd.apache.org Received: (qmail 5626 invoked by uid 99); 6 Feb 2009 18:22:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Feb 2009 10:22:13 -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 (nike.apache.org: domain of bigchicken05@gmail.com designates 72.14.246.240 as permitted sender) Received: from [72.14.246.240] (HELO ag-out-0708.google.com) (72.14.246.240) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Feb 2009 18:22:04 +0000 Received: by ag-out-0708.google.com with SMTP id 31so634881aga.0 for ; Fri, 06 Feb 2009 10:21:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=CwxxZFmNtW8RMmbZD5ABunCllm4aD4wA+3usn6QI9eQ=; b=Q5lhJBc7VIcgnD93XIGADEBRXxaDDHlA7T1zSfze/FvrmMaIGdNwXM3Nfm9GMUjJeZ nxu1NA/4EBE2XDEDXIh+9sIlhtR4ZhjN8+0bQmOSzpotaYMw78akJYHptm8UNsESHp6d tgVuiCEoRljdt9mYP0uen5WwL3kA1OtQsu49k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=WriQVGuXPWRxxO+2fpeBj32cHAqusC4Heck66O2w4uILwDtJXWkkoyL4pXZ5BKcRlU crgSv4Pd2ta0WoyAFs887z7CO376OvhiUgzi+EQ7uyWdD8Ji5jNKwhja0nPein2aYrSj olfmZWDCiNGuC3da19jCQphXFzT3xMdfJxNvc= MIME-Version: 1.0 Received: by 10.220.81.1 with SMTP id v1mr95534vck.6.1233944503747; Fri, 06 Feb 2009 10:21:43 -0800 (PST) Date: Fri, 6 Feb 2009 13:21:43 -0500 Message-ID: From: Kevin Castellow To: users@httpd.apache.org Content-Type: multipart/alternative; boundary=0016e6460928d1842e0462441732 X-Virus-Checked: Checked by ClamAV on apache.org Subject: [users@httpd] APR-util 1.3.4 Does not create correct connection string for Mod_dbd on Solaris & Oracle Instant Client --0016e6460928d1842e0462441732 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I am using apache 2.2.11 on Solaris10 with apr-1.3.3 and apr-util 1.3.4. The Oracle Instant Client 11_1 is installed and verified to be working with the Instant Client Sql Plus client. I am trying to use the dbd module to authenticate to Oracle. I set the configuration up in this order: DBDriver oracle DBDParams "server=ndev user=DCBDEV2 pass=DCBDEV2" DBDMin 1 DBDKeep 2 DBDMax 10 DBDExptime 60 I found a previous note using Oracle that the parameters did not match the documentation for Oracle. Using the server value first is the only way to get the Service Name correct. I have not been able to successfully pass the userid and password in any combination that I have tried. Originally I tried the documented list Oracle user, pass, dbname, server <--This was not successful for any values. The error log list this error: [Thu Feb 05 15:59:00 2009] [error] (20014)Internal error: DBD: failed to initialise [Thu Feb 05 15:59:00 2009] [error] (20014)Internal error: DBD: Can't connect to oracle Apache is sending this as the connect string to the database: This is a packet sent to the database. The user="Apache" is the owner of the process and not the name being passed in the parameters. tns.connect_data == "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=asgldsora01-vip)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ndev)(CID=(PROGRAM=httpd)(HOST=asgldsdev02b)(USER=apache))))" Thanks for any suggestions or comments on getting this to work. Kevin --0016e6460928d1842e0462441732 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I am using apache 2.2.11 on Solaris10 with apr-1.3.3 and apr-util 1.3.= 4.  The Oracle Instant Client 11_1 is installed and verified to be wor= king with the Instant Client Sql Plus client.
 
I am trying to use the dbd module to authenticate to Oracle.
 
 
I set the configuration up in this order:
DBDriver oracle
DBDParams "server=3Dndev user=3DDCBDEV2 p= ass=3DDCBDEV2"
DBDMin 1
DBDKeep 2
DBDMax 10
DBDExptime 60
 
I found a previous note using Oracle that the parameters did not match= the documentation for Oracle.  Using the server value first is the on= ly way to get the Service Name correct.  I have not been able to succe= ssfully pass the userid and password in any combination that I have tried.<= /div>
 
Originally I tried the documented list
Oracle user, pass, dbname, server  <--This was not successful f= or any values.=20
 =20
The error log list this error:
[Thu Feb 05 15:59:00 2009] [error] (20014)Internal error: DBD: failed t= o initialise
 
[Thu Feb 05 15:59:00 2009] [error] (20014)Internal error: DBD: Can'= t connect to
oracle
 
 
Apache is sending this as the connect string to the database:
This is a packet sent to the database.  The user=3D"Apache&q= uot;  is the owner of the process and not the name being passed in the= parameters.
tns.connect_data =3D=3D "(DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DTC= P)(HOST=3Dasgldsora01-vip)(PORT=3D1521))(CONNECT_DATA=3D(SERVER=3DDEDICATED= )(SERVICE_NAME=3Dndev)(CID=3D(PROGRAM=3Dhttpd)(HOST=3Dasgldsdev02b)(USER=3D= apache))))"
 
 
Thanks for any suggestions or comments on getting this to work.
Kevin
--0016e6460928d1842e0462441732--