Citation Envoyé par survivant Voir le message
ouin.. sauf que là.. il insère en double dans la DB. Probablement à cause du cdr_odbc.conf et le cdr_adaptive.

quelle est la raison que le adaptive n'insère pas calldate ?
j'ai trouvé.

il faut ajouter un alias

; cdr_adaptive_odbc.conf
[adaptive_connection]
connection=asterisk
table=cdr
usegmtime=yes
alias start => calldate

et à la fin.. on obtient :

Code:
		   48 Query	INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,lastapp,duration,billsec,disposition,amaflags,uniqueid) VALUES ({ ts '2010-11-17 02:37:52' },'"SoftPhone" <1001>','1001','**34','Interne','SIP/1001-00000000','Hangup',2,2,'ANSWERED',3,'1289961472.0')
		   48 Query	SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
		   48 Query	INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ({ts '2010-11-17 02:37:52'},'\"SoftPhone\" <1001>','1001','**34','Interne','SIP/1001-00000000','','Hangup','',2,2,'ANSWERED',3,'','1289961472.0','')
101116 18:38:06	   35 Query	select * from cdr
Code:
|  3 | 2010-11-17 02:37:52 | "SoftPhone" <1001> | 1001 | **34 | Interne  | SIP/1001-00000000 |            | Hangup  |          |        2 |       2 | ANSWERED    |        3 |             | 1289961472.0 |           |
|  4 | 2010-11-17 02:37:52 | "SoftPhone" <1001> | 1001 | **34 | Interne  | SIP/1001-00000000 |            | Hangup  |          |        2 |       2 | ANSWERED    |        3 |             | 1289961472.0 |           |