|
From: Kurtis H. <khe...@cs...> - 2012-05-16 21:06:12
|
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 > > |