We have been running against SQL 7.0 SP1 (SP1 is very important) We
started with the source to the DLL that IPSwitch is using. From there we
wrote our dll to be fully threaded and using a single connection to the
database which is persistant. Once a user is in memory cache they are held
(and their information) in the cache for 45minutes before we flush them
from the cache. When they make changes to their account via the web
interface (like password whatever) this is written to the cache and
flagged to be updated back to SQL when they expire.
Now the bad part. This better have a good environment / power system as
you lose power your in for a world of hurt.. We currently run about 25,000
users in the database. This is a common database for Radius/Billing/Imail
running from a Quad Xeon PIII-500 on hardware raid 5.
The problems you are seeing might be the fact the machine is not respond
fast enough. We use dedicated Gigabit ethernet between the servers for
internal use and then 100Mbit external Interfaces on all the servers..
Specific config of what we have is available upon request. The source to
the DLL is not available at this time as it is very specific to our task.
Again I will itterate the only problem I have ever seen with properly
configured servers (thanks Mr. Donnely) is that IMAP goes nuts under heavy
load...
--Matt
------------------------------------------------------------------------
Matthew S. Bailey, President Journey Communications, Inc.
[EMAIL PROTECTED] PO Box 2003
(517) 779-2400 Mt. Pleasant, MI 48858
Inexpensive Wholesale Services for Michigan -- michix.com
------------------------------------------------------------------------
On Tue, 24 Aug 1999, Chris Maccioli wrote:
> I purchased Imail (foolish move) without first evaluating it fully, based on
> its claim of connectivity to external database. Unfortunatly I did not have
> SQL 7 running before buying IMAIL. I am starting a site and the programmer
> I have is using SQL 7 for all user, and other business info. Hopefully if
> Ipswitch ges enough complaints about this they will do something about it,
> or I guess they will lose another customer.
>
> If anyone has gotten Imail to work with SQL 7, with or without added
> programming, please post how to get the solution.
>
> Lenny if you get your mail server (the one being developed) up and running
> shortly, let me know if you are interested in selling a copy.
>
> Thanks
> Chris Maccioli
> Chris Maccioli
> [EMAIL PROTECTED]
>
>
>
> ----- Original Message -----
> From: Lenny Bauman <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 24, 1999 9:21 PM
> Subject: RE: [IMail Forum] POP Hangs on SQL 7 Interruption
>
>
> > Imail does not support ODBC connection to SQL it will only support
> > connections to Access and should not be called ODBC compatible. We have
> > brought up many issues with tech support and have been told each time
> "well
> > it works with access". We looked at version 5 for the ODBC claims and
> are
> > now paying a developer $6,500 to develop a mail server that will work with
> > ODBC that way it is meant to work. BTW this mail server is 65% complete
> and
> > in testing is 35% faster using ODBC then Imail every will be.
> >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]On Behalf Of Andrews, Bryan
> > > (CCI-Atlanta)
> > > Sent: Tuesday, August 24, 1999 3:29 PM
> > > To: '[EMAIL PROTECTED]'
> > > Cc: 'Daniel Donnelly'
> > > Subject: RE: [IMail Forum] POP Hangs on SQL 7 Interruption
> > >
> > >
> > > Wow. This may cause us to re-evaluate our server selection if this is
> not
> > > being addressed by IPSWITCH.
> > >
> > > Does this fall under the realm of 'unsupported' or is it something that
> > > IPSWITCH is looking into? Unfortunately one of the strongest
> > > qualities that
> > > drew us to IMAIL was SQL support. Our implementation demands user
> > > info to be
> > > accessible by our web application. Is this an issue for IMAP as
> > > well or does
> > > it only affect POP (as our app will be using IMAP)?
> > >
> > > Thanks for any further info on this matter.
> > >
> > >
> > > -----Original Message-----
> > > From: Curt LaMontagne [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, August 24, 1999 3:13 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [IMail Forum] POP Hangs on SQL 7
> > > Interruption
> > >
> > > We've been able to isolate a pretty serious problem: the POP
> > > server hangs,
> > > or more accurately, refuses to authenticate, if the SQL 7
> > > service is
> > > interuppted at all. Since the POP service is still running,
> > > however,
> > > there's no easy way to monitor this.
> > >
> > > Ipswitch support tells me this is a known issue with no know
> > > fix. Has
> > > anyone else had this problem, and, if so, is there a
> > > reasonable solution?
> > > I'm thinking of writing a little email client dll on hte
> > > server to try to
> > > log on periodically, and if it fails, restart the service -
> > > but I'm open for
> > > other alternatives.
> > >
> > > Thanks for any help or ideas,
> > >
> > > Curt LaMontagne
> > > USWeb/CKS Phoenix
> > >
> > > 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.
