> > 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" <[email protected] > >: > > > 2010/12/3 marcus rothe <[email protected]> > >> 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/>
-- _____________________________________________________________________ -- 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
