[Gsmmap] A4 parameter query in catcher_analysis.sql

[Seyed Mostafa Farmanbar]

Hi,

I am trying to trigger A4 parameter of snoopsnitch with openbts software. I
am configuring the openbts for this but no alarm is produced for A4.I check
the cell_info table. I find ‘rat’ field is null. Although the ‘rat’ field
in session-info table isn’t null and have true value. Then I check the
cell-info.c code. I see that c->rat isn’t assigned in this code. I changed
the A4 parameter query in catcher_analysis.sql:


CREATE VIEW a4 as
SELECT
        l.id,
        l.mcc,
        l.mnc,
        l.lac,
        l.cid,
        count(*) AS value,
        CASE WHEN count(*) > 1 THEN 1 ELSE 0 END AS score
FROM cell_info AS l LEFT JOIN cell_info AS r
ON
        l.mcc = r.mcc AND
        l.mnc = r.mnc AND
        l.lac = r.lac AND
        l.cid = r.cid AND
        --l.rat = r.rat AND
        l.bcch_arfcn != r.bcch_arfcn AND
        l.first_seen < r.first_seen
WHERE
        l.mcc > 0 AND
        l.lac > 0 AND
        l.cid > 0 AND
        --r.bcch_arfcn != null
        r.bcch_arfcn is not null
GROUP BY l.mcc, l.mnc, l.lac, l.cid;


 This is worked for me. There are two questions here. 1) Why ‘rat’ in
cell-info table is null? And where  is it going to be set. 2)  Has anyone
been able to trigger this parameter with the main catcher_analysis.sql ?


Thank in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.srlabs.de/pipermail/gsmmap/attachments/20190122/3d1e36d8/attachment.html>