Realtime database

ckleea

Any Ching has tried to configure realtime mysql database to log CDR? Though I am able to use GUI, it has a lot of bugs

ckleea

回復 23# bubblestar

Glad to hear

bubblestar

Successfully created cdr_mysql and imported all data from Master.csv now.  Also, I can manage to view those CDR details in Internet Browser via Asterisk-CDR-Viewer in a systematic manner.

Thanks ckleea C-hing for his recommendation and advice.

ckleea

回復 15# ckleea

I can also get it running now. Not easy

ckleea

I have logging to both CSV and mysql database

ckleea

回復 19# bubblestar


    Importcdr.php scripts can be found on #13

You need to enable cdr.conf and cdr_mysql.conf

bubblestar

Both Asterisk Web Manager and CDR Viewer have been installed successfully and can see in the Browser. But, as you said, I am now stuck in the mysql.  

Where is your importcdr.php script? Could you show me how?  Thanks

ckleea

回復 17# bubblestar

You need to enable CDR logging to mysql first.

See my importcdr.php script and enable you cdr_mysql.conf

bubblestar

A neat and beauiful GUI, worth a try.  Thanks.

ckleea

i have installed two web gui programs.

1. http://www.micpc.com/astwebmgr/astwebmgr.tar.gz
It has a lot more features.

下載 (28.62 KB)

2011-10-3 06:34

2. http://code.google.com/p/asterisk-cdr-viewer/

下載 (45.41 KB)

2011-10-3 06:39

Both of them are not difficult to implement.

ckleea

alang CHing site has a demonstration of CDR-stats but I can't complete in my centos 5.7 server.

There are some typos but I am able to fix

http://www.osslab.com.tw/VoIP/IP ... 6%96%b0%e7%89%88%29

ckleea

I have used this to look at the CDR records.

http://code.google.com/p/asterisk-cdr-viewer/

ckleea

Have a look at this page for import CSV file into mySQL

http://leifmadsen.wordpress.com/ ... to-mysql-cdr-table/

bubblestar

Post-dated cheque is accepted.

Yes, we can try to add these kind of features, for fun, for learning or for whatever purpose.

ckleea

In fact the purpose of looking at the CDR is to get an idea whether unusual dialing happens.
Other essential features are to properly log the registration information to prevent hacker attack