RE: [qmailtoaster] List all users on system?

[Aaron Spurlock]

Perfect! I can definitely use that in a script!

> -Original Message-
> From: Philip Nix Guru [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 02, 2007 1:36 PM
> To: qmailtoaster-list@qmailtoaster.com
> Subject: Re: [qmailtoaster] List all users on system?
> 
> Aaron Spurlock wrote:
> > I am looking to find a way to list all of the users on my qmail
> toaster.
> > I currently use Maia Mailguard as my spam solution, and would like
to
> be
> > able to have it query for the existence of a user on my qmail
toaster
> > box to confirm whether or not to accept an email. My goal is to not
> have
> > to add individual users to my Mailguard box, but just have their
> > existence verified where they already exist!
> >
> > I noticed that vpopmail stores all of the domains as separate tables
> in
> > MySQL and all of the users as just the first part of the email
> address
> > inside those tables.
> >
> > Does anyone know of a way to do a query against the database for
> > [EMAIL PROTECTED] for instance and have it work? It seems like you would
> > first need to query dir_control to see if the domain exists, and
then
> > query that domain table to see if the user exists.
> >
> > Mailguard uses postfix, and I hoped to stick the query into the
> > recipient check line, but I'm not sure this is the type of thing
that
> > can be done with one query. I assume a script could be written that
> > would iterate through all of the tables and dump them to a file that
> > postfix could then use as a master list, but I'd like a cleaner
> > way...Thanks for any thoughts!
> >
> >
-
> >  QmailToaster hosted by: VR Hosted <http://www.vr.org>
> >
-
> > To unsubscribe, e-mail: qmailtoaster-list-
> [EMAIL PROTECTED]
> > For additional commands, e-mail: qmailtoaster-list-
> [EMAIL PROTECTED]
> >
> >
> Hello
> To list all users in a quick way
> simply launch this command
> /home/vpopmail/bin/vpopbull -nV
> 
> To check on a user, test the return code on this command vuserinfo
> email_address
> 
> That should do it
> 
> Cheers
> 
> 
> -
>  QmailToaster hosted by: VR Hosted <http://www.vr.org>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: qmailtoaster-list-
> [EMAIL PROTECTED]


-
 QmailToaster hosted by: VR Hosted <http://www.vr.org>
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [qmailtoaster] List all users on system?

[Philip Nix Guru]

Aaron Spurlock wrote:

I am looking to find a way to list all of the users on my qmail toaster.
I currently use Maia Mailguard as my spam solution, and would like to be
able to have it query for the existence of a user on my qmail toaster
box to confirm whether or not to accept an email. My goal is to not have
to add individual users to my Mailguard box, but just have their
existence verified where they already exist!

I noticed that vpopmail stores all of the domains as separate tables in
MySQL and all of the users as just the first part of the email address
inside those tables.

Does anyone know of a way to do a query against the database for
[EMAIL PROTECTED] for instance and have it work? It seems like you would
first need to query dir_control to see if the domain exists, and then
query that domain table to see if the user exists.

Mailguard uses postfix, and I hoped to stick the query into the
recipient check line, but I'm not sure this is the type of thing that
can be done with one query. I assume a script could be written that
would iterate through all of the tables and dump them to a file that
postfix could then use as a master list, but I'd like a cleaner
way...Thanks for any thoughts!

-
 QmailToaster hosted by: VR Hosted 
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

  

Hello
To list all users in a quick way
simply launch this command
/home/vpopmail/bin/vpopbull -nV

To check on a user, test the return code on this command vuserinfo 
email_address


That should do it

Cheers


-
QmailToaster hosted by: VR Hosted 
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [qmailtoaster] List all users on system?

[Philip Nix Guru]

Aaron Spurlock wrote:

I am looking to find a way to list all of the users on my qmail toaster.
I currently use Maia Mailguard as my spam solution, and would like to be
able to have it query for the existence of a user on my qmail toaster
box to confirm whether or not to accept an email. My goal is to not have
to add individual users to my Mailguard box, but just have their
existence verified where they already exist!

I noticed that vpopmail stores all of the domains as separate tables in
MySQL and all of the users as just the first part of the email address
inside those tables.

Does anyone know of a way to do a query against the database for
[EMAIL PROTECTED] for instance and have it work? It seems like you would
first need to query dir_control to see if the domain exists, and then
query that domain table to see if the user exists.

Mailguard uses postfix, and I hoped to stick the query into the
recipient check line, but I'm not sure this is the type of thing that
can be done with one query. I assume a script could be written that
would iterate through all of the tables and dump them to a file that
postfix could then use as a master list, but I'd like a cleaner
way...Thanks for any thoughts!

-
 QmailToaster hosted by: VR Hosted 
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

  

Hello
a quick way to just list all users
/home/vpopmail/bin/vpopbull -nV

To check on a user get the error return code from the vuserinfo 
email_address



-P


-
QmailToaster hosted by: VR Hosted 
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]