[horde] Permissions and imap auth

Jan Schneider jan at horde.org
Wed Nov 18 15:36:53 UTC 2015


Zitat von Ico Izquierdo <ico at cc.upv.es>:

> Hello,
> I'm using Horde Groupware Webmail Edition 5.2.11.
> The system authenticate against imap server. Can be that the reaswon  
> because I can't add permissions.
> For example I have two ldap directories and one localsql configured  
> as backends in Turba. I would like configure that "Add" option only  
> show the localsql, not ldap.
> When I try to establish some permission in Turba application it  
> stops pushing up a message like:
>
> No se ha creado "Contactos (turba)": QUERY FAILED: ORA-01400: no se  
> puede realizar una inserción NULL en  
> ("ORDENU"."HORDE_PERMS"."PERM_PARENTS") at offset 67 INSERT INTO  
> horde_perms (perm_name, perm_parents) VALUES ('turba', '').

Oracle doesn't like empty strings in NOT NULL columns. We should make  
the perm_parents column NULL and also use NULL instead of '' in  
Horde_Perms_Sql.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/



More information about the horde mailing list