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

角色

I though you did not use GUI at all and just for testing only.

YH

ckleea

GUI is just for checking connection. No real use now. always use CLI to look for results

角色

In fact, I believe bubblestar and I do not use GUI on Intel ATOM-based Asterisk server.

YH

ckleea

Just want to use other software to look at the CDR files. If I log the information into mysql table, then it would be very easy to look at the CDR records by web based query

bubblestar

Yes, it can be our next topic to discuss. The existing plain text file is too raw to be read.

ckleea

A2 billing is an interesting product to test

bubblestar

Once A2 billing is up and running, YH and those who use your service will get the bill.  

Qnewbie

Fortunately, the bill does not specify the deadline

ckleea

looking forward to have.

Just kidding.
My usage of VOIP is not that big.

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

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

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

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

ckleea

I have used this to look at the CDR records.

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

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