Interesting that you should mention this: I am using Asterisk 1.4x and had the same issue - but fixed it. My issue was a combination of permissions and configuration.
1. in your cdr_addon_mysql.conf , have you tried connecting to the database using the credentials within ? - start there 2. in your /etc/mysql/my.cnf - there is a line 'Logging and Replication' - do you have that enabled so you can see the SQL queries in the log? 3. if you connect to the asterisk cli ( asterisk -rvvvvv) do you see any messages regarding the database? Glen [email protected] said the following on 6/4/2010 11:19 AM: > Most of the time there is no error message at all. > > Tiago Geada <[email protected]> wrote: > > >> pasting the error would help >> >> On 3 June 2010 20:56, <[email protected]> wrote: >> >> >>> Hi. For several months now asterisk will mysteriously stop inserting >>> records into cdr database. I am using mysql and the asterisk addons >>> 1.6.2 to accomplish this. Sometimes there is a strange error about >>> column names, but often there is no error, it just stops. I just have >>> to restart asterisk to get things going again, so I am stumped as to >>> what is happening, or even how to troubleshoot. I usually run in >>> verbosity 4, but am not seeing anything of interest. >>> >>> Any ideas would be appreciated. >>> >>> -- >>> Your life is like a penny. You're going to lose it. The question is: >>> How do >>> you spend it? >>> >>> John Covici >>> [email protected] >>> >>> -- >>> _____________________________________________________________________ >>> -- 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 >>> >>> >> ---------------------------------------------------- >> Alternatives: >> >> ---------------------------------------------------- >> -- >> _____________________________________________________________________ >> -- 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 >> -- _____________________________________________________________________ -- 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
