Re: [Openbts-discuss] Query Subscriber DB

[Kurtis H. <khe...@cs...>]

It's a field in SIP_BUDDIES

On Wed, May 16, 2012 at 2:00 PM, Joel Parker <joe...@ya...> wrote:
> I have the IMEI turned on in the openBTS config database but do not know
> where the Subscriber registry is.
>
> --  Joel
>
> ________________________________
> From: Kurtis Heimerl <khe...@cs...>
> To: Joel Parker <joe...@ya...>
> Cc: Michael Gulley <Mic...@kr...>;
> "ope...@li..."
> <ope...@li...>
> Sent: Wednesday, May 16, 2012 3:48 PM
>
> Subject: Re: [Openbts-discuss] Query Subscriber DB
>
> Its in the subscriber registry, but you need to turn on the recording
> of the IMEI in OpenBTS's configuration database.
>
> On Wed, May 16, 2012 at 1:45 PM, Joel Parker <joe...@ya...> wrote:
>> So where is the subscriber registry or what table can I find the IMEI in ?
>>
>> -- Joel
>>
>> ________________________________
>> From: Michael Gulley <Mic...@kr...>
>> To: Joel Parker <joe...@ya...>; Kurtis Heimerl
>> <khe...@cs...>; "ope...@li..."
>> <ope...@li...>
>> Sent: Wednesday, May 16, 2012 3:24 PM
>>
>> Subject: Re: [Openbts-discuss] Query Subscriber DB
>>
>> correct.
>>
>> I've only seen the IMEI by looking in the subscriber registry.  And then
>> it
>> is not always there.  Sometimes it shows "NULL" for the IMEI.
>>
>> Seems like you have to make a phone call first before the IMEI field gets
>> populated, but my database may be getting confused becasue I am swapping
>> SIM
>> cards in and out of various handsets.
>> ________________________________________
>> From: Joel Parker [joe...@ya...]
>> Sent: Wednesday, May 16, 2012 3:13 PM
>> To: Kurtis Heimerl; ope...@li...
>> Subject: Re: [Openbts-discuss] Query Subscriber DB
>>
>> Yes, but that doesn't show me the corresponding IMEI will it ?
>>
>> ________________________________
>> From: Kurtis Heimerl <khe...@cs...>
>> To: Joel Parker <joe...@ya...>;
>> ope...@li...
>> Sent: Wednesday, May 16, 2012 3:08 PM
>> Subject: Re: [Openbts-discuss] Query Subscriber DB
>>
>> Just look into the tmsis table form the OpenBTS command line. The
>> command is "tmsis"
>>
>> On Wed, May 16, 2012 at 1:06 PM, Joel Parker
>> <joe...@ya...<mailto:joe...@ya...>> wrote:
>>> I want to match up the IMSI and IMEI of my test phones and TIMSI to send
>>> test messages / calls.
>>>
>>> -- Joel
>>>
>>> ________________________________
>>> From: Kurtis Heimerl
>>> <khe...@cs...<mailto:khe...@cs...>>
>>> To: Joel Parker <joe...@ya...<mailto:joe...@ya...>>;
>>>
>>>
>>> ope...@li...<mailto:ope...@li...>
>>> Sent: Wednesday, May 16, 2012 3:04 PM
>>>
>>> Subject: Re: [Openbts-discuss] Query Subscriber DB
>>>
>>> SIP_BUDDIES holds the IMSI->Number mappings.
>>>
>>> What data are you looking for, exactly?
>>>
>>> On Wed, May 16, 2012 at 1:02 PM, Joel Parker
>>> <joe...@ya...<mailto:joe...@ya...>> wrote:
>>>> That only has the following tables :
>>>>
>>>> sqlite> .tables
>>>> RRLP            SIP_BUDDIES    dialdata_table
>>>>
>>>> I am looking for IMSI, TMSI, etc.
>>>>
>>>> ________________________________
>>>> From: Kurtis Heimerl
>>>> <khe...@cs...<mailto:khe...@cs...>>
>>>> To: Joel Parker <joe...@ya...<mailto:joe...@ya...>>
>>>> Sent: Wednesday, May 16, 2012 2:56 PM
>>>>
>>>> Subject: Re: [Openbts-discuss] Query Subscriber DB
>>>>
>>>> It's usually in /var/lib/asterisk/sqlite3db/sqlite3.db, though it's
>>>> configurable (in OpenBTS.db) to be anywhere. Look for subscriber
>>>> registry in that db.
>>>>
>>>> On Wed, May 16, 2012 at 12:52 PM, Joel Parker
>>>> <joe...@ya...<mailto:joe...@ya...>>
>>>> wrote:
>>>>> do you know what the subscribers db name is ? I tried OpenBTS.db and
>>>>> sipauthserve.db but both were config db's ?
>>>>>
>>>>> ________________________________
>>>>> From: Kurtis Heimerl
>>>>> <khe...@cs...<mailto:khe...@cs...>>
>>>>> To: Joel Parker <joe...@ya...<mailto:joe...@ya...>>
>>>>> Cc: Michael Gulley
>>>>>
>>>>> <Mic...@kr...<mailto:Mic...@kr...>>;
>>>>>
>>>>>
>>>>> "ope...@li...<mailto:ope...@li...>"
>>>>>
>>>>>
>>>>> <ope...@li...<mailto:ope...@li...>>
>>>>> Sent: Wednesday, May 16, 2012 2:44 PM
>>>>>
>>>>> Subject: Re: [Openbts-discuss] Query Subscriber DB
>>>>>
>>>>> Sqlite3 needs to be directed to a specific database file.
>>>>>
>>>>> On Wed, May 16, 2012 at 12:37 PM, Joel Parker
>>>>> <joe...@ya...<mailto:joe...@ya...>>
>>>>> wrote:
>>>>>> So on the device, I start the sqlite3 cli client and type .databases
>>>>>> but
>>>>>> it
>>>>>> doesn't show anything even though it has subscribers ?
>>>>>>
>>>>>> sqlite> .databases
>>>>>> seq  name
>>>>>> file
>>>>>> ---  ---------------
>>>>>> ----------------------------------------------------------
>>>>>> 0    main
>>>>>>
>>>>>> I normally use mysql so sqlite is a bit different for me, so maybe I
>>>>>> am
>>>>>> doing something wrong.
>>>>>>
>>>>>> -- Joel
>>>>>>
>>>>>> ________________________________
>>>>>> From: Kurtis Heimerl
>>>>>> <khe...@cs...<mailto:khe...@cs...>>
>>>>>> To: Michael Gulley
>>>>>>
>>>>>> <Mic...@kr...<mailto:Mic...@kr...>>
>>>>>> Cc: Joel Parker
>>>>>> <joe...@ya...<mailto:joe...@ya...>>;
>>>>>>
>>>>>>
>>>>>> "ope...@li...<mailto:ope...@li...>"
>>>>>>
>>>>>>
>>>>>> <ope...@li...<mailto:ope...@li...>>
>>>>>> Sent: Wednesday, May 16, 2012 2:32 PM
>>>>>> Subject: Re: [Openbts-discuss] Query Subscriber DB
>>>>>>
>>>>>> This only works if you've installed that cgi script.
>>>>>>
>>>>>> The database itself is just an sqlite3 DB, you can query it using any
>>>>>> sqlite3 query tool.
>>>>>>
>>>>>> On Wed, May 16, 2012 at 12:23 PM, Michael Gulley
>>>>>>
>>>>>>
>>>>>> <Mic...@kr...<mailto:Mic...@kr...>>
>>>>>> wrote:
>>>>>>> visit this URL from a connected browser:
>>>>>>>
>>>>>>> http://192.168.0.21/cgi/srmanager.cgi
>>>>>>>
>>>>>>> your IP address may not be the same as mine, but this CGI script lets
>>>>>>> you
>>>>>>> interact with the subscriber registry.
>>>>>>>
>>>>>>>
>>>>>>> ________________________________________
>>>>>>> From: Joel Parker
>>>>>>> [joe...@ya...<mailto:joe...@ya...>]
>>>>>>> Sent: Wednesday, May 16, 2012 2:14 PM
>>>>>>> To:
>>>>>>>
>>>>>>> ope...@li...<mailto:ope...@li...>
>>>>>>> Subject: [Openbts-discuss] Query Subscriber DB
>>>>>>>
>>>>>>> Is it possible to query the Subscriber DB ? I want to make sure the
>>>>>>> registered handsets match my test handsets.
>>>>>>> ***NOTICE*** This e-mail and/or the attached documents may contain
>>>>>>> technical data within the definition of the International Traffic
>>>>>>> in Arms Regulations and/or Export Administration Regulations, and
>>>>>>> are subject to the export control laws of the U.S. Government.
>>>>>>> Transfer of this data by any means to a foreign person, whether in
>>>>>>> the United States or abroad, without an export license or other
>>>>>>> approval from the U.S. Department of State or Commerce, as
>>>>>>> applicable, is prohibited. No portion of this e-mail or its
>>>>>>> attachment(s) may be reproduced without written consent of Kratos
>>>>>>> Defense & Security Solutions, Inc. Any views expressed in this
>>>>>>> message are those of the individual sender, except where the
>>>>>>> message states otherwise and the sender is authorized to state them
>>>>>>> to be the views of any such entity. The information contained in
>>>>>>> this message and or attachments is intended only for the person or
>>>>>>> entity to which it is addressed and may contain confidential and/or
>>>>>>> privileged material. If you are not the intended recipient or
>>>>>>> believe that you may have received this document in error, please
>>>>>>> notify the sender and delete this e-mail and any attachments
>>>>>>> immediately.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------
>>>>>>> Live Security Virtual Conference
>>>>>>> Exclusive live event will cover all the ways today's security and
>>>>>>> threat landscape has changed and how IT managers can respond.
>>>>>>> Discussions
>>>>>>> will include endpoint security, mobile security and the latest in
>>>>>>> malware
>>>>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>>>>>> _______________________________________________
>>>>>>> Openbts-discuss mailing list
>>>>>>>
>>>>>>>
>>>>>>> Ope...@li...<mailto:Ope...@li...>
>>>>>>> https://lists.sourceforge.net/lists/listinfo/openbts-discuss
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Openbts-discuss mailing list
>>
>> Ope...@li...<mailto:Ope...@li...>
>> https://lists.sourceforge.net/lists/listinfo/openbts-discuss
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Openbts-discuss mailing list
>> Ope...@li...
>> https://lists.sourceforge.net/lists/listinfo/openbts-discuss
>>
>>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Openbts-discuss mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openbts-discuss
>
>