[asterisk-users] cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.
Joshua C. Colp
jcolp at digium.com
Fri Dec 7 08:08:08 CST 2018
On Fri, Dec 7, 2018, at 9:54 AM, hw wrote:
> On 12/07/2018 02:25 PM, Joshua C. Colp wrote:
> > On Fri, Dec 7, 2018, at 9:19 AM, hw wrote:
> >> Hi,
> >> is cdr logging using odbc buggy? I'im only getting an error
> >> "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.".
> >> Connecting with isql to the datasource given in cdr_odbc.conf works just
> >> fine, and using the database for sippeers also works.
> > This message is output when the "dsn" value provided in cdr_odbc.conf does not match a dsn/class (context name) configured in res_odbc.conf
> > You should confirm they match and if still encountering a problem then provide the configuration.
> Thanks, it's working now. I've been using the name of the data source
> rather than the name of the section. It doesn't make any sense to call
> it data source name (dsn) at places where the name of a section is expected.
The cdr_odbc module originates from 15 years ago, so it's unsurprising.
> It also doesn't make sense that the section name in res_odbc.conf should
> be relevant here. Resources (res) would be configuration information
> --- the tables for this are created with alembic --- while logging
> information is something else --- and the tables for it are not created
> with alembic.
The resource module implements the interface to ODBC and provides/manages the connections. Other modules are consumers of it and thus reference it.
> This could use a lot of cleanup and (or at least) much better documentation.
If you'd like to contribute documentation improvements they follow the same process as everything. If there's wiki pages that could use improvement just leave a comment and after a few you'll be granted access to edit things.
Joshua C. Colp
Digium - A Sangoma Company | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
More information about the asterisk-users