On 9/17/07, <b class="gmail_sendername">Luís Palma</b> <<a href="mailto:lpalma@gmail.com">lpalma@gmail.com</a>> wrote:<div><span class="gmail_quote"></span> <br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Is there a way to enable the usage of UNIQUEID CDR field using a MySQL database backend for storing CDRs without having to recompile asterisk-addons as stated here <a href="http://www.voip-info.org/wiki-Asterisk+cdr+mysql" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.voip-info.org/wiki-Asterisk+cdr+mysql</a> ?<br><br>After version 1.4 it is said in release that it can be done (not sure if it applies to mysql backend)</blockquote><div><br>In addons v1.4.2, it's not possible without recompilation. You get one of two versions of code depending on the definition of a compile time constant. If that constant isn't defined, the text of the SQL INSERT statement in the shared module will be:
<br><br>INSERT INTO %s (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,userfield)<br><br>instead of<br><br>INSERT INTO %s (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield)
<br></div></div><br>In the -trunk version of cdr_addon_mysql.c, the behaviour of loguniqueid was changed from a compile-time to runtime option, just like userfield already was.<br><br>The changes to make loguniqueid a runtime option are pretty small, and trivial to backport to the
1.4 branch on their own. You'd have to do more research to see if you can just build the trunk version against 1.4, given that trunk also has added MySQL SSL support.<br><br>Of course, if your question stems from the fact that you are unable to recompile anything in your installation, none of this is much help. :(
<br><br>-- <br>j.