[asterisk-bugs] [JIRA] (ASTERISK-24634) cdr_adaptive_odbc fails to enter data in db

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-24634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton closed ASTERISK-24634.
-----------------------------------

    Resolution: Suspended

> cdr_adaptive_odbc fails to enter data in db
> -------------------------------------------
>
>                 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.6.0, 12.8.0
>         Environment: ubuntu 14.04
>            Reporter: Yuriy Gorlichenko
>            Assignee: Rusty Newton
>
> 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)