[horde] HORDE and Interbase

[Havel Zdeněk]

OK,

here are tables and configuration for working prefs and log to interbase
(auth and category I don't use now):

CREATE TABLE HORDE_PREFS (
       PREF_UID VARCHAR(32) NOT NULL,
       PREF_SCOPE VARCHAR(16) DEFAULT '' NOT NULL,
       PREF_NAME VARCHAR(32) NOT NULL,
       PREF_VALUE VARCHAR(2048),
      PRIMARY KEY (PREF_UID,PREF_SCOPE,PREF_NAME)
);

CREATE TABLE LOG_TABLE (
       UNIXTIME INTEGER NOT NULL,
       IDENT CHAR(16) NOT NULL,
       PRIORITY INTEGER,
       message VARCHAR(200),
      PRIMARY KEY (UNIXTIME,IDENT)
);


in horde.conf

$conf['log']['enabled'] = true;
$conf['log']['type'] = 'sql';
$conf['log']['name'] = 'LOG_TABLE';
$conf['log']['priority'] = LOG_ALERT;
$conf['log']['ident'] = 'horde';
$conf['log']['params']['dsn']=
'ibase://loginname:password@ServerWithInterbase/var/lib/ibase/myhorde.gdb


$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['phptype'] = 'ibase';
$conf['prefs']['params']['hostspec'] = 'ServerWithInterbase';
$conf['prefs']['params']['username'] = 'loginname';
$conf['prefs']['params']['password'] = 'password';
$conf['prefs']['params']['database'] = 'var/lib/ibase/myhorde.gdb';
$conf['prefs']['params']['table'] = 'horde_prefs';


all other changes was written in mail from Alexander Knauer, need make
changes from section 4, 5 (without changes in /horde/lib/Perms/sql.php).


                                 Zdenek Havel
 

> -----Original Message-----
> From: Jon Parise [mailto:jon at horde.org] 
> Sent: Tuesday, January 15, 2002 6:08 PM
> To: 'horde at lists.horde.org'
> Subject: Re: [horde] HORDE and Interbase
> 
> 
> On Tue, Jan 15, 2002 at 06:03:34PM +0100, Havel Zdenk wrote:
> 
> > Thanks for all.
> > Problem solved. 
> 
> Great.
> 
> > I was create database from mail "[horde] short summary on 
> IMP & HORDE 
> > with interbase" from "Alexander Knauer". All is right, in 
> this mail, 
> > but in HORDE_PREFS table horde don't use name for field in 
> table "UID" 
> > but "PREFS_UID" and "PREFS_SCOPE" instead "SCOPE".
>  
> Could you please provide your table schema for the 
> horde_prefs table for Interbase?  That way, we can include it 
> with future Horde releases.
> 
> -- 
> Jon Parise (jon at csh.rit.edu)  .  Information Technology 
> (2001) http://www.csh.rit.edu/~jon/  :  Computer Science House Member
> 
> -- 
> Horde mailing list: http://horde.org/horde/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>