[RadiusNT] RE: RadiusNT Digest

GFBuerk ( Gfbuerk@jbelltech.com )
Tue, 2 Nov 1999 17:16:13 -0500

Below is the sql script i use to verify mailusers without using any of
emerald screwy domain stuff. To use this script replace verifymailuser with
this script. And then create an esid(external system ID) in emerald for
Vopmail/MailSite. Then create a service(s) for email specifing the esid of
VopMail/MailSite. add this service to your MBRs that will have email
addresses on the mailserver. Just fill in email address and password field.
Make sure you tell the mailserver to create mailboxes for the doimains you
will use.

This is for people who want the email address control in emerald but do not
want to create billing groups for each domain you host.(dumb)

Also your users will have to login to Vopmail/MailSite as User@Domain /
Password if they leave the domain off it will append the default domain in
MAILSITE/VOPMAIL not emerald!

if exists (select * from sysobjects where id =
object_id('dbo.VerifyMailUser') and sysstat & 0xf = 4)
drop procedure dbo.VerifyMailUser
GO

CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32),
@esid integer AS
Select Login, Shell, Email, d.MailDomain, Password, HomeDir