Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: SendGrid

...

If they should have readonly DB access, you can modify the Ansible script temporarily to create a MySQL user for them, and then run "GRANT 'squaresdb-ro' TO $NEWUSER@localhost; SET DEFAULT ROLE ALL TO $NEWUSER@localhost;" to give them permissions.

 

...

SendGrid

We use SendGrid for outgoing mail; see Passwords for information on administering it.

We need to authenticate each sender, starting May 2023. SendGrid doesn't obviously expose the list of attempted senders, but we can get some from Postfix's logs:

adehnert@instance-2:~$ zgrep -oE "from=<[^>]*>" /var/log/mail.log* | cut -d : -f 2 | sort | uniq -c
      5 from=<root>
     10 from=<root@tech-squares-photos.mit.edu>
     32 from=<squaresdb>
      9 from=<squares-db-auto@mit.edu>
     32 from=<squaresdb@tech-squares-photos.mit.edu>
     10 from=<squares@mit.edu>