Adobe Connect hosted customers have long enjoyed the option of having their Connect account administrative email sent out to users on behalf of a specified email source rather than the system email parameter configured during installation of the Connect server. In order to exploit this option for on-premise Connect deployments, you first need to apply the following SQL update statement. This will add a row into the pps_account_features table:
insert into PPS_ACCOUNT_FEATURES
(ACCOUNT_ID, FEATURE_ID, DATE_BEGIN, DATE_END)
values (7, 71, ‘2014-02-20 00:00:00.000′,’3000-01-01 00:00:00.000′)
After adding this row, check the system email settings with the SQL statement below to make sure it is correctly configured:
select * from PPS_CONFIG
where name like ‘%email%
The results of the query above should correspond with the settings prescribed on local port 8510 on the Connect server settings page in the Connect server configuration wizard.
SECTION NAME VALUE COMMON_NAME
hosted validation-emaillist NULL
main config-bcc-email NULL NULL
main config-support-email email@example.com NULL
main config-system-email firstname.lastname@example.org NULL
After making the prescribed database changes, they will either take effect immediately after you cycle the Adobe Connect and Flash Media services or after 10 minutes. You do not need to cycle the services unless the change must be immediate.
With the above settings in place, if you create a user in Connect with the email address email@example.com and then you add Joe to the Meeting Hosts group, the admin designated in the system-email parameter on the server settings page will send email on Joe’s behalf.
To prove this, simply log in, as Joe, create a meeting and add the user with email firstname.lastname@example.org (or anyone you chose) as a meeting participant and send that person a meeting invitation. It should read: email@example.com; on behalf of; firstname.lastname@example.org:
The meeting invitation will look something like this:
From: email@example.com [mailto:firstname.lastname@example.org] On Behalf Of Joe
Sent: Sunday, February 23, 2014 5:30 PM
To: WhoeverIChoose@wherever.com; WhoeverIChoose
Subject: Adobe Connect – Meeting Invitation to “My most excellent meeting”
When: February 23, 2014 5:30 PM-6:30 PM (UTC-05:00) Eastern Time (US & Canada).
Please join me in an Adobe Connect Meeting.
Meeting Name: The Only Meeting <snip>
Note: This will not affect password reset email messages.