I am trying to use MySQL as my SQL database for Imail but it seems that
ODBCUSER.dll doesnt work with it. Any ideas how I can make it work?
Jon Cline
Enthusiast, Inc.
http://www.enthusiastonline.com | Do what you love!
[EMAIL PROTECTED]
-----Original Message-----
From: Jeffrey Marsh <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Wednesday, June 21, 2000 11:05 AM
Subject: RE: [IMail Forum] Looking for coldfusion Automated signup front end
for imail anyone got one???
>We use CF to add/remove/modify the Imail user table in SQL. If our table is
>called domain_com, we insert users there. Ron is right about the aliases.
To
>get around that, we created a domain_com_not table. It has two fields
>(UserID [varchar], Alias [bit]). We fill it full of bad words (the
>four-letter variety) and any other userIDs we don't want a user signing up
>to get. - webmaster, postmaster, etc. The alias field for all these is set
>to "no".
>
> We then use REG.EXE from the NT Resource Kit. It can read the registry of
a
>remote computer on the same LAN. Anytime we add an alias to Imail, we run
>this CF page to populate the domain_com_not table with aliases and set the
>alias field to "yes". As part of the stored procedure to add users, it
>checks the desired userid against both tables to make sure it s not already
>taken.
>
>Hope that helps. BTW, we do use Imail web messaging with the HumanKind
>templates (thanks Ron).
>
>--
>Jeffrey B. Marsh
>No job is so simple that it can't be done wrong.
>
>
>
> -----Original Message-----
>From: Jeff Vitale [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 20, 2000 9:07 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [IMail Forum] Looking for coldfusion Automated signup
>front end for imail anyone got one???
>
>Scott, I believe you can use a com object by using the cold fusion cfobject
>tag. This would allow me to call your com object from within my cold fusion
>script.
>
>However, I really need to use sql server as my database because I
anticipate
>a couple hundred thousand users, and I want to offe othere services as well
>such that they have the same username. This means that other services will
>be accessing the same database as Imail. One of these other services is a
>storefront solution which is writen in coldfusion and it must use sql
>server. That's the biggest reason I need to use sql server at this point
(in
>addition to performance issues as well).
>
>Jeff
>
>
>----- Original Message -----
>From: "Scott Pouliot" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, June 21, 2000 11:53 AM
>Subject: RE: [IMail Forum] Looking for coldfusion Automated signup front
end
>for imail anyone got one???
>
>
>> I'm not all that familiar with ColdFusion, but does it allow you to use
>COM
>> Objects like a bunch of other languages do? If so, I've already built a
>COM
>> Object that utilizes Adduser.exe and the IMail Registry for the purpose
of
>> adding users on the fly.
>>
>> Scott
>>
>> -----Original Message-----
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
>> Sent: Wednesday, June 21, 2000 12:39 PM
>> To: [EMAIL PROTECTED]
>> Subject: RE: [IMail Forum] Looking for coldfusion Automated signup front
>> end for imail anyone got one???
>>
>>
>> > I am starting a a vanity email service where members
>> > can select among approx
>> > 50 virtual domains for their email address (like
>> > hotmail with a choice of
>> > domain). I will be using imail.
>> >
>> > I was thinking of using coldfusion as the front end.
>> > Has anyone done this?
>> > If so do you have any code you can share, or perhaps
>> > make available for a
>> > small fee.
>> >
>> > I took the coldfusion class from allaire, but some
>> > starter code would make
>> > my life much easier.
>> >
>> > Looking for autosignup, automatd password retreival,
>> > and using sql as the
>> > back end database.
>>
>> Jeff,
>>
>> Have a look at our EZSignUp utility (demo at
>> http://mail.hksi.net)... you'll see you can choose your domain
>> from a pop-up. That solution uses ASP served by IIS on the same
>> machine.
>>
>> We're a ColdFusion shop, so I appreciate your wanting to do a
>> webmail interface with CF, but you're in for a big, big job.
>> You'll have to rely on POP'ing the mail out, which is quite time
>> and processor-intensive with CF. You could probably spend 6
>> programmer-months working on a CF WebMail system, and still not
>> have half the functionality that you can get (especially
>> administrative functions) using IMail's web messaging service
>> and either stock or custom templates.
>>
>> You could use CF4.5 and its <cfexecute> tag to trigger the
>> adduser utility in a similar fashion to our EZSignUp ASP
>> solution. Or, just insert the rows directly into SQL7... but if
>> you bypass the adduser utility, remember that you're not
>> checking against the Alias names, which IMail stores in the
>> registry. So, users might get an account by the name of "info"
>> or "sales", overriding your aliases, unless you do a hard-wired
>> check for such names in the CF code.
>>
>> hope this helps,
>> Ron
>>
>> ron allen hornbaker humankind systems, inc.
>> mailto:[EMAIL PROTECTED]
>> HKSI WebMail Templates for IMail v6x ~ Now 464 Installations
>> Worldwide
>> Demo: http://mail.hksi.net Buy:
>> http://humankindsystems.com/products
>>
>>
>>
>>
>>
>>
>>
>> Please visit http://www.ipswitch.com/support/mailing-lists.html
>> to be removed from this list.
>>
>> Please visit http://www.ipswitch.com/support/mailing-lists.html
>> to be removed from this list.
>>
>
>
>Please visit http://www.ipswitch.com/support/mailing-lists.html
>to be removed from this list.
>Please visit http://www.ipswitch.com/support/mailing-lists.html
>to be removed from this list.
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
