CIDlookup to MS SQL server

Status
Not open for further replies.

matt

Member
Oct 30, 2017
36
1
8
47
I am just setting up an new install and try to connect to am MS SQL server for the CIDlookup.

In FS_CLI i get the following message:
2023-02-03 13:26:16.085314 93.33% [ERR] switch_core_sqldb.c:1322 SQL ERR: [ SELECT ID AS name FROM dbo.ProImport$ WHERE Telephone='0170109' ] no such table: dbo.ProImport$
2023-02-03 13:26:16.085314 93.33% [ERR] mod_cidlookup.c:530 Unable to lookup cid: (null)

That´s the config:
<configuration name="cidlookup.conf" description="cidlookup Configuration">
<settings>
<!-- comment out url to not setup a url based lookup -->
<!-- <param name="url" value="192.168.1.20:1865"/> -->

<!-- comment out whitepages-apikey to not use whitepages.com, you must
get an API key from http://developer.whitepages.com/ -->
<!-- <param name="whitepages-apikey" value="MYAPIKEY"/>-->

<!-- set to false to not cache (in memcache) results from the url query -->
<param name="cache" value="true"/>
<!-- expire is in seconds -->
<param name="cache-expire" value="86400"/>

<!-- <param name="odbc-dsn" value="$${dsn_system}"/> -->
<param name="odbc-dsn" value="ALTelDat user password"/>

<!-- comment out sql to not setup a database (directory) lookup -->
<param name="sql" value="
SELECT ID AS name
FROM dbo.ProImport$
WHERE Telephone='${caller_id_number}'
"/>

<!-- comment out citystate-sql to not setup a database (city/state)
lookup -->
<!--
<param name="citystate-sql" value="
SELECT ratecenter||' '||state as name
FROM npa_nxx_company_ocn
WHERE npa = ${caller_id_number:1:3} AND nxx = ${caller_id_number:4:3}
LIMIT 1
"/>
-->
</settings>
</configuration>

But when I connect with isql the query works without any problem.

It also works on another FusionPBX system without any problem.

Where is my mistake?
 
Status
Not open for further replies.