* 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,MAX_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,MAX_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,MAX_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,MAX_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,MAX_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,MAX_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.
