-
-
Notifications
You must be signed in to change notification settings - Fork 102
P-Charging-Vector error inserting in database #556
Description
When I enable the CustomHeader module for P-Charging Vector, a syntax error occurs during insertion into the database. The SIP P-Charging-Vector field looks like this: P-Charging-Vector: icid-value="sp-cen-pcscf02.1b3.bbd5.20240911010144".
root@SPOCEN-HOMER-AGENT1:/var/log/postgresql# tail -n 10 postgresql-16-main.log
2024-09-10 21:25:55.328 -03 [323583] homer_user@homer_data ERRO: sintaxe de entrada inválida para o tipo de dados json
2024-09-10 21:25:55.328 -03 [323583] homer_user@homer_data DETALHE: O elemento "sp" não é válido.
2024-09-10 21:25:55.328 -03 [323583] homer_user@homer_data CONTEXTO: dado JSON, linha 1: ...ser_agent":"","P-Charging-Vector":"icid-value="sp...
COPY hep_proto_1_call, linha 2, coluna data_header: "{"ruri_user":"","ruri_domain":"","from_user":"+55","from_tag":"tC12wFyACK","to_user":"015..."
2024-09-10 21:25:55.328 -03 [323583] homer_user@homer_data INSTRUÇÂO: COPY hep_proto_1_call(sid,create_date,protocol_header,data_header,raw) FROM STDIN
2024-09-10 21:25:55.334 -03 [323585] homer_user@homer_data ERRO: sintaxe de entrada inválida para o tipo de dados json
2024-09-10 21:25:55.334 -03 [323585] homer_user@homer_data DETALHE: O elemento "sp" não é válido.
HEPAddr = "0.0.0.0:9060"
HEPTCPAddr = "0.0.0.0:9060"
HEPTLSAddr = "0.0.0.0:9061"
HEPWSAddr = "0.0.0.0:3000"
ESAddr = ""
ESDiscovery = true
LokiURL = ""
LokiBulk = 200
LokiTimer = 4
LokiBuffer = 100000
LokiHEPFilter = [1,5,100]
LokiAllowOutOfOrder = false
ForceHEPPayload = []
PromAddr = "0.0.0.0:9096"
PromTargetIP = ""
PromTargetName = ""
DBShema = "homer7"
DBDriver = "postgres"
DBAddr = "localhost:5432"
DBUser = "homer_user"
DBPass = "mXeiiqHdz8Y6qkMMlpy8gYamBQ"
DBDataTable = "homer_data"
DBConfTable = "homer_config"
DBBulk = 150000
DBTimer = 4
DBBuffer = 2999999999
DBWorker = 8
DBRotate = true
DBPartLog = "24h"
DBPartSip = "24h"
DBPartQos = "24h"
DBDropDays = 0
DBDropDaysCall = 0
DBDropDaysRegister = 0
DBDropDaysDefault = 0
DBDropOnStart = false
DBUsageProtection = false
DBUsageScheme = "percentage"
DBPercentageUsage = "80%"
DBMaxSize = "30MB"
Dedup = false
DiscardMethod = []
AlegIDs = ["P-Charging-Vector"]
CustomHeader = ["P-Charging-Vector"]**
SIPHeader = []
LogDbg = ""
LogLvl = "info"
LogStd = false
LogSys = false
Config = "./heplify-server.toml"
ConfigHTTPAddr = ""