My webhost (Dreamhost) has recently been blocking our mass mailing as spam and they say in order to comply with their rules, and remain unblocked, we need to provide proof that we use double opt-in and share the logs that show subscriptions with a timestamp and IP address.
I figured out how to enable double opt-in and got that working. But when researching the subscription logs I found that the civicrm_subscription_history table has a tracking field with the description "IP address or other tracking info," but instead of an IP address it contains the foreign key ID to either the civicrm_mailing_event_subscribe or civicrm_mailing_event_unsubscribe tables. Neither of these tables contains an IP address log.
I've searched for the IP address in other tables with no luck.
- Does CiviCRM log the IP address from the subscription confirmation?
- If so, where?
- If not, is there some way to enable it?