Activate DrWeb across multiple domains

[wdriver]

I have hundreds of mail accounts across 250+ domains & want to turn DrWeb on for ALL mail accounts.

There is no easy way through the Plesk interface to do this unless i go into each individual domain & then do a 'group operation'. This will take hours to complete.

Does anyone know where the settings are in the 'psa' mysql database so i can go in and update it all instantly. I am fully familiar with mysql so don't need any code advice. Just need to know the 'table' name, column & parameter to set.

Thanks in advance
Wayne.

 

[ghawley]

I have the same problem.....did you have any luck here?

 

[wdriver]

Hi,

Here is the reply i got from Plesk support. I have not had a chance to apply this yet so i don't know if it works sorry.

-------------------------------------------
Dear Wayne,

you are right, there is no such automatic feature in Plesk. However if
you want to enable drweb virus protection for all mail accounts at once
you may use Plesk creation utility:

# /usr/local/psa/bin/mail.sh --help

For example the following command will enable drweb for account
mail@domain.tld:

# /usr/local/psa/bin/mail.sh --update mail@domain.tld -drweb
<off|inout|in|out>

To get list of all mail accounts use the following command:

# mysql -B -uadmin -p`cat /etc/psa/.psa.shadow` psa -e'select
m.mail_name, "@", d.name from domains d, mail m where m.dom_id=d.id;' |
perl -pi -e 's/\t//g'

Using this information you may create a script that enable drweb for all
mail accounts on the server.

Thanks,

--
Anastasiya Bezborodova
Technical Support Engineer
SWsoft, Inc.

-------------------------------------------