[asterisk-users] Asterisk + mySQL

[jonas kellens]

[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 

I have the following columns (for billing) :

accountcode	src	dst	dcontext	clid	channel
dstchannel 	lastapp 	lastdata 	start 	answer 	end 	duration
billsec 	disposition 	amaflags

Why does it want to write to a column calldate ?? Where is this
defined ??

Thanks for the help !
Jonas.


On Fri, 2009-06-19 at 14:13 -0500, Miguel Molina wrote:

> jonas kellens escribió: 
> 
> > On Thu, 2009-06-18 at 11:52 -0500, Tilghman Lesher wrote: 
> > 
> > > In modules.conf:  noload => cdr_csv.so
> > > 
> > >     
> > 
> > 
> > Are there other modules I need to load or unload ??
> > 
> > asterisk*CLI> module show like cdr
> > Module                         Description
> > Use Count 
> > cdr_addon_mysql.so             MySQL CDR Backend
> > 0         
> > app_setcdruserfield.so         CDR user field apps
> > 0         
> > func_cdr.so                    CDR dialplan function
> > 0         
> > app_cdr.so                     Tell Asterisk to not maintain a CDR
> > for  0         
> > cdr_manager.so                 Asterisk Manager Interface CDR
> > Backend   0         
> > app_forkcdr.so                 Fork The CDR into 2 separate entities
> > 0         
> > cdr_csv.so                     Comma Separated Values CDR Backend
> > 0         
> > cdr_custom.so                  Customizable Comma Separated Values
> > CDR  0         
> > 8 modules loaded
> > asterisk*CLI> module show like odbc
> > Module                         Description
> > Use Count 
> > 0 modules loaded
> > asterisk*CLI> module show like sql
> > Module                         Description
> > Use Count 
> > cdr_addon_mysql.so             MySQL CDR Backend
> > 0         
> > app_addon_sql_mysql.so         Simple Mysql Interface
> > 0         
> > res_config_mysql.so            MySQL RealTime Configuration Driver
> > 0         
> > 3 modules loaded
> > 
> > modules.conf :
> > 
> > autoload=yes
> > noload=pbx_gtkconsole.so
> > load=res_musiconhold.so
> > load=cdr_addon_mysql.so
> > noload=chan_alsa.so
> > 
> > Why is there a res_mysql.conf and a cdr_mysql.conf ?? They both look
> > alike...
> > 
> > 
> 
> There's no other modules you need to load/unload. To disable CSV CDR
> recording just add what Tilghman told you into modules.conf.
> 
> cdr_mysql.conf is for MySQL CDR backend database settings.
> res_mysql.conf is for MySQL Asterisk Realtime Architecture (ARA)
> backend database settings.
> 
> Cheers,
> 
> -- 
> Ing. Miguel Molina
> Grupo de Tecnología
> Millenium Phone Center
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090622/8ae0570d/attachment.htm