View source for Mail Integration with Reporting Module


== Prerequisites ==

Before you get started with this guide, you&nbsp;have to complete some basic steps.

First, we'll assume that you have an access of SafeSquid server.

We are also assuming&nbsp;that you've&nbsp;'''Reporting Module set up'''. You can follow this guide to [[Setup_Reporting_Module|Setup Reporting Module]] and come back.

&nbsp;

== Mail Integration ==

Change directory to /usr/local/safesquid/api

<tt><code>Command:cd /usr/local/safesquid/api</code></tt>

Open '''config.ini''' from SafeSquid console

<code>Command:vim config.ini</code>

Find <kbd>mail_details</kbd> block and fill the mailing details. Refer the below table while filling the details.

{| border="1" cellpadding="1" cellspacing="1" style="width: 500px"
|-
| style="width: 120px" | useremail
| style="width: 366px" | Sender Email Address
|-
| style="width: 120px" | userpaaswd
| style="width: 366px" | Password of the Sender Email
|-
| style="width: 120px" | smtpserver
| style="width: 366px" | FQDN/IP of your SMTP server
|-
| style="width: 120px" | smtpport
| style="width: 366px" | Port on which your SMTP server is listening on
|-
| style="width: 120px" | toaddr
| style="width: 366px" | Reciever Email Addresses
|-
| style="width: 120px" | ccinfo
| style="width: 366px" | Email addresses to cc, if any
|}

'''<span style="font-size:larger">Important Notes</span>'''

*All the fields are mandatory except <tt>ccinfo</tt>. Set the value as '''none '''if you would like to leave the field empty. 
*<tt>toaddr </tt>and <tt>ccinfo </tt>can have comma separated values<br/> '''Eg''': admin@safesquid.net,itsecurity@safesquid.net,manager@safesquid.net 
*Leaving any of the fields empty would lead to malfunctioning of the Reporting Module. So make sure to set the value as '''none '''for empty fields. 

&nbsp;

The mail has been scheduled to be sent at 7am everyday using a cronjob which is configured automatically while installing the Reporting Module as shown below.

<code>0&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp; * * * root /bin/bash&nbsp;&nbsp; /usr/local/safesquid/api/sendmail.py</code>

The cronjob can be modified to reschedule the mailing as per your requirement by editing the file <code>/etc/crontab</code>

{{Seo|keywords=mail reports,daily reports,executive reports,secure web gateway|description=Integrate your mail with the Reporting Module to get daily reports on your Mail}}

[[Category:How To]]