[asterisk-users] cdr_odbc not working for some reason

Tilghman Lesher tilghman at mail.jeffandtilghman.com
Fri May 30 14:04:41 CDT 2008


On Friday 30 May 2008 13:47:48 Sanjay Rajdev wrote:
> Here is the output::
>
> localhost*CLI> module unload cdr_odbc.so
> == Unregistered 'ODBC' CDR backend
>
> localhost*CLI> module load cdr_odbc.so
> == Parsing '/etc/asterisk/cdr_odbc.conf : Found
> -- cdr_odbc : dsn is asterisk
> -- cdr_odbc : username is asterisk
> -- cdr_odbc : password is [secret]
> -- cdr_odbc : table is cdr
> Loaded cdr_odbc.so => (ODBC CDR Backed)
>
> localhost*CLI>

Okay, then it appears to be connecting, so the most likely
cause of no CDRs in the database is that your table layout does
not match what cdr_odbc expects.  You have two options at this
point:  either you can make the backend cdr table match what
cdr_odbc wants (in terms of fields) or you can use the backport
of cdr_adaptive_odbc, which will allow you to adapt the records to
your layout, instead of the other way around.

http://svncommunity.digium.com/view/tilghman/branches/1.4/

-- 
Tilghman



More information about the asterisk-users mailing list