[horde] Re: RE horde problem

[samer khalil]

Hi Jan

We were able to see the pages for calendar, notes etc but there is still one
problem: one in say ten trials to access the page are successful. This means
that we click on the Month shortcut the first time, we are able to see a
month view of the calendar.subsequent request will fail with a "The page
cannot be displayed" error.

The listener.log file from the oracle server shows successful connection to
the database. The other log files (horde.log etc show nothing).
Any ideas why this random erratic behavior?
The final configuration we reached in config.php is the following.
$conf['sql']['phptype'] = 'oci8';
$conf['sql']['persistent'] = true;
$conf['sql']['port'] = '';
$conf['sql']['protocol'] = '';
$conf['sql']['hostspec'] = 'europa.aub.edu.lb';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = 'password';
$conf['sql']['database'] = '';
$conf['sql']['charset'] = '';




On Mon, 21 Mar 2005 10:21:48 +0100, Jan Schneider <jan at horde.org> wrote:
> Zitat von samer khalil <samerk1 at gmail.com>:
> 
> >> Depending on the PHP and PEAR DB versions you have, you might need to
> >> specify the 'database' parameter instead.
> >
> > Do you mean by this the $conf['sql']['database'] ? and would this include
> > the name of the database (Oracle SID) or the tnsnames entry?
> > I am not using Oracle 10G, its 9i (9.2.0.4).
> > Here are the settings from the conf.php file:( I have placed the tnsnames
> > entry in database parameter and left out the hostspec parameter.
> >
> > $conf['sql']['phptype'] = 'oci8';
> > $conf['sql']['persistent'] = true;
> > $conf['sql']['port'] = 1521;
> > $conf['sql']['protocol'] = 'tcp';
> > $conf['sql']['hostspec'] = '';
> > $conf['sql']['username'] = 'horde';
> > $conf['sql']['password'] = 'password';
> > $conf['sql']['database'] = 'europa';
> > $conf['sql']['charset'] = 'iso-8859-1';
> >
> > It's still not working. It's not locating the Oracle server anymore.as
> > if it is not reading from tnsnames.ora
> 
> DB's oic8 driver only uses the "username", "password", optionally "charset",
> and "hostspec" OR "database" parameters. Which of the latter two it uses
> depends on the PHP version you have. I know, this completely mad, but out
> of Horde's scope.
> 
> That means that you define the connection parameters in "hostspec" or
> "database". To be sure to use the correct one, simply set both to the same
> value.
> 
> If you compiled PHP with recent enough Oracle client libraries (this has
> nothing to do with the server version you use), you can use the Easy
> Connect syntax. e.g. "//hostname:port/database". See the Oracle
> documentation on the Easy Connect syntax.
> 
> If your client libraries can't handle this sytax, you need to define the
> connection parameters in tnsnames.ora as usual, and put the uses service
> name in the "hostspec" and "database" parameters.
> 
> > Also, what is the role of the horde.php file since it appears to hold
> > configuration info for database connection as well.
> 
> This a configuration file that you left over from an old Horde version.
> 
> Jan.
> 
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> 


-- 
Samer Khalil
Unix System administrator