OpenBTS: 2.8 Edit User di sqlite3.db: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
← Older editNewer edit →
Onnowpurbo (talk | contribs)
69,477 edits
Onnowpurbo (talk | contribs)
69,477 edits
Onnowpurbo (talk | contribs)
69,477 edits
Line 30: Line 30:


* [[OpenBTS]]
* [[OpenBTS]]
* [[OpenBTS: Arsitektur secara umum]]


===Persiapan===
===Persiapan===
Line 41: Line 42:
* [[USRP: Rangkaian Board USRP]]
* [[USRP: Rangkaian Board USRP]]
* [[OpenBTS: Tethr untuk Bencana Alam]]
* [[OpenBTS: Tethr untuk Bencana Alam]]
* [[USRP: Tip Pemesanan]]


===OpenBTS 2.6===
===OpenBTS 2.6===
Line 49: Line 51:
* [[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 55: Line 58:
* [[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 75: Line 79:
* [[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]] '''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 82: Line 91:
* [[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 89: Line 99:
* [[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: 2.8 Edit User di sqlite3.db]] '''RECOMMEND'''
* [[OpenBTS: Yate Softswitch]]
* [[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: Yate Config Test]]
* [[OpenBTS: 2.8 Instalasi Real Time Asterisk]] '''RECOMMENDED'''
* [[OpenBTS: 2.8 Instalasi Real Time Asterisk]] '''RECOMMENDED'''
Line 100: Line 115:
===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 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]]
===GPRS===
* [[OpenBTS: GPRS]]


===Power Amplifier===
===Power Amplifier===
Line 120: Line 156:
* [[Power Amplifier 900MHz]]
* [[Power Amplifier 900MHz]]
* [[Duplexer]]
* [[Duplexer]]
* [[OpenBTS: Menaikan Jangkauan OpenBTS]]


===Lain Lain===
===Lain Lain===
Line 150: Line 187:
* [[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]]


===Dokumentasi Video===
===Dokumentasi Video===


* http://www.metrotvnews.com/read/newsprograms/2012/10/14/14624/212/Teknologi-BTS
* http://youtu.be/8ogOcUSpINU (1/6)
* http://youtu.be/8ogOcUSpINU (1/6)
* http://youtu.be/F5d7HGuhppk (2/6)
* http://youtu.be/F5d7HGuhppk (2/6)

Revision as of 00:16, 22 August 2013

Persiapan 

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

Persiapan

OpenBTS 2.6

OpenBTS 2.8

Multi OpenBTS 2.8

Ettus E110

Ettus N210

GPRS

Power Amplifier

Lain Lain

Catatan Sejarah

Dokumentasi Video

Retrieved from "https://lms.onnocenter.or.id/wiki/index.php?title=OpenBTS:_2.8_Edit_User_di_sqlite3.db&oldid=38108"