[asterisk-users] CDR userfield not written into DB
Hi everybody, i've been googling for quite some time now but can't find an answer to my problem... I'm using Asterisk 1.2.12.1 with mysql as the cdr backend. In the dialplan i've written exten = 1234,n,Set(CDR(userfield)=blah) exten = 1234,n,Answer() exten = 1234,n,Queue(.) exten = 1234,n,Hangup() When I'm doing a call I can see that the statement is executed. But when the call finishes, a cdr is written into the DB with an empty 'userfield'. I'm sure, I'm missing something but can't figure out, what... Thanks Norbert ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR userfield not written into DB
Norbert Zawodsky schrieb: I'm using Asterisk 1.2.12.1 with mysql as the cdr backend. In the dialplan i've written exten = 1234,n,Set(CDR(userfield)=blah) exten = 1234,n,Answer() exten = 1234,n,Queue(.) exten = 1234,n,Hangup() When I'm doing a call I can see that the statement is executed. But when the call finishes, a cdr is written into the DB with an empty 'userfield'. I'm sure, I'm missing something but can't figure out, what... /etc/asterisk/cdr_mysql.conf : [global] userfield=1 ... Philipp Kempgen -- AMOOMA GmbH - Bachstr. 126 - 56566 Neuwied - http://www.amooma.de Geschäftsführer: Stefan Wintermeyer, Handelsregister: Neuwied B14998 Asterisk: http://the-asterisk-book.com - http://das-asterisk-buch.de Videos of the AMOOCON VoIP conference 2009 - http://www.amoocon.de -- ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR userfield not written into DB
Norbert Zawodsky wrote: Hi everybody, i've been googling for quite some time now but can't find an answer to my problem... My first hit on Google: http://www.mail-archive.com/asterisk-users@lists.digium.com/msg147997.html exten = 1234,n,Set(CDR(userfield)=blah) This is version 1.4.x format. Doug -- Ben Franklin quote: Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety. ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR userfield not written into DB
Philipp Kempgen schrieb: Norbert Zawodsky schrieb: I'm using Asterisk 1.2.12.1 with mysql as the cdr backend. In the dialplan i've written exten = 1234,n,Set(CDR(userfield)=blah) exten = 1234,n,Answer() exten = 1234,n,Queue(.) exten = 1234,n,Hangup() When I'm doing a call I can see that the statement is executed. But when the call finishes, a cdr is written into the DB with an empty 'userfield'. I'm sure, I'm missing something but can't figure out, what... /etc/asterisk/cdr_mysql.conf : [global] userfield=1 ... Philipp Kempgen Oh god! That simple Sorry!! ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR is not written
Hi, have you installed asterisk-addons, too? The cdr-MySQL driver is in the addons package. CLI show modules ... cdr_addon_mysql.so MySQL CDR Backend ... When this line appears, the driver is allready there. Your cdr_mysql.conf must contain something like that: [global] hostname=localhost dbname=asteriskcdrdb password=my_db_password user=my_db_user Peter Khaled Chehab schrieb: There is a creation for Master.csv in /var/log/asterisk/cdr-csv and its filled with data ,but there is no pushing to mysql,asteriskcdrdb table cdr How or what is the procedure to let the data enters mysql . Regards ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] CDR is not written
There is a creation for Master.csv in /var/log/asterisk/cdr-csv and its filled with data ,but there is no pushing to mysql,asteriskcdrdb table cdr How or what is the procedure to let the data enters mysql . Regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Murphy Sent: Thursday, May 17, 2007 9:43 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR is not written On Thu, 2007-05-17 at 10:54 -0700, Khaled Chehab wrote: I created Master.csv in /var/log/asterisk/cdr-csv ,even did not work,do freepbx make this problem,and how can I trouble shoot it. To get the CSV backend to pump CDRs into the /var/log/asterisk/cdr-csv/Master.csv file, you need to: a. in cdr.conf, in the general section, the enable=yes can optionally be there. just make sure it does ***NOT*** say enable=no b. in cdr.conf, the [csv] section must be there, and not commented out. I don't know what freepbx does to cdr.conf, but that file is a good place to start checking. BTW, doesn't freepbx have a mailing list? Wouldn't it be better asking there? Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Williams Sent: Wednesday, May 16, 2007 11:58 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [SPAM]RE: [asterisk-users] CDR is not written I fought this for a bit when I found if the file Master.csv didn't exist, it wouldn't create it on it's own. I created an empty csv file, CDR started writing. Ken From: [EMAIL PROTECTED] on behalf of Khaled Chehab Sent: Thu 5/17/2007 10:50 AM To: [EMAIL PROTECTED] Cc: asterisk-users@lists.digium.com Subject: [asterisk-users] CDR is not written I installed asterisk 1.4.4 final ,but the cdr is not written any patch or tweaking can be done Regards * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete
RE: [asterisk-users] CDR is not written
I fought this for a bit when I found if the file Master.csv didn't exist, it wouldn't create it on it's own. I created an empty csv file, CDR started writing. Ken From: [EMAIL PROTECTED] on behalf of Khaled Chehab Sent: Thu 5/17/2007 10:50 AM To: [EMAIL PROTECTED] Cc: asterisk-users@lists.digium.com Subject: [asterisk-users] CDR is not written I installed asterisk 1.4.4 final ,but the cdr is not written any patch or tweaking can be done Regards * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * winmail.dat___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] CDR is not written
I installed asterisk 1.4.4 final ,but the cdr is not written any patch or tweaking can be done Regards * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. *___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [SPAM]RE: [asterisk-users] CDR is not written
I created Master.csv in /var/log/asterisk/cdr-csv ,even did not work,do freepbx do this problem,and how can I trouble shoot it. Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Williams Sent: Wednesday, May 16, 2007 11:58 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [SPAM]RE: [asterisk-users] CDR is not written I fought this for a bit when I found if the file Master.csv didn't exist, it wouldn't create it on it's own. I created an empty csv file, CDR started writing. Ken From: [EMAIL PROTECTED] on behalf of Khaled Chehab Sent: Thu 5/17/2007 10:50 AM To: [EMAIL PROTECTED] Cc: asterisk-users@lists.digium.com Subject: [asterisk-users] CDR is not written I installed asterisk 1.4.4 final ,but the cdr is not written any patch or tweaking can be done Regards * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] CDR is not written
I created Master.csv in /var/log/asterisk/cdr-csv ,even did not work,do freepbx make this problem,and how can I trouble shoot it. Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Williams Sent: Wednesday, May 16, 2007 11:58 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [SPAM]RE: [asterisk-users] CDR is not written I fought this for a bit when I found if the file Master.csv didn't exist, it wouldn't create it on it's own. I created an empty csv file, CDR started writing. Ken From: [EMAIL PROTECTED] on behalf of Khaled Chehab Sent: Thu 5/17/2007 10:50 AM To: [EMAIL PROTECTED] Cc: asterisk-users@lists.digium.com Subject: [asterisk-users] CDR is not written I installed asterisk 1.4.4 final ,but the cdr is not written any patch or tweaking can be done Regards * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDR is not written
On Thu, 2007-05-17 at 10:54 -0700, Khaled Chehab wrote: I created Master.csv in /var/log/asterisk/cdr-csv ,even did not work,do freepbx make this problem,and how can I trouble shoot it. To get the CSV backend to pump CDRs into the /var/log/asterisk/cdr-csv/Master.csv file, you need to: a. in cdr.conf, in the general section, the enable=yes can optionally be there. just make sure it does ***NOT*** say enable=no b. in cdr.conf, the [csv] section must be there, and not commented out. I don't know what freepbx does to cdr.conf, but that file is a good place to start checking. BTW, doesn't freepbx have a mailing list? Wouldn't it be better asking there? Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Williams Sent: Wednesday, May 16, 2007 11:58 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [SPAM]RE: [asterisk-users] CDR is not written I fought this for a bit when I found if the file Master.csv didn't exist, it wouldn't create it on it's own. I created an empty csv file, CDR started writing. Ken From: [EMAIL PROTECTED] on behalf of Khaled Chehab Sent: Thu 5/17/2007 10:50 AM To: [EMAIL PROTECTED] Cc: asterisk-users@lists.digium.com Subject: [asterisk-users] CDR is not written I installed asterisk 1.4.4 final ,but the cdr is not written any patch or tweaking can be done Regards * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * ___ --Bandwidth and Colocation provided