See my comments below. GlenM <[email protected]> wrote:
> 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 I don't have such a file, instead I have cdr_mysql.conf which does connect. > 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? Could you point out which line, I found no line with replic as a search string. > 3. if you connect to the asterisk cli ( asterisk -rvvvvv) do you see any > messages regarding the database? Only when first starting up, default port, etc. > > 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 -- 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
