While ODBC isn't required for the core for a few modules such as mod_sofia, most modules that use a database do need ODBC - mod_cidlookup is one of them.<br><br>-Steve<br><br><br><div class="gmail_quote">On 21 February 2011 08:18, Erik Dekkers <span dir="ltr"><<a href="mailto:erik.dekkers@wvds.nl">erik.dekkers@wvds.nl</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Thnx for the answer,<br>
<br>
Mod_cidlookup requires that you set a DSN so it knows where to get the data right? How would I connect mod_cidlookup to a db without setting a DSN?<br>
<br>
Regards<br>
<br>
Erik<br>
<br>
-----Oorspronkelijk bericht-----<br>
Van: <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a>] Namens Steven Ayre<br>
Verzonden: maandag 21 februari 2011 1:04<br>
Aan: FreeSWITCH Users Help<br>
Onderwerp: Re: [Freeswitch-users] ODBC error STATE: HY000 CODE 21 ERROR<br>
<div><div></div><div class="h5"><br>
Correct. Sqlite doesn't use odbc, you only need unixodbc if you want to connect via odbc to mysql, mssql, postgresql etc.<br>
<br>
Steve on iPhone<br>
<br>
On 20 Feb 2011, at 21:34, curriegrad2004 <<a href="mailto:curriegrad2004@gmail.com">curriegrad2004@gmail.com</a>> wrote:<br>
<br>
> sqlite should be built in freeswitch without needing unixODBC. There's<br>
> no need to use unixODBC unless you're trying to use MySQL or MSSQL<br>
> with FreeSwitch, iirc.<br>
><br>
> On Sun, Feb 20, 2011 at 10:41 AM, Erik Dekkers <<a href="mailto:erik.dekkers@wvds.nl">erik.dekkers@wvds.nl</a>> wrote:<br>
>> Hi guys,<br>
>><br>
>><br>
>><br>
>> At the moment I'm doing some testing with mod_cidlookup. My intention<br>
>> is to match the incoming numbers against a local database. Right now<br>
>> im trying to set it up with SQLite.<br>
>><br>
>> I've installed SQLite, unixODBC and created a DSN (freeswitch is also<br>
>> compiled with odbc support). When testing the connection to the<br>
>> SQLite database with the isql utility everything works:<br>
>><br>
>><br>
>><br>
>> +---------------------------------------+<br>
>> | Connected! |<br>
>> | |<br>
>> | sql-statement |<br>
>> | help [tablename] |<br>
>> | quit |<br>
>> | |<br>
>> +---------------------------------------+<br>
>> SQL><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> Unfortunately when starting freeswitch I get this error in the console:<br>
>><br>
>><br>
>><br>
>> 2011-02-20 19:28:44.203665 [ERR] switch_odbc.c:365 STATE: HY000 CODE<br>
>> 21<br>
>> ERROR: [unixODBC][SQLite]connect failed<br>
>><br>
>> 2011-02-20 19:28:44.203672 [CRIT] switch_core_sqldb.c:386 Failure!<br>
>> 2011-02-20 19:28:44.203677 [CRIT] mod_cidlookup.c:137 Cannot Open<br>
>> ODBC Database!<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> Here's my config from /conf/autoload_configs/cidlookup.conf.xml:<br>
>><br>
>><br>
>><br>
>> <configuration name="cidlookup.conf" description="cidlookup Configuration"><br>
>> <settings><br>
>> <param name="cache" value="false"/><br>
>> <!-- expire is in seconds --><br>
>> <param name="cache-expire" value="86400"/><br>
>> <param name="odbc-dsn" value="mysqlitedb"/><br>
>><br>
>> <!-- comment out sql to not setup a database (directory) lookup --><br>
>> <param name="sql" value="<br>
>> SELECT name||' ('||type||')' AS name<br>
>> FROM phonebook p JOIN numbers n ON <a href="http://p.id" target="_blank">p.id</a> = n.phonebook_id<br>
>> WHERE n.number='${caller_id_number}'<br>
>> LIMIT 1<br>
>> "/><br>
>> </settings><br>
>> </configuration><br>
>><br>
>> I someone could point me into the right direction that would be great.<br>
>><br>
>> Kind regards,<br>
>><br>
>> Erik Dekkers (wvds-nl)<br>
>> _______________________________________________<br>
>> FreeSWITCH-users mailing list<br>
>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-us" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-us</a><br>
>> ers<br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>><br>
>><br>
><br>
> _______________________________________________<br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-use" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-use</a><br>
> rs<br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>