Re: [asterisk-users] Abandon events in cdr
Sorry, of course cdr.conf not queues.conf. marcus Am 01.12.2010 19:16 schrieb marcus rothe sync...@googlemail.com: Hi Rodrigo, have you got enabled the appropriate line in queues. Conf? Regards Marcus Thanks very much, I include the line unansweredy=yes in the cdr.conf and solve the problem. Thanks again! -- Rodrigo Lang Opening your mind - Just another Open Source sitehttp://openingyourmind.wordpress.com/ I messed up in the records, did not fix the problem. The calls that are going to leave the queue and still are no records in the cdr! The output of the command show status cdr: AST * CLI cdr status show CDR logging: enabled CDR mode: simple CDR output unanswered calls: no CDR registered backend: mysql The option of unanswered calls is to no, but is cdr.conf configre to yes. Look: cat / etc / asterisk / cdr.conf [General] enable = yes unansweredy = yes safeshutdown = yes endbeforehexten = yes [Mysql] host = localhost Thanks again, -- Rodrigo Lang Opening your mind - Just another Open Source sitehttp://openingyourmind.wordpress.com/ -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Abandon events in cdr
On 3 Dec 2010, at 13:47, Rodrigo Lang wrote: unansweredy = yes Remove the extra y. S -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Abandon events in cdr
No, i am standing absolutely at the beginning. I think the table structure should be googleable. But i haven 't found an automatism to dump the queuelog flatfile into a database table. Found a perl script but it doesn' t work for me. Am 03.12.2010 19:29 schrieb Rodrigo Lang rodrigoferreiral...@gmail.com : 2010/12/3 marcus rothe sync...@googlemail.com That sounds good. Rodrigo, allow me one question. I'm not very familar with databases but have the need to report out of the queuelog. Have you got a hint for me how to export the queueslog file into a database table? Thanks in advance, Regards Marcus Hi. Assuming you use Debian and have all your repositories ok, do: Install mysql Database: aptitude -y install mysql-server libmysqlclient15-dev mysql-client Install php5 to run my script: aptitude -y install php5 php5-cli php5-cgi php5-mysql To create the MySQL table I use this script [1], I pasted in the pastebin now. This script creates the CDR and Queue_log tables. To convert your cvs queue_log for MySQL, use this script [2]. I did it now and have tested, it worked for me. Make a backup of queue_log before use. [1] http://pastebin.com/2v5UPg3Q [2] http://pastebin.com/TCJHkPXP Any questions just ask. If you find an error in php script just let me know, then I stand corrected. And please answer in the list. So when someone needs the same procedure like you needed now, he can find in list history. Best regards, -- Rodrigo Lang Opening your mind - Just another Open Source sitehttp://openingyourmind.wordpress.com/ -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Abandon events in cdr
Sorry, of course cdr.conf not queues.conf. marcus Am 01.12.2010 19:16 schrieb marcus rothe sync...@googlemail.com: Hi Rodrigo, have you got enabled the appropriate line in queues. Conf? Regards Marcus Thanks very much, I include the line unansweredy=yes in the cdr.conf and solve the problem. Thanks again! -- Rodrigo Lang Opening your mind - Just another Open Source sitehttp://openingyourmind.wordpress.com/ -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users