電訊茶室 - Powered by Discuz! Board

標題: Realtime database [打印本頁]

作者: ckleea 時間: 2011-10-1 13:11 標題: Realtime database

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

作者: 角色 時間: 2011-10-1 22:51

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

YH

作者: ckleea 時間: 2011-10-1 22:54

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

作者: 角色 時間: 2011-10-1 23:01

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

YH

作者: ckleea 時間: 2011-10-1 23:10

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 時間: 2011-10-1 23:22

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

作者: ckleea 時間: 2011-10-1 23:26

A2 billing is an interesting product to test

作者: bubblestar 時間: 2011-10-1 23:33

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

作者: Qnewbie 時間: 2011-10-1 23:35

本帖最後由 Qnewbie 於 2011-10-1 23:36 編輯

Fortunately, the bill does not specify the deadline

作者: ckleea 時間: 2011-10-1 23:36

looking forward to have.

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

作者: ckleea 時間: 2011-10-1 23:37

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 時間: 2011-10-1 23:41

Post-dated cheque is accepted.

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

作者: ckleea 時間: 2011-10-2 13:04

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

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

作者: ckleea 時間: 2011-10-3 05:50

I have used this to look at the CDR records.

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

作者: ckleea 時間: 2011-10-3 05:52

本帖最後由 ckleea 於 2011-10-3 18:54 編輯

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 時間: 2011-10-3 06:35

本帖最後由 ckleea 於 2011-10-3 06:39 編輯

i have installed two web gui programs.

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

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

screenshot.03-10-2011 06.32.03.png

Both of them are not difficult to implement.

圖片附件: screenshot.03-10-2011 06.25.06.png (2011-10-3 06:34, 28.62 KB) / 下載次數 945
http://telecom-cafe.com/forum/attachment.php?aid=935&k=9357e79ce51d9b20656e96276e1af2e2&t=1744001827&sid=wYX6h2

圖片附件: screenshot.03-10-2011 06.32.03.png (2011-10-3 06:39, 45.41 KB) / 下載次數 979
http://telecom-cafe.com/forum/attachment.php?aid=936&k=fa6e3e6ee28c8e8139949c82531e1469&t=1744001827&sid=wYX6h2

作者: bubblestar 時間: 2011-10-3 09:46

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

作者: ckleea 時間: 2011-10-3 12:46

回復 17# bubblestar

You need to enable CDR logging to mysql first.

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

作者: bubblestar 時間: 2011-10-3 13:19

本帖最後由 bubblestar 於 2011-10-3 13:34 編輯

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 時間: 2011-10-3 18:55

回復 19# bubblestar

Importcdr.php scripts can be found on #13

You need to enable cdr.conf and cdr_mysql.conf

作者: ckleea 時間: 2011-10-3 19:03

I have logging to both CSV and mysql database

作者: ckleea 時間: 2011-10-3 21:29

回復 15# ckleea

I can also get it running now. Not easy

作者: bubblestar 時間: 2011-10-4 13:17

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 時間: 2011-10-4 13:41

回復 23# bubblestar

Glad to hear

歡迎光臨電訊茶室 (http://telecom-cafe.com/forum/)