> > Sorry, of course cdr.conf not queues.conf. marcus > > Am 01.12.2010 19:16 schrieb "marcus rothe" <synco16 at 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 site<http://openingyourmind.wordpress.com/> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20101201/c8dd8e16/attachment.htm
> > Sorry, of course cdr.conf not queues.conf. marcus >> >> Am 01.12.2010 19:16 schrieb "marcus rothe" <synco16 at 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 site<http://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 site<http://openingyourmind.wordpress.com/> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20101203/3b90e06e/attachment.htm
On 3 Dec 2010, at 13:47, Rodrigo Lang wrote:> unansweredy = yesRemove the extra y. S
> > 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" <rodrigoferreiralang at gmail.com > >: > > > 2010/12/3 marcus rothe <synco16 at 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 site<http://openingyourmind.wordpress.com/> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20101203/f7f0a0be/attachment.htm