Asteriskcdrdb TABLE cdr Duration field

General Help
1

When I do a do a mysql>DESCRIBE cdr;
the output shows that the Default value for row “duration” is 0.

This is a problem, because when i do a

select * FROM cdr INTO OUTFILE ‘/tmp/asteriskcdrdb_out/secondout.csv’;

the output does not show the duration field. “Duration” shows up in the GUI, but not when taking directly from the database.

I tried changing the value for duration in Webmin, but can only get it to accept Null.

There is also nothing written in /etc/asterisk/cdr.conf and there doesn’t appear to be anything in the GUI Advanced Settings to enable this.

Any advice?

Thanks.

2