Support A2Billing :

provided by Star2Billing S.L.

 Support A2Billing :
It is currently Thu Apr 18, 2024 1:17 pm
Hosted Voice Broadcast

View unanswered posts | View active topics


Board index » Features » CALLBACK

All times are UTC




Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
canadian
 Post subject: cid-callback seen as all-callback + prefix problem
PostPosted: Tue Nov 07, 2006 8:44 pm 
Offline

Joined: Tue Nov 07, 2006 8:25 pm
Posts: 23
Hi,

I have trouble to make cid-callback work (SIP trunk for incoming and outgoing calls), I noticed that the SQL query is weird (prefix is the full number) and also that the AGI doesn't see it's a CID-callback (ALL-CALLBACK MODE), see below:

asterisk logs
Code:
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Executing Goto("SIP/XXX-1-6ef9", "custom-a2billing-cid-callback|s|1") in new stack
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Goto (custom-a2billing-cid-callback,s,1)
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Executing DeadAGI("SIP/XXX-1-6ef9", "a2billing.php|1|all-callback|514") in new stack
Nov 7 15:22:38 VERBOSE[8203] logger.c: -- Launched AGI Script /var/lib/asterisk/agi-bin/a2billing.php
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:58 - IDCONFIG : 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:67 - MODE : all-callback
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: A2Billing AGI internal configuration:
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: Array
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [debug] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [answer_call] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [logger_enable] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [log_file] => /tmp/a2billing.log
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_goodbye] =>
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [play_menulanguage] => 1
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [force_language] => EN
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [intro_prompt] =>
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [len_cardnumber] => 10
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [len_aliasnumber] => 15
Nov 7 15:22:38 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [len_voucher] => 15
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [min_credit_2call] => 0
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [min_duration_2bill] => 2
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [notenoughcredit_cardnumber] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [notenoughcredit_assign_newcardnumber_cid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [use_dnid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [no_auth_dnid] => Array
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] => 2400
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [1] => 2300
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [number_try] => 3
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_balance_after_auth] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_balance_after_call] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_rateinitial] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [say_timetocall] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [auto_setcallerid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [force_callerid] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_sanitize] => BOTH
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_enable] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_askpincode_ifnot_callerid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card] =>
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_assign_card_to_cid] => 1
Nov 7 15:22:39 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_typepaid] => POSTPAY
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_credit] => 0
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_credit_limit] => 5
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cid_auto_create_card_tariffgroup] => 6
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [callerid_authentication_over_cardnumber] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [sip_iax_friends] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [sip_iax_pstn_direct_call_prefix] => 9
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [sip_iax_pstn_direct_call] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [extracharge_did] => Array
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [extracharge_fee] => Array
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [dialcommand_param] => |30|HL(%timeout%:61000:30000)
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [dialcommand_param_sipiax_friend] => |30|HL(3600000:61000:30000)
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [switchdialcommand] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [maxtime_tocall_negatif_free_route] => 300
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [send_reminder] =>
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [record_call] => 1
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [monitor_formatfile] => gsm
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [base_currency] => CAD
Nov 7 15:22:40 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_force_currency] =>
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [currency_association] => Array
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [0] => cad:prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [1] => usd:prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [2] => mxn:pesos
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [3] => eur:euro
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [4] => all:credit
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [file_conf_enter_destination] => prepaid-enter-dest
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [file_conf_enter_menulang] => prepaid-menulang2
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [currency_association_internal] => Array
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [cad] => prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [usd] => prepaid-dollar
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [mxn] => pesos
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [eur] => euro
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [all] => credit
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:41 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: AGI Request:
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: Array
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: (
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_request] => a2billing.php
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_channel] => SIP/XXX-1-6ef9
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_language] => en
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_type] => SIP
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_uniqueid] => 1162930958.26630
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callerid] => 5145551111
Nov 7 15:22:42 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_calleridname] => OPENFACE INTERN
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callingpres] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callingani2] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callington] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_callingtns] => 0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_dnid] => 5144480254
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_rdnis] => unknown
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_context] => custom-a2billing-cid-callback
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_extension] => s
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_priority] => 1
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_enhanced] => 0.0
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: [agi_accountcode] =>
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: )
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514:
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:490 get_agi_request_parameter = 5145551111 ; SIP/XXX-1-6ef9 ; 1162930958.26630 ; ; s
Nov 7 15:22:43 VERBOSE[8203] logger.c: a2billing.php|1|all-callback|514: line:565 - [MODE : ALL-CALLBACK - 5145551111]


then in the a2billing log:

Code:
[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[CC_asterisk_rate-engine: (1, 5145145551111)]
[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[CC_asterisk_rate-engine: SUPER QUERY]
SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
      
      cc_ratecard.id,   dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock,
      connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,
      timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,   
      cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,
      tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,
      cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,
      rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix,
      musiconhold,
      tp_trunk.failover_trunk AS tp_failover_trunk,
      rt_trunk.failover_trunk AS rt_failover_trunk,
      tp_trunk.addparameter AS tp_addparameter_trunk,
      rt_trunk.addparameter AS rt_addparameter_trunk
      
      
      FROM cc_tariffgroup
      RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=1
      
      INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
      
      LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
      LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
      LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
      
      WHERE (dialprefix=SUBSTRING('5145145551111',1,length(dialprefix)) OR dialprefix='defaultprefix')
      AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
      AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
       AND (starttime <= 2362 AND endtime >=2362)
      AND idtariffgroup='1'
      
      AND ( cc_tariffplan.dnidprefix LIKE '5145145551111%' OR (cc_tariffplan.dnidprefix='all' AND 0 = 0))
      
      
      ORDER BY LENGTH(dialprefix) DESC

[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[CALLBACK-CALLERID : CALLED=5145145551111 | Error : There is no route to call back your phonenumber !!!]
[07/11/2006 15:22:43]:[CallerID:5145551111]:[CN:]:[exit]


I have a tariff for 514 area code, using the default SIP trunk and "callerid authentication" is set to yes in a2billing.conf.

I don't understand what's wrong, please help !!
Top
 Profile  
 
canadian
 Post subject:
PostPosted: Tue Nov 07, 2006 9:13 pm 
Offline

Joined: Tue Nov 07, 2006 8:25 pm
Posts: 23
I forgot to mention, I use:
Asterisk@home 2.7 (Asterisk 1.2.5)
pcntl is installed
Top
 Profile  
 
canadian
 Post subject:
PostPosted: Tue Nov 07, 2006 10:38 pm 
Offline

Joined: Tue Nov 07, 2006 8:25 pm
Posts: 23
FIXED.

it was DNID PREFIX in ratecard, it was set at 514 and not "all".
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
Auto Dialer Software


Board index » Features » CALLBACK

All times are UTC


Who is online

Users browsing this forum: No registered users and 8 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Advertisements by Advertisement Management