Finding all AOL redirects

[nvoth]

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

 

[jspilon]

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%';

 

[nvoth]

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

 

[jspilon]

nice!

thanks for posting it