[asterisk-bugs] [JIRA] (ASTERISK-24634) cdr_adaptive_odbc

[Yuriy Gorlichenko (JIRA)]

Yuriy Gorlichenko created ASTERISK-24634:
--------------------------------------------

             Summary: cdr_adaptive_odbc
                 Key: ASTERISK-24634
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24634
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: CDR/cdr_adaptive_odbc
    Affects Versions: 12.8.0, 12.6.0
         Environment: ubuntu 14.04
            Reporter: Yuriy Gorlichenko


Hello! I already wrote at irc about problem with cdr_adaptive_odbc connection to database. This issue still lives at my instanses 12.6.0 and 12.8.0-rc2:
When I do core reload cdr_adaptive_odbc sucessfully reads by parcer but no colums printed. And when I try to call- no entries to save cdr to database. But it not aconnection to database problem because if I change alias start parameter at cdr_adaptive_odbc file to id - I see error about dublicate entry.

Connection to the database works fine because I use realtime dialplan to rhe same database.

my odbc.ini
[asterisk-connector]

Driver = MySQL
Database = production
Server = 127.0.0.1
Port = 3213
Username = cdbun
Password = cdbpass

Socket = /run/mysqld/mysqld.sock

cdr_adaptive_odbc.conf

[production]
connection=production
table=asterisk_db_cdr
alias start => calldate



cdr set debug on

0x351be38 - Processing Dial End message for channel SIP/kamailio1-0000000d, peer SIP/peer1-0000000e
0x351be38 - Transitioning CDR for SIP/kamailio1-0000000d from state Dial to DialedPending
0x351be38 - Set answered time to 1419221504.112213
    -- Channel SIP/kamailio1-0000000d joined 'simple_bridge' basic-bridge <c9511b08-68ed-413b-acf1-9ac412d691ef>
Bridge Enter message for channel SIP/kamailio1-0000000d: 1419221504.00113051
0x351be38 - Updating Party A SIP/kamailio1-0000000d snapshot
0x351be38 - Processing bridge enter for SIP/kamailio1-0000000d
0x351be38 - Transitioning CDR for SIP/kamailio1-0000000d from state DialedPending to Dial
0x351be38 - Transitioning CDR for SIP/kamailio1-0000000d from state Dial to Bridged
    -- Channel SIP/peer1-0000000e joined 'simple_bridge' basic-bridge <c9511b08-68ed-413b-acf1-9ac412d691ef>
Bridge Enter message for channel SIP/peer1-0000000e: 1419221504.00113660
0x33d0e98 - Updating Party A SIP/peer1-0000000e snapshot
0x33d0e98 - Processing bridge enter for SIP/peer1-0000000e
0x33d0e98 - Transitioning CDR for SIP/peer1-0000000e from state Single to Bridged
0x351be38 - Party A SIP/kamailio1-0000000d has new Party B SIP/peer1-0000000e

    -- Channel SIP/peer1-0000000e left 'simple_bridge' basic-bridge <c9511b08-68ed-413b-acf1-9ac412d691ef>
Bridge Leave message for SIP/peer1-0000000e: 1419221506.00272169
0x33d0e98 - Processing Bridge Leave for SIP/peer1-0000000e
0x33d0e98 - Transitioning CDR for SIP/peer1-0000000e from state Bridged to Finalized
    -- Channel SIP/kamailio1-0000000d left 'simple_bridge' basic-bridge <c9511b08-68ed-413b-acf1-9ac412d691ef>
Bridge Leave message for SIP/kamailio1-0000000d: 1419221506.00272261
0x351be38 - Processing Bridge Leave for SIP/kamailio1-0000000d
0x351be38 - Transitioning CDR for SIP/kamailio1-0000000d from state Bridged to Finalized
  == Spawn extension (external.dial, 123456789, 16) exited non-zero on 'SIP/kamailio1-0000000d'
    -- Executing [h at external.dial:1] Hangup("SIP/kamailio1-0000000d", "") in new stack
  == Spawn extension (external.dial, h, 1) exited non-zero on 'SIP/kamailio1-0000000d'
0x351be38 - Beginning finalize/dispatch for SIP/kamailio1-0000000d
0x351be38 - Dispatching CDR for Party A SIP/kamailio1-0000000d, Party B SIP/peer1-0000000e
0x33d0e98 - Beginning finalize/dispatch for SIP/peer1-0000000e
0x33d0e98 - Dispatching CDR for Party A SIP/peer1-0000000e, Party B <none>



--
This message was sent by Atlassian JIRA
(v6.2#6252)