Instead of <span class="e" id="q_10822474e7070cfd_1">hostname=localhost, it would be </span><span class="e" id="q_10822474e7070cfd_1">hostname=IP address of MySQL server.</span><br><br><div><span class="gmail_quote">On 12/12/05,
<b class="gmail_sendername">Innocent Evil</b> <<a href="mailto:innocent.evil@inbox.com">innocent.evil@inbox.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>I was also following this thread.</div>
<div>Would anybody please tell, what would be configuration file if mysql is a different machine than asterisk box?</div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div> </div>
<div>--<br>You don't have any choice, you already made it before you came here.</div><div><span class="e" id="q_10822474e7070cfd_1"><br><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div>-----Original Message-----<br><b>From:</b> <a href="mailto:traci.asterisk@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">traci.asterisk@gmail.com</a><br><b>Sent:</b> Mon, 12 Dec 2005 21:16:23 -0500
<br><b>To:</b> <a href="mailto:asterisk-users@lists.digium.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">asterisk-users@lists.digium.com</a><br><b>Subject:</b> Re: [Asterisk-Users] CDR MySQL<br>
<br></div>
<div>
<div>I believe you are missing 2 variables in your conf file:<br><br><br>table=cdr<br>(the table your cdrs should be stored)<br><br>sock=/var/lib/mysql/mysql.sock<br>(the location to your mysql.sock)<br><br>try something like this:
<br><br>[global]<br>hostname=localhost<br>dbname=dbasterisk<br>table=cdr<br>password=dbpassword<br>user=dbuser<br>sock=/var/lib/mysql/mysql.sock<br>userfield=1<br><br>
<div><span class="gmail_quote">On 12/12/05, <b class="gmail_sendername">Juanjo Portela</b> <<a href="mailto:juanjo.portela@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">juanjo.portela@gmail.com
</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow<br>[global]
<br>hostname=localhost<br>dbname=dbasterisk<br>password=dbpassword<br>user=dbuser<br>userfield=1<br>Any ideas?<br>Thank you in advance, <br>Juanjo<br>_______________________________________________<br>--Bandwidth and Colocation provided by
<a href="http://Easynews.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Easynews.com</a> --<br><br>Asterisk-Users mailing list<br>To UNSUBSCRIBE or update options visit: <br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div></div></blockquote>
</span></div><br>_______________________________________________<br>--Bandwidth and Colocation provided by <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://Easynews.com" target="_blank">Easynews.com
</a> --<br><br>Asterisk-Users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">
http://lists.digium.com/mailman/listinfo/asterisk-users</a><br><br><br></blockquote></div><br>