You can also enter into the CLI in order to see if you can spot any error regarding cdr_mysql, or 'duplicated value for key...' after hangin up a call.

There might be a corruption in the 'cdr' table (I've seen this sometimes). You could try a 'repair table cdr' from the MySQL CLI.

Note: Sometimes, corrumptions in myISAM tables not always produce the data to be unaccessible, but just make it impossible to insert new records.


David Backeberg wrote:
On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman <[email protected]> wrote:
I did an upgrade to the SVN trunk on the 12/9 and when I looked in my mysql
table for CDR's today there are no entries since the update.
I have rebuilt and re-installed and re-started asterisk still no CDR's
flowing to mysql. I did not change any configs. I checked to make sure that
the cdr_mysql option was selected under the make menu options. The module
shows it is there when I do a modules show. I don't get any errors saying it
can't write to the table.  My voicemail settings are pulling from the same
server.

Any ideas on what I could try to fix this or how I could test to see what is
causing it?

Rebooting is a good clue. You could check your firewall settings.
Firewalls can stop mysql connections.

Try manually connecting to the mysql server from the asterisk system
and see what happens.

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


--
Jose P. Espinal
http://www.eSlackware.com
IRC: Khratos @ #asterisk / -doc / -bugs


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to