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

From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs)
No edit summary
Onnowpurbo (talk | contribs)
No edit summary
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 13: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