* This is the modus mailing list * The "Note:" part is the one I needed all the detail on. I already know how to insert records.
I would like a descriptions like so... UseDomainSieve integer Specifies weather we should use the domain sieve settings (Possible values 1 for yes, -1 for no) SieveLevel integer Specifies the level of filtering (1 normal, 2 strong, 4 extreme) Etc.. Is there, or can there be, something like this made in a somewhat timely fashion? It would be REALLY helpful to a lot of us here on the list. Jim Barstow Sr. Network Engineer Diversified Solutions and Services, Inc. 22645 Canal Road, Suite B Orange Beach, AL 36561 251.980.8968 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Customer Support Sent: Monday, December 08, 2003 11:30 AM To: [EMAIL PROTECTED] Subject: [Modus] SQL Extended Database Schema Descriptions * This is the modus mailing list * Actually, I wrote up something for this recently ... this how you setup a "minimal" record in the extended db that should work with all the proper setting inheritence: Lets say you're starting with a barebones text file containing your user accounts and passwords Ex: [EMAIL PROTECTED],somepassword [EMAIL PROTECTED],anotherpassword [EMAIL PROTECTED],moocow [EMAIL PROTECTED],heymom [domain.com is the default domain] You would need to transform this into this SQL statement to input the mimimum fields required for proper authentication: INSERT INTO VOPMAIL(USERNAME,VOPPASS,DOMAIN,BOXQUOTA,WARNINGLEVEL,MAX_MESSAGE_SIZE,M AX_I N_MSG_DAILY, MESSAGE_LIFETIME,MAILBOX_LIFETIME,MAX_OUT_MSG_DAILY,MAX_OUT_VOLUME_DAILY ,USE _DOM_ACCESSKEYS) VALUES ('jimbob','somepassword',NULL,-1,-1,-1,-1,-1,-1,-1,-1,1); The NULL Value is for the default domain only. If it's any other domain, (ie: xyz.com), you would specify it, ex: INSERT INTO VOPMAIL(USERNAME,VOPPASS,DOMAIN,BOXQUOTA,WARNINGLEVEL,MAX_MESSAGE_SIZE,M AX_I N_MSG_DAILY, MESSAGE_LIFETIME,MAILBOX_LIFETIME,MAX_OUT_MSG_DAILY,MAX_OUT_VOLUME_DAILY ,USE _DOM_ACCESSKEYS) VALUES ('jimbob','somepassword','xyz.com',-1,-1,-1,-1,-1,-1,-1,-1,1); This would create a minimal entry in the extended database that will work for jimbob. So to input into the database all four users in the above example, you would have an SQL script like this: INSERT INTO VOPMAIL(USERNAME,VOPPASS,DOMAIN,BOXQUOTA,WARNINGLEVEL,MAX_MESSAGE_SIZE,M AX_I N_MSG_DAILY, MESSAGE_LIFETIME,MAILBOX_LIFETIME,MAX_OUT_MSG_DAILY,MAX_OUT_VOLUME_DAILY ,USE _DOM_ACCESSKEYS) VALUES ('jimbob','somepassword',NULL,-1,-1,-1,-1,-1,-1,-1,-1,1); INSERT INTO VOPMAIL(USERNAME,VOPPASS,DOMAIN,BOXQUOTA,WARNINGLEVEL,MAX_MESSAGE_SIZE,M AX_I N_MSG_DAILY, MESSAGE_LIFETIME,MAILBOX_LIFETIME,MAX_OUT_MSG_DAILY,MAX_OUT_VOLUME_DAILY ,USE _DOM_ACCESSKEYS) VALUES ('joebob','anotherpassword',NULL,-1,-1,-1,-1,-1,-1,-1,-1,1); INSERT INTO VOPMAIL(USERNAME,VOPPASS,DOMAIN,BOXQUOTA,WARNINGLEVEL,MAX_MESSAGE_SIZE,M AX_I N_MSG_DAILY, MESSAGE_LIFETIME,MAILBOX_LIFETIME,MAX_OUT_MSG_DAILY,MAX_OUT_VOLUME_DAILY ,USE _DOM_ACCESSKEYS) VALUES ('billybob','moocow',NULL,-1,-1,-1,-1,-1,-1,-1,-1,1); INSERT INTO VOPMAIL(USERNAME,VOPPASS,DOMAIN,BOXQUOTA,WARNINGLEVEL,MAX_MESSAGE_SIZE,M AX_I N_MSG_DAILY, MESSAGE_LIFETIME,MAILBOX_LIFETIME,MAX_OUT_MSG_DAILY,MAX_OUT_VOLUME_DAILY ,USE _DOM_ACCESSKEYS) VALUES ('richard','moocow','xyz.com',-1,-1,-1,-1,-1,-1,-1,-1,1); Repeat for every other user. Note: The minus ones (-1) you see are basically setting up the DB so that the user Quota's are disabeled and set to inherit the value from the domain or the server. The value (1) at the end is to setup the DB so that the user inherits the access keys from the domain or the server-level settings. -- Yves Lacombe Vircom Technical Support and Anti-Spam team "We Fix!" ----- Original Message ----- From: "Thomas L. Utley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 08, 2003 12:24 PM Subject: [Modus] SQL Extended Database Schema Descriptions > * This is the modus mailing list * > > Good luck :-) I have been trying to get that information for several weeks > now :-( > > Tom > > > Jim Barstow wrote: > > > * This is the modus mailing list * > > > > I am trying to build my user manager for the SQL ExtDB and have it > > working, however I would like to know what the descriptions of the > > different fields are as well as the possible values for the fields. > > I had a system on my old one and some of them were 0s and 1s, some > > were -1s and 1s, and I don't remember which is which. > > > > I want to setup defaults so when a new user is created in the db it > > automatically fills in all the default values instead of <null>s. > > > > Thanks, > > > > Jim Barstow > > Sr. Network Engineer > > Diversified Solutions and Services, Inc. > > 22645 Canal Road, Suite B > > Orange Beach, AL 36561 > > 251.980.8968 > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Thomas L. Utley > > Sent: Saturday, December 06, 2003 9:51 AM > > To: [EMAIL PROTECTED] > > Subject: [Modus] Quarantine Database > > > > * This is the modus mailing list * > > > > Hello, I have the quarantine database in SQL and it has been working > > fine for 2 days and all of a sudden we are getting the error below > > when we try and access the Quarantine database from webmail. We > > also get an error if we try and access it from the Modus > > Administrator. Sql server seems to be up and running. > > > > Webmail Error > > An internal error occurred. Please try again later and contact your > > ISP if the problem persists. Description : Code : &H800E03E9 > > > > ModusAdmin Error > > The connection to the database cannot be established. > > > > I have stopped and restarted both Sql server and all modusmail > > services. Still did not fix it. > > > > Any Ideas ? > > > > Thanks > > > > -- > > > > Tom Utley > > > > UData Corporation > > (419) 294-4141 > > Upper Sandusky's Premier Internet Service Provider > > Offering v90/56k, Dedicated and Wireless connectivity Wyandot > > County's only T3(45megabit) Circuit > > > > ** > > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > > word "UNSUBSCRIBE" in the body or subject line. > > > > ** > > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > > word "UNSUBSCRIBE" in the body or subject line. > > -- > > Tom Utley > > UData Corporation > (419) 294-4141 > Upper Sandusky's Premier Internet Service Provider > Offering v90/56k, Dedicated and Wireless connectivity > Wyandot County's only T3(45megabit) Circuit > > > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > word "UNSUBSCRIBE" in the body or subject line. > ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
