no it is bytea. I also tried changing it to text but results are same. On Fri, Dec 26, 2014 at 1:21 PM, Bogdan-Andrei Iancu <[email protected]> wrote:
> 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 Developerhttp://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:[email protected]:9090$\ > x00sip:[email protected]:9090#\x00sip:[email protected]\x0e\x00192.168.3.1 > <http://x00sip:[email protected]:9090#%5Cx00sip:[email protected]%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 > [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
