[horde] Permissions and imap auth

[Ico Izquierdo]

El 18/11/2015 a las 16:36, Jan Schneider escribió:
>
> 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.
>
Hi, Jan and Mike,
I've modified perm_parents column making it nullable in database schema.
Now I can add and modify permissions but the result is not as I thought.

I try to configure permissions from Config-Admin interface like this:
Todos los permisos
     Contactos (turba) -> all permissions
         Orígenes (sources) -> all permissions
             Personal de la UPV (upvnet) -> Show, Read

In database the result is like this:
31    turba a:1:{s:7:"default";i:30;}
32    turba:sources           :31 a:1:{s:7:"default";i:30;}
33    turba:sources:upvnet    :31:32 a:1:{s:7:"default";i:6;}

Now I can't see that source neither adding nor in Other contacts menu.

Maybe permissions are not well established?

Thanks in advance

-- 
Ico Izquierdo
Analista-Programador
ASIC - UPV