Difference between revisions of "OpenBTS: Set SQLite Subscriber Registry secara manual"

From OnnoWiki
Jump to navigation Jump to search
 
(42 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Masuk ke Database SubscriberRegistry
 
Masuk ke Database SubscriberRegistry
  
 +
sudo su
 
  sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db
 
  sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db
 +
 +
akan keluar
 +
 +
sqlite>
 +
 +
==Cek database==
 +
 +
.databases
 +
 +
seq  name            file                                                     
 +
---  ---------------  ----------------------------------------------------------
 +
0    main            /var/lib/asterisk/sqlite3dir/sqlite3.db                 
 +
1    temp 
 +
 +
 +
==Cek table==
 +
 +
.tables
 +
 +
DIALDATA_TABLE  RRLP            SIP_BUDDIES    rates 
 +
 +
 +
==Cek isi table DIALDATA_TABLE==
 +
 +
select * from DIALDATA_TABLE;
 +
 +
1|2100|IMSI001010000000000
 +
2|2001|IMSI001010000000001
 +
3|2002|IMSI001010000000002
 +
 +
Atau
 +
 +
select exten, dial from dialdata_table;
 +
 +
2100|IMSI001010000000000
 +
2001|IMSI001010000000001
 +
2002|IMSI001010000000002
 +
 +
 +
==Cek isi table SIP_BUDDIES==
 +
 +
select * from SIP_BUDDIES ;
 +
 +
1|IMSI001010000000000|phones|allowed_not_screened|||||||dynamic|no|friend||||2100|0.0.0.0|info||||||||||||all|gsm||127.0.0.1|5062|IMSI001010000000000||||||||||1|no|no|no|no||no||yes|accept|1800|90|uas||||yes|500||120|||0||0||yes|no||||1|0|0|5ce5d6b846184773c5a070411204f864|972f8224|||0|0|1||0|
 +
2|IMSI001010000000001|phones|allowed_not_screened|||||||dynamic|no|friend||||2001|0.0.0.0|info||||||||||||all|gsm||127.0.0.1|5062|IMSI001010000000001||||||||||1|no|no|no|no||no||yes|accept|1800|90|uas||||yes|500||120|||0||0||yes|no||||1|0|0|||2104076337d2c83cfae1669771cbc944||0|0|1||0|
 +
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
 +
 +
select name, username, type, context, host from sip_buddies;
 +
 +
IMSI001010000000000|IMSI001010000000000|friend|phones|dynamic
 +
IMSI001010000000001|IMSI001010000000001|friend|phones|dynamic
 +
IMSI001010000000002|IMSI001010000000002|friend|phones|dynamic
 +
 +
Atau
 +
 +
select name, username, callerid, type, context, host from sip_buddies;
 +
 +
IMSI001010000000000|IMSI001010000000000|2100|friend|phones|dynamic
 +
IMSI001010000000001|IMSI001010000000001|2001|friend|phones|dynamic
 +
IMSI001010000000002|IMSI001010000000002|2002|friend|phones|dynamic
 +
 +
==Masukan Sebuah IMSI / Sebuah Handphone==
 +
 +
Untuk satu buah nomor IMSI510110052460084 yang akan diberi nomor 2222 kita perlu memasukan
 +
 +
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');
 +
 +
 +
 +
==Masukan SIP Phone==
 +
 +
Untuk satu buah SIP Phone yang akan diberi nomor misalnya 2000, dll kita perlu memasukan
 +
 +
INSERT INTO dialdata_table (exten, dial) VALUES ('2000', '2000');
 +
insert into sip_buddies (name,username,callerid,secret,ipaddr,type,context,host) values ('2000','2000','2000','123456','127.0.0.1','friend','phones','dynamic');
 +
 +
 +
INSERT INTO dialdata_table (exten, dial) VALUES ('2030', '2030');
 +
insert into sip_buddies (name,username,callerid,secret,ipaddr,type,context,host) values ('2030','2030','2030','123456','127.0.0.1','friend','phones','dynamic');
 +
 +
 +
INSERT INTO dialdata_table (exten, dial) VALUES ('2031', '2031');
 +
insert into sip_buddies (name,username,callerid,secret,ipaddr,type,context,host) values ('2031','2031','2031','123456','127.0.0.1','friend','phones','dynamic');
 +
 +
 +
INSERT INTO dialdata_table (exten, dial) VALUES ('2032', '2032');
 +
insert into sip_buddies (name,username,callerid,secret,ipaddr,type,context,host) values ('2032','2032','2032','123456','127.0.0.1','friend','phones','dynamic');
 +
 +
==Masukan ke Table DIALDATA_TABLE==
 +
 +
Contoh
 +
 +
INSERT INTO dialdata_table (exten, dial) VALUES ('2222', 'IMSI510110052460084');
 +
INSERT INTO dialdata_table (exten, dial) VALUES ('1111', 'IMSI510112410440152');
 +
 +
id akan di tambahkan secara automatis
 +
 +
===DELETE data DIALDATA_TABLE===
 +
 +
Contoh
 +
 +
DELETE from DIALDATA_TABLE where ID = 7;
 +
 +
==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');
 +
 +
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510112410440152','IMSI510112410440152','1111','127.0.0.1','friend','phones','dynamic');
 +
 +
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
 +
 +
more /usr/local/src/openbts-2.8.0/openbts/trunk/SR/test.srmanager/test.db.init
 +
 +
===DELETE data SIP_BUDDIES===
 +
 +
Contoh
 +
 +
DELETE from SIP_BUDDIES where ID = 7;
 +
 +
==Test Data==
 +
 +
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');
 +
 +
==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
 +
 +
==Pranala Menarik==
 +
 +
* [[OpenBTS]]
 +
* [[OpenBTS: Arsitektur secara umum]]
 +
 +
===Persiapan===
 +
 +
* [[USRP: High Precision Clock]]
 +
* [[USRP: Menyambungkan ClockTamer ke USRP1]]
 +
* [[USRP: Kalibrasi ClockTamer]]
 +
* [[USRP: ClockTamer Control Protocol]]
 +
* [[USRP: ClockTamer Flashing]]
 +
* [[USRP: Instalasi Board]]
 +
* [[OpenBTS: GIT Source Code]]
 +
* [[USRP: Rangkaian Board USRP]]
 +
* [[OpenBTS: Tethr untuk Bencana Alam]]
 +
* [[USRP: Tip Pemesanan]]
 +
 +
===Script===
 +
 +
* [[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 2.8.0 di RangeNetwork Dev Kit]]
 +
* [[OpenBTS: Script Membuat OpenBTS di RangeNetwork Dev Kit]]
 +
 +
===OpenBTS 2.6===
 +
 +
* [[GNURadio]]
 +
* [[GNURadio: Ubuntu Install]]
 +
* [[GNURadio: Menggunakan UHD]]
 +
* [[GNURadio: Ubuntu Install GNURadio 3.4.2]] '''RECOMMENDED'''
 +
* [[GNURadio: Ubuntu Install GNURadio 3.4.2 Clock 52MHz]] '''RECOMMENDED'''
 +
* [[GNURadio: Ubuntu 13.04 Install GNURadio 3.4.2 Clock 52MHz]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Contoh Aplikasi]]
 +
* [[GNURadio: Spectrum Analizer GSM]]
 +
* [[GNURadio: Mengubah board RFX1800 menjadi RFX900]]
 +
* [[GNURadio: Programming Untuk Pemula]]
 +
* [[OpenBTS: Ubuntu Install]] '''RECOMMENDED'''
 +
* [[OpenBTS: Ubuntu Install OpenBTS 2.6 Clock 52MHz]] '''RECOMMENDED'''
 +
* [[OpenBTS: Ubuntu 13.04 Install OpenBTS 2.6 Clock 52MHz]] ''NOT RECOMMENDED''
 +
* [[OpenBTS: Konfigurasi]] '''RECOMMENDED'''
 +
* [[OpenBTS: Kalibrasi]]
 +
* [[OpenBTS: Konfigurasi Asterisk untuk OpenBTS]] '''RECOMMENDED'''
 +
* [[OpenBTS: Menjalankan smqueue]]
 +
* [[OpenBTS: Mengoperasikan BTS]] '''RECOMMENDED'''
 +
* [[OpenBTS: Tampilan di Nokia saat pakai OpenBTS]]
 +
* [[OpenBTS: Operasi 1800 MHz]]
 +
* [[OpenBTS: Beberapa Tips]]
 +
* [[OpenBTS: USRP2]]
 +
* [[OpenBTS: Amplifier]]
 +
* [[OpenBTS: SMS]]
 +
* [[AirProbe]]
 +
 +
===OpenBTS 2.8===
 +
 +
* [[GNURadio: Ubuntu 11.10 Install]] ''NOT RECOMMENED''
 +
* [[GNURadio: Ubuntu 11.10 instalasi menggunakan Repo]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Download GNURadio]]
 +
* [[GNURadio: Install UHD]]
 +
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.3.0]]
 +
* [[GNURadio: Ubuntu 12.10 Instal GNURadio 3.3.0]]
 +
* [[GNURadio: Ubuntu 12.10 Instal GNURadio 3.4.1]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.4.2]] '''RECOMMENDED'''
 +
* [[GNURadio: Ubuntu 12.04 Instal GNURadio 3.4.2]] '''RECOMMENDED'''
 +
* [[GNURadio: Ubuntu 12.04.1 Instal GNURadio 3.4.2]] '''RECOMMENDED'''
 +
* [[GNURadio: Ubuntu 12.10 Instal GNURadio 3.4.2]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Ubuntu 13.04 Instal GNURadio 3.4.2]] '''RECOMMENDED'''
 +
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.5.0]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.5.3.2]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.6.0]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Ubuntu 11.10 Install dari GIT GNURadio]] ''NOT RECOMMENDED''
 +
* [[GNURadio: Ubuntu 11.10 cek USRP Daughter Board]]
 +
* [[GNURadio: UHD]] ''NOT RECOMMENDED''
 +
* [[GNURadio: UHD Image]] ''NOT RECOMMENDED''
 +
* [[GNURadio: UHD burn EEPROM RFX Board di USRP1]] ''NOT RECOMMENDED''
 +
* [[GNURadio: UHD Identifikasi Device]]
 +
* [[OpenBTS: Ubuntu 11.10 Install]]
 +
* [[OpenBTS: dari GIT ttsou]]
 +
* [[OpenBTS: 2.8 dari SVN Install]]
 +
* [[OpenBTS: 2.8 dari SVN Install Clock 52MHz]] '''RECOMMENDED'''
 +
* [[OpenBTS: 2.8 dari SVN Install Clock 52MHz di Ubuntu 12.10]] '''RECOMMENDED'''
 +
* [[OpenBTS: 2.8 dari SVN Install Clock 52MHz di Ubuntu 13.04]] '''RECOMMENDED'''
 +
* [[OpenBTS: 2.8 dari SVN 2.8.0 Install Clock 52MHz di Ubuntu 13.04]] '''RECOMMENDED'''
 +
* [[OpenBTS: 2.8 dari SVN Install Clock 52MHz dengan UHD tanpa GNURadio]] ''NOT RECOMMENDED''
 +
* [[OpenBTS: 2.8 Edit User di sqlite3.db]] '''RECOMMEND'''
 +
* [[OpenBTS: Yate Softswitch]] '''RECOMMENDED'''
 +
* [[OpenBTS: Yate Softswitch install Ubuntu 12.10]] '''RECOMMENDED'''
 +
* [[OpenBTS: Yate Softswitch install Ubuntu 13.04]] '''RECOMMENDED'''
 +
* [[OpenBTS: Yate Config Test]]
 +
* [[OpenBTS: 2.8 Instalasi Real Time Asterisk]] '''RECOMMENDED'''
 +
* [[OpenBTS: 2.8 Menjalankan]] '''RECOMMENDED'''
 +
* [[OpenBTS: 2.8 Konfigurasi]]
 +
* [[OpenBTS: 2.8 Konfigurasi Cognitive Radio Elsabagh]]
 +
* [[OpenBTS: 2.8 Konfigurasi Subscriber Registery]]
 +
* [[OpenBTS: Database SQLite]]
 +
* [[OpenBTS: Set SQLite Subscriber Registry secara manual]]
 +
* [[OpenBTS: FreeSWITCH]]
 +
 +
===Multi OpenBTS 2.8===
 +
 +
* [[OpenBTS: Pola Multi OpenBTS]] '''RECOMMENDED'''
 +
* [[Multi OpenBTS: Catatan Konfigurasi]] '''RECOMMENDED'''
 +
 +
===OpenBTS 3.1.x===
 +
 +
* [[OpenBTS: Install UHD untuk USRP1]]
 +
* [[OpenBTS: UHD Identifikasi Device]]
 +
* [[OpenBTS: OpenBTS 3.1.3 Compile]] '''Tidak bisa untuk USRP1'''
 +
* [[OpenBTS: Yate Compile]]
 +
 +
===Ettus E110===
 +
 +
* [[OpenBTS: E110 Cara Login]]
 +
* [[OpenBTS: E110 Install Image di MicroSD]] '''*RECOMMENDED*'''
 +
* [[OpenBTS: E110 Cek Daughter Board]]
 +
* [[OpenBTS: E110 Mengubah Master Clock]]
 +
* [[OpenBTS: E110 Kalibrasi Clock]]
 +
* [[OpenBTS: E110 Konfigurasi Jaringan]]
 +
* [[OpenBTS: E110 Bekerja dengan opkg]]
 +
* [[OpenBTS: E110 Instalasi iptables]]
 +
* [[OpenBTS: E110 GNURadio]]
 +
* [[OpenBTS: E110 Compile UHD]] ''Not Recommended''
 +
* [[OpenBTS: E110 Compile UHD dari Release Bukan git]] ''Not Recommended''
 +
* [[OpenBTS: E110 UHD burn EEPROM RFX Board]] ''Not Recommended''
 +
* [[OpenBTS: E110 Install UHD Image]] ''Not Recommended''
 +
* [[OpenBTS: E110 Instalasi OpenBTS]]
 +
* [[OpenBTS: E110 Instalasi OpenBTS 2.6]] ''NOT RECOMMENDED''
 +
* [[OpenBTS: E110 Instalasi OpenBTS 2.8 untuk MultiBTS]] '''*RECOMMENDED*'''
 +
* [[OpenBTS: E110 Yate Softswitch]]
 +
 +
===Ettus N210===
 +
 +
* [[OpenBTS: N210 Instalasi GPSDO Kit]]
 +
* [[OpenBTS: N210 GNURadio]]
 +
* [[OpenBTS: N210 GNURadio 3.7.0]]
 +
* [[OpenBTS: N210 Instalasi OpenBTS]]
 +
* [[OpenBTS: N210 Instalasi Yate]]
 +
* [[OpenBTS: N210 Yate Config Test]]
 +
* [[OpenBTS: N210 Burn Firmware]]
 +
 +
===RangeNetworks===
 +
 +
* [[OpenBTS: RangeNetwork Default Setting]]
 +
* [[OpenBTS: RangeNetwork Compile GNURadio UHD]]
 +
* [[OpenBTS: RangeNetwork Compile]]
 +
* [[OpenBTS: RangeNetwork Compile OpenBTS 3.1.3]] '''*RECOMMENDED*'''
 +
* [[OpenBTS: RangeNetwork Yate Compile]] '''*RECOMMENDED*'''
 +
* [[OpenBTS: RangeNetwork Web Interface]]
 +
* [[OpenBTS: RangeNetwork Trunk ke Asterisk Lain]]
 +
* [[VoIP: Trunk]]
 +
 +
 +
===GPRS===
 +
 +
* [[OpenBTS: GPRS]]
 +
* [[OpenBTS: GPRS Konfigurasi]]
 +
* [[OpenBTS: GPRS untuk dibelakang Router dengan NAT]]
 +
 +
===Briker OpenBTS===
 +
 +
* [[OpenBTS: Briker]]
 +
 +
===FreeSWITCH OpenBTS===
 +
 +
* [[OpenBTS: FreeSWITCH]]
 +
 +
===Power Amplifier===
 +
 +
* [[Driver 900MHz]]
 +
* [[Power Amplifier 900MHz]]
 +
* [[Duplexer]]
 +
* [[OpenBTS: Menaikan Jangkauan OpenBTS]]
 +
 +
===Lain Lain===
 +
 +
* [[OpenBTS: Materi Magang di ICTWATCH]]
 +
* [[OpenBTS: Seminar Outline]]
 +
* [[OpenBTS: Workshop Outline]]
 +
* [[Membuat Base Station GSM Open Source]]
 +
* [[Teknologi Selular]]
 +
* [[GSM: Daftar Channel Frekuensi]]
 +
* [[Wireless Internet]]
 +
* [[OpenBSC]]
 +
* [[AirProbe]]
 +
* [[Base station subsystem]]
 +
* [[GSM]]
 +
* [[Asterisk]]
 +
* [[Mobile phone]]
 +
 +
===Catatan Legal dan Pendukung===
 +
 +
* [[Siapa Bilang OpenBTS Ilegal?]]
 +
* [[OpenBTS: Catatan MNC dan MCC Indonesia]]
 +
* [[OpenBTS: Catatan MNC dan MCC COOL]]
 +
* [[OpenBTS : Alokasi Frekuensi Operator GSM Indonesia]]
 +
* [[GSM: Daftar Channel Frekuensi]]
 +
 +
===Catatan Sejarah===
 +
 +
* [[2011/04/30 - Workshop OpenBTS Pertama di Indonesia dilakukan di Univ Gajah Putih Takengon Aceh Tengah]]
 +
* [[OpenBTS: Daftar Workshop atau Seminar yang pernah dilakukan]]
 +
* [[OpenBTS: Daftar Artikel di Media]]
 +
* [[OpenBTS: Permohonan Kanal dan DID untuk OpenBTS]]
 +
* [[OpenBTS: 2013/02/19 - OpenBTS TelkomSel Mengudara di Muscat Oman]]
 +
* [[OpenBTS: Beroperasi di Papua]]
 +
 +
===Dokumentasi Video===
 +
 +
* http://www.metrotvnews.com/read/newsprograms/2012/10/14/14624/212/Teknologi-BTS
 +
* http://youtu.be/8ogOcUSpINU (1/6)
 +
* http://youtu.be/F5d7HGuhppk (2/6)
 +
* http://youtu.be/90Jgq6bOgrQ (3/6)
 +
* http://youtu.be/cNkx_qNqdfc (4/6)
 +
* http://youtu.be/6LCuoeI57ak (5/6)
 +
* http://youtu.be/-dEqcHoIlYk (6/6)
 +
* http://www.youtube.com/watch?v=Ff_rw4kAOZg&feature=share
 +
 +
===Perjuangan OpenBTS===
 +
 +
* http://www.technologyreview.com/news/522371/how-remote-places-can-get-cellular-coverage-by-doing-it-themselves/?utm_campaign=socialsync&utm_medium=social-post&utm_source=twitter
 +
 +
 +
 +
[[Category: Wireless]]
 +
[[Category: Selular]]

Latest revision as of 11:06, 8 May 2019

Masuk ke Database SubscriberRegistry 

sudo su
sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db

akan keluar 

sqlite>

Cek database

.databases

seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /var/lib/asterisk/sqlite3dir/sqlite3.db                   
1    temp


Cek table

.tables

DIALDATA_TABLE  RRLP            SIP_BUDDIES     rates


Cek isi table DIALDATA_TABLE

select * from DIALDATA_TABLE;

1|2100|IMSI001010000000000
2|2001|IMSI001010000000001
3|2002|IMSI001010000000002

Atau 

select exten, dial from dialdata_table;

2100|IMSI001010000000000
2001|IMSI001010000000001
2002|IMSI001010000000002


Cek isi table SIP_BUDDIES

select * from SIP_BUDDIES ;

1|IMSI001010000000000|phones|allowed_not_screened|||||||dynamic|no|friend||||2100|0.0.0.0|info||||||||||||all|gsm||127.0.0.1|5062|IMSI001010000000000||||||||||1|no|no|no|no||no||yes|accept|1800|90|uas||||yes|500||120|||0||0||yes|no||||1|0|0|5ce5d6b846184773c5a070411204f864|972f8224|||0|0|1||0|
2|IMSI001010000000001|phones|allowed_not_screened|||||||dynamic|no|friend||||2001|0.0.0.0|info||||||||||||all|gsm||127.0.0.1|5062|IMSI001010000000001||||||||||1|no|no|no|no||no||yes|accept|1800|90|uas||||yes|500||120|||0||0||yes|no||||1|0|0|||2104076337d2c83cfae1669771cbc944||0|0|1||0|
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 

select name, username, type, context, host from sip_buddies;

IMSI001010000000000|IMSI001010000000000|friend|phones|dynamic
IMSI001010000000001|IMSI001010000000001|friend|phones|dynamic
IMSI001010000000002|IMSI001010000000002|friend|phones|dynamic

Atau 

select name, username, callerid, type, context, host from sip_buddies;

IMSI001010000000000|IMSI001010000000000|2100|friend|phones|dynamic
IMSI001010000000001|IMSI001010000000001|2001|friend|phones|dynamic
IMSI001010000000002|IMSI001010000000002|2002|friend|phones|dynamic

Masukan Sebuah IMSI / Sebuah Handphone

Untuk satu buah nomor IMSI510110052460084 yang akan diberi nomor 2222 kita perlu memasukan 

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


Masukan SIP Phone

Untuk satu buah SIP Phone yang akan diberi nomor misalnya 2000, dll kita perlu memasukan 

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



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



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



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

Masukan ke Table DIALDATA_TABLE

Contoh 

INSERT INTO dialdata_table (exten, dial) VALUES ('2222', 'IMSI510110052460084');
INSERT INTO dialdata_table (exten, dial) VALUES ('1111', 'IMSI510112410440152');

id akan di tambahkan secara automatis

DELETE data DIALDATA_TABLE

Contoh 

DELETE from DIALDATA_TABLE where ID = 7;

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

insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510112410440152','IMSI510112410440152','1111','127.0.0.1','friend','phones','dynamic');

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 

more /usr/local/src/openbts-2.8.0/openbts/trunk/SR/test.srmanager/test.db.init

DELETE data SIP_BUDDIES

Contoh 

DELETE from SIP_BUDDIES where ID = 7;

Test Data

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

Referensi

Pranala Menarik

Persiapan

Script

OpenBTS 2.6

OpenBTS 2.8

Multi OpenBTS 2.8

OpenBTS 3.1.x

Ettus E110

Ettus N210

RangeNetworks


GPRS

Briker OpenBTS

FreeSWITCH OpenBTS

Power Amplifier

Lain Lain

Catatan Legal dan Pendukung

Catatan Sejarah

Dokumentasi Video

Perjuangan OpenBTS

Retrieved from "https://onnocenter.or.id/wiki/index.php?title=OpenBTS:_Set_SQLite_Subscriber_Registry_secara_manual&oldid=56297"