I would have looked into code by now but its taking me a while to go through it as I recently started studying it. I thought of posting in case its some know issue.
On Tue, Dec 23, 2014 at 5:27 PM, John Nash <john.nash...@gmail.com> wrote: > I think the issue is somewhere in storing these values into the postgres > DB (Not checked with mysql) because .... > > 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. > > BTW my version is Server:: OpenSIPS (1.12.0dev-notls (x86_64/linux)) > > > > > > > > On Tue, Dec 23, 2014 at 5:19 PM, Răzvan Crainea <raz...@opensips.org> > wrote: > >> Hi, Josh! >> >> Most likely it is a printing problem. The dialog variables are stored in >> the DB as binary/non-printable data. That's why you can't see them properly >> when doing a select. >> >> Best regards, >> >> Răzvan Crainea >> OpenSIPS Solutionswww.opensips-solutions.com >> >> On 12/23/2014 01:08 PM, 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 >> <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>:9090$\ >> x00sip:1111111111 at 192.168.7.5 >> <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>:9090#\x00sip:11025111111111 >> at 192.168.7.8 >> <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>\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 >> >> >> >> _______________________________________________ >> Devel mailing >> listDevel@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/devel >> >> >> >> _______________________________________________ >> Devel mailing list >> Devel@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel >> >> >
_______________________________________________ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel