Hello,<div><br></div><div>I am currently trying to set up CDR logging. I got all the ODBC stuff for my mysql server set up, also checked there's a connection using "odbc show" in the asterisk console:</div><div>
<div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> Name: asterisk<br> DSN: asterisk-connector<br>
Last connection attempt: 1970-01-01 01:00:00<br> Pooled: No<br> Connected: Yes</blockquote></div><div><br></div><div>I also created a table for the CDR logs:</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
CREATE TABLE asterisk_cdr (id int NOT NULL AUTO_INCREMENT, PRIMARY KEY (id));</blockquote><div>This table is also referenced in /etc/asterisk/cdr_adaptive_odbc.conf.</div><div><br></div><div>Now, what is the next step? </div>
<div>1) Do I have to call any CDR function in my dialplan for the CDR logging to become really active?</div><div>2) Do I have to create more fields in my asterisk_cdr table manually? Guess it should all be done automatically? Would I have needed the ID field at all?</div>
<div><br></div><div>Thanks for any hint :-)</div><div><br></div><div><br></div><div>Best regards</div><div>Stefan</div>