<span style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt">Jose<br />
<br />
Thanks for your response. It appears that the issue was that the mysql client drivers were updated when I installed some mono updates and I had to recompile asterisk the system was actually writing completely blank entries for every call. Once asterisk was compiled using the newer mysql client lib things started to work again. The moral of the story is if you update anything on the box that may change mysql at all you should do a complete make clean and recompile.<br />
<br />
Bryant<br />
<br />
<div id="divSignature"></div>
<br />
<br />
<span style="font-family: tahoma,arial,sans-serif; font-size: 10pt;"><hr width="100%" size="2" align="center" />
<b>From</b>: "Jose P. Espinal" <jpe@slackware-es.com><br />
<b>Sent</b>: Thursday, December 23, 2010 12:19 PM<br />
<b>To</b>: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com><br />
<b>Subject</b>: Re: [asterisk-users] cdr_mysql stopped working</span><br />
<br />
You can also enter into the CLI in order to see if you can spot any <br />
error regarding cdr_mysql, or 'duplicated value for key...' after hangin <br />
up a call.<br />
<br />
There might be a corruption in the 'cdr' table (I've seen this <br />
sometimes). You could try a 'repair table cdr' from the MySQL CLI.<br />
<br />
Note: Sometimes, corrumptions in myISAM tables not always produce the <br />
data to be unaccessible, but just make it impossible to insert new records.<br />
<br />
<br />
David Backeberg wrote:<br />
> On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman <BryantZ@zktech.com> wrote:<br />
>> I did an upgrade to the SVN trunk on the 12/9 and when I looked in my mysql<br />
>> table for CDR's today there are no entries since the update.<br />
>> I have rebuilt and re-installed and re-started asterisk still no CDR's<br />
>> flowing to mysql. I did not change any configs. I checked to make sure that<br />
>> the cdr_mysql option was selected under the make menu options. The module<br />
>> shows it is there when I do a modules show. I don't get any errors saying it<br />
>> can't write to the table. My voicemail settings are pulling from the same<br />
>> server.<br />
>><br />
>> Any ideas on what I could try to fix this or how I could test to see what is<br />
>> causing it?<br />
> <br />
> Rebooting is a good clue. You could check your firewall settings.<br />
> Firewalls can stop mysql connections.<br />
> <br />
> Try manually connecting to the mysql server from the asterisk system<br />
> and see what happens.<br />
> <br />
> --<br />
> _____________________________________________________________________<br />
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --<br />
> New to Asterisk? Join us for a live introductory webinar every Thurs:<br />
> http://www.asterisk.org/hello<br />
> <br />
> asterisk-users mailing list<br />
> To UNSUBSCRIBE or update options visit:<br />
> http://lists.digium.com/mailman/listinfo/asterisk-users<br />
> <br />
<br />
-- <br />
Jose P. Espinal<br />
http://www.eSlackware.com<br />
IRC: Khratos @ #asterisk / -doc / -bugs<br />
<br />
<br />
--<br />
_____________________________________________________________________<br />
-- Bandwidth and Colocation Provided by http://www.api-digital.com --<br />
New to Asterisk? Join us for a live introductory webinar every Thurs:<br />
http://www.asterisk.org/hello<br />
<br />
asterisk-users mailing list<br />
To UNSUBSCRIBE or update options visit:<br />
http://lists.digium.com/mailman/listinfo/asterisk-users<br />
<br /></span>