[horde] newbie win horde + oracle

Longinos Ferrando lofesa at gmail.com
Mon Oct 31 05:21:11 PST 2005


Hi all.
I tried to install horde 3.0.6 in a RedHat 4 AS with this conf:
Pear modules:
Installed packages:
===================
Package Version State
Archive_Tar 1.3.1 stable
Console_Getopt 1.2 stable
DB 1.7.6 stable
Date 1.4.5 stable
File 1.2.2 stable
HTML_Template_IT 1.1.2 stable
HTTP 1.3.6 stable
HTTP_Request 1.2.4 stable
Log 1.9.2 stable
Mail 1.1.9 stable
Mail_Mime 1.3.1 stable
Net_SMTP 1.2.7 stable
Net_Socket 1.0.6 stable
Net_URL 1.0.14 stable
Net_UserAgent_Detect 2.1.0 stable
PEAR 1.3.2 stable
SOAP 0.9.1 beta
XML_Parser 1.2.7 stable
XML_RPC 1.4.4 stable


and with these rpm's :
php-oci8-4.3.9-3.8
php-imap-4.3.9-3.8
php-pear-4.3.9-3.8
php-xmlrpc-4.3.9-3.8
php-gd-4.3.9-3.8
php-ldap-4.3.9-3.8
php-ncurses-4.3.9-3.8httpd-suexec-2.0.52-19.ent
system-config-httpd-1.3.1-1
httpd-manual-2.0.52-19.ent
httpd-2.0.52-19.ent
httpd-devel-2.0.52-19.ent
php-4.3.9-3.8
php-domxml-4.3.9-3.8
php-mbstring-4.3.9-3.8
oracle-instantclient-sqlplus-10.1.0.4-1
oracle-instantclient-jdbc-10.1.0.4-1
oracle-instantclient-basic-10.1.0.4-1
oracle-instantclient-devel-10.1.0.4-1

I have config oracle in the horde database settings tab , and preference
system with driver horde default.
I get this message if I configure oracle as a backend database : (only first
lines of message):


DB Error: connect failed

[línea 385 de /var/www/html/horde/lib/Horde/Prefs/sql.php]
Detalles (también en el archivo de registro de Horde):

object(db_error)(8) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-24)
["message"]=>
string(24) "DB Error: connect failed"
["userinfo"]=>
string(73) " [nativecode=ORA-01017: invalid username/password; logon denied]
** Array"
["backtrace"]=>
array(12) {
[0]=>
array(6) {..................

the message say that user/password is invalid, but I have tried this script:

error_reporting(E_ALL);
require_once 'DB.php';


$db = Db::connect('oci8://user:password@tnsnames_string', false);
if (Db::isError($db))
{
die($db->getMessage());
}

$res = $db->query("SELECT * FROM tab");
print_r($res);
if (Db::isError($res))
{
die($res->getMessage());
}

?>

and work fine, thus I think this a mistake with the $dsn that horde send to
Pear:DB.
I have tried Horde 3.0.5, 3.0.6.RC1 and 3.0.6 with the same results.
Any clue?


More information about the horde mailing list