[OpenSIPS-Users] Issue in storing Dialog Variables into the Database (Postgresql)

John Nash john.nash778 at gmail.com
Mon Dec 22 08:27:52 CET 2014


I am using Opensips with dialog module and using DB as Postgresql. I am
using modparam("dialog", "db_mode", 1). At the time of dialog creation I am
also setting values to some dialog variables which I can see with mi fifo
commands.

My issue is when i run a select query 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 some special character at the end)

On the other hand 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:919811618189 at 192.168.7.5:9090#\x00sip:11025919811618189 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

Somehow values after accX_db are not being stored into the DB.

Any ideas?

John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20141222/671fc711/attachment.htm>


More information about the Users mailing list