Cowboy Denny Posted December 12, 2022 Share Posted December 12, 2022 You might get yourself in a dilema where you need to reset BIG-IQ without rebuilding the VM. All you need to do is type: clear-rest-storage This will clear any past configuration. Below is an example of what it looks like when you type the above command [root@mifnt1slbiq01:Active:Standalone] config # clear-rest-storage Stopping tokumond... Clearing searchd and tokumon checkpoint... Dropping tokumon checkpoint Deleting es-config index Deleting tokumon index % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 431 100 431 0 0 261k 0 --:--:-- --:--:-- --:--:-- 420k Deleting all searchd indexes Stopping restjavad and related daemons... Stopping elasticsearch... Deleting elasticsearch data... Deleting /var/config/rest/elasticsearch/data/nodes... Resetting elasticsearch config... Stopping setupd... Stopping guiserver... Replace biq_provision.cfg with default... Removing fileobject files... Reloading service webd Initializing Postgres BIG-IQ database... Loading Postgres configuration from /var/config/rest/service.config.json... Postgres configuration successfully loaded! Checking PostgreSQL availability... PostgreSQL is ready to accept connections. Deleting 'bigiq_db' database if exists... Disconnecting all active user sessions on 'bigiq_db' if exists... UPDATE 1 DROP DATABASE Deleting 'bigiq' user role if exists... DROP ROLE Deleting 'postgres_replication' user role if exists... DROP ROLE Generating initial 'bigiq_db' schema... CREATE DATABASE bigiq_db CREATE DATABASE Executing initial schema creation Loading all schemas Creating 500 tables Creating 500 tables Creating 500 tables Creating 500 tables Initializing RBAC built-in model and Performing final steps Building stored procedures for related_to queries Building schema querying functions Building built-in rbac definitions Changing DB user passwords database schema creation successful for bigiq database schema creation successful for postgres_replication UPDATE 1 Running migrations via migrate-bigiq... Mon Dec 12 07:07:07 EST 2022 - MIGRATE | INFO] Running flyway-bigiq -n migrate Flyway Community Edition 6.5.2 by Redgate Database: jdbc:postgresql://localhost:5432/bigiq_db (PostgreSQL 11.3) Executing SQL callback: beforeValidate - update v84 script checksum Successfully validated 110 migrations (execution time 00:00.066s) Creating Schema History table "public"."flyway_schema_history" with baseline ... Successfully baselined schema with version: 1 Current version of schema "public": 1 Migrating schema "public" to version 2 - common functions Migrating schema "public" to version 3 - asm upgrade policy signatures Migrating schema "public" to version 4 - asm drop policy signatures differencer tables Migrating schema "public" to version 5 - asm upgrade parent policy web scraping Migrating schema "public" to version 6 - asm clear discovery optimization data Migrating schema "public" to version 7 - ssm upgrade dos profiles application Migrating schema "public" to version 8 - create cm access current-config apm ephemeral-auth radius-auth client clientstate Migrating schema "public" to version 9 - create cm access current-config apm ephemeral-auth radius-auth client host-groups clienthostgroupsstate Migrating schema "public" to version 10 - create cm access current-config apm ephemeral-auth radius-auth profile clients profileclientsstate Migrating schema "public" to version 11 - create cm access current-config apm ephemeral-auth radius-auth profile profilestate Migrating schema "public" to version 12 - create cm access current-config apm ephemeral-auth ssh-security-config sshsecurityconfigstate Migrating schema "public" to version 13 - create cm access current-config apm policy agent okta-mfa oktamfastate Migrating schema "public" to version 14 - create cm access current-config apm profile webssh websshstate Migrating schema "public" to version 15 - create cm access current-config apm resource webssh-resource websshresourcestate Migrating schema "public" to version 16 - create cm access utility policy remove-orphaned-policyitems-task removeorphanedpolicyitemstaskitemstate Migrating schema "public" to version 17 - create cm access working-config apm aaa okta-connector oktaconnectorstate Migrating schema "public" to version 18 - create cm access working-config apm ephemeral-auth ldap-auth profile profilestate Migrating schema "public" to version 19 - create cm access working-config apm ephemeral-auth radius-auth client clientstate Migrating schema "public" to version 20 - create cm access working-config apm ephemeral-auth radius-auth client host-groups clienthostgroupsstate Migrating schema "public" to version 21 - create cm access working-config apm ephemeral-auth radius-auth profile clients profileclientsstate Migrating schema "public" to version 22 - create cm access working-config apm ephemeral-auth radius-auth profile profilestate Migrating schema "public" to version 23 - create cm access working-config apm ephemeral-auth ssh-security-config sshsecurityconfigstate Migrating schema "public" to version 24 - create cm access working-config apm policy agent okta-mfa oktamfastate Migrating schema "public" to version 25 - create cm access working-config apm profile webssh websshstate Migrating schema "public" to version 26 - create cm access working-config apm resource webssh-resource websshresourcestate Migrating schema "public" to version 27 - create cm asm policy-analyzer entities status configanalyzerentitystatusstate Migrating schema "public" to version 28 - create cm asm policy-analyzer policy-in-use status policyinusestatus Migrating schema "public" to version 29 - create cm asm policy-analyzer signature-file status signaturefilestatus Migrating schema "public" to version 30 - create cm asm policy-analyzer violations status configanalyzerviolationsstatusstate Migrating schema "public" to version 31 - create cm asm reports analyzer config-analyzer-rules configanalyzerrulestate Migrating schema "public" to version 32 - create cm asm reports analyzer config-analyzer-suggestions configanalyzersuggestionstate Migrating schema "public" to version 33 - create cm asm reports analyzer config-analyzer-suggestions suggestions configanalyzersuggestionrulestate Migrating schema "public" to version 34 - create cm asm reports policy-diff asmpolicydifferencerstate Migrating schema "public" to version 35 - create cm asm tasks policy-analyzer asmpolicyanalyzertaskstate Migrating schema "public" to version 36 - create cm asm tasks policy-diff policydifftaskstate Migrating schema "public" to version 37 - create cm asm utility config-analyzer-rules-helper defaultshelperstate Migrating schema "public" to version 38 - create cm firewall tasks unusedobjects unusedobjectstaskitemstate Migrating schema "public" to version 39 - create cm global dts-notifications dtsnotificationstate Migrating schema "public" to version 40 - create cm global tasks disable-bot-logging botremoteloggingdisabletaskitemstate Migrating schema "public" to version 41 - create cm global tasks enable-bot-logging botremoteloggingsetuptaskitemstate Migrating schema "public" to version 42 - create cm security-shared current-config zones zonestate Migrating schema "public" to version 43 - create cm security-shared working-config dosattackalerts dosattackalertcriterionstate Migrating schema "public" to version 44 - create cm security-shared working-config zones zonestate Migrating schema "public" to version 45 - create cm shared import-deploy-settings importdeploysettingsstate Migrating schema "public" to version 46 - create cm sslo activenetworkobjects sslodependencygraphstate Migrating schema "public" to version 47 - create cm sslo o365 schedule-deployment ssloo365taskschedulerstate Migrating schema "public" to version 48 - create cm sslo tasks api sslodeclarativedeploymenttaskstate Migrating schema "public" to version 49 - create cm sslo tasks deploy-o365-urls ssloo365deploytaskstate Migrating schema "public" to version 50 - create cm sslo tasks discoveryandimport sslodeclarativediscoveryandimporttaskstate Migrating schema "public" to version 51 - create cm system teem-registration teemregistrationstate Migrating schema "public" to version 52 - transfer cm system usage-data-history usagedatahistorystate frm tks to liveo Migrating schema "public" to version 53 - transfer create cm system usage-data-info usagedatainfostate frm tks to liveo Migrating schema "public" to version 54 - create shared file data filtermetadatastate Migrating schema "public" to version 55 - create shared file publish publishtaskstate Migrating schema "public" to version 56 - create shared file store storagestate Migrating schema "public" to version 57 - create shared settings api-status availability apisettingsstate Migrating schema "public" to version 58 - create shared settings api-status log resource-property apisettingsstate Migrating schema "public" to version 59 - create shared settings api-status log resource apisettingsstate Migrating schema "public" to version 60 - create cm asm policy-analyzer geolocation-file status geolocationfilestatus Migrating schema "public" to version 61 - create function address to inet Migrating schema "public" to version 62 - update kind to table name Migrating schema "public" to version 63 - update 7.1 selflink inflate query Migrating schema "public" to version 64 - create cm access current-config apm ephemeral-auth ldap-auth profile profilestate Migrating schema "public" to version 65 - create cm access current-config apm aaa okta-connector oktaconnectorstate Migrating schema "public" to version 66 - asm upgrade policy cookies Migrating schema "public" to version 67 - sanitize cm system usage data tables Migrating schema "public" to version 68 - upgrade asm refinements file Migrating schema "public" to version 69 - create cm asm policy-analyzer violations fileupload status fileuploadviolationstatusstate Migrating schema "public" to version 70 - upgrade tacacs refinements Migrating schema "public" to version 71 - create cm shared esmgmt cluster-ssl-task esclusterssltaskstate Migrating schema "public" to version 72 - update rbac functions Migrating schema "public" to version 73 - create cm asm policy-analyzer attack-signatures status attacksignaturestatus Migrating schema "public" to version 74 - create cm asm policy-analyzer policy-building suggestions status policybuildingsuggestionsstatusstate Migrating schema "public" to version 75 - create cm access workflow access-workflow accessworkflowtaskstate Migrating schema "public" to version 76 - create cm access workflow container accessworkflowcontainerstate Migrating schema "public" to version 77 - asm reset defaults Migrating schema "public" to version 78 - update afm rules Migrating schema "public" to version 79 - asm drop policy subcollection display names Migrating schema "public" to version 80 - create cm adc-core current-config ltm monitor http2 adcmonitorhttp2state Migrating schema "public" to version 81 - create cm adc-core working-config ltm monitor http2 adcmonitorhttp2state Migrating schema "public" to version 82 - create cm adc-core template-config ltm monitor http2 adcmonitorhttp2state Migrating schema "public" to version 83 - asm upgrade policy threat campaigns Migrating schema "public" to version 84 - update sec policy rules Migrating schema "public" to version 85 - create cm asm policy-analyzer brute-force-attack-protection status bruteforceattackprotectionstatusworkerstate Migrating schema "public" to version 86 - delete redundant asm policy signatures indexes Migrating schema "public" to version 87 - update rbac remove tags to have condition Migrating schema "public" to version 88 - add null check in rbac add pattern proc Migrating schema "public" to version 89 - create cm access current-config apm aaa active-directory activedirectorystate Migrating schema "public" to version 90 - create cm access current-config apm policy agent ending-abort endingabortstate Migrating schema "public" to version 91 - create cm access current-config apm policy agent event-wait eventwaitstate Migrating schema "public" to version 92 - create cm access current-config apm policy policy-item policyitemstate Migrating schema "public" to version 93 - create cm access current-config apm resource address-space addressspacestate Migrating schema "public" to version 94 - create cm access current-config apm resource network-access address-space-exclude networkaccessaddressspaceexcludestate Migrating schema "public" to version 95 - create cm access current-config apm resource network-access address-space-include networkaccessaddressspaceincludestate Migrating schema "public" to version 96 - create cm access current-config apm resource network-access networkaccessstate Migrating schema "public" to version 97 - create cm access working-config apm aaa active-directory activedirectorystate Migrating schema "public" to version 98 - create cm access working-config apm policy agent ending-abort endingabortstate Migrating schema "public" to version 99 - create cm access working-config apm policy agent event-wait eventwaitstate Migrating schema "public" to version 100 - create cm access working-config apm policy policy-item policyitemstate Migrating schema "public" to version 101 - create cm access working-config apm resource address-space addressspacestate Migrating schema "public" to version 102 - create cm access working-config apm resource network-access address-space-exclude networkaccessaddressspaceexcludestate Migrating schema "public" to version 103 - create cm access working-config apm resource network-access address-space-include networkaccessaddressspaceincludestate Migrating schema "public" to version 104 - create cm access working-config apm resource network-access networkaccessstate Migrating schema "public" to version 105 - create cm firewall tasks ips-cache ipscachetaskstate Migrating schema "public" to version 106 - create cm firewall cache ips-cache-receiver ipscachestate Migrating schema "public" to version 107 - create cm device licensing purchasepool purchasepoollicensestate Migrating schema "public" to version 108 - create rbac top table and proc Migrating schema "public" to version 109 - update rbac add pattern proc Migrating schema "public" to version 110 - asm update defaults evasions http protocols Migrating schema "public" to version 111 - asm update policies evasions http protocols Successfully applied 110 migrations to schema "public" (execution time 00:02.954s) stopping restjavad and tokumond ALTER DEFAULT PRIVILEGES clear the index and drop replication slot, okay if not exist Dropping tokumon checkpoint Deleting es-config index Deleting tokumon index ERROR: replication slot "searchmon_1" does not exist delete cache collections delete canonical model delete tags importing built-in RBAC canonical model add back the principalRefs restarting tokumond and restjavad Migrations completed Successfully initialized 'bigiq_db' and related resources Starting tokumond... Starting elasticsearch... Starting restjavad... Starting pabnagd... Starting setupd... Starting guiserver... Link to comment Share on other sites More sharing options...
Recommended Posts