<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.24.5">
</HEAD>
<BODY TEXT="#000000" BGCOLOR="#ffffff">
[Jun 22 17:51:48] ERROR[13726]: cdr_addon_mysql.c:249 mysql_log: mysql_cdr: Failed to insert into database: (1054) Unknown column 'calldate' in 'field list' == Spawn extension <BR>
<BR>
I have the following columns (for billing) :<BR>
<BR>
accountcode src dst dcontext clid channel<BR>
dstchannel lastapp lastdata start answer end duration<BR>
billsec disposition amaflags<BR>
<BR>
Why does it want to write to a column calldate ?? Where is this defined ??<BR>
<BR>
Thanks for the help !<BR>
Jonas.<BR>
<BR>
<BR>
On Fri, 2009-06-19 at 14:13 -0500, Miguel Molina wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
jonas kellens escribió: <BR>
<BLOCKQUOTE TYPE=CITE>
On Thu, 2009-06-18 at 11:52 -0500, Tilghman Lesher wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
In modules.conf: noload => cdr_csv.so
</PRE>
</BLOCKQUOTE>
<BR>
Are there other modules I need to load or unload ??<BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">asterisk*CLI> module show like cdr</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">Module Description Use Count </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">cdr_addon_mysql.so MySQL CDR Backend 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">app_setcdruserfield.so CDR user field apps 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">func_cdr.so CDR dialplan function 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">app_cdr.so Tell Asterisk to not maintain a CDR for 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">cdr_manager.so Asterisk Manager Interface CDR Backend 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">app_forkcdr.so Fork The CDR into 2 separate entities 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">cdr_csv.so Comma Separated Values CDR Backend 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">cdr_custom.so Customizable Comma Separated Values CDR 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">8 modules loaded</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">asterisk*CLI> module show like odbc</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">Module Description Use Count </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">0 modules loaded</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">asterisk*CLI> module show like sql</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">Module Description Use Count </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">cdr_addon_mysql.so MySQL CDR Backend 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">app_addon_sql_mysql.so Simple Mysql Interface 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">res_config_mysql.so MySQL RealTime Configuration Driver 0 </FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">3 modules loaded</FONT></FONT><BR>
<BR>
modules.conf :<BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">autoload=yes</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">noload=pbx_gtkconsole.so</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">load=res_musiconhold.so</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">load=cdr_addon_mysql.so</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#0000ff">noload=chan_alsa.so</FONT></FONT><BR>
<BR>
Why is there a <I><FONT COLOR="#0000ff">res_mysql.conf</FONT></I> and a <I><FONT COLOR="#0000ff">cdr_mysql.conf</FONT></I> ?? They both look alike...<BR>
<BR>
<BR>
</BLOCKQUOTE>
There's no other modules you need to load/unload. To disable CSV CDR recording just add what Tilghman told you into modules.conf.<BR>
<BR>
cdr_mysql.conf is for MySQL CDR backend database settings.<BR>
res_mysql.conf is for MySQL Asterisk Realtime Architecture (ARA) backend database settings.<BR>
<BR>
Cheers,
<PRE>
--
Ing. Miguel Molina
Grupo de Tecnología
Millenium Phone Center
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>