Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

user and mailbox management with ldap

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


carlos.hanson at gmail

Jan 30, 2009, 11:26 AM

Post #1 of 7 (1349 views)
Permalink
user and mailbox management with ldap

Greetings,

I am testing DBMail as a replacement to our Postfix maildir setup. All
our accounts live in Active Directory, and I can successfully
authenticate to AD to check mail.

Because our current setup is on the file system, if I want to delete a
user's mailbox, I delete their home directory on the mail server. I do
not want to delete their AD account, since we manage our those
accounts with other tools. dbmail-users allows me to "empty all
mailboxes for a user" with the -e flag, but I don't see an option to
delete one or all mailboxes without having to delete the AD account.

Has anyone else come across this situation or something similar? Do I
just need to deal with the database directly? Maybe I just need to
modify dbmail-users to add a check to see if I want to delete the AD
account.

I'll take any suggestions before I dig into the code.

Thanks.

--
Carlos Hanson
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail


aaron at serendipity

Jan 30, 2009, 11:42 AM

Post #2 of 7 (1273 views)
Permalink
Re: user and mailbox management with ldap [In reply to]

Without getting into the implementation details, it sounds like you want a
"disable email for this user" option?

Aaron


On Fri, 30 Jan 2009 11:26:24 -0800, Carlos Hanson <carlos.hanson [at] gmail>
wrote:
> Greetings,
>
> I am testing DBMail as a replacement to our Postfix maildir setup. All
> our accounts live in Active Directory, and I can successfully
> authenticate to AD to check mail.
>
> Because our current setup is on the file system, if I want to delete a
> user's mailbox, I delete their home directory on the mail server. I do
> not want to delete their AD account, since we manage our those
> accounts with other tools. dbmail-users allows me to "empty all
> mailboxes for a user" with the -e flag, but I don't see an option to
> delete one or all mailboxes without having to delete the AD account.
>
> Has anyone else come across this situation or something similar? Do I
> just need to deal with the database directly? Maybe I just need to
> modify dbmail-users to add a check to see if I want to delete the AD
> account.
>
> I'll take any suggestions before I dig into the code.
>
> Thanks.
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail


carlos.hanson at gmail

Jan 30, 2009, 12:07 PM

Post #3 of 7 (1269 views)
Permalink
Re: user and mailbox management with ldap [In reply to]

Not really a disable email. More of a clear out all records of this
account in the database as if they never had email. I haven't looked
at the code for deleting an account, but my expectation is that is
part of the deletion. Since I don't want to delete the LDAP account,
that option doesn't work for me.

The disable email is a good idea though in addition to the delete all
mailboxes. There may be times when you want to disable an account
temporarily, or perhaps permanently without the desire to purge all
email and mailboxes.


On Fri, Jan 30, 2009 at 11:42 AM, Aaron Stone <aaron [at] serendipity> wrote:
> Without getting into the implementation details, it sounds like you want a
> "disable email for this user" option?
>
> Aaron
>
>
> On Fri, 30 Jan 2009 11:26:24 -0800, Carlos Hanson <carlos.hanson [at] gmail>
> wrote:
>> Greetings,
>>
>> I am testing DBMail as a replacement to our Postfix maildir setup. All
>> our accounts live in Active Directory, and I can successfully
>> authenticate to AD to check mail.
>>
>> Because our current setup is on the file system, if I want to delete a
>> user's mailbox, I delete their home directory on the mail server. I do
>> not want to delete their AD account, since we manage our those
>> accounts with other tools. dbmail-users allows me to "empty all
>> mailboxes for a user" with the -e flag, but I don't see an option to
>> delete one or all mailboxes without having to delete the AD account.
>>
>> Has anyone else come across this situation or something similar? Do I
>> just need to deal with the database directly? Maybe I just need to
>> modify dbmail-users to add a check to see if I want to delete the AD
>> account.
>>
>> I'll take any suggestions before I dig into the code.
>>
>> Thanks.
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>



--
Carlos Hanson
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail


aaron at serendipity

Jan 30, 2009, 9:16 PM

Post #4 of 7 (1263 views)
Permalink
Re: user and mailbox management with ldap [In reply to]

Sounds like dbmail-user -e is indeed what you're looking for.

On Fri, 2009-01-30 at 12:07 -0800, Carlos Hanson wrote:
> Not really a disable email. More of a clear out all records of this
> account in the database as if they never had email. I haven't looked
> at the code for deleting an account, but my expectation is that is
> part of the deletion. Since I don't want to delete the LDAP account,
> that option doesn't work for me.
>
> The disable email is a good idea though in addition to the delete all
> mailboxes. There may be times when you want to disable an account
> temporarily, or perhaps permanently without the desire to purge all
> email and mailboxes.
>
>
> On Fri, Jan 30, 2009 at 11:42 AM, Aaron Stone <aaron [at] serendipity> wrote:
> > Without getting into the implementation details, it sounds like you want a
> > "disable email for this user" option?
> >
> > Aaron
> >
> >
> > On Fri, 30 Jan 2009 11:26:24 -0800, Carlos Hanson <carlos.hanson [at] gmail>
> > wrote:
> >> Greetings,
> >>
> >> I am testing DBMail as a replacement to our Postfix maildir setup. All
> >> our accounts live in Active Directory, and I can successfully
> >> authenticate to AD to check mail.
> >>
> >> Because our current setup is on the file system, if I want to delete a
> >> user's mailbox, I delete their home directory on the mail server. I do
> >> not want to delete their AD account, since we manage our those
> >> accounts with other tools. dbmail-users allows me to "empty all
> >> mailboxes for a user" with the -e flag, but I don't see an option to
> >> delete one or all mailboxes without having to delete the AD account.
> >>
> >> Has anyone else come across this situation or something similar? Do I
> >> just need to deal with the database directly? Maybe I just need to
> >> modify dbmail-users to add a check to see if I want to delete the AD
> >> account.
> >>
> >> I'll take any suggestions before I dig into the code.
> >>
> >> Thanks.
> > _______________________________________________
> > DBmail mailing list
> > DBmail [at] dbmail
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
>
>

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail


carlos.hanson at gmail

Jan 31, 2009, 6:44 PM

Post #5 of 7 (1259 views)
Permalink
Re: user and mailbox management with ldap [In reply to]

dbmail-users -e simply deletes all the email. It does not delete any mailboxes.

Let me try again. I want to delete an account: email, mailboxes, any
record of usage. I assume that dbmail-users -d does that already.
However, when using LDAP, I do not want to delete the LDAP account,
just the dbmail records.


On Fri, Jan 30, 2009 at 9:16 PM, Aaron Stone <aaron [at] serendipity> wrote:
> Sounds like dbmail-user -e is indeed what you're looking for.
>
> On Fri, 2009-01-30 at 12:07 -0800, Carlos Hanson wrote:
>> Not really a disable email. More of a clear out all records of this
>> account in the database as if they never had email. I haven't looked
>> at the code for deleting an account, but my expectation is that is
>> part of the deletion. Since I don't want to delete the LDAP account,
>> that option doesn't work for me.
>>
>> The disable email is a good idea though in addition to the delete all
>> mailboxes. There may be times when you want to disable an account
>> temporarily, or perhaps permanently without the desire to purge all
>> email and mailboxes.
>>
>>
>> On Fri, Jan 30, 2009 at 11:42 AM, Aaron Stone <aaron [at] serendipity> wrote:
>> > Without getting into the implementation details, it sounds like you want a
>> > "disable email for this user" option?
>> >
>> > Aaron
>> >
>> >
>> > On Fri, 30 Jan 2009 11:26:24 -0800, Carlos Hanson <carlos.hanson [at] gmail>
>> > wrote:
>> >> Greetings,
>> >>
>> >> I am testing DBMail as a replacement to our Postfix maildir setup. All
>> >> our accounts live in Active Directory, and I can successfully
>> >> authenticate to AD to check mail.
>> >>
>> >> Because our current setup is on the file system, if I want to delete a
>> >> user's mailbox, I delete their home directory on the mail server. I do
>> >> not want to delete their AD account, since we manage our those
>> >> accounts with other tools. dbmail-users allows me to "empty all
>> >> mailboxes for a user" with the -e flag, but I don't see an option to
>> >> delete one or all mailboxes without having to delete the AD account.
>> >>
>> >> Has anyone else come across this situation or something similar? Do I
>> >> just need to deal with the database directly? Maybe I just need to
>> >> modify dbmail-users to add a check to see if I want to delete the AD
>> >> account.
>> >>
>> >> I'll take any suggestions before I dig into the code.
>> >>
>> >> Thanks.
>> > _______________________________________________
>> > DBmail mailing list
>> > DBmail [at] dbmail
>> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
>> >
>>
>>
>>
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>



--
Carlos Hanson
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail


paul at nfg

Feb 1, 2009, 1:50 AM

Post #6 of 7 (1258 views)
Permalink
Re: user and mailbox management with ldap [In reply to]

Use sql:

begin;
delete from dbmail_users where userid='someusername';
commit;

this will delete (per cascade) all mailboxes and messages connected.
Upon next delivery to this user, the record in dbmail_users will be
re-created.


Carlos Hanson wrote:
> dbmail-users -e simply deletes all the email. It does not delete any mailboxes.
>
> Let me try again. I want to delete an account: email, mailboxes, any
> record of usage. I assume that dbmail-users -d does that already.
> However, when using LDAP, I do not want to delete the LDAP account,
> just the dbmail records.
>
>
> On Fri, Jan 30, 2009 at 9:16 PM, Aaron Stone <aaron [at] serendipity> wrote:
>> Sounds like dbmail-user -e is indeed what you're looking for.
>>
>> On Fri, 2009-01-30 at 12:07 -0800, Carlos Hanson wrote:
>>> Not really a disable email. More of a clear out all records of this
>>> account in the database as if they never had email. I haven't looked
>>> at the code for deleting an account, but my expectation is that is
>>> part of the deletion. Since I don't want to delete the LDAP account,
>>> that option doesn't work for me.
>>>
>>> The disable email is a good idea though in addition to the delete all
>>> mailboxes. There may be times when you want to disable an account
>>> temporarily, or perhaps permanently without the desire to purge all
>>> email and mailboxes.
>>>
>>>
>>> On Fri, Jan 30, 2009 at 11:42 AM, Aaron Stone <aaron [at] serendipity> wrote:
>>>> Without getting into the implementation details, it sounds like you want a
>>>> "disable email for this user" option?
>>>>
>>>> Aaron
>>>>
>>>>
>>>> On Fri, 30 Jan 2009 11:26:24 -0800, Carlos Hanson <carlos.hanson [at] gmail>
>>>> wrote:
>>>>> Greetings,
>>>>>
>>>>> I am testing DBMail as a replacement to our Postfix maildir setup. All
>>>>> our accounts live in Active Directory, and I can successfully
>>>>> authenticate to AD to check mail.
>>>>>
>>>>> Because our current setup is on the file system, if I want to delete a
>>>>> user's mailbox, I delete their home directory on the mail server. I do
>>>>> not want to delete their AD account, since we manage our those
>>>>> accounts with other tools. dbmail-users allows me to "empty all
>>>>> mailboxes for a user" with the -e flag, but I don't see an option to
>>>>> delete one or all mailboxes without having to delete the AD account.
>>>>>
>>>>> Has anyone else come across this situation or something similar? Do I
>>>>> just need to deal with the database directly? Maybe I just need to
>>>>> modify dbmail-users to add a check to see if I want to delete the AD
>>>>> account.
>>>>>
>>>>> I'll take any suggestions before I dig into the code.
>>>>>
>>>>> Thanks.
>>>> _______________________________________________
>>>> DBmail mailing list
>>>> DBmail [at] dbmail
>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>>
>>>
>>>
>> _______________________________________________
>> DBmail mailing list
>> DBmail [at] dbmail
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>
>
>


--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail


carlos.hanson at gmail

Feb 1, 2009, 2:06 AM

Post #7 of 7 (1258 views)
Permalink
Re: user and mailbox management with ldap [In reply to]

Thanks. I thought that might be where I would end up. I was worried it
would be more complicated. Thank goodness for cascade on delete.


On Sun, Feb 1, 2009 at 1:50 AM, Paul J Stevens <paul [at] nfg> wrote:
>
> Use sql:
>
> begin;
> delete from dbmail_users where userid='someusername';
> commit;
>
> this will delete (per cascade) all mailboxes and messages connected.
> Upon next delivery to this user, the record in dbmail_users will be
> re-created.
>
>
> Carlos Hanson wrote:
>> dbmail-users -e simply deletes all the email. It does not delete any mailboxes.
>>
>> Let me try again. I want to delete an account: email, mailboxes, any
>> record of usage. I assume that dbmail-users -d does that already.
>> However, when using LDAP, I do not want to delete the LDAP account,
>> just the dbmail records.
>>
>>
>> On Fri, Jan 30, 2009 at 9:16 PM, Aaron Stone <aaron [at] serendipity> wrote:
>>> Sounds like dbmail-user -e is indeed what you're looking for.
>>>
>>> On Fri, 2009-01-30 at 12:07 -0800, Carlos Hanson wrote:
>>>> Not really a disable email. More of a clear out all records of this
>>>> account in the database as if they never had email. I haven't looked
>>>> at the code for deleting an account, but my expectation is that is
>>>> part of the deletion. Since I don't want to delete the LDAP account,
>>>> that option doesn't work for me.
>>>>
>>>> The disable email is a good idea though in addition to the delete all
>>>> mailboxes. There may be times when you want to disable an account
>>>> temporarily, or perhaps permanently without the desire to purge all
>>>> email and mailboxes.
>>>>
>>>>
>>>> On Fri, Jan 30, 2009 at 11:42 AM, Aaron Stone <aaron [at] serendipity> wrote:
>>>>> Without getting into the implementation details, it sounds like you want a
>>>>> "disable email for this user" option?
>>>>>
>>>>> Aaron
>>>>>
>>>>>
>>>>> On Fri, 30 Jan 2009 11:26:24 -0800, Carlos Hanson <carlos.hanson [at] gmail>
>>>>> wrote:
>>>>>> Greetings,
>>>>>>
>>>>>> I am testing DBMail as a replacement to our Postfix maildir setup. All
>>>>>> our accounts live in Active Directory, and I can successfully
>>>>>> authenticate to AD to check mail.
>>>>>>
>>>>>> Because our current setup is on the file system, if I want to delete a
>>>>>> user's mailbox, I delete their home directory on the mail server. I do
>>>>>> not want to delete their AD account, since we manage our those
>>>>>> accounts with other tools. dbmail-users allows me to "empty all
>>>>>> mailboxes for a user" with the -e flag, but I don't see an option to
>>>>>> delete one or all mailboxes without having to delete the AD account.
>>>>>>
>>>>>> Has anyone else come across this situation or something similar? Do I
>>>>>> just need to deal with the database directly? Maybe I just need to
>>>>>> modify dbmail-users to add a check to see if I want to delete the AD
>>>>>> account.
>>>>>>
>>>>>> I'll take any suggestions before I dig into the code.
>>>>>>
>>>>>> Thanks.
>>>>> _______________________________________________
>>>>> DBmail mailing list
>>>>> DBmail [at] dbmail
>>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>>>
>>>>
>>>>
>>> _______________________________________________
>>> DBmail mailing list
>>> DBmail [at] dbmail
>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>>
>>
>>
>
>
> --
> ________________________________________________________________
> Paul Stevens paul at nfg.nl
> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
> The Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>



--
Carlos Hanson
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.