<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff size=2>Hi
Miklos,</FONT></SPAN></DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff size=2>try
starting * with -vvvvvvvvvvvc and see if there is any
warning</FONT></SPAN></DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff size=2>also,
try connecting to your mysql server by issuing >mysql asteriskcdrdb then
</FONT></SPAN></DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff size=2>>
show tables;</FONT></SPAN></DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff size=2>>
select * from cdr;</FONT></SPAN></DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff
size=2>best,</FONT></SPAN></DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=258143421-12122003><FONT face=Arial color=#0000ff
size=2>PHM</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
asterisk-users-admin@lists.digium.com
[mailto:asterisk-users-admin@lists.digium.com] <B>On Behalf Of </B>listas
iPfone<BR><B>Sent:</B> sexta-feira, 12 de dezembro de 2003 16:47<BR><B>To:</B>
Asterisk-Users@lists.digium.com<BR><B>Subject:</B> [Asterisk-Users] Mysql
CDR<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi all</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I just installed the mysql cdr support and my
database is not registering the calls :(</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>using show modules i see that the cdr_csv.so and
the cdr_addon_mysql.so are loaded</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It is necessary to unload the cdr_csv.so?
how to do it?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>in crd_mysql.conf i have:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>[global]<BR>hostname=localhost<BR>dbname=asteriskcdrdb<BR>password=new_password
<BR>user=asteriskcdruser<BR>;port=3306<BR>;sock=/tmp/mysql.sock</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>i copied the crd_mysql.conf to the /etc/asterisk
directory..it is to be there ..or not?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>and in modules.conf i have:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>load => cdr_addon_mysql.so</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It is correct? something more is needed? ( i
created the database and table from wiki instructions)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>How can i know if asterisk is or not trying to
register the calls to the database?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>miklos</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face="Arial, Helvetica, sans-serif" size=2><B><FONT
color=#ff0000>iP</FONT><FONT color=#999999>FONE</FONT> </B>Telefonia IP<BR>Rua
Caio Graco 735 São Paulo SP <BR>iPBX +55 11 3801-3702<BR>UK +44 870 -
3403539<BR>FWD 64662<BR>sip:ipfone@sipserver.com.br <BR><A
href="http://www.ipfone.com.br">www.ipfone.com.br</A><BR><A
href="mailto:info@ipfone.com.br">info@ipfone.com.br</A></FONT>
</DIV></BLOCKQUOTE></BODY></HTML>