|
I believe it's listed in the IMail manual
Bill. Give it a look ;-) You may still need to do the
addition....but that's what Windows calculator was made for right? I never
leave home without it!
Scott
----- Original Message -----
Sent: Monday, September 13, 1999 1:22
PM
Subject: Re: [IMail Forum] External
Databases
Everyone,
I see a need here for a list of the
exact numbers, does anyone happen to have one :-)
----- Original Message -----
Sent: Monday, September 13, 1999 12:58
PM
Subject: Re: [IMail Forum] External
Databases
the numbers used for the flags are bitwise
operators. A value of 132 means the user has web access (128) and
cannot change password (4) = 132
to set a flag, add up the numbers for all the options you
want to give the user. for example, if you want to give the user web
messaging (128) and make them a list administrator (1024) they get a flag of
1152 (128+1024)
----- Original Message -----
Sent: Sunday, September 12, 1999
11:04 PM
Subject: Re: [IMail Forum] External
Databases
Bill
I had read that and set up the table like that. Then I
tried the default way which sets up a table for you, etc. funny thing is I
just deleted the tables that were in my database, changed the imail
database to the external database, set up three accounts , and the web
messaging login works, so now I am going to test out the mail box. The
strange thing, at least I find it strange, is the flag for just a web
access user showed to be 132. The web access with host administrator shows
a flag of 388, and web access with Imail administrator ability is 644. All
three of these flag numbers are completely different then the ones that
were my first two table tries. Anyways maybe it all works now, we'll see.
I can say one thing this product seems to be much better overall than
SLmail / Emurl which is the first product that I evaluated. I have to have
this web based email system up YESTERDAY,
so would everyone in this list generally agree that
Imail is the best product out there for the price.
Thanks for all the help
Sam
Sam,
The order that the database
sends info to Imail is very important. I tried several things and found
that the flags setting needs to be last. Then I found the
following from a readme file I got from the ftp.ipswitch.com site. The exact path
once there is: /ipswitch/product_support/imail
Default ODBC
Tables
-------------------
The default ODBC table
consists of 7 entries:
USERID - text
PASSWORD - text
FULLNAME - text
USERDIR
- text
MAILADDR - text
MAXSIZE -
integer
MAXMSGS - integer
FLAGS -
integer
The provided implementation expects
these entries to be
in sequence. Additional information
(after flags) MAY
exist in the table.
BTW... I was reminded by Scott ( thank you
Scott :-) ) that 128 is the proper flag for web access...I
apologize
I too am new to the list but have already
found it of great use.
Bill
----- Original Message -----
Sent: Monday, September 13, 1999
1:33 AM
Subject: Re: [IMail Forum]
External Databases
I saw some info in the user manual pdf file on
the flags, or maybe it was in the knowledge base, I did see that there
were certain numbers that you need, although I didn't quite understand
which ones were supposed to be used hex or dec. The numbers that Imail
Admin inserted into the database when I created the users didn't seem
to correspond to the numbering scheme. Are you saying that I need to
like maybe set the default value for the flag column to
130 before I ever create any users?
Sam
Sam,
I ran into this also and
what I found out was that I was not setting the flags in the
database first. If I set them with Imail then I still could not
login as the user or send them email. But if I set them in the
database first, I could. After some playing around to see what the
number would be I came up with 130. That gives the user web access
(http://site.com:8383). How I
discovered the correct flag for the parameters was I created users
in the user admin in Imail then looked at the database for the flags
that were set. Iam using an online web site to signup users and am
using hidden tags for the flags and mail message sizes. I would give
the address to you but I do not have it yet on a production machine.
I am testing and tweaking the setup internally. I am trying to get
the database to suggest a userid if the one they chose is already in
use.
Good luck and let me know
how it works for you.
Bill
----- Original Message -----
Sent: Monday, September 13,
1999 12:58 AM
Subject: [IMail Forum]
External Databases
I have been a subscriber to this forum for two
days now, and have seen some comments in regards to external
databases. I posted some messages about login errors that were due
to the way I set up the external database. Since I can deduce that
external databases due work can someone tell me if there is
anything special that I might have overlooked in the setup
process. I created a blank database and an ODBC datasource. I can
connect to the database and create user accounts using the
IMAIL administrator, I can add records manually to the
database and the users will then show up in the User
Administrator. I can't send mail to them though or use web
messaging to login. I have successfully implemented the Imail
database option, but would like to use the external
option.
Thanks in advance
Sam
|
