[horde] Re: RE horde problem

[Jan Schneider]

Please keep discussions on the list.

Zitat von George Salloum <georges at aub.edu.lb>:

>
> Hi Jan
> Thanks for replying back with respect to my error on Horde and Oracle 9i.
> I don't know If you can help me but I have been able to isolate the error
> down to the conf.php more specifically with the setting:
> $conf['sql']['hostspec'] = '193.188.129.15';

Depending on the PHP and PEAR DB versions you have, you might need to 
specify the 'database' parameter instead.

> I have tried all combinations. Logic says I should have the tnsnames entry
> in here. yet whatever I add, I get it back in the listener.log file on my

Exactly. But if you built PHP with the 10g client libraries or instant 
client, you can specify an Easy Connect parameter there.

> Oracle server as being used as the service name, you will also note that the
> SID values contains an asterisk instead of having the database sid in it.
> 18-MAR-2005 17:09:12 *
> (CONNECT_DATA=(SID=*)(SERVICE_NAME=193.188.129.15)(CID=(PROGRAM=)(HOST=nemo.
> aub.edu.lb)(USER=www))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=193.188.129.122)(PORT=37603)) * establish *
> 193.188.129.15 * 12514
> When I connect (successfully) using sqlplus I get
> 18-MAR-2005 16:26:31 *
> (connect_data=(SERVICE_NAME=FPSTEST)(CID=(PROGRAM=)(HOST=nemo.aub.edu.lb)(US
> ER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=193.188.129.122)(PORT=37574)) *
> establish * FPSTEST * 0
> I would greatly appreciate if you could just point me in the direction to
> look.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/