CID Superfecta 2.2.3 returns NULL in FreePBX 2.6.0.1

[jeffszone]

I am trying to get the CallerID Superfecta 2.2.3 module working in a generic/manual installation of CentOS 5.4 with Asterisk 1.6.0.21 and FreePBX 2.6.0.1. Upon initially installing the module I get an HTTP auth password request from my browser when trying to open CID Superfecta within the FreePBX gui. None of my existing passwords work. I tried deleting the .htaccess file as several forums have suggested, but it still prompts for this password I don't have. I then modified the .htaccess to allow from all / Satisfy Any. Now I am able to load the module in my browser without any problems.

However, it doesn't ever return any Caller ID CNAM info what so ever. I tried numerous data sources none of which returned any results at all. For diagnostic purposes I disabled all of the outside sources and enabled just the Asterisk Phonebook. When I type a number that does exist in the Asterisk Phonebook into the box and click "Debug", it does successfully query the data source but it fails to return the corresponding name entry. Instead it just returns a null or blank value:

Processing Default Scheme.
CID matching enabled...Valid CID: 9894849400.
Searching Asterisk Phonebook ...

However I am certain that it is successfully querying the data source as it behaves differently when I enter a bogus number that does not exist in the database. In such a case it specifically returns "not found" instead:

Processing Default Scheme.
CID matching enabled...Valid CID: 9891234567.
Searching Asterisk Phonebook ... not found

It appears that whatever is causing it to not return the name it has found when querying the local Asterisk Phonebook is also preventing it from returning any name from any 3rd party data source, as it doesn't seem to make any difference which one I enable, they all respond with null/blank values.

Does anyone have any idea how to fix this problem?

 

[patrick_elx]

did you check in the option tab of the asterisk lookup source if you entered the proper informations?

 

[jeffszone]

By option tab I assume you mean the panel on the right that comes up to give you options for the selected lookup sources that have an "==>" next to them. The Asterisk Phonebook source does not require any additional information and has no options panel. I've tried several other lookup sources both with and without additional options. All attribute the same behavior. For example Google will return "not found" when I do a debug test on my cell number, but if I put in my land line # it returns a blank / null response... But if I go out to Google on the web myself and search, my home number has a listing.

What it comes down to is that CallerID Superfecta IS in fact querying whatever databases are selected and is able to determine whether a listing exists or not, as it says "not found" appropriately. But it does not display the information it has found when information is available. How do I fix this?

 

[patrick_elx]

that's weird...

Ok let's try step by step to see where it's stops.

- is the number in your asterisk phonebook entered the same way than you enter it in your test (no space, leading number or other features)

- did you try to have a look with phpmyadmin at your asterisk phonebook table to check if there is anything looking wrong in it

- try to query the db the same way as asterisk by opening in your browser the following address:
http://PBXIPADDRESS/admin/modules/superfecta/bin/callerid.php?thenumber=YOURNUMBER

- have a look at your /var/log/httpd/ folder and see if you can find any error reported by the querry.

 

[jennifermehl]

me too

I am having the same problem the original poster describes.

I have FreePBX 2.6.0.1 and Asterisk 1.6.1.14. I can successfully upload the module, and create a test scheme. I have tested with sources that I know are working fine with the non-module superfecta source (which I'm using in production - I'd like to migrate to the module version so that I can more easily change source lookup order on the fly).

When I try the debug with a known good number, I get NULL output, and it never moves on to the next source to query.

 

[jennifermehl]

I think my issue is that the MySQL table was not correctly created. I'm seeing the following message on the backup/redundant server:

FATAL ERROR

SELECT source, value FROM superfectaconfig WHERE source LIKE 'base_%' AND field = 'order' ORDER BY ABS(value) [nativecode=1146 ** Table 'asterisk.superfectaconfig' doesn't exist]SQL -
SELECT source, value FROM superfectaconfig WHERE source LIKE 'base_%' AND field = 'order' ORDER BY ABS(value)



How can I create the mysql table manually? (mysql is running in cluster mode.)

 

[jennifermehl]

I've found the appropriate tables in the mysql db and changed them to use the ndbcluster engine, so now the debug lookups are working on my backup server.

However, it is still returning null results on my primary server. I'll dig around some more to see if I can tell what the difference is.

 

[jennifermehl]

A quick update to my issue (which may or may not have been the same as the OP). My primary server showed this in the http error log when initiating a query of callerid.php:

PHP Fatal error: Call to undefined function mb_detect_encoding() in /var/www/html/admin/modules/superfecta/bin/callerid.php on line 738

After comparing php packages on the 2 servers, I determined that I was missing one, so I installed php-mbstring.i386 0:5.1.6-24.el5_4.5 on the primary, and now the lookup is functioning properly.

 

[tradefair]

you need to install php-mbstring