[Freeswitch-users] ODBC error STATE: HY000 CODE 21 ERROR

[Steven Ayre]

Correct. Sqlite doesn't use odbc, you only need unixodbc if you want to connect via odbc to mysql, mssql, postgresql etc.

Steve on iPhone

On 20 Feb 2011, at 21:34, curriegrad2004 <curriegrad2004 at gmail.com> wrote:

> sqlite should be built in freeswitch without needing unixODBC. There's
> no need to use unixODBC unless you're trying to use MySQL or MSSQL
> with FreeSwitch, iirc.
> 
> On Sun, Feb 20, 2011 at 10:41 AM, Erik Dekkers <erik.dekkers at wvds.nl> wrote:
>> Hi guys,
>> 
>> 
>> 
>> At the moment I'm doing some testing with mod_cidlookup. My intention is to
>> match the incoming numbers against a local database. Right now im trying to
>> set it up with SQLite.
>> 
>> I've installed SQLite, unixODBC and created a DSN (freeswitch is also
>> compiled with odbc support). When testing the connection to the SQLite
>> database with the isql utility everything works:
>> 
>> 
>> 
>> +---------------------------------------+
>> | Connected!                            |
>> |                                       |
>> | sql-statement                         |
>> | help [tablename]                      |
>> | quit                                  |
>> |                                       |
>> +---------------------------------------+
>> SQL>
>> 
>> 
>> 
>> 
>> 
>> Unfortunately when starting freeswitch I get this error in the console:
>> 
>> 
>> 
>> 2011-02-20 19:28:44.203665 [ERR] switch_odbc.c:365 STATE: HY000 CODE 21
>> ERROR: [unixODBC][SQLite]connect failed
>> 
>> 2011-02-20 19:28:44.203672 [CRIT] switch_core_sqldb.c:386 Failure!
>> 2011-02-20 19:28:44.203677 [CRIT] mod_cidlookup.c:137 Cannot Open ODBC
>> Database!
>> 
>> 
>> 
>> 
>> 
>> Here's my config from /conf/autoload_configs/cidlookup.conf.xml:
>> 
>> 
>> 
>> <configuration name="cidlookup.conf" description="cidlookup Configuration">
>>   <settings>
>>     <param name="cache" value="false"/>
>>     <!-- expire is in seconds -->
>>     <param name="cache-expire" value="86400"/>
>>     <param name="odbc-dsn" value="mysqlitedb"/>
>> 
>>     <!-- comment out sql to not setup a database (directory) lookup -->
>>     <param name="sql" value="
>>      SELECT name||' ('||type||')' AS name
>>       FROM phonebook p JOIN numbers n ON p.id = n.phonebook_id
>>       WHERE n.number='${caller_id_number}'
>>       LIMIT 1
>>       "/>
>>   </settings>
>> </configuration>
>> 
>> I someone could point me into the right direction that would be great.
>> 
>> Kind regards,
>> 
>> Erik Dekkers (wvds-nl)
>> _______________________________________________
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>> 
>> 
> 
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org