Re: [asterisk-users] MySQL and Channel Event Logging
Hey, Murph! Good to see you're still active 'round these parts! I actually have not delved too far into CEL, I had just started looking into it when I noticed that there wasn't anything for MySQL and so I began searching and finally making this inquiry :) I will take a peek at the source code for the other backends and see if I can't hack something together to submit to the community. Past that, once I've learned a bit more about CEL in general, I'll let you know how I plan on using that table (sorry, I currently have no idea what's in the table yet, but I'll learn). Thanks, by the way, for your work on CEL (I remember drooling over a blog post or two of yours that mentioned the beginnings of work on CEL), on AEL v2, and last but not least, listening to my suggestions and whatnot regarding AEL :) Cheers, Sherwood McGowan On Wed, Oct 13, 2010 at 11:17 PM, Steve Murphy m...@parsetree.com wrote: On Wed, Oct 13, 2010 at 9:52 PM, Sherwood McGowan sherwood.mcgo...@gmail.com wrote: On Wed, Oct 13, 2010 at 9:53 PM, Paul Belanger paul.belan...@polybeacon.com wrote: On Wed, Oct 13, 2010 at 9:31 PM, Sherwood McGowan sherwood.mcgo...@gmail.com wrote: Hey all, sorry if this has been covered, but I've not found anything after a couple hours' worth of googling. I can see (and I'm familiar with) all the usual MySQL addon apps once I install Asterisk 1.8.x, but I cannot find any reference to MySQL and the new CEL logging tool other than ODBC. Is this the only method available to use MySQL with CEL at this time? Looking at the CEL config files, I don't see one specifically for MySQL. I do have it up and running via ODBC, for what it's worth. -- Paul Belanger | dCAP Thanks mate, I appreciate the reply. That's what I've seen from looking at the configs right now. When I wrote the CEL backends, I probably skipped the MySQL stuff, because it would be in the addons stuff for Asterisk. But, if you look at the similarities between the CEL backends, and the CDR backends, you'll probably notice that you could pump out a myseql backend with the same mods in a short amount of time. I would be curious to see how you plan to use that table! Have you mapped out your sql statements yet? murf -- Steve Murphy ParseTree Corp -- _ -- 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
[asterisk-users] MySQL and Channel Event Logging
Hey all, sorry if this has been covered, but I've not found anything after a couple hours' worth of googling. I can see (and I'm familiar with) all the usual MySQL addon apps once I install Asterisk 1.8.x, but I cannot find any reference to MySQL and the new CEL logging tool other than ODBC. Is this the only method available to use MySQL with CEL at this time? Thanks, Sherwood -- _ -- 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
Re: [asterisk-users] MySQL and Channel Event Logging
On Wed, Oct 13, 2010 at 9:31 PM, Sherwood McGowan sherwood.mcgo...@gmail.com wrote: Hey all, sorry if this has been covered, but I've not found anything after a couple hours' worth of googling. I can see (and I'm familiar with) all the usual MySQL addon apps once I install Asterisk 1.8.x, but I cannot find any reference to MySQL and the new CEL logging tool other than ODBC. Is this the only method available to use MySQL with CEL at this time? Looking at the CEL config files, I don't see one specifically for MySQL. I do have it up and running via ODBC, for what it's worth. -- Paul Belanger | dCAP Polybeacon | Consultant Jabber: paul.belan...@polybeacon.com | IRC: pabelanger (Freenode) blog.polybeacon.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
Re: [asterisk-users] MySQL and Channel Event Logging
On Wed, Oct 13, 2010 at 9:53 PM, Paul Belanger paul.belan...@polybeacon.com wrote: On Wed, Oct 13, 2010 at 9:31 PM, Sherwood McGowan sherwood.mcgo...@gmail.com wrote: Hey all, sorry if this has been covered, but I've not found anything after a couple hours' worth of googling. I can see (and I'm familiar with) all the usual MySQL addon apps once I install Asterisk 1.8.x, but I cannot find any reference to MySQL and the new CEL logging tool other than ODBC. Is this the only method available to use MySQL with CEL at this time? Looking at the CEL config files, I don't see one specifically for MySQL. I do have it up and running via ODBC, for what it's worth. -- Paul Belanger | dCAP Polybeacon | Consultant Jabber: paul.belan...@polybeacon.com | IRC: pabelanger (Freenode) blog.polybeacon.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 Thanks mate, I appreciate the reply. That's what I've seen from looking at the configs right now. -- _ -- 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
Re: [asterisk-users] MySQL and Channel Event Logging
On Wed, Oct 13, 2010 at 9:52 PM, Sherwood McGowan sherwood.mcgo...@gmail.com wrote: On Wed, Oct 13, 2010 at 9:53 PM, Paul Belanger paul.belan...@polybeacon.com wrote: On Wed, Oct 13, 2010 at 9:31 PM, Sherwood McGowan sherwood.mcgo...@gmail.com wrote: Hey all, sorry if this has been covered, but I've not found anything after a couple hours' worth of googling. I can see (and I'm familiar with) all the usual MySQL addon apps once I install Asterisk 1.8.x, but I cannot find any reference to MySQL and the new CEL logging tool other than ODBC. Is this the only method available to use MySQL with CEL at this time? Looking at the CEL config files, I don't see one specifically for MySQL. I do have it up and running via ODBC, for what it's worth. -- Paul Belanger | dCAP Thanks mate, I appreciate the reply. That's what I've seen from looking at the configs right now. When I wrote the CEL backends, I probably skipped the MySQL stuff, because it would be in the addons stuff for Asterisk. But, if you look at the similarities between the CEL backends, and the CDR backends, you'll probably notice that you could pump out a myseql backend with the same mods in a short amount of time. I would be curious to see how you plan to use that table! Have you mapped out your sql statements yet? murf -- Steve Murphy ParseTree Corp -- _ -- 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