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

← Older revision		Revision as of 04:06, 8 May 2019
Line 111:		Line 111:
	==Masukan ke Table SIP_BUDDIES==		==Masukan ke Table SIP_BUDDIES==

			Ini aman untuk memasukan info
	~~INSERT into SIP_BUDDIES VALUES (3,'IMSI001010000000002','phones','allowed_not_screened',,,,,,,'dynamic','no','friend',,,,2002,'0.0.0.0','~~info',,,,,,,,,,,,'all','gsm',,'127.0.0.1',5062,'IMSI001010000000002',,,,,,,,,,1,'no','no','no','no',,'no',,'yes','accept',1800,90,'uas',,,,'yes',500,,120,,,0,,0,,'yes','no',,,,1,0,0,,,'d7c1dd6599fd6d9737939032b1d6d918',,0,0,1,,0,);

	~~atau~~

	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 ('IMSI510110052460084','IMSI510110052460084','2222','127.0.0.1','friend','phones','dynamic');
Line 121:		Line 118:

	id akan ditambahkan secara automatis.		id akan ditambahkan secara automatis.

			Atau (ini lebih beresiko salah)

			INSERT into SIP_BUDDIES VALUES (3,'IMSI001010000000002','phones','allowed_not_screened',,,,,,,'dynamic','no','friend',,,,2002,'0.0.0.0','info',,,,,,,,,,,,'all','gsm',,'127.0.0.1',5062,'IMSI001010000000002',,,,,,,,,,1,'no','no','no','no',,'no',,'yes','accept',1800,90,'uas',,,,'yes',500,,120,,,0,,0,,'yes','no',,,,1,0,0,,,'d7c1dd6599fd6d9737939032b1d6d918',,0,0,1,,0,);

	Detail parameter SIP_BUDDIES dapat dilihat di file		Detail parameter SIP_BUDDIES dapat dilihat di file
Line 131:		Line 132:

	DELETE from SIP_BUDDIES where ID = 7;		DELETE from SIP_BUDDIES where ID = 7;


	==Test Data==		==Test Data==

Onnowpurbo: /* Test Data */

2017-05-11T03:08:21Z

Test Data

← Older revision		Revision as of 03:08, 11 May 2017
Line 163:		Line 163:
	INSERT INTO dialdata_table (exten, dial) VALUES ('2032', 'IMSI510107013804199');		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 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');

	==Referensi==		==Referensi==

Onnowpurbo at 01:14, 9 April 2017

2017-04-09T01:14:52Z

← 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

Onnowpurbo: /* Test Data */

2017-04-07T22:10:09Z

Test Data

← 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

Onnowpurbo: /* Test Data */

2017-04-07T12:49:41Z

Test Data

← Older revision		Revision as of 12:49, 7 April 2017
Line 151:		Line 151:
	INSERT INTO dialdata_table (exten, dial) VALUES ('2002', 'IMSI510105852803044');		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 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');

	==Referensi==		==Referensi==

Onnowpurbo: /* Test Data */

2017-04-07T12:43:54Z

Test Data

← Older revision		Revision as of 12:43, 7 April 2017
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 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');

	~~INSERT INTO dialdata_table (exten, dial) VALUES ('2003', 'IMSI510112410440152');~~
	~~insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510112410440152','IMSI510112410440152','2003~~','127.0.0.1','friend','phones','dynamic');

	==Referensi==		==Referensi==

Onnowpurbo: /* Pranala Menarik */

2014-02-16T01:57:59Z

Pranala Menarik

← Older revision		Revision as of 01:57, 16 February 2014
Line 181:		Line 181:
	* [[OpenBTS: Script Membuat GNURadio 3.4.2 di Ubuntu 13.04]]		* [[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 dan yate di Ubuntu 13.04]]
			* [[OpenBTS: Script Membuat OpenBTS 2.8.0 di RangeNetwork Dev Kit]]
	* [[OpenBTS: Script Membuat OpenBTS di RangeNetwork Dev Kit]]		* [[OpenBTS: Script Membuat OpenBTS di RangeNetwork Dev Kit]]

Line 305:		Line 306:
	* [[OpenBTS: RangeNetwork Compile OpenBTS 3.1.3]] '''RECOMMENDED'''		* [[OpenBTS: RangeNetwork Compile OpenBTS 3.1.3]] '''RECOMMENDED'''
	* [[OpenBTS: RangeNetwork Yate Compile]] '''RECOMMENDED'''		* [[OpenBTS: RangeNetwork Yate Compile]] '''RECOMMENDED'''
			* [[OpenBTS: RangeNetwork Web Interface]]
			* [[OpenBTS: RangeNetwork Trunk ke Asterisk Lain]]
			* [[VoIP: Trunk]]


	===GPRS===		===GPRS===

Onnowpurbo: /* Test Data */

2014-01-25T22:58:56Z

Test Data

← Older revision		Revision as of 22:58, 25 January 2014
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 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');

	~~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==

Onnowpurbo: /* Test Data */

2014-01-25T22:54:20Z

Test Data

← 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');

Onnowpurbo: /* DELETE data SIP_BUDDIES */

2014-01-25T22:51:40Z

DELETE data SIP_BUDDIES

← 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==