Support #2360
Read CDR via CTRL interface in SGSN
100%
Description
How can you access per subscriber CDRs in the SGSN with either GETs or TRAPs(preferable)?
Related issues
History
#1 Updated by laforge 9 months ago
- Status changed from New to In Progress
- % Done changed from 0 to 40
The only capability related to CDR is the capability to write CDRs in CSV format. Related functionality is contained in http://git.osmocom.org/openbsc/tree/openbsc/src/gprs/sgsn_cdr.c which will write format like this:
"timestamp,imsi,imei,msisdn,cell_id,lac,hlr,event,pdp_duration,ggsn_addr,sgsn_addr,apni,eua_addr,vol_in,vol_out,charging_id\n"
- gprs attach
- routing area update
- gprs detach
- release of mm context
- PDP context activation
- PDP context deactivation
- PDP context termination
- PDP context release
- periodically with a configurable timer ("cdr interval <1-2147483647>")
The internal statistics counters for per-MM-context and per-PDP-context in/out bytes and packets should be readable via the CTRL interface, but this is currenrly broken due to bad choice of naming, see #2362
#4 Updated by laforge 9 months ago
laforge wrote:
The only capability related to CDR is the capability to write CDRs in CSV format. Related functionality is contained in http://git.osmocom.org/openbsc/tree/openbsc/src/gprs/sgsn_cdr.c which will write format like this:
"timestamp,imsi,imei,msisdn,cell_id,lac,hlr,event,pdp_duration,ggsn_addr,sgsn_addr,apni,eua_addr,vol_in,vol_out,charging_id\n"
Please also see chapter 9.4 of http://ftp.osmocom.org/docs/latest/osmosgsn-usermanual.pdf describing this feature.
#5 Updated by laforge 8 months ago
- Status changed from In Progress to Feedback
- Assignee changed from laforge to oramadan
How do we proceed here?
We have the existing CSV format support as described above. It would be relatively easy to add TRAPs in similar fashion, i.e. send the CSV line as a trap (rathe than a file write). But are the existing/stated triggers
gprs attach routing area update gprs detach release of mm context PDP context activation PDP context deactivation PDP context termination PDP context release periodically with a configurable timer ("cdr interval <1-2147483647>")
sufficient?
#13 Updated by pespin 5 months ago
- Status changed from In Progress to Feedback
- % Done changed from 40 to 90
Implemented in:
remote: https://gerrit.osmocom.org/5086 sgsn_cdr: Split log formatting into a snprintf function remote: https://gerrit.osmocom.org/5087 Add vty cmd 'cdr trap' to send CDR through CTRL iface
Waiting for review.
#15 Updated by pespin 5 months ago
- Status changed from In Progress to Feedback
Documentation submitted in gerrit:
remote: New Changes: remote: https://gerrit.osmocom.org/5113 OsmoSGSN: configuration: Move pdp ctx specific CDR fields to its own table remote: https://gerrit.osmocom.org/5114 OsmoSGSN: configuration: Add missing pdp-periodic event remote: https://gerrit.osmocom.org/5115 OsmoSGSN: configuration: Document CDR CTRL interface