PBXiaF 1.3 and AsteriDex DB look up

[leonash07]

Hi newbie here,

My new PBXiaF 1.3 as follows:
Running on VMware 1.04 on Lenovo T60.
256 MB of memory
with two trunk and two extension.
System was running good with no issue with AsteriDex DB look up for almost 1.5 months. Until two days ago I imported about 20 more entry via csv format. I guess I didn't do my homework right. Now my CallerID Superfecta for FreePBX doesn't work any more. Here is the asterisk log information:

Executing [Gizmo5@from-pstn:1] Set("SIP/Gizmo5-b7c05060", "__FROM_DID=Gizmo5") in new stack
Executing [Gizmo5@from-pstn:2] Gosub("SIP/Gizmo5-b7c05060", "cidlookup|cidlookup_1|1") in new stack
Executing [cidlookup_1@cidlookup:1] GotoIf("SIP/Gizmo5-b7c05060", "1?cidlookup|cidlookup_return|1") in new stack
Goto (cidlookup,cidlookup_return,1)
Executing [cidlookup_return@cidlookup:1] LookupCIDName("SIP/Gizmo5-b7c05060", "") in new stack
Changed Caller*ID name to AsteriDex data base open failed
Executing [cidlookup_return@cidlookup:2] Return("SIP/Gizmo5-b7c05060", "") in new stack
Executing [Gizmo5@from-pstn:3] Gosub("SIP/Gizmo5-b7c05060", "app-blacklist-check|s|1") in new stack
Executing [s@app-blacklist-check:1] LookupBlacklist("SIP/Gizmo5-b7c05060", "") in new stack
Executing [s@app-blacklist-check:2] GotoIf("SIP/Gizmo5-b7c05060", "0?blacklisted") in new stack
Executing [s@app-blacklist-check:3] Return("SIP/Gizmo5-b7c05060", "") in new stack
Executing [Gizmo5@from-pstn:4] GotoIf("SIP/Gizmo5-b7c05060", "1 ?cidok") in new stack
Goto (from-pstn,Gizmo5,6)
Executing [Gizmo5@from-pstn:6] NoOp("SIP/Gizmo5-b7c05060", "CallerID is "AsteriDex data base open failed" <XXXXXXXX>") in new stack.

For CallerID.php my setting is as follows:
$AsteriDex = '1'
$Google = '1'
$AnyWho = '1'
$WhitePagesCAD = '1';
I'm guessing my import of csv files messed up CallerID Superfecta lookup. Anyway to fix this? This is for every incoming calls. If more information is required please ask me and I will provide the information. However, please tell me how to get the information as I'm still learning bolts and nuts of PBXiaF.

Leo

 

[wardmundy]

Use phpMyAdmin in FreePBX to browse through your AsteriDex database. It should be pretty obvious what's come unglued. Just delete the problem entries.

 

[leonash07]

Ward,
Thanks for quick response.
I browse through AsteriDex DB and look at each entry under user1 table and all the contact information seems to look OK. If I delete the AsteriDex DB and recreate from stracth with all the entry would you think it will fix the problem. As I see there is a Drop option which allows me to delete the DB.

 

[leonash07]

Ward,
I guess I might have solved the problem. I delete entry from the via http://pbx/asteridex/admin.php and recreated the entry. Once the entry was created via the web page, the incoming call pull the information from the AsteriDex DB. I did this step after you menat to delete the problem entries. However, you were right it might have be the import entry but I could tell from the DB if it was good or not. Once the entry import entry was deleted and recreted fix the problem. Still confused why it would no show the old entry. I will delete all the entry via admin page and recreate via admin page. Hoepfully this will fix my problem.