provided by Star2Billing S.L.

Hello everybody and thank you for reading my post.

I had A2Billing 1.4 installed and working perfectly, however, after reboot, suddenly every call I make I receive playback of the file 'prepaid-dest-unreachable'. This is strange because I have correctly setup Callplan, RateCards, and Rates, and the whole installation was working perfectly before reboot.

MySQL is working fine because the whole authorization / enter pin number script is done, but when it gets to the point of entering the destination number, it always fails.

For example, with the following query I get these results

Query

SELECT *
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id
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 = '00346'


Results (only one row)
id 1
iduser 0
idtariffplan 0
tariffgroupname TestCallPlan
lcrtype 0
creationdate 2009-09-11 01:46:37
removeinterprefix 0
id_cc_package_offer -1
idtariffgroup 1
idtariffplan 2
id 2
iduser 0
tariffname TarjetaHonesta
creationdate 2009-09-13 08:09:13
startingdate 2009-01-01 08:08:35
expirationdate 2034-09-13 08:08:35
description
id_trunk 2
secondusedreal 3026
secondusedcarrier 0
secondusedratecard 0
reftariffplan 0
idowner 0
dnidprefix all
calleridprefix all
id 2182
idtariffplan 2
dialprefix 00346
buyrate 0
buyrateinitblock 0
buyrateincrement 0
rateinitial 0.1235
initblock 0
billingblock 0
connectcharge 0
disconnectcharge 0
stepchargea 0
chargea 0
timechargea 0
billingblocka 0
stepchargeb 0
chargeb 0
timechargeb 0
billingblockb 0
stepchargec 0
chargec 0
timechargec 0
billingblockc 0
startdate 2009-09-13 08:28:00
stopdate 2019-09-13 08:28:00
starttime 0
endtime 10079
id_trunk 2
musiconhold
id_outbound_cidgroup -1
rounding_calltime 0
rounding_threshold 0
additional_block_charge 0
additional_block_charge_time 0
tag
disconnectcharge_after 0
is_merged 0
additional_grace 0
minimal_cost 0
announce_time_correction 1
destination 346
id_trunk 2
trunkcode Jazztel21-SP06
trunkprefix 1147
providertech SIP
providerip 130.117.110.21
removeprefix
secondusedreal 3026
secondusedcarrier 0
secondusedratecard 0
creationdate 2009-09-11 03:03:52
failover_trunk -1
addparameter
id_provider 1
inuse 0
maxuse -1
status 1
if_max_use 0
id_trunk 2
trunkcode Jazztel21-SP06
trunkprefix 1147
providertech SIP
providerip 130.117.110.21
removeprefix
secondusedreal 3026
secondusedcarrier 0
secondusedratecard 0
creationdate 2009-09-11 03:03:52
failover_trunk -1
addparameter
id_provider 1
inuse 0
maxuse -1
status 1
if_max_use 0


So it seems the Database is properly configured, I really don't know where to look next?

Any help would be appreciated.

Regards,

Alejandro