provided by Star2Billing S.L.

Hello Everyone,
i having problem with callback config, i have searched this probem in the form and i make everythink but i still having problem. Our config is below,

sip.conf

[inbound]
type=peer
dtmfmode=rfc2833
context=a2billing-cid-callbacknew
insecure=very
host=192.168.1.6
nat=no

additional_a2billing_sip.conf,

[4443807376]
type=friend
username=4443807376
accountcode=4443807376
regexten=4443807376
callerid=05925989999
amaflags=billing
secret=4443807376
nat=yes
dtmfmode=RFC2833
qualify=yes
canreinvite=yes
disallow=all
allow=ulaw
allow= alaw
allow= gsm
allow= g729
host=dynamic
context=a2billing-cid-callbacknew
regseconds=0
cancallforward=yes

extensions.comf,

[a2billing-cid-callbacknew]
exten => 1360717xxxx,1,Ringing()
exten => 1360717xxxx,n,DeadAGI(a2billing.php|2|cid-callback)
exten => 1360717xxxx,n,Wait(60)

a2billing.conf

[agi-conf2]

debug = 3

asterisk_version = 1_4

answer_call = YES

play_audio = YES

say_goodbye = NO

play_menulanguage = NO

force_language =

intro_prompt =

min_credit_2call = 0

min_duration_2bill = 0

notenoughcredit_cardnumber = YES

notenoughcredit_assign_newcardnumber_cid = NO

use_dnid = NO

no_auth_dnid = 2400,2300

number_try = 1

force_callplan_id =

say_balance_after_auth = NO

say_balance_after_call = NO

say_rateinitial = NO

say_timetocall = NO

auto_setcallerid = YES

force_callerid =

cid_sanitize = NO

cid_enable = YES

cid_askpincode_ifnot_callerid = YES

cid_auto_assign_card_to_cid = YES

cid_auto_create_card = NO

cid_auto_create_card_len = 10

cid_auto_create_card_typepaid = POSTPAY

cid_auto_create_card_credit = 0

cid_auto_create_card_credit_limit = 1000

cid_auto_create_card_tariffgroup = 6

callerid_authentication_over_cardnumber = NO

sip_iax_friends = NO

sip_iax_pstn_direct_call = NO

ivr_voucher = NO

ivr_voucher_prefix = 8

jump_voucher_if_min_credit = NO

extracharge_did =

extracharge_fee =

dialcommand_param = "|60|HRrL(%timeout%:61000:30000)"

dialcommand_param_sipiax_friend = "|60|HL(3600000:61000:30000)"

switchdialcommand = NO

failover_recursive_limit = 2

maxtime_tocall_negatif_free_route = 5400

send_reminder = NO

record_call = NO

monitor_formatfile = gsm

agi_force_currency =

currency_association = usd:dollars,mxn:pesos,eur:euros,all:credit

file_conf_enter_destination = prepaid-enter-dest

file_conf_enter_menulang = prepaid-menulang2

callback_bill_1stleg_ifcall_notconnected = YES

My mobile phone number is 05925989999
My toll free number is 1360717xxxx

asterisk log,
localhost*CLI>
-- Executing [1360717xxxx@a2billing-cid-callbacknew:1] Ringing("SIP/192.168.1.9-09fa0bb8", "") in new stack
-- Executing [1360717xxxx@a2billing-cid-callbacknew:2] DeadAGI("SIP/192.168.1.9-09fa0bb8", "a2billing.php|2|cid-callback") in new stack
[Oct 26 10:24:23] WARNING[5484]: res_agi.c:2116 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|2|cid-callback: A2Billing AGI internal configuration:
a2billing.php|2|cid-callback: Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [debug] => 3
a2billing.php|2|cid-callback: [asterisk_version] => 1_2
a2billing.php|2|cid-callback: [answer_call] =>
a2billing.php|2|cid-callback: [play_audio] => 1
a2billing.php|2|cid-callback: [say_goodbye] =>
a2billing.php|2|cid-callback: [play_menulanguage] =>
a2billing.php|2|cid-callback: [force_language] =>
a2billing.php|2|cid-callback: [intro_prompt] =>
a2billing.php|2|cid-callback: [min_credit_2call] => 0
a2billing.php|2|cid-callback: [min_duration_2bill] => 0
a2billing.php|2|cid-callback: [notenoughcredit_cardnumber] => 1
a2billing.php|2|cid-callback: [notenoughcredit_assign_newcardnumber_cid] => 1
a2billing.php|2|cid-callback: [use_dnid] => 1
a2billing.php|2|cid-callback: [no_auth_dnid] => Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [0] => 2400
a2billing.php|2|cid-callback: [1] => 2300
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: [number_try] => 3
a2billing.php|2|cid-callback: [force_callplan_id] =>
a2billing.php|2|cid-callback: [say_balance_after_auth] =>
a2billing.php|2|cid-callback: [say_balance_after_call] =>
a2billing.php|2|cid-callback: [say_rateinitial] =>
a2billing.php|2|cid-callback: [say_timetocall] =>
a2billing.php|2|cid-callback: [auto_setcallerid] => 1
a2billing.php|2|cid-callback: [force_callerid] =>
a2billing.php|2|cid-callback: [cid_sanitize] =>
a2billing.php|2|cid-callback: [cid_enable] => 1
a2billing.php|2|cid-callback: [cid_askpincode_ifnot_callerid] => 1
a2billing.php|2|cid-callback: [cid_auto_assign_card_to_cid] => 1
a2billing.php|2|cid-callback: [cid_auto_create_card] =>
a2billing.php|2|cid-callback: [cid_auto_create_card_len] => 10
a2billing.php|2|cid-callback: [cid_auto_create_card_typepaid] => POSTPAY
a2billing.php|2|cid-callback: [cid_auto_create_card_credit] => 0
a2billing.php|2|cid-callback: [cid_auto_create_card_credit_limit] => 1000
a2billing.php|2|cid-callback: [cid_auto_create_card_tariffgroup] => 6
a2billing.php|2|cid-callback: [callerid_authentication_over_cardnumber] =>
a2billing.php|2|cid-callback: [sip_iax_friends] =>
a2billing.php|2|cid-callback: [sip_iax_pstn_direct_call_prefix] => 555
a2billing.php|2|cid-callback: [sip_iax_pstn_direct_call] =>
a2billing.php|2|cid-callback: [ivr_voucher] =>
a2billing.php|2|cid-callback: [ivr_voucher_prefix] => 8
a2billing.php|2|cid-callback: [jump_voucher_if_min_credit] =>
a2billing.php|2|cid-callback: [extracharge_did] => Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [0] =>
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: [extracharge_fee] => Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [0] =>
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: [dialcommand_param] => |60|HRrL(%timeout%:61000:30000)
a2billing.php|2|cid-callback: [dialcommand_param_sipiax_friend] => |60|HL(3600000:61000:30000)
a2billing.php|2|cid-callback: [switchdialcommand] =>
a2billing.php|2|cid-callback: [failover_recursive_limit] => 2
a2billing.php|2|cid-callback: [maxtime_tocall_negatif_free_route] => 5400
a2billing.php|2|cid-callback: [send_reminder] =>
a2billing.php|2|cid-callback: [record_call] =>
a2billing.php|2|cid-callback: [monitor_formatfile] => gsm
a2billing.php|2|cid-callback: [agi_force_currency] =>
a2billing.php|2|cid-callback: [currency_association] => Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [0] => usd:dollars
a2billing.php|2|cid-callback: [1] => mxn:pesos
a2billing.php|2|cid-callback: [2] => eur:euros
a2billing.php|2|cid-callback: [3] => all:credit
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: [file_conf_enter_destination] => prepaid-enter-dest
a2billing.php|2|cid-callback: [file_conf_enter_menulang] => prepaid-menulang2
a2billing.php|2|cid-callback: [callback_bill_1stleg_ifcall_notconnected] => 1
a2billing.php|2|cid-callback: [logger_enable] => 1
a2billing.php|2|cid-callback: [log_file] => /tmp/a2billing.log
a2billing.php|2|cid-callback: [currency_association_internal] => Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [usd] => dollars
a2billing.php|2|cid-callback: [mxn] => pesos
a2billing.php|2|cid-callback: [eur] => euros
a2billing.php|2|cid-callback: [all] => credit
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: [ivr_voucher_prefixe] => 8
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: file:a2billing.php - line:75 - IDCONFIG : 2
a2billing.php|2|cid-callback: file:a2billing.php - line:76 - MODE : cid-callback
a2billing.php|2|cid-callback: file:a2billing.php - line:88 - AGI Request:
a2billing.php|2|cid-callback: file:a2billing.php - line:89 - Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [agi_request] => a2billing.php
a2billing.php|2|cid-callback: [agi_channel] => SIP/192.168.1.9-09fa0bb8
a2billing.php|2|cid-callback: [agi_language] => en
a2billing.php|2|cid-callback: [agi_type] => SIP
a2billing.php|2|cid-callback: [agi_uniqueid] => 1193408663.1
a2billing.php|2|cid-callback: [agi_callerid] => 05925989999
a2billing.php|2|cid-callback: [agi_calleridname] => 05925989999
a2billing.php|2|cid-callback: [agi_callingpres] => 0
a2billing.php|2|cid-callback: [agi_callingani2] => 0
a2billing.php|2|cid-callback: [agi_callington] => 0
a2billing.php|2|cid-callback: [agi_callingtns] => 0
a2billing.php|2|cid-callback: [agi_dnid] => 1360717xxxx
a2billing.php|2|cid-callback: [agi_rdnis] => unknown
a2billing.php|2|cid-callback: [agi_context] => a2billing-cid-callbacknew
a2billing.php|2|cid-callback: [agi_extension] => 1360717xxxx
a2billing.php|2|cid-callback: [agi_priority] => 2
a2billing.php|2|cid-callback: [agi_enhanced] => 0.0
a2billing.php|2|cid-callback: [agi_accountcode] =>
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: file:Class.A2Billing.php - line:601 - get_agi_request_parameter = 05925989999 ; SIP/192.168.1.9-09fa0bb8 ; 1193408663.1 ; ; 1360717xxxx
a2billing.php|2|cid-callback: file:a2billing.php - line:406 - [MODE : CALLERID-CALLBACK - 05925989999]
a2billing.php|2|cid-callback: file:Class.A2Billing.php - line:1466 - [CID_ENABLE - CID_CONTROL - CID:05925989999]
a2billing.php|2|cid-callback: file:Class.A2Billing.php - line:1483 - QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.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_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='05925989999'
a2billing.php|2|cid-callback: RESULT : Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [0] => Array
a2billing.php|2|cid-callback: (
a2billing.php|2|cid-callback: [0] => 05925989999
a2billing.php|2|cid-callback: [cid] => 05925989999
a2billing.php|2|cid-callback: [1] => 2
a2billing.php|2|cid-callback: [id_cc_card] => 2
a2billing.php|2|cid-callback: [2] => t
a2billing.php|2|cid-callback: [activated] => t
a2billing.php|2|cid-callback: [3] => 14.81900
a2billing.php|2|cid-callback: [credit] => 14.81900
a2billing.php|2|cid-callback: [4] => 1
a2billing.php|2|cid-callback: [tariff] => 1
a2billing.php|2|cid-callback: [5] => t
a2billing.php|2|cid-callback: [6] => 0
a2billing.php|2|cid-callback: [inuse] => 0
a2billing.php|2|cid-callback: [7] => 0
a2billing.php|2|cid-callback: [simultaccess] => 0
a2billing.php|2|cid-callback: [8] => 0
a2billing.php|2|cid-callback: [typepaid] => 0
a2billing.php|2|cid-callback: [9] =>
a2billing.php|2|cid-callback: [creditlimit] =>
a2billing.php|2|cid-callback: [10] => en
a2billing.php|2|cid-callback: [language] => en
a2billing.php|2|cid-callback: [11] => 4443807376
a2billing.php|2|cid-callback: [username] => 4443807376
a2billing.php|2|cid-callback: [12] => 0
a2billing.php|2|cid-callback: [removeinterprefix] => 0
a2billing.php|2|cid-callback: [13] => 06454563171
a2billing.php|2|cid-callback: [redial] => 06454563171
a2billing.php|2|cid-callback: [14] => 0
a2billing.php|2|cid-callback: [enableexpire] => 0
a2billing.php|2|cid-callback: [15] => 1508334227
a2billing.php|2|cid-callback: [UNIX_TIMESTAMP(expirationdate)] => 1508334227
a2billing.php|2|cid-callback: [16] => 0
a2billing.php|2|cid-callback: [expiredays] => 0
a2billing.php|2|cid-callback: [17] => 8
a2billing.php|2|cid-callback: [nbused] => 8
a2billing.php|2|cid-callback: [18] => 1192787833
a2billing.php|2|cid-callback: [UNIX_TIMESTAMP(firstusedate)] => 1192787833
a2billing.php|2|cid-callback: [19] => 1192715132
a2billing.php|2|cid-callback: [UNIX_TIMESTAMP(cc_card.creationdate)] => 1192715132
a2billing.php|2|cid-callback: [20] => USD
a2billing.php|2|cid-callback: [currency] => USD
a2billing.php|2|cid-callback: [21] =>
a2billing.php|2|cid-callback: [lastname] =>
a2billing.php|2|cid-callback: [22] =>
a2billing.php|2|cid-callback: [firstname] =>
a2billing.php|2|cid-callback: [23] =>
a2billing.php|2|cid-callback: [email] =>
a2billing.php|2|cid-callback: [24] => 2170786081
a2billing.php|2|cid-callback: [uipass] => 2170786081
a2billing.php|2|cid-callback: [25] => -1
a2billing.php|2|cid-callback: [id_campaign] => -1
a2billing.php|2|cid-callback: [26] => 2
a2billing.php|2|cid-callback: [id] => 2
a2billing.php|2|cid-callback: [27] => 039411991944140
a2billing.php|2|cid-callback: [useralias] => 039411991944140
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: )
a2billing.php|2|cid-callback:
a2billing.php|2|cid-callback: file:Class.A2Billing.php - line:1742 - [SET LANGUAGE() en]
a2billing.php|2|cid-callback: file:Class.A2Billing.php - line:634 - [CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='4443807376']
a2billing.php|2|cid-callback: file:a2billing.php - line:419 - [TRY : callingcard_ivr_authenticate]
a2billing.php|2|cid-callback: file:a2billing.php - line:434 - [destination: - 05925989999]
a2billing.php|2|cid-callback: file:a2billing.php - line:438 - [resfindrate: - 1]
a2billing.php|2|cid-callback: file:Class.A2Billing.php - line:634 - [CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='4443807376']
-- AGI Script a2billing.php completed, returning 0

[root@localhost /]# service asterisk status
asterisk (pid 5139) is running...

[root@localhost /]# service a2billing-callback-daemon status
a2billing-callback-daemon (pid 4487) is running...

i am calling this number 1360717xxxx with my mobile phone but callback application is not working,

somebody have idea, where is the problem?

Best regards,

That looks like it should have queued a callback properly.
Does the callback daemon's log file hold any clues?
How about the list of queued callbacks in the Admin interface?

Hello,
i have wrote a2billing_agi log files, pls check,

[27/10/2007 20:41:39]:[file:a2billing.php - line:75]:[CallerID:]:[CN:]:[IDCONFIG : 2]
[27/10/2007 20:41:39]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[MODE : cid-callback]
[27/10/2007 20:41:39]:[file:Class.A2Billing.php - line:601]:[CallerID:05925989999]:[CN:]:[ get_agi_request_parameter = 05925989999 ; SIP/192.168.1.9-09b36df8 ; 1193532093.0 ; ; 1360717xxxx]
[27/10/2007 20:41:39]:[file:a2billing.php - line:406]:[CallerID:05925989999]:[CN:]:[[MODE : CALLERID-CALLBACK - 05925989999]]
[27/10/2007 20:41:39]:[file:Class.A2Billing.php - line:1465]:[CallerID:05925989999]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:05925989999]]
[27/10/2007 20:41:39]:[file:Class.A2Billing.php - line:1466]:[CallerID:05925989999]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:05925989999]]
[27/10/2007 20:41:40]:[file:Class.A2Billing.php - line:1483]:[CallerID:05925989999]:[CN:]:[QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.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_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='05925989999'
RESULT : Array
(
[0] => Array
(
[0] => 05925989999
[cid] => 05925989999
[1] => 2
[id_cc_card] => 2
[2] => t
[activated] => t
[3] => 14.60900
[credit] => 14.60900
[4] => 1
[tariff] => 1
[5] => t
[6] => 0
[inuse] => 0
[7] => 0
[simultaccess] => 0
[8] => 0
[typepaid] => 0
[9] =>
[creditlimit] =>
[10] => en
[language] => en
[11] => 4443807376
[username] => 4443807376
[12] => 0
[removeinterprefix] => 0
[13] => X.X.X.X
[redial] => X.X.X.X
[14] => 0
[enableexpire] => 0
[15] => 1508334227
[UNIX_TIMESTAMP(expirationdate)] => 1508334227
[16] => 0
[expiredays] => 0
[17] => 11
[nbused] => 11
[18] => 1192787833
[UNIX_TIMESTAMP(firstusedate)] => 1192787833
[19] => 1192715132
[UNIX_TIMESTAMP(cc_card.creationdate)] => 1192715132
[20] => USD
[currency] => USD
[21] =>
[lastname] =>
[22] =>
[firstname] =>
[23] =>
[email] =>
[24] => 2170786081
[uipass] => 2170786081
[25] => -1
[id_campaign] => -1
[26] => 2
[id] => 2
[27] => 039411991944140
[useralias] => 039411991944140
)

)
]
[27/10/2007 20:41:40]:[file:Class.A2Billing.php - line:1653]:[CallerID:05925989999]:[CN:]:[ - Account code - 4443807376]
[27/10/2007 20:41:40]:[file:Class.A2Billing.php - line:1742]:[CallerID:05925989999]:[CN:4443807376]:[[SET LANGUAGE() en]]
[27/10/2007 20:41:40]:[file:Class.A2Billing.php - line:1745]:[CallerID:05925989999]:[CN:4443807376]:[[credit=14.60900 :: tariff=1 :: active=t :: isused=0 :: simultaccess=0 :: typepaid=0 :: creditlimit= :: language=en]]
[27/10/2007 20:41:40]:[file:Class.A2Billing.php - line:634]:[CallerID:05925989999]:[CN:4443807376]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='4443807376']]
[27/10/2007 20:41:40]:[file:a2billing.php - line:419]:[CallerID:05925989999]:[CN:4443807376]:[[TRY : callingcard_ivr_authenticate]]
[27/10/2007 20:41:40]:[file:a2billing.php - line:434]:[CallerID:05925989999]:[CN:4443807376]:[[destination: - 05925989999]]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:72]:[CallerID:05925989999]:[CN:4443807376]:[[CC_asterisk_rate-engine: (1, 05925989999)]]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:121]:[CallerID:05925989999]:[CN:4443807376]:[[CC_asterisk_rate-engine: CALLERID]
05925989999
]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:135]:[CallerID:05925989999]:[CN:4443807376]:[[CALLERID_QUERY]
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=1 WHERE calleridprefix=SUBSTRING('05925989999',1,length(calleridprefix))
[RESULT]Array
(
[0] => Array
(
[0] => 0
[count(calleridprefix)] => 0
)

)

]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:181]:[CallerID:05925989999]:[CN:4443807376]:[[RATE ENGINE 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,
id_outbound_cidgroup,
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer


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
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer

WHERE (dialprefix=SUBSTRING('05925989999',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 <= 8441 AND endtime >=8441)
AND idtariffgroup='1'
AND ( dnidprefix=SUBSTRING('05925989999',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('05925989999',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:191]:[CallerID:05925989999]:[CN:4443807376]:[[rate-engine: Count Total result 1]]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:280]:[CallerID:05925989999]:[CN:4443807376]:[[CC_asterisk_rate-engine: Count Total result 1]]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:281]:[CallerID:05925989999]:[CN:4443807376]:[[CC_asterisk_rate-engine: number_trunk 1]]
[27/10/2007 20:41:40]:[file:a2billing.php - line:438]:[CallerID:05925989999]:[CN:4443807376]:[[resfindrate: - 1]]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:293]:[CallerID:05925989999]:[CN:4443807376]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (14.60900)]]
[27/10/2007 20:41:40]:[file:Class.RateEngine.php - line:299]:[CallerID:05925989999]:[CN:4443807376]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:12510]]
[27/10/2007 20:41:40]:[file:a2billing.php - line:523]:[CallerID:05925989999]:[CN:4443807376]:[[CALLBACK-ALL : INSERT CALLBACK REQUEST IN SPOOL : QUERY= INSERT INTO cc_callback_spool (uniqueid, status, server_ip, num_attempt, channel, exten, context, priority, variable, id_server_group, callback_time, account, callerid, timeout ) VALUES ('20414-91halsg', 'PENDING', 'localhost', '0', 'SIP/X.X.X.X/05925989999', '1000', 'a2billing-callback', '1', 'CALLED=05925989999|MODE=CID|CBID=20414-91halsg|LEG=4443807376', '1', ADDDATE( CURRENT_TIMESTAMP, INTERVAL 10 SECOND ), '4443807376', '05925989999', '30000')]]
[27/10/2007 20:41:40]:[file:Class.A2Billing.php - line:634]:[CallerID:05925989999]:[CN:4443807376]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='4443807376']]
[27/10/2007 20:41:40]:[CallerID:05925989999]:[CN:4443807376]:[[exit]]


i didn't found, where is the wrong?

Again this shows you successfully queueing a callback.

Your screenshot shows 'agi result' and 'manager result' are empty but status is 'ERROR' (not 'PENDING') so the callback daemon is running and tried to process the call but failed for some reason.

Again: