I thought I had this resolved, but apparently not. Every call generates this:
Oct 15 16:54:19 ERROR[1115579712]: cdr_addon_mysql.c:200 mysql_log: Failed to insert into database. We know from the mysql log that * is connecting to MySQL: 041015 16:14:02 12 Connect [EMAIL PROTECTED] on asteriskcdrdb According to the MySQL log, * is trying to do this: 041015 16:54:19 12 Query INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,dura tion,billsec,disposition,amaflags,accountcode,userfield) VALUES ('2004-10-15 16:53:56','\"Jim\" <7401>','7401','7368','outgoing', 'SIP/Ciscoe7f578-a503','SIP/Ciscod66bbf-1-55da','Hangup','',23,3,'ANSWER ED',3,'','') Here's the table structure (I set those "allow nulls" while trying to solve this problem): mysql> describe cdr; +-------------+--------------+------+-----+---------------------+------- + | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------------------+------- + | userfield | varchar(255) | YES | | NULL | | | accountcode | varchar(20) | YES | | NULL | | | src | varchar(80) | | | | | | dst | varchar(80) | | | | | | dcontext | varchar(80) | | | | | | clid | varchar(80) | | | | | | channel | varchar(80) | | | | | | dstchannel | varchar(80) | YES | | NULL | | | lastapp | varchar(80) | YES | | NULL | | | lastdata | varchar(80) | YES | | NULL | | | calldate | datetime | | | 0000-00-00 00:00:00 | | | duration | int(11) | | | 0 | | | billsec | int(11) | | | 0 | | | disposition | varchar(45) | | | | | | amaflags | int(11) | YES | | NULL | | +-------------+--------------+------+-----+---------------------+------- + 15 rows in set (0.00 sec) I'm pretty sure the permissions are right: Mysql> show grants for [EMAIL PROTECTED]; GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'asterisk'@'localhost' IDENTIFIED BY PASSWORD 'yadayada' GRANT ALL PRIVILEGES ON `asteriskcdrdb`.`asteriskcdrdb` TO 'asterisk'@'localhost' WITH GRANT OPTION If there's a specific error message from MySQL in response to the INSERT, I haven't been able to locate it. Ideas anyone? Thanks Jim Shilliday _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users