action log - possible to email ?

[ManfredZ]

Hi,

is there a way to get the action log (User CP logins etc.) emailed?

 

[IgorG]

As possible solution you can use following custom script:

#!/bin/bash
SUBJECT="Plesk action log"
TO="name@gmail.com"
MESSAGE="/tmp/plesk_action_log.log"

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select la.date, la.ip_address, la.user, a.name, lc.component, lc.old_value, lc.new_value from actions a, log_actions la, log_components lc where lc.action_id=la.id and la.action_id=a.id" >> $MESSAGE

/bin/mail -s "$SUBJECT" "$TO" < $MESSAGE

rm $MESSAGE

exit 0

 

[ManfredZ]

thx Igor

(The following errors occurred with your submission:

1. The message you have entered is too short. Please lengthen your message to at least 10 characters.)

 

[IgorG]

Where and how it occurs?