Update from old Security Mode: Difference between revisions
m (Jbree moved page Update from Old Security mode to new to Update from old Security Mode without leaving a redirect: Rename) |
(Added missing detail and polished) |
||
Line 1: | Line 1: | ||
This procedure will migrate systems onto a new security model. |
This procedure will migrate systems onto a new security model. |
||
It covers updating from sec_id based records in zz_record_security to being in zz_[table name]_rs tables and limiting to one sec_id per 'target/permission' combination. |
|||
<b>Update Procedure:</b><br/> |
<b>Update Procedure:</b><br/> |
||
This procedure has been designed with minimum downtime; the UI should be fully usable up until the resecure step and largely useable (see the * below) until the 'update_fap' step. The full resecure takes approx 1 hour on July's P&P live data. |
This procedure has been designed with minimum downtime; the UI should be fully usable up until the resecure step and largely useable (see the * below) until the 'update_fap' step. The full resecure takes approx 1 hour on July's P&P live data. |
||
Check if there are any systems with pure numeric sec_ids left, i.e., last config build before March 2013 (check timestamp of /etc/zymonic/[system]/cache/*) - if you identify systems with a last config build before that then |
Check if there are any systems with pure numeric sec_ids left, i.e., last config build before March 2013 (check timestamp of /etc/zymonic/[system]/cache/*) - if you identify systems with a last config build before that then email developers@zednax.com to ask for guidance before continuing. |
||
<ol> |
<ol> |
||
<li> |
<li> |
||
Zymobuild |
Zymobuild |
||
<pre>sudo zymobuild</pre> |
|||
</li><li> |
</li><li> |
||
Config build |
Config build |
||
<pre>sudo zymonic_toolkit.pl System config_build --system SYSTEM</pre> |
|||
</li><li> |
</li><li> |
||
Resecure all tables (leaves them with entries in both tables)* |
Resecure all tables (leaves them with entries in both tables)* |
||
Line 18: | Line 22: | ||
<pre>sudo zymonic_toolkit.pl System detect_record_security_modes --system SYSTEM --debugfile /tmp/detect_security.log</pre> |
<pre>sudo zymonic_toolkit.pl System detect_record_security_modes --system SYSTEM --debugfile /tmp/detect_security.log</pre> |
||
</li><li> |
</li><li> |
||
Do a full update_fap |
|||
<pre>sudo zymonic_toolkit.pl System update_fap --system SYSTEM --full yes</pre> |
<pre>sudo zymonic_toolkit.pl System update_fap --system SYSTEM --full yes</pre> |
||
</li><li> |
</li><li> |
Latest revision as of 16:18, 2 April 2019
This procedure will migrate systems onto a new security model.
It covers updating from sec_id based records in zz_record_security to being in zz_[table name]_rs tables and limiting to one sec_id per 'target/permission' combination.
Update Procedure:
This procedure has been designed with minimum downtime; the UI should be fully usable up until the resecure step and largely useable (see the * below) until the 'update_fap' step. The full resecure takes approx 1 hour on July's P&P live data.
Check if there are any systems with pure numeric sec_ids left, i.e., last config build before March 2013 (check timestamp of /etc/zymonic/[system]/cache/*) - if you identify systems with a last config build before that then email developers@zednax.com to ask for guidance before continuing.
-
Zymobuild
sudo zymobuild
-
Config build
sudo zymonic_toolkit.pl System config_build --system SYSTEM
-
Resecure all tables (leaves them with entries in both tables)*
sudo zymonic_toolkit.pl Security resecure --system SYSTEM --zname '*' --unsecured true --debugfile=/tmp/full_resecure.log
-
Run detect security mode
sudo zymonic_toolkit.pl System detect_record_security_modes --system SYSTEM --debugfile /tmp/detect_security.log
-
Do a full update_fap
sudo zymonic_toolkit.pl System update_fap --system SYSTEM --full yes
-
Config build
sudo zymonic_toolkit.pl System config_build --system SYSTEM
If at all possible adding new entries / changing existing entries in tables that are connected to 'groups' e.g. eBex areas, regions, companies and P&P clients should be avoided from the beginning of resecure until the end of the final config build - if changes are made then an additional resecure after the last config build should solve any resulting issues.
From starting update_fap to completing the config build the system will be unusable as there will be no accessible pages and all the menus will be empty.