[OpenSIPS-Devel] [opensips] Issue in storing Dialog Variables into the Postgres database (#398)

[johnnash13]

Version: OpenSIPS (1.12.0dev-notls (x86_64/linux))
Issue Description: when i run a select query on dialog table and try to see "vars" column contents (I set vars column data type as text for simplicity), I do not see all information stored. It seems to be truncated. I see like below ...
"accX_table#acc|accX_flags#5 DB_MISSED_FLAG DB_FLAG CDR_FLAG FAIL_TRANS_FLAG|accX_db# " (There is one special character at the end)
When i see dialog using mi fifo command I see full list of variables.
accX_table:: acc
accX_flags:: 5 DB_MISSED_FLAG DB_FLAG CDR_FLAG FAIL_TRANS_FLAG
accX_db:: \b\x00\x00\x00\x1d\x00sip:test at 192.168.7.5:9090$\x00sip:11111111 at 192.168.7.5:9090#\x00sip:110251111111 at 192.168.7.8\x0e\x00192.168.3.1?\x00\x00\n\x001419221825
accX_leg:: \x00\x00\x00\x00
accX_core:: \x06\x00INVITE \x0052a5e031f1fa4a50883cf14fcfb0dfb1"\x007C34DE52-54979B3E000CEDFB-4BCFC700 \x00e26faa1c7c654b1dbe6b1d86a12b2e61\x03\x00200\x02\x00OK\b\x00E\x9b\x97T\x00\x00\x00\x00
accX_created:: >\x9b\x97T\x00\x00\x00\x00
caller_IP:: 192.168.3.1
ring_time:: 1419221825

The issue seems be at the time of storing dialog var (Binary info) instead of just printing error and is verified using following observation..

1- I connected one call and let dialog created and then restarted opensips and again checked dialog variables (using opensipsctl) and found dialog variables gone (I could see the dialog other core values though)
2- When dialog is created I ran following queries
select position('accX_db'::bytea in vars) from dialog (To check position of "accX_db after that non-printable binary data is there")
select length(vars) from dialog (Checked total binary length)
and found there was only one byte after "accX_db" so I think it is not storing complete value.


---
Reply to this email directly or view it on GitHub:
https://github.com/OpenSIPS/opensips/issues/398
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20141224/c97a3476/attachment.htm>