The install doesn't automatically add them like it did in the upgrade to 7? Is it supposed to?
Trent ----------- Trent M. Davenport - Systems Administrator Northern Television Systems Ltd - WHTV 203-4103 4th Avenue, Whitehorse, YT Y1A 1H6 (867) 393-2225 X204, (867) 393-2224 FAX www.whtvcable.com <http://www.whtvcable.com> ( [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John Weiner Sent: May 13, 2002 9:18 AM To: [EMAIL PROTECTED] Subject: Re: [imail] 7.1 breaks my external DB setup Stated in the Imail 7.10 release notes: http://support.ipswitch.com/kb/IM-20020507-DM01.htm When installing IMail v7.1 over any earlier version, in which one or more hosts are configured to use an external user database, new columns must be added to the database tables. This is due to additional user-level data which must be stored for use with the new Web Messaging features and for Web Calendaring. These new columns must be added to the user table for each IMail host configured to use an external database. NOTE: If a custom ODBC driver was used with an earlier version of IMail, the driver must be modified to accommodate the new columns. Source code for the basic ODBCUser.dll driver (tailored for SQL Server and Access) may be obtained by download from the IMail Support Center: ftp://ftp.ipswitch.com/Ipswitch/Product_Support/IMail/odbcuser.dll These database column additions must be made before installing IMail v7.1. Also, if a custom ODBC database driver will be used with IMail, it must be created and ready for use. New columns and their types are as follows: IMail Server v7.1 New Columns Database Column Default Name Type Value ------------------------ -------- NUMNOTIFY INTEGER 0 LASTNOTIFY INTEGER 0 Hope it helps, John ----- Original Message ----- From: "Terrence Koeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 10, 2002 11:53 PM Subject: RE: [imail] 7.1 breaks my external DB setup Replacing the 7.10 odbcuser.dll with the one from 7.04 (94,208 bytes) seems to fix this. With the 7.10 dll the problem is step by step reproducable. -- Regards, Terrence Koeman Technical Director/Administrator MediaMonks B.V. (www.mediamonks.nl) Please quote all replies in correspondence. > -----Original Message----- > From: Terrence Koeman [mailto:[EMAIL PROTECTED]] > Sent: Saturday, May 11, 2002 05:46 > To: '[EMAIL PROTECTED]' > Subject: 7.1 breaks my external DB setup > > > I've just attempted to upgrade imail 7.04 to 7.10 on a dev > box. It has 50+ domains with the userinfo stored in an access > ODBC database. > > After the upgrade which goes without errors all the users > seem to have have 'disappeared'. They are still in the db, > but are not accessible or visible in imail adminsitrator. > > I can add a new user, but on hitting F5 after creating the > user it disappears again. This goes without any errors too. > > After letting the box sit for 5 minutes while I was seeking > an older version odbcuser.dll, the box crashed on some kernel > pool violation by iwebmsg.exe. This box had been up for 45 > days until that crash. > > Any ideas? > > -- > Regards, > > Terrence Koeman > > Technical Director/Administrator > MediaMonks B.V. (www.mediamonks.nl) > > Please quote all replies in correspondence. > ______________________________________________________________________ The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc. Questions, Comments or Complain like Hell.. mailto:[EMAIL PROTECTED] Message Archive... http://www.tallylist.com/archives/index.cfm/mlist.4 To Manage your Subscription......... http://humankindsystems.com/lists ______________________________________________________________________ The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc. Questions, Comments or Complain like Hell.. mailto:[EMAIL PROTECTED] Message Archive... http://www.tallylist.com/archives/index.cfm/mlist.4 To Manage your Subscription......... http://humankindsystems.com/lists ______________________________________________________________________ The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc. Questions, Comments or Complain like Hell.. mailto:[EMAIL PROTECTED] Message Archive... http://www.tallylist.com/archives/index.cfm/mlist.4 To Manage your Subscription......... http://humankindsystems.com/lists
