asterisk users - Aug 2012 - Enable CDR logging?

Hello,

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:

  Name:   asterisk
>   DSN:    asterisk-connector
>     Last connection attempt: 1970-01-01 01:00:00
>   Pooled: No
>   Connected: Yes

I also created a table for the CDR logs:
> CREATE TABLE asterisk_cdr (id int NOT NULL AUTO_INCREMENT, PRIMARY KEY
> (id));
This table is also referenced in /etc/asterisk/cdr_adaptive_odbc.conf.

Now, what is the next step?
1) Do I have to call any CDR function in my dialplan for the CDR logging to
become really active?
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?

Thanks for any hint :-)


Best regards
Stefan
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20120819/4df8e40c/attachment.htm>

Stefan at WPF wrote:
> Thanks for any hint :-)
/etc/odbc.ini

[MySQL-cdr]
Description     = CDR Database
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = 172.19.8.9
User            = username
Password        = password
Database        = asteriskcdr
Option          = 3

/etc/asterisk/res_odbc.conf

[MySQL-cdr]
enable => yes
dsn => MySQL-cdr
username => username
password => password
preconnect => yes

/etc/asterisk/cdr_odbc.conf

[global]
dsn=MySQL-cdr
;loguniqueid=yes
dispositionstring=yes
table=cdr
usegmtime=no
;hrtime=yes


Doug


-- 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."