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

Bogdan-Andrei Iancu bogdan at opensips.org
Fri Dec 26 08:51:02 CET 2014


Hi John,

I see you also open a ticket on this:
     https://github.com/OpenSIPS/opensips/issues/398

I suppose your dialog table does have a reasonable size constrain for 
the vars column, right ?

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 22.12.2014 09:27, John Nash wrote:
> 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 
> <http://x00sip:919811618189@192.168.7.5:9090#%5Cx00sip:11025919811618189@192.168.7.8%5Cx0e%5Cx00192.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
>
>
>
>
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20141226/9f2b492a/attachment.htm>


More information about the Users mailing list