Re: [IMail Forum] [IMail_Forum DIGEST]

[Domingo A. Pichardo]

I'm using external databases for 2 different domains and haven't had any
issues.
Attached is a page that defines the "required" fields to the database.
You can always add more if you like but these are the bare bone required.
Also keep in mine that the program expects the fields in that specific
order.

Regards,
Domingo A. Pichardo
NET2001S.COM

----- Original Message -----
From: List Server <[EMAIL PROTECTED]>
Sent: Saturday, October 23, 1999 3:29 AM
Subject: [IMail_Forum DIGEST]


> ----------------------------------------------------------------------
>
> From: "Peter Salvage" <[EMAIL PROTECTED]>
> Date: Fri, 22 Oct 1999 12:34:33 +0200
> Subject: [IMail Forum] iMail v.5 with SQL7
> Reply-To: [EMAIL PROTECTED]
> Hi all
>
> We're currently using version 4.06 and are thinking of upgrading to
> version 5 because of the external database support. However, based on a
> few posts to the list recently, there appears to be some issues with
> version 5 and SQL7?
>
> If so, are there any fixes for odbcuser.dll? Secondly, what fields are
> required by iMail in the database? I can't seem to get that info in the
> doc's although it's extremely possible that I'm looking in the wrong
> place :-)
>
> TIA
> /wiZZ
>
> ----------------------------------------------------------------------
>
> Date: Fri, 22 Oct 1999 14:18:06 +0200
> From: "Luca Salvadori" <[EMAIL PROTECTED]>
> Subject: [IMail Forum] Mailbox backup
> Reply-To: [EMAIL PROTECTED]
> Hi,
>
> Is there any way to save mailboxes to local PCs? I mean, some users would
like, before deleting a mailbox from server, save it somewhere in case of
further need.
> Please consider that users access IMail through the web ONLY.
> Any help is greatly appreciated.
>
> Best regards
> Luca Salvadori
> LABEN S.p.A.
> Milan - Italy

Title: IMail - Values in the FLAGS attribute in an external database

Return to KnowledgeBase Search Page
IMail - Values in the FLAGS attribute in an external database
Product:	Version:	Platform:
IMail	5.0+	NT
Question/Problem: I've been trying to make IMail to work with an external SQL database.  However, IMail can not enable "web access" for each user because there is no value for it in the FLAGS attribute. I would appreciate it if you can give the value in the FLAGS attribute in order to enable "web access" feature. Answer/Solution: The default ODBC table, mentioned in Step 7 on page 17 of the IMail manual, consists of 9 entries: USERID - text PASSWORD - text FULLNAME - text USERDIR - text MAILADDR - text MAXSIZE - integer MAXMSGS - integer FLAGS - integer TYPE - integer The provided implementation expects these entries to be in sequence. Additional information (after type) MAY exist in the table. The "Flags" value acts like a bitmap. Factors such as web access and host administration increase the Flags value. The following is a table of the options and their weight in the bitmap: Hex Decimal Option ====================================================== 1        1         Account access disabled 2        2         Hide from information services 4        4         User cannot change password 80      128    Web Messaging 100    256    Host Administrator 200    512    IMail System Administrator 400    1024  List Administrator 1000  4096  User cannot modify LDAP attributes. So, if the user's Flags value has an 8 in the second digit of the hex value (like 80, or 180), the user has web access.
Document #:		Revision Date:
IM-19990609-DM02		08/11/99

Return To KnowledgeBase Search Page

Title: IMail - Dr. Watson when adding a user to external database

Return to KnowledgeBase Search Page
IMail - Dr. Watson when adding a user to external database
Product:	Version:	Platform:
IMail	5.0+	NT
Question/Problem: I get a Dr. Watson error when I try to add a user. Answer/Solution: In general this means that IMail does not have correct permissions to write to the database. Problem 1: The ODBC database is on another physical computer and the IMail Services do not have permissions to connect to the database. Run the IMail services as a user that has access to communicate across the network. In most cases the local system account (the default user the services run as) does not have permission to access resources across the network. Problem 2: IMail must use a system DSN. Check to make sure you did not create a User DSN or File DSN instead. Problem 3: IMail is using an incorrect Username or Password for the Database. Try using "dsn_name;UID=username;PWD=password" in the DSN field in the external database configuration section. Problem 4: The fields in the table are incorrect. We recommend specifying a non-existent table when first configuring the external database settings. If the table does not exist IMail will create a new table, with the required fields. Check the release notes for your version to verify the fields that IMail requires. Problem 5: We recommend that you configure the database in the following order rather than just working through the IMail Administrator: 1. Go to Control Panel > IMail Server > Global > Virtual Host Admin. 2. Click on the domain 3. Choose an external database. 4. Click SAVE before going to configure. 5. Click on configure. 6. Specify the System DSN. If you need a username and password use: dsn_name;UID=username;PWD=password. NOTE: If you need to use a username that user must have a password. Both UID and PWD must be specified. 7. Specify a nonexistent table name. 8. Save the changes and exit. 9. Now go to the IMail Administrator and add a user.
Document #:		Revision Date:
IM-19990623-DM03		08/11/99

Return To KnowledgeBase Search Page