mysqlitedb is your dsn? Can you can share your unixodbc config files - perhaps there's a problem in there.<div><br></div><div>-Steve</div><div><br><br><div class="gmail_quote">On 21 February 2011 08:49, 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div lang="NL" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">Steve,</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">Thnx for this explanation! Now it’s clear to me.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">Still having the connection failure. Any idea’s how to fix it? The errorcodes doesn’t provide detailed information of the problem and how to fix it.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">Thnx</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">Erik</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"></p><div class="im">
<b><span lang="EN-US" style="font-size:10.0pt">Van:</span></b><span lang="EN-US" style="font-size:10.0pt"> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>] <b>N</b></span><b><span style="font-size:10.0pt">amens </span></b></div>
<span style="font-size:10.0pt">Steven Ayre<br><b>Verzonden:</b> maandag 21 februari 2011 9:37<div><div></div><div class="h5"><br><b>Aan:</b> FreeSWITCH Users Help<br><b>Onderwerp:</b> Re: [Freeswitch-users] ODBC error STATE: HY000 CODE 21 ERROR</div>
</div></span><p></p><div><div></div><div class="h5"><p class="MsoNormal"> </p><p class="MsoNormal" style="margin-bottom:12.0pt">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></p><div><p class="MsoNormal">On 21 February 2011 08:18, Erik Dekkers <<a href="mailto:erik.dekkers@wvds.nl" target="_blank">erik.dekkers@wvds.nl</a>> wrote:</p><p class="MsoNormal">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" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">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</p><div><div><p class="MsoNormal"><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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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></p>
</div></div></div><p class="MsoNormal"> </p></div></div></div></div><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></blockquote></div><br></div>