Definitely interested, I have been looking into doing a similar thing myself
(just caching), but I'm not really a C++ programmer.
Lot's of questions:
1. What sort of expiry does it do, how does it handle changes, i.e. if I
changed a users password in the SQL database table (not using imail) how
long before that change would be picked up.
I was working on the idea of expiring the data after around 10 mins.
2. Do you have to run it in single table mode, though single table is nicer,
I do not really want to migrate 1000's of domains.
3. How much extra memory does the caching take up? Is the level of caching
controllable?
4. Would the price include the source code?
5. Does it still use cursors? I was looking at testing whether using a
criticalsection during the database read would solve the multithreaded
concurrency issue?
6. Does the Imail getfirstuserentry and getnextuserentry functions still
lock up the database and stop authentication (I wasn't sure how to fix that
apart from caching the whole table)?
Thanks
Steve
Steven Moore
Internet Development Engineer
Research Machines PLC
+44 1235 823522
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Steven Plautz
Sent: 17 October 2000 19:03
To: [EMAIL PROTECTED]
Subject: [IMail Forum] odbcuser.dll
I'm testing a new revision to IMail's odbcuser.dll (Mike Nice's version),
which incorporates a cache buffer and event logging. It can also merge all
mail domains into a single database table. I noticed that just signing on
IMail's web interface requires about 10 repetitive SQL queries. I couldn't
believe it. This appears to be a definite vast improvement not only in web
server response, but also in reducing the load on the database server.
Reports show over a 97% hit rate on IMail's webmsg & POP3 services. In
addition, it can keep the mail server up and running during SQL outages
since there's a cache to fall back to. Our IMail server started slowing
down at about 6000 database mailboxes on a dual 500mhz, compaq with 512megs
of ram due to ODBC issues. This appears to greatly increase that
limitation.
Anyone willing to spend $99 for such a dll for IMail? Of course, I'm
willing to sell it off to IPSwitch for IMail v7 too.
Steven Plautz
System Administrator of ISP Operations
Picus - Sybercom
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Eric A.
Shanbrom
Sent: Tuesday, October 17, 2000 1:39 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] changing the username
Actually the user@domain login is only for domains that are sans IP
addresses. If you can set up a virtual domain with an IP address your users
will connect to this particular IP and just log on as their userid.
Eric S
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 16, 2000 4:27 PM
Subject: RE: [IMail Forum] changing the username
> > I plan to run a SINGLE domain on my Imail box. The old usernames did not
> > include the domain name. I want to transfer all these users to
> > the new box.
> > How can I allow my users to continue to use their name only,without
> > specifying the domain. I want the move to be transparent to the users.
>
> Andrew,
>
> If you're only running a single domain, there should be no problem. With
> IMail, you only have to specify the "@domain.com" part for virtual
domains,
> not the primary one.
>
> Hope this helps,
> Ron
>
> ron allen hornbaker humankind systems, inc. mailto:[EMAIL PROTECTED]
> HKSI WebMail Templates for IMail v6x ~ Now 754 Installations Worldwide
> Classic... http://mail.hksi.net Killer... http://killerwebmail.com
>
>
>
>
>
>
> 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/
>
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/
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/
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/
