Hi Someone may have an issue to my problem : - I install mysql server and create a database named "asteriskdb" to store some data of asterisk. OK - I create a table "cdr" in order to replace de Master.csv . OK - I set up Areski CDR (asterisk-stats) for my environnement thank to http://www.voip-info.org/wiki/view/Asterisk+CDR+Areski+GUI. OK - I can acces to Areski CDR web pages throug my browser but when I click on some button to see CDRs nothing ! Asterisk, Areski CDR and mysql are on same machine. Here a sample of my define.php file define ("HOST", "ipbx"); define ("PORT", "3306"); define ("USER", "asterisk"); define ("PASS", "asterisk"); define ("DBNAME", "asteriskdb"); define ("DB_TYPE", "mysql"); define ("DB_TABLENAME", "cdr"); Any ideas ? regards harry. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090813/bd43a0ab/attachment.htm
The appropriate venue for this question is some forum, mailing list or other communication channel provided by the creators of Areski. This is not an Asterisk issue. harry R wrote:> Hi > > Someone may have an issue to my problem : > - I install mysql server and create a database named "asteriskdb" to > store some data of asterisk. OK > - I create a table "cdr" in order to replace de Master.csv . OK > - I set up Areski CDR (asterisk-stats) for my environnement thank to > http://www.voip-info.org/wiki/view/Asterisk+CDR+Areski+GUI. OK > - I can acces to Areski CDR web pages throug my browser but when I click > on some button to see CDRs nothing ! > > Asterisk, Areski CDR and mysql are on same machine. > > Here a sample of my define.php file > define ("HOST", "ipbx"); > define ("PORT", "3306"); > define ("USER", "asterisk"); > define ("PASS", "asterisk"); > define ("DBNAME", "asteriskdb"); > define ("DB_TYPE", "mysql"); > define ("DB_TABLENAME", "cdr"); > > Any ideas ? > > regards > > harry. > > > ------------------------------------------------------------------------ > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > AstriCon 2009 - October 13 - 15 Phoenix, Arizona > Register Now: http://www.astricon.net > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users-- Alex Balashov Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671
Have you configured your /etc/asterisk/cdr_mysql.conf file? Ish harry R wrote:> Hi > > Someone may have an issue to my problem : > - I install mysql server and create a database named "asteriskdb" to > store some data of asterisk. OK > - I create a table "cdr" in order to replace de Master.csv . OK > - I set up Areski CDR (asterisk-stats) for my environnement thank to > http://www.voip-info.org/wiki/view/Asterisk+CDR+Areski+GUI. OK > - I can acces to Areski CDR web pages throug my browser but when I > click on some button to see CDRs nothing ! > > Asterisk, Areski CDR and mysql are on same machine. > > Here a sample of my define.php file > define ("HOST", "ipbx"); > define ("PORT", "3306"); > define ("USER", "asterisk"); > define ("PASS", "asterisk"); > define ("DBNAME", "asteriskdb"); > define ("DB_TYPE", "mysql"); > define ("DB_TABLENAME", "cdr"); > > Any ideas ? > > regards > > harry. > > ------------------------------------------------------------------------ > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > AstriCon 2009 - October 13 - 15 Phoenix, Arizona > Register Now: http://www.astricon.net > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users-- Ishfaq Malik Software Developer PackNet Ltd Office: 0161 660 3062
2009/8/13 Ishfaq Malik <ish at pack-net.co.uk>> Have you configured your /etc/asterisk/cdr_mysql.conf file?Yeah I configure it. Now everytime I do a call, a CDR line is added in my table "cdr". -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090813/9de9ddec/attachment.htm