Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-12 Thread Tanstaafl
On 3/9/2014 12:10 PM, Tanstaafl wrote: The problem is, SOGo does not have support for using 'Groups' for ACLs when using SQL for the AUTH backend. It also does not (yet) have support for different AUTH and USER DB backends. So, as things stand now, I'm going to have to manually add every single

Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-10 Thread Tanstaafl
On 3/10/2014 10:38 AM, Reindl Harald wrote: So, I need an SQL schema that allows for the creation of 'Groups', that the email 'accounts' can be made members of, that can then be queried to test if any given email user is a member of any given group. Hopefully that was a little clearer that

Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-10 Thread Reindl Harald
Am 10.03.2014 15:34, schrieb Tanstaafl: > On 3/10/2014 9:42 AM, Sergei Golubchik wrote: >> Hi, Tanstaafl! >> >> On Mar 09, Tanstaafl wrote: >>> So, as things stand now, I'm going to have to manually add every >>> single individual userid to every single resource they will need to >>> have access

Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-10 Thread Tanstaafl
On 3/10/2014 9:42 AM, Sergei Golubchik wrote: Hi, Tanstaafl! On Mar 09, Tanstaafl wrote: So, as things stand now, I'm going to have to manually add every single individual userid to every single resource they will need to have access too, rather than just doing this with groups. This is wha

Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-10 Thread Sergei Golubchik
Hi, Tanstaafl! On Mar 09, Tanstaafl wrote: > > So, as things stand now, I'm going to have to manually add every > single individual userid to every single resource they will need to > have access too, rather than just doing this with groups. This is what SQL standard roles were designed to solve

[Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-09 Thread Tanstaafl
Hello all, We have a postfixadmin+mariadb sql database we have been using for many, many years (well, only recently migrated from mysql to mariadb, and it was totally transparent, so thanks for that!). This system is rock solid, and we have no desire to change it. We are in the process of se