----- Original Message -----
From: "Webmaster" <[EMAIL PROTECTED]>
To: "Imail Forum" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 5:04 PM
Subject: [IMail Forum] External Database
> I need some information on setting up an external database for Imail 6.
>
> What does the table look like? What are the field in it? What info goes
in
> these fields?
The required fields are: userid, password, fullname,userdir and flags. The
table has to be named the same as the domain, but swap the period for an
underscore. What else you include is up to you.
The flags values are
Access Disabled - 1
Hide from information services - 2
User cannot change password - 4
Allow web access - 128
(user is a) Host administrator - 256
(user is a) IMail sysadmin - 512
(user is a) List Admin - 1024
(user) Connot Modify LDAP - 4096
> How do I add/edit/remove a user? How do I add/edit/remove an alias? What
> about aliases whose destination goes to multiple accounts?
Write a SQL command to make the approiate changes, delete a user - delete
that line in the database etc
Aliases etc are handled differently. I'm not the expert here, but I managed
to get 60 free mail domains set up and running in a day or so doing what I
needed them to do from reading the help files and making educated guesses
after seeing what IMail did with the database when I changed things, so I am
sure there are things that I missed.
> I need to do this using SQL commands. So once you I know what the table
> looks like, I also need to know what information goes in each field to
> accomplish the above.
>
> Just a little background, I plan on making some ASP pages that will
add/edit
> aliases in the database?
I read the help file, and then mucked about with it for a couple of hours
one afternoon - worked for me.
Dan
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
