On Tue, 2004-07-06 at 04:07, Tomek Jarzynka wrote:
> Hi,
> 
> I thought DBmail is SQL-based, and so, that the userlist is
> stored entirely in the database. To my dismay, I could not
> add a working e-mail address to the base using solely SQL
> queries. Do I really have to use the dbmail-adduser command?
> Or have I done something wrong? What is the correct command
> set to manage users? 
> 
> I could not find any decent DBmail documentation, including
> man pages for the dbmail console tools. 
> 
> By the way, how do I properly *remove* a user or otherwise 
> change his properties?
> 
> TIA

What I did is

Add user to the users  table
add alias to the aliases table
add a mailbox to the mailboxes table

and works fine

to delete the user an all of his mail

just delete  the user from the aliases table 
and delete the user from the users table

The database schema has on DELETE CASCADE so deletes all the records the
other tables

I'm using  PostgreSQL

-- 
 ,''`.  Leonel Nunez
: :' :  http://enelserver.com
`. `'   DEBIAN GNU/LINUX
  `-    A REAL FREE OS


Reply via email to