SSP Data Storage: Difference between revisions

From Cramsession
Jump to navigationJump to search
✍️ Verified Author: MflavellClick to view professional profile & credentials
(Created page with " Data is stored in an SQLite3 database to access the database: sqlite3 /config/db/operator_info.db It is useful to use: .mode column to make data more readable. some useful commands. .tables '''displays tables''' .shell clear '''clears the screen'''")
 
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 14: Line 14:
some useful commands.
some useful commands.


  .tables '''displays tables'''
  .tables  
  .shell clear '''clears the screen'''
''displays tables''
 
  .shell clear  
''clears the screen''
 
Some useful tables:
 
cluster_specs
''Contains cluster information - as of 7/24/25 this had cleartext passwords''
 
v_center_resource_infos
''Contains most of the critical parameters you will need for testing APIs''

Latest revision as of 16:24, 24 July 2025

Data is stored in an SQLite3 database

to access the database:

sqlite3 /config/db/operator_info.db

It is useful to use:

.mode column

to make data more readable.

some useful commands.

.tables 
displays tables
.shell clear 
clears the screen

Some useful tables:

cluster_specs
Contains cluster information - as of 7/24/25 this had cleartext passwords
v_center_resource_infos
Contains most of the critical parameters you will need for testing APIs