Re: [IMail Forum] External Databases

[Bill James]

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 ----- From: Samuel Miller To: [EMAIL PROTECTED] 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  -----Original Message----- From: Bill James <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, September 13, 1999 12:23 AM Subject: Re: [IMail Forum] External Databases 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 ----- From: Samuel Miller To: [EMAIL PROTECTED] 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