[asterisk-users] Is possible to install CDR-Viewer in Asterisk 11?

[Vitor Mazuco]

Hi everyone!

I'm trying to install a database using the asterisk-CDR-viewer. It
uses MySQL and I'm using Asterisk 11.I know that it needs to
synchronize with the ODBC database.

But I'm in trouble, it shows an error message will play when the
database "cdr_odbc.c: 163 odbc_log:. Unable to retrieve database
handle CDR failed."

See the full log

[/code]
cdr-teste*CLI> module reload res_odbc.so
    -- Reloading module 'res_odbc.so' (ODBC resource)
  == Parsing '/etc/asterisk/res_odbc.conf': Found
[Dec 14 10:44:03] NOTICE[1591]: res_odbc.c:1529 odbc_obj_connect:
Connecting asterisk
[Dec 14 10:44:03] NOTICE[1591]: res_odbc.c:1568 odbc_obj_connect:
res_odbc: Connected to asterisk [asterisk-connector]
[Dec 14 10:44:03] NOTICE[1591]: res_odbc.c:919 load_odbc_config:
Registered ODBC class 'asterisk' dsn->[asterisk-connector]
cdr-teste*CLI>
  == Using SIP RTP CoS mark 5
    -- Executing [2020 at ramais:1] Dial("SIP/2021-00000002",
"SIP/2020,60,tT") in new stack
  == Using SIP RTP CoS mark 5
    -- Called SIP/2020
    -- SIP/2020-00000003 is ringing
       > 0xb6e2f110 -- Probation passed - setting RTP source address
to 192.2.1.165:57040
[Dec 14 10:44:16] NOTICE[1593][C-00000001]: res_rtp_asterisk.c:4441
ast_rtp_read: Unknown RTP codec 95 received from '(null)'
    -- SIP/2020-00000003 answered SIP/2021-00000002
       > 0xb6e10210 -- Probation passed - setting RTP source address
to 192.2.1.60:8000
       > 0xb6e2f110 -- Probation passed - setting RTP source address
to 192.2.1.165:57040
[Dec 14 10:44:17] ERROR[1593][C-00000001]: cdr_odbc.c:163 odbc_log:
Unable to retrieve database handle.  CDR failed.
  == Spawn extension (ramais, 2020, 1) exited non-zero on 'SIP/2021-00000002'
[/code]

I don't know if can be the problem in my files of configuration

[code]/etc/asterisk/res_odbc.conf[/code]

[code]
[asterisk]
enabled => yes
dsn => asterisk-connector
username => root
password => 100567
pooling => no
limit => 1
pre-connect => yes
[/code]

And my [code]/etc/asterisk/cdr_odbc.conf[/code]

[code]
;
; cdr_odbc.conf
;
[global]
dsn=asterisk-connector
loguniqueid=yes
username=asterisk
password=100567
dispositionstring=yes
table=cdr               ;"cdr" is default table name
usegmtime=no             ; set to "yes" to log in GMT
hrtime=yes              ;Enables microsecond accuracy with the billsec
and duration fields
;newcdrcolumns=yes ; Enable logging of post-1.8 CDR columns
(peeraccount, linkedid, sequence)
~
[/code]

Can anyone tell me what is the problem?