[horde] Permissions and imap auth

[Michael J Rubinsky]

Quoting Ico Izquierdo <ico at cc.upv.es>:

> 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
>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org

I can't reproduce this. The perms data looks a little off to me also.  
I think these should be of type "matrix" so e.g. with the perms you  
have shown above you should see something like:

|      21 | turba                                                       
       | NULL         |  
a:2:{s:4:"type";s:6:"matrix";s:7:"default";i:30;}                       
                                                                        
                                                                        
                       |
|      22 | turba:sources                                               
       | :21          |  
a:2:{s:4:"type";s:6:"matrix";s:7:"default";i:30;}                       
                                                                        
                                                                        
                       |
|      23 | turba:sources:localsql                                      
       | :21:22       | a:2:{s:4:"type";s:6:"matrix";s:7:"default";i:6;}




-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5751 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20151203/7707ed59/attachment.bin>