Am 18.06.2012 21:49, schrieb James Sharp:
On 6/18/2012 11:52 AM, Thorsten Göllner wrote:
Hi,

I am trying now for over 4 hours setting up cdr-logging via odbc into a
mysql database. But with no success. Do you have any hint for me?


*SNIP*

But after a call hangup I get the following error:
cdr_odbc.c: Unable to retrieve database handle. CDR failed.

What is going wrong here, please?

The DSN that you specify in cdr_odbc.con should be the DSN you configured in res_odbc.conf, in this case "mysql" versus "MySQL-asterisk".

I beat head against the desk for hours because of this same issue.

This solved the problem. The CDR is written to the mysql database. Thanks. It would never have occurred to me.

BUT the cli command "odbc show all" still shows and "uninitialized" last connection attempt. Never mind?

CLI> odbc show all

ODBC DSN Settings
-----------------

  Name:   mysql
  DSN:    MySQL-asterisk
    Last connection attempt: 1970-01-01 01:00:00
  Pooled: No
  Connected: Yes


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to