Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000411 [Yate - Yet Another Telephony Engine] module major always 2016-03-05 13:48 2016-03-09 14:09
Reporter asymetrixs View Status public  
Assigned To
Priority normal Resolution open  
Status new   Product Version 4.x
Summary 0000411: pgsqldb module cannot be used with dbwave
Description Trying to save a recorded message in PostgreSQL always fails because of connection encoding. Setting encoding=utf8 in pgsqldb.conf does not solve the problem.
Additional Information Yate Message:
SENDING TO YATE: %%>message:6248f90dadc34a72aadf7cf77ed8c044:1457120646:chan.masquerade::message=chan.attach:id=dumb/2:consumer=dbwave/record/75069263b40e46bebd90f27f1101c328.slin:single=true:consumer_account=dbrec:consumer_query=INSERT INTO ivr_record(ivr, caller, data) VALUES ('IVRVoiceMailWorker', 'test_ivr2', E'${data}');:
%%<message:6248f90dadc34a72aadf7cf77ed8c044:true:chan.attach::id=dumb/2:single=true:consumer_account=dbrec:consumer_query=INSERT INTO ivr_record(ivr, caller, data) VALUES ('IVRVoiceMailWorker', 'test_ivr2', E'${data}');:handlers=analyzer%z10,callfork%z10,conf%z10,dumb%z10,dbwave%z90,analyzer%z100,tonedetect%z100,pbx%z100,filetransfer%z100,wave%z100:module=dumb:status=outgoing:targetid=sip/2:billid=1457116514-2:peerid=sip/2:lastpeerid=sip/2:answered=false:direction=outgoing

Table to save in:
CREATE TABLE ivr_record
  id serial NOT NULL,
  ivr text NOT NULL,
  caller text NOT NULL,
  deleted boolean NOT NULL DEFAULT false,
  created timestamp without time zone NOT NULL DEFAULT now(),
  data2 text,
  data bytea,
  data3 bytea[],
  CONSTRAINT ivr_record_pkey PRIMARY KEY (id)
-> data/data2/data3 were just for testing purposes, problem is always the same

PostgreSQL Log:
2016-03-04 20:10:25 UTC ERROR: invalid byte sequence for encoding "UTF8": 0xf8

Yate Log:
2016-03-04_21:10:25.172234 <pgsqldb:WARN> Query 'INSERT INTO ivr_record(ivr, caller, data2) VALUES ('IVRVoiceMailWorker', 'test_ivr2', encode('\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0??\0\0\0\0\0\0\0\0??\0\0\0\0\0\0\0\0?? <...and many more....>
2016-03-04_21:10:25.172234 <pgsqldb:ALL> Query for 'dbrec.1' returned 0 rows, 0 affected [02564248]
Tags No tags attached.
Attached Files

- Relationships

-  Notes
vir (reporter)
2016-03-09 14:09

Here is Postgresql's format for binary data: [^]

- Issue History
Date Modified Username Field Change
2016-03-05 13:48 asymetrixs New Issue
2016-03-09 14:09 vir Note Added: 0000610

Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker