[asterisk-users] problem with inserting records into cdr

[GlenM]

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

covici at ccs.covici.com said the following on 6/4/2010 11:19 AM:
> Most of the time there is no error message at all.
>
> Tiago Geada <tiago.geada at gmail.com> wrote:
>
>   
>> pasting the error would help
>>
>> On 3 June 2010 20:56, <covici at ccs.covici.com> 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
>>>         covici at ccs.covici.com
>>>
>>> --
>>> _____________________________________________________________________
>>> -- 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
>>