<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=utf-8"><META content="IBISIT WebMail" name=GENERATOR></HEAD><BODY><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><BR><BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=msgHeaders>-----Original Message-----<BR><B>From:</B> traci.asterisk@gmail.com<BR><B>Sent:</B> Mon, 12 Dec 2005 21:16:23 -0500<BR><B>To:</B> asterisk-users@lists.digium.com<BR><B>Subject:</B> Re: [Asterisk-Users] CDR MySQL<BR><BR></DIV>
<DIV class=oldBody>
<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">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">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">http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></BLOCKQUOTE></BODY></HTML>