problem with horde and oracle

[Alex Schieber]

Hello,

I have a problem authenticating users using oracle7.3.4 with horde2.0 (php 4.1.1 and apache 1.3.20).
I tested php/oracle without horde, and that works, so I guess it's a case of misconfiguration from my part. Here's an extract from config/horde.php :

$conf['auth']['driver'] = 'sql';

$conf['auth']['params'] = array( 
'phptype' => 'oci8', 
'hostspec' => 'myhost', 
'username' => 'alex', 
'password' => 'xxxxx', 
'protocol' => 'tcp', 
'database' => 'mydatabase', 
'table' => 'horde_users' 
);

When trying to login, I get a pear error :

object(pear_error)(7) { 
["error_message_prefix"]=> 
string(0) "" 
["mode"]=> 
int(1) 
["level"]=> 
int(1024) 
["code"]=> 
NULL 
["message"]=> 
string(32) "Unable to connect to SQL server." 
["userinfo"]=> 
NULL 
["callback"]=> 
NULL 
} 
[/usr/local/apache/htdocs/horde/lib/Auth/sql.php : 109

Has anyone a clue ?

Thanks
alex



>From pgc at ucecom.com Date: 14 Jan 2002 13:44:37 -0500
Return-Path: <pgc at ucecom.com>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 64129 invoked from network); 14 Jan 2002 13:39:46 -0000
Received: from unknown (HELO ucecom.com) (195.8.161.130)
  by clark.horde.org with SMTP; 14 Jan 2002 13:39:46 -0000
Received: from hankey.ucecom.com ([140.4.2.19]) by stan.ucecom.com
          (Netscape Messaging Server 3.6)  with ESMTP id AAA363AD
          for <horde at lists.horde.org>; Mon, 14 Jan 2002 14:27:30 +0000
From: "Paul Cooper" <pgc at ucecom.com>
To: horde at lists.horde.org
In-Reply-To: 
	<5.1.0.14.0.20020114101402.01b119a0 at mailhost.montpellier.cpu.fr>
References: <5.1.0.14.0.20020114101402.01b119a0 at mailhost.montpellier.cpu.fr>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Evolution/1.0.1 
Date: 14 Jan 2002 13:44:37 -0500
Message-Id: <1011033878.23947.10.camel at hankey.ucecom.com>
Mime-Version: 1.0
Subject: Re: [horde] problem with horde and oracle

On Mon, 2002-01-14 at 04:32, Alex Schieber wrote:
> Hello,
> 
> I have a problem authenticating users using oracle7.3.4 with horde2.0 (php 4.1.1 and apache 1.3.20).
> I tested php/oracle without horde, and that works, so I guess it's a case of misconfiguration from my part. Here's an extract from config/horde.php :

Just a guess as I've never used oracle but, does oracle 7.3.4 work with
the oracle 8 call interface? When tested php+oracle did you connect to
it using the older Ora_* functions?

Paul

> $conf['auth']['driver'] = 'sql';
> 
> $conf['auth']['params'] = array( 
> 'phptype' => 'oci8', 
> 'hostspec' => 'myhost', 
> 'username' => 'alex', 
> 'password' => 'xxxxx', 
> 'protocol' => 'tcp', 
> 'database' => 'mydatabase', 
> 'table' => 'horde_users' 
> );
> 
> When trying to login, I get a pear error :
> 
> object(pear_error)(7) { 
> ["error_message_prefix"]=> 
> string(0) "" 
> ["mode"]=> 
> int(1) 
> ["level"]=> 
> int(1024) 
> ["code"]=> 
> NULL 
> ["message"]=> 
> string(32) "Unable to connect to SQL server." 
> ["userinfo"]=> 
> NULL 
> ["callback"]=> 
> NULL 
> } 
> [/usr/local/apache/htdocs/horde/lib/Auth/sql.php : 109
> 
> Has anyone a clue ?
> 
> Thanks
> alex
> 
> 
> -- 
> Horde mailing list: http://horde.org/horde/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
-- 
-----------------------------------------------------------------
Paul Cooper                             |  Tel: 0121 331 7858
Senior Programmer and Database Engineer |  Fax: 0121 331 7859
UCEcom                                  |  mailto:pgc at ucecom.com
University of Central England           |  http://www.ucecom.com
Birmingham, B4 7DX                      |
-----------------------------------------------------------------