Fwd: RE: [dev] Informix as db for Horde/IMP/Mnemo/Krnolith ?

[Chuck Hagenbuch]

Please keep conversations on the list so that they are archived and others can
answer.

----- Forwarded message from jim-cramer at uiowa.edu -----
    Date: Mon, 28 Jul 2003 08:49:54 -0500
    From: Jim Cramer <jim-cramer at uiowa.edu>
Reply-To: Jim Cramer <jim-cramer at uiowa.edu>
 Subject: RE: [dev] Informix as db for Horde/IMP/Mnemo/Krnolith ?
      To: Chuck Hagenbuch <chuck at horde.org>

Thanks Chuck,

 I have specified 'ifx' in config/horde.php and in the
backend configuration section of
the .php config files for knonolith and other apps I want
to use.  Below are my exact specifications in horde.php.

 Is there anything else
that I need to do to get PHP/Horde/Horde apps talking to
the specified database?  ':1526' is the port on the
data base server, 'server08', that the Informix engine is
listening for connections on.

 When the Horde login page comes up and I login, I get an
error that it cannot find the database.  I get:

"A fatal error has occurred:
DB Error: no such database
[line 108 of /usr/local/opt/apache-1.3.27/htdocs/horde/lib/Prefs/sql.php]
Details have been logged for the administrator."

where it fails on &DB::connect.

Where is the log file this error is referring to?
Also, what sort of trace/debug facilities are available for me
to use to help track down what is going on?  I looked at
the &connect function in DB.php and it seems that it has some sort
of debug option.


Thanks much for your help,
Sincerely,

Jim Cramer
Data Base Administrator
Computer Systems Support,
College of Engineering,
University of Iowa



// This is an example configuration for a MySQL preference backend.
// The SQL script to setup the preference database is placed in
// horde/scripts/db/prefs.sql.
$conf['prefs']['params']['phptype'] = 'ifx';
$conf['prefs']['params']['hostspec'] = 'server08.icaen.uiowa.edu:1526';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['protocol'] = 'tcp';
$conf['prefs']['params']['password'] = '********';
$conf['prefs']['params']['database'] = 'webmail';
$conf['prefs']['params']['table'] = 'horde_prefs';



> -----Original Message-----
> From: dev-bounces at lists.horde.org [mailto:dev-bounces at lists.horde.org]On
> Behalf Of Chuck Hagenbuch
> Sent: Sunday, July 27, 2003 9:09 PM
> To: dev at lists.horde.org
> Subject: Re: [dev] Informix as db for Horde/IMP/Mnemo/Krnolith ?
>
>
>
> Quoting Jim Cramer <jim-cramer at uiowa.edu>:
>
> >  I would like to know how to deal with anything like this and
> any Informix
> > database-specific installation procedures.  I can create the tables
> > from the .sql script files and I have the DBD::Informix Perl driver
> > working, but what else is there to do?
>
> Well, you need PHP talking to Informix, not Perl. Then try the
> 'ifx' PEAR DB
> driver (phptype = 'ifx' instead of phptype = 'mysql', etc). Once
> you have that
> working, if you want to submit any necessary patches for tablenames, etc.,
> we'll look at them.
>
> -chuck
>
> --
> Charles Hagenbuch, <chuck at horde.org>
> They're just looking at a wall of meat.
>
> --
> Horde developers mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
>



----- End forwarded message -----


-chuck

--
Charles Hagenbuch, <chuck at horde.org>
They're just looking at a wall of meat.