mailsite procedures

Mike Hollyman ( )
Fri, 20 Feb 1998 17:48:54 -0600 (CST)

OK, I have installed mailsite and added the user MailServer to
the Emerald database. I added the listed below procedures to the
Emerald database and given MailServer the execute permission to them.

I have 2 accounts in emerald, one with NO email field, the other
with login@test.domain where test.domain is the domain in mailsite. When
I go into mailsite to add database email accounts, it doesn't return any
users to add. Can you tell me where to start to debug this?

Here's the procedures:

CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32),
@esid integer AS

Select Login, Shell, EMail, d.MailDomain, Password, HomeDir