Yeah I have all the correct fields, that was the first problem I had, I couldn't add new users, but once I added the right fields that was fixed, although this didn�t fix my other problem.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sergio Rinc�n Jaramillo Sent: Monday, May 27, 2002 4:55 PM To: [EMAIL PROTECTED] Subject: Re: [IMail Forum] imail 7.10 SQL Question Check out that you have the right columns, check this article, i had te same problem, you just need to have the right database format. http://support.ipswitch.com/kb/IM-19990609-DM02.htm Look at the differences between the old versions of Imail and V 7+. This shall be the minimum column names that you should have: USERID - text PASSWORD - text FULLNAME - text USERDIR - text MAILADDR - text MAXSIZE - integer MAXMSGS - integer FLAGS - integer TYPE - integer These database column additions must be made before installing IMail v7.0. Also, if a custom ODBC database driver will be used with IMail, it must be created and ready for use. The new columns and their types are as follows: Database Column Default Name Type Value ------------------------ -------- NUMTRIES INTEGER 0 ATTEMPTTIME INTEGER 0 NUMTIMESSUSP INTEGER 0 LASTLOGIN INTEGER 0 SPNDUSRACCT INTEGER 0 IWOPTIONS INTEGER 0 SPELLCHKG INTEGER 0 ICALENBL INTEGER -1 SPELLENBL INTEGER -1 NUMSGSTNS INTEGER -1 IWDEPTH INTEGER -1 PRVWSIZE INTEGER -1 STRTDAY INTEGER -1 ENTRYGRNL INTEGER -1 STARTTIME INTEGER -1 ENDTIME INTEGER -1 MAXEVNTDISP INTEGER -1 MAXTSKDISP INTEGER -1 MAXNOTEDISP INTEGER -1 MAXDLYRCURCNT INTEGER -1 MAXWKLYRCURCNT INTEGER -1 MAXMONRCURCNT INTEGER -1 MAXYRLYRCURCNT INTEGER -1 DISPCMPLTDTSKS INTEGER -1 HOURSCLOCK INTEGER -1 MAXSRCHRESPPG INTEGER -1 MAXEVENTTITLELEN INTEGER -1 MAXTASKTITLELEN INTEGER -1 CONFIRMONDELETE INTEGER -1 TIMEZONE VARCHAR(255) "" (empty string) DEFVIEW VARCHAR(40) "" DEFCALNM VARCHAR(40) "" For all existing user records, these columns should be set to the default values shown in the table above. ----- Original Message ----- From: "Len Conrad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 27, 2002 6:28 PM Subject: Re: [IMail Forum] imail 7.10 SQL Question > > >I have imail server setup to use my SQL 2000 DB. Everything seems to > >work fine, I can create users and they show in the database just fine. > >My problem is that I cannot log in through the web service or through > >pop3, it always gives a bad username/password error. I have read your > >KB article that says I must set the imail services to a user that has > >SQL DB permissions, I have done this and it still does not work, I have > >restarted the services. What can I do to fix this? > > turn on odbc logging and see what's up > > Len > > www.menandmice.com/DNS-training : DNS Training > BIND8NT.MEIway.com : ISC BIND for NT4 & W2K > IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways > > > 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 the Knowledge Base for answers to frequently asked > questions: http://www.ipswitch.com/support/IMail/ > > 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 the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/ 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 the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/
