怎么查询obproxy租户proxysys中有哪些内部表？

[AntTech_RFKTWX]

怎么查询obproxy租户proxysys中有哪些内部表？又是怎么知道white_list表有多少列？desc命令报错了？

[淇铭]

其实没有表的概念的 只有参数信息 为了方便 查看参数信息 才有这个表的 按照官方给的文档设置就好了

[AntTech_RFKTWX]

哦，好吧

[旭辉]

实际上不是表，是配置，可以通过这种方式看下字段

[Sunshining]

666学习一点

[AntTech_RFKTWX]

学习了

[AntTech_RFKTWX]

好的，谢谢了，通过如下命令确实可以查询出来。
[admin@localhost ~]$ strings ./obproxy/etc/proxyconfig_v1.db | grep “CREATE TABLE”
CREATE TABLE proxy_config(vid int NOT NULL default -1, vip varchar(100) NOT NULL default ‘’, vport int NOT NULL default 0, tenant_name varchar(128) collate nocase NOT NULL default ‘’, cluster_name varchar(260) collate nocase NOT NULL default ‘’, name varchar(130) collate nocase NOT NULL, value varchar(4100) NOT NULL, info varchar(1024), range varchar(64), need_reboot bool, visible_level varchar(20), config_level varchar(20) NOT NULL, primary key(vid, vip, vport, tenant_name, cluster_name, name))7
CREATE TABLE ssl_config(gmt_created date default (datetime(‘now’, ‘localtime’)), gmt_modified date, cluster_name varchar(256) collate nocase, tenant_name varchar(256) collate nocase, name varchar(256) collate nocase, value text collate nocase, primary key(cluster_name, tenant_name, name))3
CREATE TABLE resource_unit(gmt_created date default (datetime(‘now’, ‘localtime’)), gmt_modified date, cluster_name varchar(256) collate nocase, tenant_name varchar(256) collate nocase, name varchar(256) collate nocase, value text collate nocase, primary key(cluster_name, tenant_name, name))9
CREATE TABLE white_list(gmt_created date default (datetime(‘now’, ‘localtime’)), gmt_modified date, cluster_name varchar(256) collate nocase, tenant_name varchar(256) collate nocase, name varchar(256) collate nocase, value text collate nocase, primary key(cluster_name, tenant_name))3
CREATE TABLE all_table_version(gmt_created date default (datetime(‘now’, ‘localtime’)), gmt_modified date, table_name varchar(1000), version int default 0, primary key(table_name))A