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[1]. 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. [1] https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process -- 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 -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users