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
|