Skip to content

Instantly share code, notes, and snippets.

@oberstet

oberstet/gist:91ca194ccd6e283fccdbc3eb32cdfe85

Created February 26, 2021 03:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oberstet/91ca194ccd6e283fccdbc3eb32cdfe85 to your computer and use it in GitHub Desktop.
Save oberstet/91ca194ccd6e283fccdbc3eb32cdfe85 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
(cpy391_6) oberstet@intel-nuci7:~/scm/s-things/thingcloud$ make cfxshell_show_database cfxshell_export_database
sudo `which crossbarfx` shell show database .teststack/master/.crossbar/.db-mrealm-*
Database slots [dbpath="/home/oberstet/scm/s-things/thingcloud/.teststack/master/.crossbar/.db-mrealm-0e3e6ffd-1092-4d31-8716-341666867aef"]:
Slot 7099565b-7b44-4891-a0c8-83c7dbb60883 using DB table class cfxdb.mrealmschema.ApplicationRealms
Slot 89f3073a-32d5-497e-887d-7e930e9c26e6 using DB table class cfxdb.mrealmschema.IndexApplicationRealmByName
Slot 0275b858-890c-4879-945c-720235b093d7 using DB table class cfxdb.mrealmschema.IndexApplicationRealmByWebCluster
Slot 9808cb0b-1b55-4b3f-858e-39004cb11135 using DB table class cfxdb.mrealmschema.Principals
Slot 212f3455-6d4c-43ec-843d-53cd17e31974 using DB table class cfxdb.mrealmschema.IndexPrincipalByName
Slot 251c8620-425a-4eeb-ade9-4284e8670080 using DB table class cfxdb.mrealmschema.Credentials
Slot 45490b42-b167-4df6-ab1c-41d434390397 using DB table class cfxdb.mrealmschema.IndexCredentialsByAuth
Slot ed0da771-e331-4d93-b50c-d371391cd7b9 using DB table class cfxdb.mrealmschema.IndexCredentialsByPrincipal
Slot 341083bb-edeb-461c-a6d4-38dddcda6ec9 using DB table class cfxdb.mrealmschema.Roles
Slot 71b990d1-4525-44cd-9ef8-3569de8b4c80 using DB table class cfxdb.mrealmschema.IndexRoleByName
Slot 5eabdb63-9c31-4c97-b514-7e8fbac7e143 using DB table class cfxdb.mrealmschema.ApplicationRealmRoleAssociations
Slot f98ed35b-f8fb-47ba-81e1-3c014101464d using DB table class cfxdb.mrealmschema.Permissions
Slot 6cdc21bf-353d-4477-8631-8eb039142ae9 using DB table class cfxdb.mrealmschema.IndexPermissionByUri
Slot b054a230-c370-4c29-b5de-7e0148321b0a using DB table class cfxdb.mrealmschema.RouterClusters
Slot 0c80c7a8-7536-4a74-8916-4922c0b72cb7 using DB table class cfxdb.mrealmschema.IndexRouterClusterByName
Slot a091bad6-f14c-437c-8e30-e9be84380658 using DB table class cfxdb.mrealmschema.RouterClusterNodeMemberships
Slot c019457b-d499-454f-9bf2-4f7e85079d8f using DB table class cfxdb.mrealmschema.RouterWorkerGroups
Slot 4bb8ec14-4820-4061-8b2c-d1841e2686e1 using DB table class cfxdb.mrealmschema.IndexWorkerGroupByCluster
Slot e3d326d2-6140-47a9-adf9-8e93b832717b using DB table class cfxdb.mrealmschema.RouterWorkerGroupClusterPlacements
Slot 1a18739f-7224-4459-a446-6f1fedd760a7 using DB table class cfxdb.mrealmschema.IndexClusterPlacementByWorkerName
Slot 719d029f-e9d5-4b25-98e0-cf04d5a2648b using DB table class cfxdb.mrealmschema.WebClusters
Slot 296c7d17-4769-4e40-8cb7-e6c394b93335 using DB table class cfxdb.mrealmschema.IndexWebClusterByName
Slot e9801077-a629-470b-a4c9-4292a1f00d43 using DB table class cfxdb.mrealmschema.WebClusterNodeMemberships
Slot a8803ca3-09a0-4d72-8728-2469de8d50ac using DB table class cfxdb.mrealmschema.WebServices
Slot f0b05bcf-f682-49bb-929e-ac252e9867fa using DB table class cfxdb.mrealmschema.IndexWebServiceByPath
Slot d23d4dbb-5d5c-4ccc-b72a-0ff18363169f using DB table class cfxdb.mrealmschema.IndexWebClusterWebServices
Slot 256a071f-5aeb-47f3-8786-97cd8281bdb7 using DB table class cfxdb.log.mnode_logs.MNodeLogs
Slot 5ceaa500-4832-451c-adf4-4fc4968cece0 using DB table class cfxdb.log.mworker_logs.MWorkerLogs
Slot 42b1ca1f-f135-4761-8d10-f96a43612178 using DB table class cfxdb.meta.attribute.Attributes
Slot e11680d5-e20c-40b1-97d9-380b5ace1cb3 using DB table class cfxdb.meta.schema.Docs
Slot d1de0b8c-3b6d-488b-8778-5bac8528ab4b using DB table class cfxdb.meta.schema.IndexObjectToDoc
Slot ae2fe53f-f8ec-4484-8a8f-cabdf1b38358 using DB table class cfxdb.globalschema.Organizations
Slot 3fb82ab2-430d-43a1-8200-fcd6355d0410 using DB table class cfxdb.globalschema.IndexOrganizationsByName
Slot fa1ed0fc-304e-4f66-8092-d901df1735e4 using DB table class cfxdb.globalschema.Users
Slot 882a24e4-90cc-4823-94fe-c1d938daffe6 using DB table class cfxdb.globalschema.IndexUsersByPubkey
Slot 933447a3-dd79-4599-bd9a-e0d88d9b84cb using DB table class cfxdb.globalschema.IndexUsersByEmail
Slot c968886e-a2e2-490c-bc2a-6b684c3130f6 using DB table class cfxdb.globalschema.ActivationTokens
Slot 0f6a9014-2e39-4cfd-9f2b-f6ffd3d3deca using DB table class cfxdb.globalschema.IndexActivationTokensByAuthidPubkey
Slot 1219e71c-a62c-415a-bd15-ddf45e3a658b using DB table class cfxdb.globalschema.ManagementRealms
Slot 1d2e8045-ea2b-4456-be4a-7a234d3622d6 using DB table class cfxdb.globalschema.IndexManagementRealmByName
Slot eccdfc57-5632-4ad4-9c2b-2ac11e9d389f using DB table class cfxdb.globalschema.UserMrealmRoles
Slot ae89d956-273a-4ce3-b63d-52b07ae35742 using DB table class cfxdb.globalschema.Nodes
Slot 1336c623-5f38-4397-ad5b-2e6b716b57b0 using DB table class cfxdb.globalschema.IndexNodesByPubkey
Slot 6d071a33-0577-4f72-a2e1-11182f60ab9c using DB table class cfxdb.globalschema.IndexNodesByAuthid
Slot e38f7bf1-2514-400c-8c30-a979b2138503 using DB table class cfxdb.globalschema.UsageRecords
Slot 9f87bad9-695e-439d-86ad-9e23695d3f67 using DB table class cfxdb.xbr.api.Apis
Slot 57ae5d83-57b0-4214-8481-a1853f7faf87 using DB table class cfxdb.xbr.api.IndexApiByCatalog
Slot a4a0553e-24fa-4280-9959-5805f034d861 using DB table class cfxdb.xbr.block.Blocks
Slot 60ba3189-d127-4522-bfbc-ed416bf7233c using DB table class cfxdb.xbr.catalog.Catalogs
Slot 2e331469-68f8-4b1b-a1b9-904f7e29dbc5 using DB table class cfxdb.xbr.catalog.IndexCatalogsByOwner
Slot 8b10071b-5b2a-478f-8101-52dfbaf0760a using DB table class cfxdb.xbr.consent.Consents
Slot 7cdac5f2-bddf-4fda-8e3c-21938a0c3667 using DB table class cfxdb.xbr.consent.IndexConsentByMemberAddress
Slot f3d1f052-7160-48a7-b36a-221035fc9373 using DB table class cfxdb.xbr.token.TokenApprovals
Slot 7dcfffd2-4859-45d6-b9cd-ba7930a7a107 using DB table class cfxdb.xbr.token.TokenTransfers
Slot d1808139-5a3b-4a4e-abad-152dd4cd1131 using DB table class cfxdb.xbr.member.Members
Slot 861b0942-0c3f-4d41-bc35-d8c86af0b2c9 using DB table class cfxdb.xbr.market.Markets
Slot 7c3d67b4-35a3-449f-85a6-2695636fc63e using DB table class cfxdb.xbr.market.IndexMarketsByOwner
Slot 1863eb64-322a-42dd-9fce-a59c99d5b40e using DB table class cfxdb.xbr.actor.Actors
Slot 4f50a97a-4531-4eab-a91b-45cc42b3dd21 using DB table class cfxdb.xbr.market.IndexMarketsByActor
Slot d511774c-0c7b-4d3f-a2de-6748c072a56f using DB table class cfxdb.xbr.market.IndexMarketsByMaker
Slot b3d01946-85ae-49f3-ad96-b78194eb82fe using DB table class cfxdb.xbrmm.channel.PaymentChannels
Slot cffd5253-72f8-41a9-8b76-5e6ff3654e67 using DB table class cfxdb.xbrmm.channel.IndexPaymentChannelByDelegate
Slot c78e0113-3b40-42b1-a15f-0b478ccf0de4 using DB table class cfxdb.xbrmm.channel.IndexPaymentChannelByActor
Slot 878ac002-a830-488b-bfe9-f06371b8eecb using DB table class cfxdb.xbrmm.channel.PaymentChannelBalances
Slot 4e7e7c8d-db0d-4dea-8409-ac8f21ce1e10 using DB table class cfxdb.xbrmm.channel.PayingChannels
Slot cee954be-fdb2-43cc-8891-529d6c7a0c3b using DB table class cfxdb.xbrmm.channel.IndexPayingChannelByDelegate
Slot 655a9d5f-0bdf-4c2a-8102-208f6da4a566 using DB table class cfxdb.xbrmm.channel.IndexPayingChannelByRecipient
Slot c0931d5d-6d5d-4f9c-b2a3-29664a0f4c07 using DB table class cfxdb.xbrmm.channel.PayingChannelBalances
Slot dc6d175b-3dd0-4b1f-a6e8-2aec7f0e3fe5 using DB table class cfxdb.xbrmm.offer.Offers
Slot ef5f1cdc-4871-4a03-ac1c-c60e80875b8b using DB table class cfxdb.xbrmm.offer.IndexOfferByKey
Slot 87cf8eac-10d8-470d-a645-23e11343e065 using DB table class cfxdb.xbrmm.transaction.Transactions
Slot 62d140f6-c1f4-4f38-bfde-e450f29d0f95 using DB table class cfxdb.xbrmm.userkey.UserKeys
Slot d4476238-c642-4625-8844-780137152ddd using DB table class cfxdb.xbrmm.userkey.IndexUserKeyByMember
Slot def3af4e-190c-4852-93da-731934deef90 using DB table class cfxdb.xbrmm.ipfs_file.IPFSFiles
Slot d155dff2-ac36-4c69-b1b0-254ce2eb237d using DB table class cfxdb.xbrnetwork.account.Accounts
Slot 760d42a0-110e-474b-ab85-6e2396af035d using DB table class cfxdb.xbrnetwork.account.IndexAccountsByUsername
Slot 76706b89-8639-491e-8989-afc5a7c8a5b4 using DB table class cfxdb.xbrnetwork.account.IndexAccountsByEmail
Slot 432ae4fa-a23e-45d7-b2a4-c9ae868df2b3 using DB table class cfxdb.xbrnetwork.account.IndexAccountsByWallet
Slot 84d805a7-c012-4dfa-9b95-e34760767f82 using DB table class cfxdb.xbrnetwork.vaction.VerifiedActions
Slot 5b5d0ce7-33f4-4421-a6ab-ed77cafc763a using DB table class cfxdb.xbrnetwork.userkey.UserKeys
Slot 68b736f8-27df-4e3e-b80f-1b855ae5596f using DB table class cfxdb.xbrnetwork.userkey.IndexUserKeyByAccount
Database table statistics [dbpath="/home/oberstet/scm/s-things/thingcloud/.teststack/master/.crossbar/.db-mrealm-0e3e6ffd-1092-4d31-8716-341666867aef"]:
mrealmschema.roles.....................: 1 records
mrealmschema.idx_roles_by_name.........: 1 records
mrealmschema.permissions...............: 1 records
mrealmschema.idx_permissions_by_uri....: 1 records
mrealmschema.arealms...................: 1 records
mrealmschema.idx_arealms_by_name.......: 1 records
mrealmschema.arealm_role_associations..: 1 records
mrealmschema.routerclusters............: 1 records
mrealmschema.idx_routerclusters_by_name: 1 records
mrealmschema.routercluster_node_memberships: 4 records
mrealmschema.router_workergroups.......: 1 records
mrealmschema.idx_workergroup_by_cluster: 1 records
mrealmschema.router_workergroup_placements: 1 records
mrealmschema.idx_clusterplacement_by_workername: 1 records
mrealmschema.webclusters...............: 1 records
mrealmschema.idx_webclusters_by_name...: 1 records
mrealmschema.webcluster_node_memberships: 3 records
mrealmschema.webservices...............: 4 records
mrealmschema.idx_webservices_by_path...: 4 records
mrealmschema.idx_webcluster_webservices: 4 records
mrealmschema.mnode_logs................: 27 records
mrealmschema.mworker_logs..............: 27 records
sudo `which crossbarfx` shell export database \
--use-json --quiet \
--include-schemata mrealmschema --exclude-tables mrealmschema.mnode_logs,mrealmschema.mworker_logs \
.teststack/master/.crossbar/.db-mrealm-* | python -m json.tool
{
"mrealmschema": {
"roles": [
[
"0x9bf036ffca654bd89fd2b329f54d34dc",
{
"oid": "9bf036ff-ca65-4bd8-9fd2-b329f54d34dc",
"label": null,
"description": null,
"tags": null,
"name": "role1",
"created": 1614310890175849321,
"owner": null
}
]
],
"permissions": [
[
"0x918587378caf4b4fbf120f2a1a9c47b4",
{
"oid": "91858737-8caf-4b4f-bf12-0f2a1a9c47b4",
"label": null,
"description": null,
"tags": null,
"role_oid": "9bf036ff-ca65-4bd8-9fd2-b329f54d34dc",
"uri": "",
"uri_check_level": null,
"match": 2,
"allow_call": true,
"allow_register": true,
"allow_publish": true,
"allow_subscribe": true,
"disclose_caller": true,
"disclose_publisher": true,
"cache": true,
"created": null,
"owner": null
}
]
],
"arealms": [
[
"0x035327ebd8c04f94aa1474f8cb4d044d",
{
"oid": "035327eb-d8c0-4f94-aa14-74f8cb4d044d",
"label": null,
"description": null,
"tags": null,
"name": "realm1",
"status": "STOPPED",
"workergroup_oid": null,
"webcluster_oid": null,
"changed": 1614310886998583201,
"owner_oid": "e9d76112-dc25-43c5-890c-974e1417861a",
"enable_meta_api": true,
"bridge_meta_api": true
}
]
],
"arealm_role_associations": [
[
"0x035327ebd8c04f94aa1474f8cb4d044d9bf036ffca654bd89fd2b329f54d34dc",
{
"arealm_oid": "035327eb-d8c0-4f94-aa14-74f8cb4d044d",
"role_oid": "9bf036ff-ca65-4bd8-9fd2-b329f54d34dc"
}
]
],
"routerclusters": [
[
"0xc3ea60737b1c45a7a04fbc723e8565f8",
{
"oid": "c3ea6073-7b1c-45a7-a04f-bc723e8565f8",
"label": null,
"description": null,
"tags": null,
"name": "cluster2",
"status": "STOPPED",
"owner_oid": "e9d76112-dc25-43c5-890c-974e1417861a",
"changed": 1614310877503499388
}
]
],
"routercluster_node_memberships": [
[
"0xc3ea60737b1c45a7a04fbc723e8565f8052884dda45a42898762218230374103",
{
"cluster_oid": "c3ea6073-7b1c-45a7-a04f-bc723e8565f8",
"node_oid": "052884dd-a45a-4289-8762-218230374103",
"softlimit": null,
"hardlimit": null
}
],
[
"0xc3ea60737b1c45a7a04fbc723e8565f80c5aac01bc004be08de485a63a42921a",
{
"cluster_oid": "c3ea6073-7b1c-45a7-a04f-bc723e8565f8",
"node_oid": "0c5aac01-bc00-4be0-8de4-85a63a42921a",
"softlimit": null,
"hardlimit": null
}
],
[
"0xc3ea60737b1c45a7a04fbc723e8565f8a2df6e6494384512abd41d6796245487",
{
"cluster_oid": "c3ea6073-7b1c-45a7-a04f-bc723e8565f8",
"node_oid": "a2df6e64-9438-4512-abd4-1d6796245487",
"softlimit": null,
"hardlimit": null
}
],
[
"0xc3ea60737b1c45a7a04fbc723e8565f8d45591c3e39d487ba1d8ec8f9442c255",
{
"cluster_oid": "c3ea6073-7b1c-45a7-a04f-bc723e8565f8",
"node_oid": "d45591c3-e39d-487b-a1d8-ec8f9442c255",
"softlimit": null,
"hardlimit": null
}
]
],
"router_workergroups": [
[
"0x067f4994e0f648e1bad4f71fd91d399e",
{
"oid": "067f4994-e0f6-48e1-bad4-f71fd91d399e",
"label": null,
"description": null,
"tags": null,
"cluster_oid": "c3ea6073-7b1c-45a7-a04f-bc723e8565f8",
"name": "group1",
"scale": 1,
"status": "STOPPED",
"changed": 1614310883824919290
}
]
],
"router_workergroup_placements": [
[
"0xedb7de71c22b490195164f8a508dbfba",
{
"oid": "edb7de71-c22b-4901-9516-4f8a508dbfba",
"worker_group_oid": "067f4994-e0f6-48e1-bad4-f71fd91d399e",
"cluster_oid": "c3ea6073-7b1c-45a7-a04f-bc723e8565f8",
"node_oid": "0c5aac01-bc00-4be0-8de4-85a63a42921a",
"worker_name": "group1_1",
"status": null,
"changed": null,
"tcp_listening_port": null
}
]
],
"webclusters": [
[
"0x18630b5132c54ded97ae4630268bf090",
{
"oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"label": null,
"description": null,
"tags": null,
"name": "cluster1",
"status": "STOPPED",
"owner_oid": "e9d76112-dc25-43c5-890c-974e1417861a",
"changed": 1614310874328450895,
"tcp_version": null,
"tcp_port": 8080,
"tcp_shared": true,
"tcp_interface": null,
"tcp_backlog": null,
"tls_key": null,
"tls_certificate": null,
"tls_chain_certificates": null,
"tls_ca_certificates": null,
"tls_dhparam": null,
"tls_ciphers": null,
"http_client_timeout": null,
"http_hsts": null,
"http_hsts_max_age": null,
"http_access_log": null,
"http_display_tracebacks": null
}
]
],
"webcluster_node_memberships": [
[
"0x18630b5132c54ded97ae4630268bf090052884dda45a42898762218230374103",
{
"cluster_oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"node_oid": "052884dd-a45a-4289-8762-218230374103",
"parallel": 2,
"standby": null
}
],
[
"0x18630b5132c54ded97ae4630268bf0900c5aac01bc004be08de485a63a42921a",
{
"cluster_oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"node_oid": "0c5aac01-bc00-4be0-8de4-85a63a42921a",
"parallel": 2,
"standby": null
}
],
[
"0x18630b5132c54ded97ae4630268bf090a2df6e6494384512abd41d6796245487",
{
"cluster_oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"node_oid": "a2df6e64-9438-4512-abd4-1d6796245487",
"parallel": 2,
"standby": null
}
]
],
"webservices": [
[
"0x0ae272173c6943569d5b364a09347cad",
{
"oid": "0ae27217-3c69-4356-9d5b-364a09347cad",
"label": null,
"description": null,
"tags": null,
"webcluster_oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"path": "settings",
"type": "json",
"value": {
"foo": "bar",
"baz": [
1,
2,
3
]
}
}
],
[
"0x7c7073e270d44a68b620631c5183c4aa",
{
"oid": "7c7073e2-70d4-4a68-b620-631c5183c4aa",
"label": null,
"description": null,
"tags": null,
"webcluster_oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"path": "info",
"type": "nodeinfo"
}
],
[
"0xa87e51c453064cfdb6a31269609646c8",
{
"oid": "a87e51c4-5306-4cfd-b6a3-1269609646c8",
"label": null,
"description": null,
"tags": null,
"webcluster_oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"path": "ws",
"type": "websocket"
}
],
[
"0xf594125299494ad3b2b11596236acbe8",
{
"oid": "f5941252-9949-4ad3-b2b1-1596236acbe8",
"label": null,
"description": null,
"tags": null,
"webcluster_oid": "18630b51-32c5-4ded-97ae-4630268bf090",
"path": "/",
"type": "static",
"directory": ".",
"options": {
"enable_directory_listing": true
}
}
]
]
}
}
(cpy391_6) oberstet@intel-nuci7:~/scm/s-things/thingcloud$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment