[asterisk-users] cdr_odbc not working for some reason

[Sanjay Rajdev]

Thanks Tilghman for the suggestion, 

While reading your mail I immediately understood what went wrong. 
In my situation the database is MS SQL Server 2000, and I generated the script of the table from an existing table where ODBC CDR is properly working, somehow the script did not generate for a constraint that we added to our Primary Key column, which is a UniqueID to generate new unique id on each insert. After your mail I guessed that this could be the only thing that would be missing. and It was. 

Thanks a lot once again. 

Regards, 
Sanjay Rajdev 

----- Original Message ----- 
From: "Tilghman Lesher" <tilghman at mail.jeffandtilghman.com> 
To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users at lists.digium.com> 
Sent: Saturday, May 31, 2008 12:34:41 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi 
Subject: Re: [asterisk-users] cdr_odbc not working for some reason 

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 

_______________________________________________ 
-- Bandwidth and Colocation Provided by http://www.api-digital.com -- 

asterisk-users mailing list 
To UNSUBSCRIBE or update options visit: 
http://lists.digium.com/mailman/listinfo/asterisk-users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080531/dc6ae41c/attachment.htm