OpenBTS: 2.8 Edit User di sqlite3.db

Persiapan

• Instalasi SQLite Database Browser
• cek /var/lib/asterisk/sqlite3dir/sqlite3.db, pastikan ada

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

• sqlite3.db adalah database Subscriber pada OpenBTS 2.8

Memasukan User / HP baru ke sqlite3.db

Mapping IMSI HP ke Nomor Telepon

• Jalankan SQLite Database Browser

sudo su
/usr/local/src/sqlitebrowser/sqlitestudio/sqlitestudio

• Edit file database

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

• Tambahkan Subscriber yang baru pada tabel

dialdata_table
sip_buddies

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