Aterisk CDR Adaptive with ODBC not output cdr

Trying to enable Asterisk CDR Adptive module with ODBC, but not generating that in the adaptive table, CDR normal it’s working well.

No errors, no logs in the MySQL DB.

This is my settings:
Ubuntu 20.04 LTS in cloud
Asterisk 18.2.0
MySQL 8

cdr_adptive.conf:
[cdr_adaptative]
connection=asterisk
table=calls
schema=control ; for databases which support schemas
usegmtime=yes ; defaults to no
alias customer_id => customer_id ;customer_id
alias did_id => did_id ;did_id
alias uuid => uniqueid
alias linkedid_uuid => linkedid
alias io => io ;io
alias type => type ;type
alias start => calldate
alias source => src
alias destination => dst
alias duration => duration
alias billsec => billsec
alias queued => queued ;queued
alias charged => charged ;charged
alias created_at => calldate ;created_at

Database control and table calls already created and ok, no errors registered

Asterisk commands return:
asterisk> odbc show all
ODBC DSN Settings

Name: asterisk
DSN: asterisk-connector
Number of active connections: 1 (out of 1)
Logging: Enabled
Number of prepares executed: 888
Number of queries executed: 898

asterisk> module reload cdr_adaptive_odbc.so
Module ‘cdr_adaptive_odbc.so’ reloaded successfully.
– Reloading module ‘cdr_adaptive_odbc.so’ (Adaptive ODBC CDR backend)
– Found adaptive CDR table calls@asterisk.

How I said CDR table base it’s working well, the issue is for second table data output (control.calls).

Can anyone help?

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.