Difference between revisions of "OpenBTS: Set SQLite Subscriber setup manual"
		
		
		
		
		
		Jump to navigation
		Jump to search
		
				
		
		
	
Onnowpurbo (talk | contribs)  (Created page with "==Test Data==  Cek IMSI dari TMSIS   OpenBTS> tmsis  IMSI            TMSI IMEI            AUTH CREATED ACCESSED TMSI_ASSIGNED   901550000000149 -    353907055098370 2    53s...")  | 
				Onnowpurbo (talk | contribs)   | 
				||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
Cek IMSI dari TMSIS  | Cek IMSI dari TMSIS  | ||
Latest revision as of 10:20, 11 May 2017
Cek IMSI dari TMSIS
OpenBTS> tmsis IMSI TMSI IMEI AUTH CREATED ACCESSED TMSI_ASSIGNED 901550000000149 - 353907055098370 2 53s 53s 0
Lakukan
sudo su sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db
Pada prompt
sqlite>
Ketik
INSERT INTO dialdata_table (exten, dial) VALUES ('2001', 'IMSI001010000000001');
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI001010000000001','IMSI001010000000001','2001','127.0.0.1','friend','phones','dynamic');
INSERT INTO dialdata_table (exten, dial) VALUES ('2002', 'IMSI510105852803044');
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510105852803044','IMSI510105852803044','2002','127.0.0.1','friend','phones','dynamic');
INSERT INTO dialdata_table (exten, dial) VALUES ('2012', 'IMSI901550000000148');
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI901550000000148','IMSI901550000000148','2012','127.0.0.1','friend','phones','dynamic');
INSERT INTO dialdata_table (exten, dial) VALUES ('2032', 'IMSI510107013804199');
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510107013804199','IMSI510107013804199','2032','127.0.0.1','friend','phones','dynamic');
INSERT INTO dialdata_table (exten, dial) VALUES ('2003', 'IMSI510103013910888');
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510103013910888','IMSI510103013910888','2003','127.0.0.1','friend','phones','dynamic');