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

From OnnoWiki
Jump to navigation Jump to search
Line 2: Line 2:
  
 
  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

Revision as of 20:46, 7 December 2013

Masuk ke Database SubscriberRegistry 

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
Retrieved from "https://onnocenter.or.id/wiki/index.php?title=OpenBTS:_Set_SQLite_Subscriber_Registry_secara_manual&oldid=38862"