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/
_______________________________________________________ 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/
