NTmail Workaround

Duane Schaub ( dschaub@terraworld.net )
Thu, 12 Feb 1998 11:01:53 -0600

There seems to be a problem with NTmail 3.03c and the external dll doing
authentications. I have included a script below that pulls users from the
database using sql_w. You then save that file and use the commandline
mail.exe program included with ntmail. I will not go into the details of
mail.exe, suffice it to say that if you type mail and hit enter, you will
get help. Also,
mail -h with an option letter immediately following it will give you more
verbose help.

BACK UP THE internet shopper REGISTRY KEY BEFORE TRYING ANYTHING!

You will need to adjust the script because mail only works on one ip at a
time. IOW, if your primary domain has several aliases, then you need only
the users in those domains. For secondary domains with seperate IP's for
the mail server, you must run the script getting each of those users into a
seperate file.

typing: mail -lfilename.txt or mail -bdomain.com -lfilename.txt will
completely overwrite any existing users. In my case, I had some special
setups already installed in ntmail. I used
mail -bdomain.com -folduser-domain.txt
to dump the existing users to a file. This file goes on the END of the
newusers file. That way any affected users will get replaced.
Furthermore, be sure to adjust the accountypes that you need. LOOK at the
resulting file before using it to make sure that you get what you expect!.

I WILL NOT BE RESPONSIBLE FOR PEOPLE SCREWING THEIR MAIL! If you are not
comfortable with this.... DON'T DO THIS.

There are many things that could be added. Example: Add stuff for
aliases, specific mail addresses, etc.

select subaccounts.login, subaccounts.login, "-"+subaccounts.password
from subaccounts, masteraccounts
where (subaccounts.customerid = masteraccounts.customerid and
( subaccounts.accounttype = "PPP U20" or
subaccounts.accounttype = "PPP U25" or
subaccounts.accounttype = "PPP C35" or
subaccounts.accounttype = "PPP C-Add15" or
subaccounts.accounttype = "Email" or
subaccounts.accounttype = "PPP Complimenta" or
subaccounts.accounttype = "PPP-Educ15" or
subaccounts.accounttype = "PPP Corp. Mail") and
( masteraccounts.groupid <> 5 and
masteraccounts.groupid <> 6 and
masteraccounts.groupid <> 12 and
masteraccounts.groupid <> 14 and
masteraccounts.groupid <> 21 and
masteraccounts.groupid <> 23 and
masteraccounts.groupid <> 25)
and (masteraccounts.active = 1 and subaccounts.active = 1))
order by subaccounts.login

==========================================================================
Duane Schaub, President |Terra World, Inc - Connecting The Planet
Terra World, Inc. |Southeast Kansas' Leading Provider
200 Arco Place, Suite 252 |Flat Fee - Never an hourly Charge
Independence, Kansas 67301 |Where Service is Top Priority!
Voice (316) 332-1616 |http://www.terraworld.net
FAX: (316) 332-1451 |dschaub@terraworld.net
===========================================================================