OpenBTS: Set SQLite Subscriber Registry secara manual - Revision history

Onnowpurbo: /* Masukan ke Table SIP_BUDDIES */

2019-05-08T04:06:01Z

Masukan ke Table SIP_BUDDIES

2017-05-11T03:08:21Z

Test Data

2017-04-09T01:14:52Z

2017-04-07T22:10:09Z

Test Data

2017-04-07T12:49:41Z

Test Data

2017-04-07T12:43:54Z

Test Data

2014-02-16T01:57:59Z

Pranala Menarik

2014-01-25T22:58:56Z

Test Data

2014-01-25T22:54:20Z

Test Data

2014-01-25T22:51:40Z

DELETE data SIP_BUDDIES

@@ Line 111: / Line 111: @@
 ==Masukan ke Table SIP_BUDDIES==
+Ini aman untuk memasukan info
   insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510110052460084','IMSI510110052460084','2222','127.0.0.1','friend','phones','dynamic');
@@ Line 121: / Line 118: @@
 id akan ditambahkan secara automatis.
 Detail parameter SIP_BUDDIES dapat dilihat di file
@@ Line 131: / Line 132: @@
   DELETE from SIP_BUDDIES where ID = 7;
 ==Test Data==

@@ Line 163: / Line 163: @@
   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');
 ==Referensi==

← Older revision		Revision as of 01:14, 9 April 2017
Line 166:		Line 166:
	==Referensi==		==Referensi==

		+	* http://tz.ucweb.com/4_ARO2
	* http://wush.net/svn/range/software/public/subscriberRegistry/trunk/SubscriberRegistry.cpp File ini berisi format tabel dari SubscriberRegistry		* http://wush.net/svn/range/software/public/subscriberRegistry/trunk/SubscriberRegistry.cpp File ini berisi format tabel dari SubscriberRegistry

← Older revision		Revision as of 22:10, 7 April 2017
Line 134:		Line 134:

	==Test Data==		==Test Data==
		+
		+	Cek IMSI dari TMSIS
		+
		+	OpenBTS> tmsis
		+	IMSI TMSI IMEI AUTH CREATED ACCESSED TMSI_ASSIGNED
		+	901550000000149 - 353907055098370 2 53s 53s 0

	Lakukan		Lakukan

@@ Line 151: / Line 151: @@
   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');
 ==Referensi==

@@ Line 149: / Line 149: @@
   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', 'IMSI001010000000002');
+  INSERT INTO dialdata_table (exten, dial) VALUES ('2002', 'IMSI510105852803044');
-  insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI001010000000002','IMSI001010000000002','2002','127.0.0.1','friend','phones','dynamic');
+  insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510105852803044','IMSI510105852803044','2002','127.0.0.1','friend','phones','dynamic');
 ==Referensi==

@@ Line 181: / Line 181: @@
 * [[OpenBTS: Script Membuat GNURadio 3.4.2 di Ubuntu 13.04]]
 * [[OpenBTS: Script Membuat OpenBTS dan yate di Ubuntu 13.04]]
 * [[OpenBTS: Script Membuat OpenBTS di RangeNetwork Dev Kit]]
@@ Line 305: / Line 306: @@
 * [[OpenBTS: RangeNetwork Compile OpenBTS 3.1.3]] '''*RECOMMENDED*'''
 * [[OpenBTS: RangeNetwork Yate Compile]] '''*RECOMMENDED*'''
 ===GPRS===

@@ Line 152: / Line 152: @@
   insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI001010000000002','IMSI001010000000002','2002','127.0.0.1','friend','phones','dynamic');
-  INSERT INTO dialdata_table (exten, dial) VALUES ('2222', 'IMSI510110052460084');
+  INSERT INTO dialdata_table (exten, dial) VALUES ('2003', 'IMSI510112410440152');
-  insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510110052460084','IMSI510110052460084','2222','127.0.0.1','friend','phones','dynamic');
+  insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510112410440152','IMSI510112410440152','2003','127.0.0.1','friend','phones','dynamic');
 ==Referensi==

← Older revision		Revision as of 22:54, 25 January 2014
Line 134:		Line 134:

	==Test Data==		==Test Data==
		+
		+	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 dialdata_table (exten, dial) VALUES ('2001', 'IMSI001010000000001');

← Older revision		Revision as of 22:51, 25 January 2014
Line 131:		Line 131:

	DELETE from SIP_BUDDIES where ID = 7;		DELETE from SIP_BUDDIES where ID = 7;
		+
		+
		+	==Test Data==
		+
		+	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', 'IMSI001010000000002');
		+	insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI001010000000002','IMSI001010000000002','2002','127.0.0.1','friend','phones','dynamic');
		+
		+	INSERT INTO dialdata_table (exten, dial) VALUES ('2222', 'IMSI510110052460084');
		+	insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510110052460084','IMSI510110052460084','2222','127.0.0.1','friend','phones','dynamic');
		+
		+	INSERT INTO dialdata_table (exten, dial) VALUES ('2222', 'IMSI510110052460084');
		+	insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510110052460084','IMSI510110052460084','2222','127.0.0.1','friend','phones','dynamic');
		+
		+	INSERT INTO dialdata_table (exten, dial) VALUES ('2222', 'IMSI510110052460084');
		+	insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510110052460084','IMSI510110052460084','2222','127.0.0.1','friend','phones','dynamic');

	==Referensi==		==Referensi==