Re: Variables disappeared in SQL CDR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Andrew,

I think I found the issue: Since GnuGk 4.9 misspelled placeholders are
not replaced. That way you have a chance to find them.

The unintended side effect was that some good placeholders like
%{connect-time} where the value is not available in direct mode would
also be left in.

That should be fixed now.

Regards,
Jan

-- 
Jan Willamowius, Founder of the GNU Gatekeeper Project
EMail  : jan@xxxxxxxxxxxxxx
Website: https://www.gnugk.org
Support: https://www.willamowius.com/gnugk-support.html

Relaxed Communications GmbH
Frahmredder 91, 22393 Hamburg, Germany
Geschäftsführer: Jan Willamowius
HRB 125261 (Amtsgericht Hamburg)
USt-IdNr: DE286003584


Andrew Herdman wrote:
> Hi Jan;
> 
> Here's a more detailed output;
> 
> Output from Log:
> 2019/03/14 12:14:02.723 5            osutils.cxx(2239)  PTLib   Created
> read/write mutex 0x7f2940036f98
> 2019/03/14 12:14:02.724 5              gksql.cxx(323)   SQLAcct Executing
> query: SELECT * FROM GKZ_SQL_CDR_START('GKZ001-DC01', '1', '0', '0', '0',
> '0', '-1', '0', '5c8a7d5500000002', 'RPD', '10.110.32.58', '90 a3 a4 6c b8
> 5f 02 1f 3e d6 57 44 2d 62 f3 b1', 'b0 a6 a4 6c b8 5f 02 1f 3e d6 57 44 2d
> 62 f3 b1', '', '2019-03-14 12:14:02', '%{alerting-time}',
> '%{connect-time}', '%{disconnect-time}', '0', '192.168.250.115', '3243',
> '10.110.34.172', '1045', 'AHRPD:h323_ID=8888:dialedDigits',
> '2:dialedDigits', '8888', '2', '2', '1640211315_GKZ001-DC01',
> '3495485836_GKZ001-DC01', '1', '0', '10.110.34.172', '', '15360', '0')
> 2019/03/14 12:14:02.747 3              gksql.cxx(122)   SQLAcct
> Disconnecting all SQL connections in pool
> 2019/03/14 12:14:02.749 2            sqlacct.cxx(222)   GKACCT  SQLAcct
> failed to store accounting data (event: 1, call: 1): (7) ERROR:  invalid
> value "%{al" for "YYYY"
> DETAIL:  Value must be an integer.
> CONTEXT:  PL/pgSQL function GKZ_sql_cdr_start(character
> varying,integer,integer,integer,integer,integer,integer,integer,character
> varying,character varying,character varying,character varying,character
> varying,character varying,character varying,character varying,character
> varying,character varying,integer,character varying,integer,character
> varying,integer,character varying,character varying,character
> varying,character varying,character varying,character varying,character
> varying,integer,integer,character varying,character
> varying,integer,character varying) line 18 at assignment
> 
> Configuration in gatekeeper.ini;
> 
> StartQuery=SELECT * FROM GKZ_SQL_CDR_START('%g', '%n', '%d', '%t', '%c',
> '%{cause-translated}', '%r', '%p', '%s', '%u', '%{gkip}', '%{CallId}',
> '%{ConfId}', '%{CallLink}', '%{setup-time}', '%{alerting-time}',
> '%{connect-time}', '%{disconnect-time}', '%{ring-time}', '%{caller-ip}',
> '%{caller-port}', '%{callee-ip}', '%{callee-port}', '%{src-info}',
> '%{dest-info}', '%{Calling-Station-Id}', '%{Called-Station-Id}',
> '%{Dialed-Number}', '%{caller-epid}', '%{callee-epid}', '%{call-attempts}',
> '%{last-cdr}', '%{media-oip}', '%{codec}', '%{bandwidth}',
> '%{client-auth-id}')
> 
> I also tried this with the 5.0.0 code (first attempt was tags/master), I
> wanted to go back further, but the github code won't compile earlier than
> 4.9, I think it's an openssl issue.
> 
> Gatekeeper(GNU) Version(5.0.0)
> Ext(amqp=0,curl=0,crypto/ssl=1,firebird=0,geoip=0,h235media=1,h46017=1,h46018=1,h46023=0,h46026=1,ipv6=1,large_fdset=16384,ldap=0,lua=0,mysql=0,odbc=0,pgsql=1,pthreads=1,radius=0,snmp=1,ssh=0,sqlite=0)
> H323Plus(1.27.0) PTLib(2.10.9) Build(Mar 14 2019, 11:52:23) Sys(Linux
> x86_64 4.9.0-3-amd64)
> Startup: Thu, 14 Mar 2019 12:12:05 -04:00   Running: 0 days 00:07:37
> 
> Andrew
> 
> 
> On Wed, Mar 13, 2019 at 2:15 PM Jan Willamowius via gnugk-users <
> gnugk-users@xxxxxxxxxxxxxxx> wrote:
> 
> > Hi,
> >
> > I can't confirm this bug so far. I'm using MySQL, not Postgres, but I
> > still see these variables being set and they aren't driver specific.
> >
> > Regards,
> > Jan
> >
> > --
> > Jan Willamowius, Founder of the GNU Gatekeeper Project
> > EMail  : jan@xxxxxxxxxxxxxx
> > Website: https://www.gnugk.org
> > Support: https://www.willamowius.com/gnugk-support.html
> >
> > Relaxed Communications GmbH
> > Frahmredder 91, 22393 Hamburg, Germany
> > Geschäftsführer: Jan Willamowius
> > HRB 125261 (Amtsgericht Hamburg)
> > USt-IdNr: DE286003584
> >
> >
> > Andrew Herdman wrote:  
> > > Updated a binary from 4.7.0 to 5.2.0 and the following variables are  
> > passed  
> > > with their variable names instead of numeric data... makes postgresql  
> > very  
> > > unhappy.
> > >
> > > Any ideas?  Config works fine with 4.7.0
> > >
> > >  '%{alerting-time}',
> > >  '%{connect-time}',
> > >  '%{disconnect-time}',  
_______________________________________________________

Posting: mailto:gnugk-users@xxxxxxxxxxxxxxx
Archive: https://lists.gnugk.org/pipermail/gnugk-users/
Unsubscribe: https://lists.gnugk.org/lists/listinfo/gnugk-users
Homepage: https://www.gnugk.org/




[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux