1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Email all E-mail accounts on a server

Discussion in 'Plesk for Linux - 8.x and Older' started by voodoochile, Aug 15, 2005.

  1. voodoochile

    voodoochile Guest

    0
     
    Hey,

    I'm trying to bounce out an email to all e-mail accounts on my psa boxes, and I'm kinda stumped as to where to pull this list of email addresses from.

    I'm trying to snag this directly from the database, and I believe it's got something to do with the mn_id column, but I'm not sure as how to tie everything else together. =(

    I can do it for main domain contacts, just about anything else, but a 100% listing of all e-mail addy's on a box eludes me somehow. =(


    If you might know how to do this, let me know, otherwise, I'll post it here when I figure it out.

    Thanks!
     
  2. jamesyeeoc

    jamesyeeoc Guest

    0
     
    This little script to list (names, passwords, domains) was posted back in May 2005, in the Plesk 7.0 forum (by wazoo):

    select d.name, m.mail_name, a.password from mail m,domains d, accounts a where d.id = m.dom_id and a.id =m.account_id and
    m.postbox = 'true' order by d.name,m.mail_name;

    It does work for Plesk 7.5.3 as well.

    Original thread:

    http://forum.plesk.com/showthread.php?threadid=23613&highlight=email+password+list+script

    If nothing else, it shows the relationship between the tables and the data you will be looking for, so you can integrate it into your script.
     
  3. voodoochile

    voodoochile Guest

    0
     
    Thanks man, that did the trick. =)
     
Loading...