[imp] sql table weirdness / pref_uid confusion

[Liam Hoekenga]

> Alright, I'm a bit confused. What do you want to be happening - sign-on from
> IMP and from Horde to work independantly? It sounds like maybe you should be
> using IMP as the Horde authenticator?
>
> -chuck

Can you use IMP as the horde authenticator?  It doesn't look like that's an
option in horde.php (it's not listed as an available authentication backend).

I'd like the horde_prefs table to us the same pref_uid regardless whether the
user logs in through horde or through imp.  Setting $servers['imap']['realm']
to '' hasn't seemed to help make this more consistant.

The liamr vs liamr@umich.edu problem seemed to happen both with mysql and oci8.

The liamr vs nothing seems to primarily happen when using oci8.  While using
mysql, I frequently get this in my errorlog:

[22-Aug-2001 14:26:28] PHP Warning:  Undefined index:   in
/usr/local/projects/webmail/html-ssl/horde/lib/Registry.php on line 530

While using oci8, i get this:
[22-Aug-2001 14:26:34] PHP Warning:  Undefined offset:  1 in
/usr/local/projects/webmail/lib/php/DB/common.php on line 139

and the occasional...
[22-Aug-2001 15:06:31] PHP Warning:  Undefined index:  pref_name in
/usr/local/projects/webmail/html-ssl/horde/lib/Prefs/sql.php on line 166

My first pass at creating the tables didn't work (the "add table" silently
ignored the primary key definitions).   horde_pref was most recently created with:

create table horde_prefs (
pref_uid        varchar2(32) not null,
pref_scope      varchar2(16) not null ,
pref_name       varchar2(32) not null,
pref_value      varchar2(4000) null,
constraint PK_HORDE_PREFS primary key (PREF_UID, PREF_SCOPE, PREF_NAME)
);

I'm pretty sure that pref_name is indexed now and that horde_prefs does have
primary keys.  So, i don't know why i'm getting the "undefined index" error. 
I'm equally curious about the "undefined offset: 1" error.  I suspect it's
probably another error the sql i'm using to create the table.  Or mebbe
something the DB abstraction layer?

sorry to take up so much bandwidth.Liam