Difference between revisions of "OpenBTS: Set SQLite Subscriber Registry secara manual"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| Line 7: | Line 7: | ||
sqlite> | sqlite> | ||
| − | Cek database | + | ==Cek database== |
.databases | .databases | ||
| Line 17: | Line 17: | ||
| − | Cek table | + | ==Cek table== |
.tables | .tables | ||
| Line 23: | Line 23: | ||
DIALDATA_TABLE RRLP SIP_BUDDIES rates | DIALDATA_TABLE RRLP SIP_BUDDIES rates | ||
| − | Cek isi table DIALDATA_TABLE | + | |
| + | ==Cek isi table DIALDATA_TABLE== | ||
select * from DIALDATA_TABLE; | select * from DIALDATA_TABLE; | ||
| Line 32: | Line 33: | ||
| − | Cek isi table SIP_BUDDIES | + | ==Cek isi table SIP_BUDDIES== |
select * from SIP_BUDDIES ; | select * from SIP_BUDDIES ; | ||
Revision as of 20:53, 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
Cek isi table SIP_BUDDIES
select * from SIP_BUDDIES ;
1|IMSI001010000000000|phones|allowed_not_screened|||||||dynamic|no|friend||||2100|0.0.0.0|info||||||||||||all|gsm||127.0.0.1|5062|IMSI001010000000000||||||||||1|no|no|no|no||no||yes|accept|1800|90|uas||||yes|500||120|||0||0||yes|no||||1|0|0|5ce5d6b846184773c5a070411204f864|972f8224|||0|0|1||0| 2|IMSI001010000000001|phones|allowed_not_screened|||||||dynamic|no|friend||||2001|0.0.0.0|info||||||||||||all|gsm||127.0.0.1|5062|IMSI001010000000001||||||||||1|no|no|no|no||no||yes|accept|1800|90|uas||||yes|500||120|||0||0||yes|no||||1|0|0|||2104076337d2c83cfae1669771cbc944||0|0|1||0| 3|IMSI001010000000002|phones|allowed_not_screened|||||||dynamic|no|friend||||2002|0.0.0.0|info||||||||||||all|gsm||127.0.0.1|5062|IMSI001010000000002||||||||||1|no|no|no|no||no||yes|accept|1800|90|uas||||yes|500||120|||0||0||yes|no||||1|0|0|||d7c1dd6599fd6d9737939032b1d6d918||0|0|1||0|