Difference between revisions of "OpenBTS: 2.8 Konfigurasi Subscriber Registery"

From OnnoWiki
Jump to navigation Jump to search
 
(17 intermediate revisions by the same user not shown)
Line 20: Line 20:
  
  
 +
==Beberapa SQLite database penting==
 +
 +
Beberapa file SQLite database yang penting
 +
 +
/etc/OpenBTS/OpenBTS.db
 +
/etc/OpenBTS/smqueue.db
 +
/etc/OpenBTS/sipauthserve.db
 +
/var/lib/asterisk/sqlite3dir/sqlite3.db
 +
 +
==Edit Menggunakan SQLiteStudio==
 +
 +
Download dari
 +
 +
http://sqlitestudio.pl/?act=download
 +
 +
Lakukan
 +
 +
chmod 777 sqlitestudio-2.1.4.bin
 +
 +
Jalankan menggunakan
 +
 +
./sqlitestudio-2.1.4.bin
 +
 +
==Edit Menggunakan SQLite Database Browser==
 +
 +
Langkah yang perlu dilakukan
 +
 +
* [[SQLite: Instalasi SQLite Database Browser | Instalasi SQLite Database Browser]]
 +
 +
Download dari http://sourceforge.net/projects/sqlitedbrowser/
 +
 +
sudo apt-get install libjpeg62
 +
mkdir /usr/local/src/sqlitebrowser
 +
mkdir /usr/local/src/sqlitebrowser
 +
cp sqlitebrowser-linux.tar.gz /usr/local/src/sqlitebrowser/
 +
cd /usr/local/src/sqlitebrowser/
 +
tar zxvf sqlitebrowser-linux.tar.gz
 +
 +
* Jalankan
 +
 +
sudo su
 +
/usr/local/src/sqlitebrowser/sqlitestudio/sqlitestudio
 +
 +
[[Image:Sqlitestudio1.png|center|200px|thumb]]
 +
 +
 +
 +
===Edit /etc/OpenBTS/OpenBTS.db===
 +
 +
[[Image:Sqlitestudio-openbtsdb1.png|center|200px|thumb]]
 +
 +
[[Image:Sqlitestudio-openbtsdb2.png|center|200px|thumb]]
 +
 +
 +
===Edit /etc/OpenBTS/smqueue.db===
 +
 +
[[Image:Sqlitestudio-smqueue1.png|center|200px|thumb]]
 +
 +
[[Image:Sqlitestudio-smqueue2.png|center|200px|thumb]]
 +
 +
===Edit /etc/OpenBTS/sipauthserve.db===
 +
 +
[[Image:Sqlitestudio-sipauthserve1.png|center|200px|thumb]]
 +
 +
[[Image:Sqlitestudio-sipauthserve2.png|center|200px|thumb]]
 +
 +
===Edit /var/lib/asterisk/sqlite3dir/sqlite3.db===
 +
 +
[[Image:Sqlitestudio-subscriberregistry2.png|center|200px|thumb]]
 +
 +
[[Image:Sqlitestudio-subscriberregistry1.png|center|200px|thumb]]
 +
 +
[[Image:Sqlitestudio-subscriberregistry3.png|center|200px|thumb]]
 +
 +
[[Image:Sqlitestudio-subscriberregistry4.png|center|200px|thumb]]
 +
 +
==Test Query ke Subscriber Registry di SQLite Database Browser==
 +
 +
Coba test apakah SQLite Database dapat memberikan responds yang benar,
 +
misalnya menggunakan perintah
 +
 +
select dial from dialdata_table where exten = 1111
 +
select ipaddr from sip_buddies where name = IMSI510110301694405
 +
select ipaddr from sip_buddies where callerid = 1111
  
 
==Manajemen Subscriber Registry via Web==
 
==Manajemen Subscriber Registry via Web==
Line 54: Line 138:
  
 
* [[OpenBTS]]
 
* [[OpenBTS]]
 +
* [[OpenBTS: Arsitektur secara umum]]
  
 
===Persiapan===
 
===Persiapan===
Line 61: Line 146:
 
* [[USRP: Kalibrasi ClockTamer]]
 
* [[USRP: Kalibrasi ClockTamer]]
 
* [[USRP: ClockTamer Control Protocol]]
 
* [[USRP: ClockTamer Control Protocol]]
 +
* [[USRP: ClockTamer Flashing]]
 
* [[USRP: Instalasi Board]]
 
* [[USRP: Instalasi Board]]
 
* [[OpenBTS: GIT Source Code]]
 
* [[OpenBTS: GIT Source Code]]
 
* [[USRP: Rangkaian Board USRP]]
 
* [[USRP: Rangkaian Board USRP]]
 
* [[OpenBTS: Tethr untuk Bencana Alam]]
 
* [[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 2.6===
 
===OpenBTS 2.6===
Line 73: Line 166:
 
* [[GNURadio: Ubuntu Install GNURadio 3.4.2]] '''RECOMMENDED'''
 
* [[GNURadio: Ubuntu Install GNURadio 3.4.2]] '''RECOMMENDED'''
 
* [[GNURadio: Ubuntu Install GNURadio 3.4.2 Clock 52MHz]] '''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: Contoh Aplikasi]]
 
* [[GNURadio: Spectrum Analizer GSM]]
 
* [[GNURadio: Spectrum Analizer GSM]]
Line 79: Line 173:
 
* [[OpenBTS: Ubuntu Install]] '''RECOMMENDED'''
 
* [[OpenBTS: Ubuntu Install]] '''RECOMMENDED'''
 
* [[OpenBTS: Ubuntu Install OpenBTS 2.6 Clock 52MHz]] '''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: Konfigurasi]] '''RECOMMENDED'''
 
* [[OpenBTS: Kalibrasi]]
 
* [[OpenBTS: Kalibrasi]]
Line 99: Line 194:
 
* [[GNURadio: Install UHD]]
 
* [[GNURadio: Install UHD]]
 
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.3.0]]
 
* [[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 11.10 Instal GNURadio 3.4.2]] '''RECOMMENDED'''
* [[GNURadio: Ubuntu 12.04 Instal GNURadio 3.4.2]] ''NOT 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.0]] ''NOT RECOMMENDED''
 
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.5.3.2]] ''NOT RECOMMENDED''
 
* [[GNURadio: Ubuntu 11.10 Instal GNURadio 3.5.3.2]] ''NOT RECOMMENDED''
Line 106: Line 206:
 
* [[GNURadio: Ubuntu 11.10 Install dari GIT GNURadio]] ''NOT RECOMMENDED''
 
* [[GNURadio: Ubuntu 11.10 Install dari GIT GNURadio]] ''NOT RECOMMENDED''
 
* [[GNURadio: Ubuntu 11.10 cek USRP Daughter Board]]
 
* [[GNURadio: Ubuntu 11.10 cek USRP Daughter Board]]
* [[GNURadio: UHD]]
+
* [[GNURadio: UHD]] ''NOT RECOMMENDED''
* [[GNURadio: UHD Image]]
+
* [[GNURadio: UHD Image]] ''NOT RECOMMENDED''
 +
* [[GNURadio: UHD burn EEPROM RFX Board di USRP1]] ''NOT RECOMMENDED''
 
* [[GNURadio: UHD Identifikasi Device]]
 
* [[GNURadio: UHD Identifikasi Device]]
 
* [[OpenBTS: Ubuntu 11.10 Install]]
 
* [[OpenBTS: Ubuntu 11.10 Install]]
Line 113: Line 214:
 
* [[OpenBTS: 2.8 dari SVN Install]]
 
* [[OpenBTS: 2.8 dari SVN Install]]
 
* [[OpenBTS: 2.8 dari SVN Install Clock 52MHz]] '''RECOMMENDED'''
 
* [[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 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 Instalasi Real Time Asterisk]] '''RECOMMENDED'''
 +
* [[OpenBTS: 2.8 Menjalankan]] '''RECOMMENDED'''
 
* [[OpenBTS: 2.8 Konfigurasi]]
 
* [[OpenBTS: 2.8 Konfigurasi]]
 +
* [[OpenBTS: 2.8 Konfigurasi Cognitive Radio Elsabagh]]
 
* [[OpenBTS: 2.8 Konfigurasi Subscriber Registery]]
 
* [[OpenBTS: 2.8 Konfigurasi Subscriber Registery]]
 
* [[OpenBTS: Database SQLite]]
 
* [[OpenBTS: Database SQLite]]
 +
* [[OpenBTS: Set SQLite Subscriber Registry secara manual]]
 +
* [[OpenBTS: FreeSWITCH]]
  
 
===Multi OpenBTS 2.8===
 
===Multi OpenBTS 2.8===
  
* [[OpenBTS: Pola Multi OpenBTS]]
+
* [[OpenBTS: Pola Multi OpenBTS]] '''RECOMMENDED'''
 +
* [[Multi OpenBTS: Catatan Konfigurasi]] '''RECOMMENDED'''
  
 
===Ettus E110===
 
===Ettus E110===
  
 
* [[OpenBTS: E110 Cara Login]]
 
* [[OpenBTS: E110 Cara Login]]
* [[OpenBTS: E110 Install Image di MicroSD]]
+
* [[OpenBTS: E110 Install Image di MicroSD]] '''*RECOMMENDED*'''
 
* [[OpenBTS: E110 Cek Daughter Board]]
 
* [[OpenBTS: E110 Cek Daughter Board]]
 
* [[OpenBTS: E110 Mengubah Master Clock]]
 
* [[OpenBTS: E110 Mengubah Master Clock]]
 
* [[OpenBTS: E110 Kalibrasi Clock]]
 
* [[OpenBTS: E110 Kalibrasi Clock]]
 +
* [[OpenBTS: E110 Konfigurasi Jaringan]]
 
* [[OpenBTS: E110 Bekerja dengan opkg]]
 
* [[OpenBTS: E110 Bekerja dengan opkg]]
 +
* [[OpenBTS: E110 Instalasi iptables]]
 
* [[OpenBTS: E110 GNURadio]]
 
* [[OpenBTS: E110 GNURadio]]
* [[OpenBTS: E110 Install UHD Image]]
+
* [[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]]
 
* [[OpenBTS: E110 Instalasi OpenBTS 2.6]] ''NOT RECOMMENDED''
 
* [[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]]
 +
 +
===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===
 
===Lain Lain===
Line 164: Line 320:
 
* [[OpenBTS: Daftar Workshop atau Seminar yang pernah dilakukan]]
 
* [[OpenBTS: Daftar Workshop atau Seminar yang pernah dilakukan]]
 
* [[OpenBTS: Daftar Artikel di Media]]
 
* [[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: Wireless]]
 
[[Category: Selular]]
 
[[Category: Selular]]

Latest revision as of 18:40, 5 January 2014

Sumber: http://wush.net/trac/rangepublic/wiki/P2.8Differences


Catatan Real-Time Asterisk

Di OpenBTS 2.8, kita tidak lagi menggunakan SIP registry internal Asterisk sebagi pengganti HLR. Kita menggunakan komponen baru yang dinamakan subscriber registry, yang berbasis pada database sqlite3 di /var/lob/asterisk/sqlite3dir/sqlite3.db. Database ini berisi tabel SIP user registration dan call routing dalam konfigurasi realtime asterisk. Ada tiga implikasi penting:

  • OpenBTS tidak dapat lagi melakukan pertukaran SIP REGISTER secara langsung dengan Asterisk. Akan tetapi, SIP REGISTER methods akan dikirim ke server baru yang dinamakan sipauthserver, SIP interface dari subscriber registry.
  • OpenBTS handset tidak dapat lagi di provision oleh Asterisk melalui /etc/asterisk/sip.conf. AKan tetapi, OpenBTS handset harus di provision subscriber registry. Jika tidak, maka Asterisk tidak akan mengetahui IP address dari handset.
  • Konfigurasi dialplan sekarang menggunakan database lookup secara explisit melalui interface ODBC untuk melakukan call routing, contoh:
[phones]
; This is the context for handsets provisioned through the realtime database.
; This assumes that OpenBTS units all are running their SIP interfaces on port 5062.
exten => _N.,1,Set(Name=${ODBC_SQL(select dial from dialdata_table where exten = \"${EXTEN}\")})
exten => _N.,n,GotoIf($["${Name}" = ""] ?outbound-trunk,${EXTEN},1)
exten => _N.,n,Set(IPAddr=${ODBC_SQL(select ipaddr from sip_buddies where name = \"${Name}\")})
exten => _N.,n,GotoIf($["${IPAddr}" = ""] ?outbound-trunk,${EXTEN},1)
exten => _N.,n,Dial(SIP/${Name}@${IPAddr}:5062)


Beberapa SQLite database penting

Beberapa file SQLite database yang penting

/etc/OpenBTS/OpenBTS.db
/etc/OpenBTS/smqueue.db
/etc/OpenBTS/sipauthserve.db
/var/lib/asterisk/sqlite3dir/sqlite3.db

Edit Menggunakan SQLiteStudio

Download dari

http://sqlitestudio.pl/?act=download

Lakukan

chmod 777 sqlitestudio-2.1.4.bin

Jalankan menggunakan

./sqlitestudio-2.1.4.bin

Edit Menggunakan SQLite Database Browser

Langkah yang perlu dilakukan

Download dari http://sourceforge.net/projects/sqlitedbrowser/
sudo apt-get install libjpeg62
mkdir /usr/local/src/sqlitebrowser
mkdir /usr/local/src/sqlitebrowser
cp sqlitebrowser-linux.tar.gz /usr/local/src/sqlitebrowser/
cd /usr/local/src/sqlitebrowser/
tar zxvf sqlitebrowser-linux.tar.gz
  • Jalankan
sudo su
/usr/local/src/sqlitebrowser/sqlitestudio/sqlitestudio
Sqlitestudio1.png


Edit /etc/OpenBTS/OpenBTS.db

Sqlitestudio-openbtsdb1.png
Sqlitestudio-openbtsdb2.png


Edit /etc/OpenBTS/smqueue.db

Sqlitestudio-smqueue1.png
Sqlitestudio-smqueue2.png

Edit /etc/OpenBTS/sipauthserve.db

Sqlitestudio-sipauthserve1.png
Sqlitestudio-sipauthserve2.png

Edit /var/lib/asterisk/sqlite3dir/sqlite3.db

Sqlitestudio-subscriberregistry2.png
Sqlitestudio-subscriberregistry1.png
Sqlitestudio-subscriberregistry3.png
Sqlitestudio-subscriberregistry4.png

Test Query ke Subscriber Registry di SQLite Database Browser

Coba test apakah SQLite Database dapat memberikan responds yang benar, misalnya menggunakan perintah

select dial from dialdata_table where exten = 1111
select ipaddr from sip_buddies where name = IMSI510110301694405
select ipaddr from sip_buddies where callerid = 1111

Manajemen Subscriber Registry via Web

WARNING: Cara ini masih gagal total

Jika kita perhatikan baik-baik source code OpenBTS maka ada srmanager.cgi di

/usr/local/src/openbts/subscriberRegistry/trunk/srmanager.cgi

Ini dapat ditampilkan ke web dengan mengarahkan konfigurasi cgi-bin apache

Edit

vi /etc/apache2/sites-enabled/000-default 
ScriptAlias /cgi/ /usr/lib/cgi-bin/
<Directory "/usr/lib/cgi-bin">
      AllowOverride None
      Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
      Order allow,deny
      Allow from all
</Directory>

Buat link

cd /usr/lib/cgi-bin/
ln -s /usr/local/src/openbts/subscriberRegistry/trunk/srmanager.cgi



Pranala Menarik

Persiapan

Script


OpenBTS 2.6

OpenBTS 2.8

Multi OpenBTS 2.8

Ettus E110

Ettus N210

RangeNetworks

GPRS

Briker OpenBTS

FreeSWITCH OpenBTS

Power Amplifier

Lain Lain

Catatan Legal dan Pendukung

Catatan Sejarah

Dokumentasi Video

Perjuangan OpenBTS