I am sorry I did not get back to you last night - I was so tired! I don't have such a file, instead I have cdr_mysql.conf which does connect. <----same thing I think - perhaps a different flavour of the module. If you type asterisk -rx "show modules" | grep mysql at the command prompt, not the CLI, do you see the module loaded?
Could you point out which line, I found no line with replic as a search string. <----try adding this to your /etc/mysql/my.cnf file and restart MySQL server. Tail the log and see if you see any messages about asterisk connecting or SQL statements. general_log_file = /var/log/mysql/mysql.log general_log = 1 I know that in the asterisk CLI, if asterisk cannot connect to your database, you *may* see a message. I know I did when mine could NOT connect. I hope these help you out - I am fairly new to Asterisk, and digging for information can sometimes be frustrating. [email protected] said the following on 6/4/2010 2:46 PM: > 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 >> > > -- _____________________________________________________________________ -- 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
