|
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
|
