CDR Report

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

Hello,
I have little problem and a question.
The problem is CDR Report, it's not showing any calls.
I have configured Asterisk to store all CDRs into a mySQL database, which is working, but the table is in another database than a2billing is storing it's info, is this a problem, or is there a way to configure a2billing to look into that other database? Or does, a2billing have it's own table for CDRs? Because then I can just reconfigure asterisk to store CDRs in that table.
Version of A2B is 1.3, and Asterisk is 1.4

Now, the question.
Can I have a2billing charge my clients by call duration and it's calls? (I mean, call inside country, outside the country, call on mobile phone, stationary phone etc etc)
Is there also a way where I could put up a template for bills so I could easily print out bills and send them to my clients?
We have and offer people of using regular VoIP telephones, we're not using softphones or any of that(ok for testing only).
Or does a2billing work only with these so called cards, where a client must buy one and can then phone over the internet with a softphone?

stavros · **Posted:** Thu Aug 07, 2008 12:24 pm

xfirestorm wrote:

Or does, a2billing have it's own table for CDRs?

Yes it does, but it populates this table itself and therefore it doesn't need Asterisk to write here too.

Quote:

Version of A2B is 1.3

There was a bug fixed before the v1.3.3 release that could prevent CDRs from being shown if there were many of them. Do you have tens of thousands of CDRs in the cc_call table already? If so upgrading to v1.3.3 will probably fix this for you.

Quote:

Or does a2billing work only with these so called cards, where a client must buy one and can then phone over the internet with a softphone?

A2B can be used as a calling card platform, yes. Your client needn't use VoIP to reach you; you can offer access numbers, which are DIDs configured to answer with A2B's IVR.

Quote:

Can I have a2billing charge my clients by call duration and it's calls? (I mean, call inside country, outside the country, call on mobile phone, stationary phone etc etc)

That is the whole reason for A2B's existence: to bill customers for calls dependant upon the duration, destination and, in some cases, the access number used to reach A2B. Or am I missing some nuance of your question?

Quote:

Is there also a way where I could put up a template for bills so I could easily print out bills and send them to my clients?

To change the layout of the invoices you'll need to modify the code. If you're conversant with HTML you should give it a go. You needn't print them as A2B has a cron job to generate and email invoices once each month.

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

It can't be the bug problem, because I've put up a temporary test asterisk machine, just for a2b, and I've configured it, made a couple of internal calls, checked asterisk DB, and calls are there, about 10 altogether.
But the production one should have a couple of thousands calls by now yes, but I haven't tried it on a production system yet, I want to get it up and running on a test machine.

Let me first define our clients.
We have a linkup to our ISPs VoIP system, and we have an Asterisk PBX, which we use, so when we get a client who wants VoIP, we either configure them everything, linkup with their ISP, configure Asterisk on their machine etc etc. And even some of those clients have situations, like we have bellow.
But some clients don't want to get linkups with their ISP(don't ask why), so we just configure them their own Asterisk server and register it with our, so techincally they are calling at our expenses, but we had some payment per month now, don't know exactly how boss was doing this, I'm here for like 2 months now.
And now we want to have something like a2b or a2b exactly to charge our customers.

Edit:
Well the cc_call table in a2b database is empty, so I guess a2b doesn't even know about the calls.

stavros · **Posted:** Thu Aug 07, 2008 2:16 pm

xfirestorm wrote:

It can't be the bug problem
Well the cc_call table in a2b database is empty, so I guess a2b doesn't even know about the calls.

Do you have pcntl installed and working (described elsewhere on this forum, and probably in your distribution's documentation), and are you using DeadAGI() to launch A2B? What does A2B say (with debug=2) on the Asterisk console at the end of a call?

Quote:

And now we want to have something like a2b or a2b exactly to charge our customers.

A2B can be used simultaneously for calling card operation, and for wholesale VoIP interconnects (authenticated by user/pass, or IP address) with one-stage-dial.

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

This is the call from the console, when I run it with asterisk -vvvc
And I've set debug = 2 in asterisk.conf AND enabled debugging with agi debug in the console:

Quote:

*CLI> agi debug
AGI Debugging Enabled
*CLI> -- Executing [32@default:1] Macro("SIP/5063-095ff708", "voice-dial|IAX2/plvoip/32") in new stack
-- Executing [s@macro-voice-dial:1] Set("SIP/5063-095ff708", "LANGUAGE()=si") in new stack
[Aug 8 09:35:58] WARNING[4351]: func_language.c:61 language_write: LANGUAGE() is deprecated; use CHANNEL(language) instead.
-- Executing [s@macro-voice-dial:2] GotoIf("SIP/5063-095ff708", "1 ?|4") in new stack
-- Goto (macro-voice-dial,s,4)
-- Executing [s@macro-voice-dial:4] GotoIf("SIP/5063-095ff708", "1 ?|9") in new stack
-- Goto (macro-voice-dial,s,9)
-- Executing [s@macro-voice-dial:9] Dial("SIP/5063-095ff708", "IAX2/plvoip/32|90|r") in new stack
-- Called plvoip/32
-- Call accepted by 172.25.0.2 (format gsm)
-- Format for call is gsm
-- IAX2/plvoip-16384 is ringing
-- Hungup 'IAX2/plvoip-16384'
== Spawn extension (macro-voice-dial, s, 9) exited non-zero on 'SIP/5063-095ff708' in macro 'voice-dial'
== Spawn extension (macro-voice-dial, s, 9) exited non-zero on 'SIP/5063-095ff708'

And this is my extensions.conf file:

Quote:

[general]
;
static=yes
writeprotect=no

[globals]
CONSOLE=Console/dsp ; Console interface for demo
IAXINFO=guest ; IAXtel username/password
TRUNK=Zap/g2 ; Trunk interface
TRUNKMSD=1 ; MSD digits to strip (usually 1 or 0)

[from-sip]
ignorepat => 9
include => default

[local]
ignorepat => 9
include => default

;
; EXTENSIONS SHEME - VoIP-PBX
;
#include "./inc/macro-ivr-menu.inc"
#include "./inc/macro-dial-result.inc"
#include "./inc/macro-voice-dial.inc"
#include "./inc/macro-voice-dial-from-mobile.inc"
#include "./inc/macro-public-tdm-out.inc"
#include "./inc/macro-public-mobile-out.inc"
#include "./inc/voice-recording.inc"
#include "./inc/trunk-test.inc"
#include "./inc/queue-operations.inc"
#include "./inc/trunk-outgoing-centrex.inc"
#include "./inc/trunk-peers.inc"
#include "./inc/trunk-incoming-centrex.inc"
#include "./inc/trunk-incoming-mobile.inc"
#include "./inc/trunk-deny-service.inc"
#include "./inc/local-users.inc"

[user-group-1]

;include => trunk-deny-service-info
include => trunk-outgoing-centrex-g1
include => default

[user-group-2]

;include => trunk-deny-service-info
include => trunk-outgoing-centrex-g2
include => default

[user-group-3]

;include => trunk-deny-service-info
include => trunk-outgoing-centrex-g3
include => default

[users-restricted]

include => default

[default]
ignorepat => 9

;
; Najprej vklju"cevanje lokalnih uporabnikov
;
include => local-users

include => trunk-peers
include => trunk-incoming-centrex
include => trunk-incoming-mobile
include => trunk-test
include => parkedcalls
include => queue-operations
include => voice-recording
include => macro-public-mobile-out
include => macro-ivr-menu

[a2billing]
; CallingCard application
exten => _X.,1,Answer
exten => _X.,2,Wait,2
exten => _X.,3,DeadAGI,a2billing.php
exten => _X.,4,Wait,2
exten => _X.,5,Hangup

I have just copied this file from our production server and added a2billing section, I didn't want to rewrite it again.

stavros · **Posted:** Fri Aug 08, 2008 11:34 am

A2Billing can't bill and store CDRs for calls that it's not involved with. Modify your dialplan so it actually launches A2Billing and I'm sure you find CDRs are stored correctly.

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

Ok, I've managed, somehow. Now when making a call I get this in "asterisk -r":

Code:

    -- Executing [30@default:1] Macro("SIP/5070-08335c00", "voice-dial|IAX2/plvoip/30") in new stack
    -- Executing [s@macro-voice-dial:1] Set("SIP/5070-08335c00", "LANGUAGE()=si") in new stack
    -- Executing [s@macro-voice-dial:2] GotoIf("SIP/5070-08335c00", "1 ?|4") in new stack
    -- Goto (macro-voice-dial,s,4)
    -- Executing [s@macro-voice-dial:4] GotoIf("SIP/5070-08335c00", "1 ?|9") in new stack
    -- Goto (macro-voice-dial,s,9)
    -- Executing [s@macro-voice-dial:9] Wait("SIP/5070-08335c00", "2") in new stack
    -- Executing [s@macro-voice-dial:10] DeadAGI("SIP/5070-08335c00", "a2billing.php") in new stack
[Aug 11 13:52:52] WARNING[4546]: res_agi.c:2238 deadagi_exec: Running DeadAGI on a live channel will cause problems, please use AGI
    -- Launched AGI Script /var/lib/asterisk/agi-bin/a2billing.php
  a2billing.php: A2Billing AGI internal configuration:                                                                                                     

Then bunch of variables and at the end:

Code:

  a2billing.php: )
  a2billing.php:
  a2billing.php: file:Class.A2Billing.php - line:621 -  get_agi_request_parameter = tomaz ; SIP/5070-08335c00 ; asterisk-1218455570.7 ;  ; s
  a2billing.php: file:a2billing.php - line:141 - [ANSWER CALL]
  a2billing.php: file:Class.A2Billing.php - line:1788 - Requesting DTMF, CARDNUMBER_LENGTH_MAX 15
[Aug 11 13:52:54] WARNING[4546]: file.c:602 ast_openstream_full: File prepaid-enter-pin-number does not exist in any format
[Aug 11 13:52:54] WARNING[4546]: file.c:912 ast_streamfile: Unable to open prepaid-enter-pin-number (format 0x4 (ulaw)): No such file or directory
  a2billing.php: file:Class.A2Billing.php - line:1790 - RES DTMF : -1
  a2billing.php: file:Class.A2Billing.php - line:1794 - CARDNUMBER ::> -1
  a2billing.php: file:Class.A2Billing.php - line:1804 - PREPAID-INVALID-DIGITS
[Aug 11 13:52:54] WARNING[4546]: file.c:602 ast_openstream_full: File prepaid-invalid-digits does not exist in any format
  a2billing.php: file:Class.A2Billing.php - line:1780 - PREPAID-INVALID-DIGITS
  a2billing.php: file:Class.A2Billing.php - line:1788 - Requesting DTMF, CARDNUMBER_LENGTH_MAX 15
[Aug 11 13:52:54] WARNING[4546]: file.c:602 ast_openstream_full: File prepaid-enter-pin-number does not exist in any format
[Aug 11 13:52:54] WARNING[4546]: file.c:912 ast_streamfile: Unable to open prepaid-enter-pin-number (format 0x4 (ulaw)): No such file or directory
  a2billing.php: file:Class.A2Billing.php - line:1790 - RES DTMF : -1
  a2billing.php: file:Class.A2Billing.php - line:1794 - CARDNUMBER ::> -1
  a2billing.php: file:Class.A2Billing.php - line:1804 - PREPAID-INVALID-DIGITS
[Aug 11 13:52:54] WARNING[4546]: file.c:602 ast_openstream_full: File prepaid-invalid-digits does not exist in any format
  a2billing.php: file:Class.A2Billing.php - line:1780 - PREPAID-INVALID-DIGITS
  a2billing.php: file:Class.A2Billing.php - line:1788 - Requesting DTMF, CARDNUMBER_LENGTH_MAX 15
[Aug 11 13:52:54] WARNING[4546]: file.c:602 ast_openstream_full: File prepaid-enter-pin-number does not exist in any format
[Aug 11 13:52:54] WARNING[4546]: file.c:912 ast_streamfile: Unable to open prepaid-enter-pin-number (format 0x4 (ulaw)): No such file or directory
  a2billing.php: file:Class.A2Billing.php - line:1790 - RES DTMF : -1
  a2billing.php: file:Class.A2Billing.php - line:1794 - CARDNUMBER ::> -1
  a2billing.php: file:Class.A2Billing.php - line:1804 - PREPAID-INVALID-DIGITS
  a2billing.php: file:a2billing.php - line:319 - [AUTHENTICATION FAILED (cia_res:-1)]
    -- AGI Script a2billing.php completed, returning 0

And my softphone reports Remote user cleared the call

I don't understand one thing in these error lines, except AUTHENTICATION FAILED, but from here on I'm totaly lost.

stavros · **Posted:** Mon Aug 11, 2008 12:14 pm

See here

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

Those sounds did the trick, but is the PIN authorization necesary?
How can I switch this of? I don't want any of this functionality, I just want to be able to calculate up the expenses of calls for each client, send them a bill, electronicly or ordniray mail.

stavros · **Posted:** Mon Aug 11, 2008 1:18 pm

Familarise yourself with the contents of a2billing.conf. This post contains some clues.

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

This is sucking the life out of me...
I've managed to stop PIN requests, but now, each time I dial a number it and call it, I hear that darn voice to re-enter the number I'm calling and press some button. I can't manage to switch this off, read half of this forum, tried almost all configurations found on this forum, but neither work.

Well this appears only for numbers that are NOT on this asterisk instalation but are on our production asterisk installation, I connect the two via IAX2.
If I open up another account on my test installation then I don't get the prompt to re-enter the number, but then I get another error, which I think I'll be able to handle.

stavros · **Posted:** Wed Aug 13, 2008 12:55 pm

Without a better description of scenario it's difficult to be sure, but I think the setting you've spent so long seeking is known as use_dnid.

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

Which is set to YES, and as far as I understand, I think this should normaly just call the Destination Number ID, without prompting for an entry right?
Well it does.
Here's the output of asterisk:

Quote:

About that PIN, it seems it was some problem with my softphone, as it did not want to register with asterisk for some reason.

stavros · **Posted:** Wed Aug 13, 2008 1:58 pm

xfirestorm wrote:

Which is set to YES, and as far as I understand, I think this should normaly just call the Destination Number ID, without prompting for an entry right?

That's right, but it does depend on you providing that dialled number to A2B via the Asterisk dialplan. Currently you're replacing the number with 's', which is why you're receiving a prompt for the destination:

Quote:

-- Executing [s@macro-voice-dial:9]
...
a2billing.php|1: [agi_extension] => s

See this post about how to integrate properly with FreePBX.

xfirestorm · **Joined:** Thu Aug 07, 2008 7:51 am **Posts:** 16

I've tried that what you said over there, but it didn't work, so I changed it a little, but it's still not working.
Now agi_extension is showing the number I'm dialing, is this ok, or must it show something else?

Edit: Sorry that I'm such a pain in the you know what.
I've changed the a2billing.conf so many time that not even the authors of a2billing would recognize it, so I copied it over once more, and now, I think it's ok, but the phone isn't rining(it could be because I didn't yet set up the dial plan in A2B only in asterisk). So this is what I get at the end:

Quote:

a2billing.php: file:a2billing.php - line:92 - Array
a2billing.php: (
a2billing.php: [agi_request] => a2billing.php
a2billing.php: [agi_channel] => SIP/2490138548-086d63d8
a2billing.php: [agi_language] => si
a2billing.php: [agi_type] => SIP
a2billing.php: [agi_uniqueid] => asterisk-1218712089.37
a2billing.php: [agi_callerid] => 346270722130500
a2billing.php: [agi_calleridname] => Tomaz Lovrec
a2billing.php: [agi_callingpres] => 0
a2billing.php: [agi_callingani2] => 0
a2billing.php: [agi_callington] => 0
a2billing.php: [agi_callingtns] => 0
a2billing.php: [agi_dnid] => 32
a2billing.php: [agi_rdnis] => unknown
a2billing.php: [agi_context] => macro-voice-dial
a2billing.php: [agi_extension] => s
a2billing.php: [agi_priority] => 9
a2billing.php: [agi_enhanced] => 0.0
a2billing.php: [agi_accountcode] => 2490138548
a2billing.php: )
a2billing.php:
a2billing.php: file:Class.A2Billing.php - line:621 - get_agi_request_parameter = 346270722130500 ; SIP/2490138548-086d63d8 ; asterisk-1218712089.37 ; 2490138548 ; s
-- AGI Script a2billing.php completed, returning 0
== Auto fallthrough, channel 'SIP/2490138548-086d63d8' status is 'UNKNOWN'

Added after 2 hours 27 minutes:

Scratch that. Something interesting.
I have 3 phone numbers on our asterisk installations.
1 installation is a production installation, and so that I don't mess it up, I've installed another one on another machine(test installation).
I'm connecting these two installations via IAX2 peers and registry:

Quote:

n24-199*CLI> iax2 show peers
Name/Username Host Mask Port Status
plvoip 172.25.0.2 (D) 255.255.255.255 4569 (T) OK (21 ms)

n24-199*CLI> iax2 show registry
Host dnsmgr Username Perceived Refresh State
172.25.0.2:4569 N n24-199 172.24.0.199:4569 20 Registered

So the numbers are:
- 32 (located on production installation, which has only Asterisk BRIstuffed)
- 199 (located on test installation)
- and my number (located on test installation)

Now, when I call number 32, which is on a different asterisk without a2b I get this:

Quote:

a2billing.php: file:Class.A2Billing.php - line:621 - get_agi_request_parameter = 346270722130500 ; SIP/2490138548-0870fac0 ; asterisk-1218714928.66 ; 2490138548 ; s
a2billing.php: file:a2billing.php - line:145 - [NO ANSWER CALL]
a2billing.php: file:Class.A2Billing.php - line:1640 - SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='2490138548'
a2billing.php: file:Class.A2Billing.php - line:1714 - [SET CHANNEL(language) en]
a2billing.php: file:Class.A2Billing.php - line:654 - [CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='2490138548']
a2billing.php: file:Class.A2Billing.php - line:1400 - [AUTO SetCallerID]
a2billing.php: file:Class.A2Billing.php - line:1406 - [REQUESTED SetCallerID : 346270722130500]
a2billing.php: file:Class.A2Billing.php - line:1417 - [EXEC SetCallerID : 346270722130500]
a2billing.php: file:a2billing.php - line:172 - [CHANNEL STATUS : 4 = Line is ringing]
a2billing.php: file:a2billing.php - line:173 - [CREDIT : 500][CREDIT MIN_CREDIT_2CALL : 0]
a2billing.php: file:Class.A2Billing.php - line:676 - 1 && && 2&& 0
-- <SIP/2490138548-0870fac0> Playing 'prepaid-enter-dest' (language 'en')

The destination to dial should be IAX2/plvoip/32,
but when I try to call number 199 which is on the same asterisk installation as my number, I get this:

Quote:

a2billing.php: file:Class.A2Billing.php - line:621 - get_agi_request_parameter = 346270722130500 ; SIP/2490138548-086d63d8 ; asterisk-1218714916.65 ; 2490138548 ; s
a2billing.php: file:a2billing.php - line:145 - [NO ANSWER CALL]
a2billing.php: file:Class.A2Billing.php - line:1640 - SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id WHERE username='2490138548'
a2billing.php: file:Class.A2Billing.php - line:1714 - [SET CHANNEL(language) en]
a2billing.php: file:Class.A2Billing.php - line:654 - [CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='2490138548']
a2billing.php: file:Class.A2Billing.php - line:1400 - [AUTO SetCallerID]
a2billing.php: file:Class.A2Billing.php - line:1406 - [REQUESTED SetCallerID : 346270722130500]
a2billing.php: file:Class.A2Billing.php - line:1417 - [EXEC SetCallerID : 346270722130500]
a2billing.php: file:a2billing.php - line:172 - [CHANNEL STATUS : 4 = Line is ringing]
a2billing.php: file:a2billing.php - line:173 - [CREDIT : 500][CREDIT MIN_CREDIT_2CALL : 0]
a2billing.php: file:Class.A2Billing.php - line:676 - 1 && && 3&& 0
a2billing.php: file:Class.A2Billing.php - line:701 - DESTINATION ::> 199
a2billing.php: file:Class.A2Billing.php - line:703 - RULES APPLY ON DESTINATION ::> 199
a2billing.php: file:Class.A2Billing.php - line:739 - ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard (Please check : id the ratecard is well create ; if the removeInter_Prefix is set according to your prefix in the ratecard ; if you hooked the ratecard to the Call Plan)
a2billing.php: file:Class.A2Billing.php - line:654 - [CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='2490138548']
-- AGI Script a2billing.php completed, returning 0

So unless I'm blind, when I try to call number 199, the destination goes through just perfectly but then strikes another error. But when I try to call number 32, it asks me to redial the number who I wish to call. These two errors are, at least to me, not even remotely connected, so there must be an error somewhere else, not that the number wouldn't be provided to a2b, am I right?

Now how to fix this? Could this be that I have not yet configured a dial plan in A2B?

provided by Star2Billing S.L.

CDR Report

Who is online