proper way to delete a user from the database?

Hi,

We had a problem a few weeks ago with our
local_recipient_map in postfix 
( long story! ) and as a result, we got about 10,000
spurious user 
accounts autocreated in maia. 

I know how to tell the good ones from the bad ones ( check
our ldap 
directory ).  That being said, what tables do I need to
delete from?   I 
think I know already, but I don't want to get in a jam and
miss one and 
have a mess on my hands.

Thanks,

Aaron
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Jul 11, 2007, at 8:53 AM, Aaron Bennett wrote:

> Hi,
>
> We had a problem a few weeks ago with our
local_recipient_map in  
> postfix
> ( long story! ) and as a result, we got about 10,000
spurious user
> accounts autocreated in maia.
>
> I know how to tell the good ones from the bad ones (
check our ldap
> directory ).  That being said, what tables do I need to
delete  
> from?   I
> think I know already, but I don't want to get in a jam
and miss one  
> and
> have a mess on my hands.

Dump the addresses to a file, and then use:

maiadbtool.db  --delete-from-file file


David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFGlOIBUy30ODPkzl0RAvRfAKCztw9voztAFA8608RKBPMnOEQ3CwCg
qQC4
XSSkJ3fAf2o1m63bmcIi4q0=
=2HuP
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Aaron Bennett wrote:
> David Morton wrote:
>> Dump the addresses to a file, and then use:
>>
>> maiadbtool.db  --delete-from-file file
> I'm running version 1.0.1 right now, and I've modified
auth.php to
> account for our oddball ldap infrastructure (and a
bunch of other
> stuff).  1.0.1 (as far as I know) didn't come with
maiadbtool.db.  Do
> you know if maiadbtool.db will work with the database
structure for 1.0.1?

There are no modifications to the database structure in
1.0.2 (and future 1.0.x
releases), so I think it should work just fine.  If you
want, look at the source
for that function and look at the SQL, and it will show what
tables are affected.


- --
David Morton
Maia Mailguard                        - http://www.maiamailguard
.com
Morton Software Design and Consulting - http://www.dgrmm.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


iD8DBQFGlPNhUy30ODPkzl0RAsh1AJsHJg/R4UarQlJzhJdBr2QJ+WJUTQCg
ykpB
Bw+Lyy3Yd0b4dD6Hise5zao=
=BTiU
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users