By default, secure conversations on eShare platform are stored on eShare infrastructure. Enterprise customers have the option of setting up Share Messages database so that all secure conversations by their users with any recipients are stored in a database managed by them. This also allows e-Share's enterprise customers to perform discovery of messages, archive or purge them as needed.
Setup of Share Messages database is a two step process:
1. Setup MySQL service in customer's Azure tenant
2. Configure Share Messages Database in e-Share admin portal
Create MySQL Server in Azure
1. Sign in portal.azure.com, click on 'Create a resource'
2. Search for 'Azure database for MySQL', select the resource followed by 'Create'
3. Select your subscription, resource group, type server name and input other required details
4. Create Administrator account with password and complete the setup. Example of the final setup screen is shown below.
5. After the database resource is created, open it to retrieve the following information:
Name: From 'Overview' tab, copy and save the 'Server name' value
SSL Certification: Switch to 'Networking' menu under 'Settings' section. Download the SSL certificate using the link in top navigation bar
6. Connect to the newly created Azure database via Azure shell using the following command:
mysql -h AZURE_SQL_URL -u ADMIN_USER -p'PASSWORD' --ssl_ca SSL_CERTIFICATE_FILE_PATH
Create DB and grant privileges to user
create database DB_NAME;
grant all privileges on DB_NAME.* TO 'ADMIN_USER'@'%';
flush privileges;
exit
Note: Text in bold must be replaced with applicable values.
Configure Share Messages Database
1. Login to e-Share portal as administrator
2. Navigate to Manage Organization > Management Dashboard > Share Messages tab
3. Complete the required fields, see description below
Host: Paste the server name copied from step #5 above
Port: 3306 (default port. If custom port was created, use that here)
Database: Value used for DB_NAME in step #6 above
User: Administrator name used to create the Azure database in step #4 above
Password: Password provided in step #4 above
4. If 'Enable Secure Transport' is turned on, 'SSL Certificate' text box is displayed. Open the SSL certificate in Notepad (see step #5 above). Copy the text from the opened Notepad and paste in the text field.
5. When done, click on 'Update Connection Data'. Verify connection is successful or update values as needed
When the Share Messages database is configured, a one-time migration of all secure conversations from eShare managed database to customer configured database is performed. All new secure conversations are stored directly only in customer configured database.