System Profile
...
See also. for detailed MDM repair information and history: MDM OUTAGES - BSD - Civil Aviation - Confluence (atlassian.net)
e-mail notifications regarding expiration of the AAIR inbox password
See also
...
For the purpose of earlier awareness and easier
...
...
phuong.nguyen@tc.gc.ca NGUYEPH
...
riadh.said@tc.gc.ca SAIDR
...
christopher.collins@tc.gc.ca COLCHRI
...
haoyuan.wang@tc.gc.ca WANGHA
...
rajesh.shah@tc.gc.ca SHAHR
...
hiren.amin@tc.gc.ca AMINH
...
siamak.shirzad@tc.gc.ca SHIRZAS
...
sufyan.maghur@tc.gc.ca MAGHUSU
...
nbox inbox access:
alain.asgill@tc.gc.ca ASGILLA
phuong.nguyen@tc.gc.ca NGUYEPH
riadh.said@tc.gc.ca SAIDR
christopher.collins@tc.gc.ca COLCHRI
haoyuan.wang@tc.gc.ca WANGHA
rajesh.shah@tc.gc.ca SHAHR
hiren.amin@tc.gc.ca AMINH
siamak.shirzad@tc.gc.ca SHIRZAS
sufyan.maghur@tc.gc.ca MAGHUSU
noreen.dertinger@tc.gc.ca DERTINN
have been granted full permission and send as to TC.AAIR-RAINA.TC@tc.gc.caThese permissions take min 24 hrs to apply at which time mailbox
can be added using instructions located in Knowledge base
article https://orion.tc.gc.ca/dwp/app/#/knowledge/KBA00002102/rkm
The following users already had access to the inbox previously:
...
In the table TR47_CAWIS_GENERAL_PROPS:
First, backup the existing password/encryption infoUPDATE TR47_CAWIS_GENERAL_PROPS A SET A.PROPERTY_VALUE =
(SELECT PROPERTY_VALUE FROM TR47_CAWIS_GENERAL_PROPS B
WHERE B.PROPERTY_NAME = 'MDM - MAILBOX PASSWORD' )
WHERE PROPERTY_NAME = 'MDM BACKUP - LAST KNOWN PASSWORD';UPDATE TR47_CAWIS_GENERAL_PROPS SET PROPERTY_VALUE =
(SELECT PROPERTY_VALUE FROM TR47_CAWIS_GENERAL_PROPS B
WHERE B.PROPERTY_NAME = 'MDM - MAILBOX PASSWORD SECRET' )
WHERE PROPERTY_NAME = 'MDM BACKUP - LAST SECRET ENCRYPTION';then, null out the encryption key
UPDATE TR47_CAWIS_GENERAL_PROPS SET PROPERTY_NAME = NULL
WHERE PROPERTY_NAME = 'MDM - MAILBOX PASSWORD SECRET';
Note : most fields (with the exception of “password” ) will be UPPERCASED when saved on the TR47 interface page in CAWIS. This would nullify any benefits of backing up up the old encrypted password at this point.
Clearing the value of “MDM - MAILBOX PASSWORD SECRET” is to tell MDM that the password is unencrypted. (Do not remove the row).
a. Set the value of “MDM - MAILBOX PASSWORD” to the new, unencrypted password.
b. Set the value of “MDM - MAILBOX PASSWORD LAST CHECK DATE to SYSDATE + 2”. This will ensure that MDM does the password change two days after the reset (you have to wait a day to do another password change)
...