On Tue, Nov 25, 2008 at 2:19 AM, Tilghman Lesher <[EMAIL PROTECTED]> wrote: > On Monday 24 November 2008 11:38:09 am Atis Lezdins wrote: >> On Sun, Nov 23, 2008 at 2:19 PM, Artifex Maximus <[EMAIL PROTECTED]> > wrote: >> > I've installed a new Asterisk 1.6.0.1 with addons and dahdi drivers >> > and tools but my calls aren't logged. I'd enabled mysql log and >> > noticed that asterisk send a 'DESC cdr' so connection is working >> > between asterisk and mysql and I am able to call other phones so >> > Asterisk is working as well. No error messages on startup though. >> > >> > Any idea why is it happen? As I realized there is some differences >> > between 1.2 (my previous system) and 1.6 log system. > > I suspect that you have some unique index on the table which is > conflicting with the inserted fields. Once you figure out which field is > causing the conflict, it should be easier to figure out where the problem > actually lies. > >> You should also check Asterisk log for warnings. 1.6 should detect >> table structure and warn about missing fields. If it's so, perhaps you >> can change asterisk -> mysql (res_cdr_addon_mysql if i remember >> correctly) to do an "alter" on your table - then it will automagically >> create missing fields. > > You remember incorrectly. None of the CDR drivers currently have the > capability to alter tables. What they will do is to adapt to the table > structure and insert only the required fields. Only realtime table drivers > have the capability of altering tables and then, only if you turn that > behavior on. By default, Asterisk does not alter table structures. >
Oh, my mistake :) > BTW, if you 'core set debug 2 cdr_addon_mysql.c' (and make sure debug is > enabled to the console, via /etc/asterisk/logger.conf), then the SQL will be > printed to the console. That should help you find where the problem lies. Actually SQL's are logged with "debug 1", "debug 2" is too much of everything. I didn't knew that you could use <filename.c> when setting debug level, seems quite useful :) Regards, Atis -- Atis Lezdins, VoIP Project Manager / Developer, IQ Labs Inc, [EMAIL PROTECTED] Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 _______________________________________________ -- 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
