Hello Everyone,
I'm not sure what I am missing here so a little point in the right direction would be appreciated.
We are using A2B 2.0.5 with Asterisk 1.8.15.0 and a few days ago, our database server failed. When the database came back online, there was corruption in the cc_sip_buddies table. When we repaired the corruption, we noticed that several VoIP accounts were missing.
We can create NEW accounts for these customers, but ideally, we want to recreate the old account numbers with new passwords. Unfortunately, during the new VoIP account creation process, we change the name, regexten, and username to the old account number problems happen. The customer is able to register, but when they attempt to make a call they get:
Code:
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:a2billing.php - line:131 - uniqueid: - [INFO : A2Billing - v2.0.5]
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:Class.A2Billing.php - line:712 - uniqueid:atlanta-1381950476.2326 - get_agi_request_parameter = 6133662039 ; SIP/XXXXXXXXX-0000087c ; atlanta-1381950476.2326 ; XXXXXXXXX ; XXXXXXX0288
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:a2billing.php - line:169 - uniqueid:atlanta-1381950476.2326 - [NO ANSWER CALL]
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:Class.A2Billing.php - line:2862 - uniqueid:atlanta-1381950476.2326 - - Account code ::> 856021197
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:Class.A2Billing.php - line:2879 - uniqueid:atlanta-1381950476.2326 - - Retrieve account info SQL ::> 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, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff = cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country = cc_country.countrycode WHERE username = 'XXXXXXXXX'
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:Class.A2Billing.php - line:2883 - uniqueid:atlanta-1381950476.2326 - PREPAID-AUTH-FAIL
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:a2billing.php - line:181 - uniqueid:atlanta-1381950476.2326 - [TRY : callingcard_ivr_authenticate]
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: a2billing.php,1: file:a2billing.php - line:613 - uniqueid:atlanta-1381950476.2326 - [NO AUTH (CN:XXXXXXXXX, cia_res:-1, CREDIT:)]
[2013-10-16 15:07:58] VERBOSE[29272] res_agi.c: -- <SIP/XXXXXXXXX-0000087c>AGI Script a2billing.php completed, returning 4
[2013-10-16 15:07:58] VERBOSE[29272] pbx.c: == Spawn extension (a2billing, XXXXXXX0288, 3) exited non-zero on 'SIP/XXXXXXXXX-0000087c'
Can anyone shed light on what could cause the PREPAID-AUTH-FAIL in this scenario? Is there another table we need to look at? MySQL gave us a clean bill of health on the database.
Thanks for the thoughts.
Perry