Database Maintenance
Used to perform database maintenance, such as
Check consistency of the database
Try to repair inconsistencies in the database
Warning
Only to be used upon direction from StoredSafe staff.
If the StoredSafe appliance has suffered an unexpected power outage, it might be necessary to repair the database tables. The Perform a database check will check the tables and inform if a Perform a database repair is needed.
┌────────────────────────────────────────────────────────────────────────────┐
│ Database Maintenance on node1 (Version 2.0.X build XXXX) │
└────────────────────────────────────────────────────────────────────────────┘
┌─┬──────────────────────────────────────────────────────────────────────────┐
│1│Perform a database check │
│2│Perform a database repair │
└─┴──────────────────────────────────────────────────────────────────────────┘
Move the cursor or enter a it's corresponding number (Q to Quit)
Main> System Settings> Database>
Perform a database check
Database Check
# Connecting to localhost...
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
ss_radius.nas OK
ss_radius.radpostauth OK
ss_radius.ss_state OK
ss_radius.yidtouser OK
storedsafe.ss_files OK
storedsafe.ss_groupkeys OK
storedsafe.ss_groups OK
storedsafe.ss_log OK
storedsafe.ss_mixedkeys OK
storedsafe.ss_objects OK
storedsafe.ss_tags OK
storedsafe.ss_tracker OK
storedsafe.ss_userbase OK
ykval.clients OK
ykval.queue OK
ykval.yubikeys OK
# Disconnecting from localhost...
Press any key to continue
Perform a database repair
Database Repair
# Connecting to localhost...
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
ss_radius.nas OK
ss_radius.radpostauth OK
ss_radius.ss_state OK
ss_radius.yidtouser OK
storedsafe.ss_files OK
storedsafe.ss_groupkeys OK
storedsafe.ss_groups OK
storedsafe.ss_log OK
storedsafe.ss_mixedkeys OK
storedsafe.ss_objects OK
storedsafe.ss_tags OK
storedsafe.ss_tracker OK
storedsafe.ss_userbase OK
ykval.clients OK
ykval.queue OK
ykval.yubikeys OK
# Disconnecting from localhost...
Press any key to continue