1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Finding all AOL redirects

Discussion in 'Plesk for Linux - 8.x and Older' started by nvoth, May 7, 2006.

  1. nvoth

    nvoth New Pleskian

    22
    57%
    Joined:
    Aug 15, 2001
    Messages:
    10
    Likes Received:
    0
    Hello,

    I need to find all the mail accounts that have redirects to any AOL.com address. The Plesk support guys offered this:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e "select domains.name, Parameters.value from domains,Parameters where domains.params_id=Parameters.id and Parameters.parameter='catch_addr' and Parameters.value like '%aol.com%';"

    BUT it doesn't really work. Any idea how to easily find all the redirects to AOL?

    Thanks,

    -Nick Voth
     
  2. jspilon

    jspilon Guest

    0
     
    connect to mysql using an authorized user...

    mysql -u admin -p

    then run the following SQL statement

    select * from psa.mail_redir where address like '%yahoo%';
     
  3. nvoth

    nvoth New Pleskian

    22
    57%
    Joined:
    Aug 15, 2001
    Messages:
    10
    Likes Received:
    0
    Thanks very much. That worked well.

    I also just figured out a grep string that would work too:

    grep aol.com /var/qmail/mailnames/*/*/.qmail

    Thanks for your help.

    -Nick Voth
     
  4. jspilon

    jspilon Guest

    0
     
    nice!

    thanks for posting it
     
Loading...