· 6 years ago · Oct 05, 2019, 12:42 AM
1root@openair-cn:~/openair-cn/scripts# cat ../src/hss_rel14/db/oai_db.cql
2CREATE KEYSPACE IF NOT EXISTS vhss WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1': '1'};
3
4CREATE TABLE IF NOT EXISTS vhss.users_imsi (
5 imsi text PRIMARY KEY,
6 access_restriction int,
7 idmmeidentity int,
8 imei text,
9 imei_sv text,
10 key text,
11 lipa_permissions text,
12 mme_cap int,
13 mmehost text,
14 mmeidentity_idmmeidentity int,
15 mmerealm text,
16 ms_ps_status text,
17 msisdn bigint,
18 niddvalidity text,
19 nir_dest_host text,
20 nir_dest_realm text,
21 opc text,
22 pgw_id int,
23 rand text,
24 rfsp_index varint,
25 sqn bigint,
26 subscription_data text,
27 ue_reachability varint,
28 urrp_mme varint,
29 user_identifier text,
30 visited_plmnid text);
31
32CREATE TABLE IF NOT EXISTS vhss.msisdn_imsi (
33 msisdn bigint PRIMARY KEY,
34 imsi text
35);
36
37CREATE TABLE IF NOT EXISTS vhss.global_ids (
38 table_name text PRIMARY KEY,
39 id counter);
40
41CREATE TABLE IF NOT EXISTS vhss.mmeidentity_host (
42 mmehost text PRIMARY KEY,
43 idmmeidentity int,
44 mmerealm text,
45 ue_reachability varint,
46 mmeisdn text);
47
48CREATE TABLE IF NOT EXISTS vhss.mmeidentity (
49 idmmeidentity int PRIMARY KEY,
50 mmehost text,
51 mmerealm text,
52 ue_reachability varint,
53 mmeisdn text);
54
55CREATE TABLE IF NOT EXISTS vhss.events (
56 scef_id text,
57 scef_ref_id bigint,
58 extid text,
59 monitoring_event_configuration text,
60 monitoring_type int,
61 msisdn bigint,
62 user_identifier text,
63 primary key (scef_id, scef_ref_id)
64);
65
66CREATE TABLE IF NOT EXISTS vhss.events_msisdn (
67 msisdn bigint,
68 scef_id text,
69 scef_ref_id bigint,
70 primary key (msisdn, scef_id, scef_ref_id)
71);
72
73CREATE TABLE IF NOT EXISTS vhss.events_extid (
74 extid text,
75 scef_id text,
76 scef_ref_id bigint,
77 primary key (extid, scef_id, scef_ref_id)
78);
79
80CREATE TABLE IF NOT EXISTS vhss.extid (
81 extid text primary key
82);
83
84CREATE TABLE IF NOT EXISTS vhss.extid_imsi (
85 extid text,
86 imsi text,
87 primary key (extid, imsi)
88);
89
90CREATE TABLE IF NOT EXISTS vhss.extid_imsi_xref (
91 imsi text,
92 extid text,
93 primary key (imsi, extid)
94);
95
96
97
98
99^^^
100Thats the file that is being referenced in the command below
101root@openair-cn:~/openair-cn/scripts# cqlsh --file ../src/hss_rel14/db/oai_db.cql $Cassandra_Server_IProot@openair-cn:~/openair-cn/scripts# ./data_provisioning_users --apn internet.smokythecat.com --apn2 internet --key fec86ba6eb707ed08905757b1bb44b8f --imsi-first 208931234561000 --msisdn-first 001011234561000 --mme-identity mme.smokythecat.com --no-of-users 20 --realm smokythecat.com --truncate True --verbose True --cassandra-cluster $Cassandra_Server_IP
102Traceback (most recent call last):
103 File "./data_provisioning_users", line 178, in <module>
104 main()
105 File "./data_provisioning_users", line 155, in main
106 '{"Subscription-Data":{"Access-Restriction-Data":41,"Subscriber-Status":0,"Network-Access-Mode":2,"Regional-Subscription-Zone-Code":["0x0123","0x4567","0x89AB","0xCDEF","0x1234","0x5678","0x9ABC","0xDEF0","0x2345","0x6789"],"MSISDN":"0x'+str(msisdn)+'","AMBR":{"Max-Requested-Bandwidth-UL":50000000,"Max-Requested-Bandwidth-DL":100000000},"APN-Configuration-Profile":{"Context-Identifier":0,"All-APN-Configurations-Included-Indicator":0,"APN-Configuration":{"Context-Identifier":0,"PDN-Type":0,"Service-Selection":"'+args.apn+'","EPS-Subscribed-QoS-Profile":{"QoS-Class-Identifier":9,"Allocation-Retention-Priority":{"Priority-Level":15,"Pre-emption-Capability":0,"Pre-emption-Vulnerability":0}},"AMBR":{"Max-Requested-Bandwidth-UL":50000000,"Max-Requested-Bandwidth-DL":100000000},"PDN-GW-Allocation-Type":0,"MIP6-Agent-Info":{"MIP-Home-Agent-Address":["172.26.17.183"]}},"APN-Configuration":{"Context-Identifier":0,"PDN-Type":0,"Service-Selection":"'+args.apn2+'","EPS-Subscribed-QoS-Profile":{"QoS-Class-Identifier":9,"Allocation-Retention-Priority":{"Priority-Level":13,"Pre-emption-Capability":1,"Pre-emption-Vulnerability":0}},"AMBR":{"Max-Requested-Bandwidth-UL":50000000,"Max-Requested-Bandwidth-DL":100000000},"PDN-GW-Allocation-Type":0,"MIP6-Agent-Info":{"MIP-Home-Agent-Address":["172.26.17.183"]}}},"Subscribed-Periodic-RAU-TAU-Timer":0}}'
107 File "/usr/lib/python3/dist-packages/cassandra/cluster.py", line 1405, in execute
108 result = future.result(timeout)
109 File "/usr/lib/python3/dist-packages/cassandra/cluster.py", line 2976, in result
110 raise self._final_exception
111cassandra.Unavailable: code=1000 [Unavailable exception] message="Cannot achieve consistency level ONE" info={'consistency': 'ONE', 'required_replicas': 1, 'alive_replicas': 0}
112root@openai