[Freeswitch-users] Error loading ODBC
Ken Rice
krice at suspicious.org
Mon Sep 29 03:31:51 EDT 2008
Actually on closer look... Theres your problem looks like you don¹t have a
DSN configured in your odbc.ini... Make sure your unixODBC installtion is
correctly configured and isql can connect to the dsn
From: preetha Ayyappan <preetha.ayyappan at gmail.com>
Reply-To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 12:44:40 +0530
To: <freeswitch-users at lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Error loading ODBC
Thanks.I have uncommented the line yoy specified and run the program
sample.js from the freeswitch console.It shows the following error:
freeswitch at localhost> 2008-09-29 18:13:03 [ERR] switch_odbc.c:160
switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC][Driver
Manager]Data source name not found, and no default driver specified
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
2008-09-29 18:13:03 [NOTICE] sample.js:1 console_log()
==============================
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:266 odbc_num_rows()
Database is not connected!
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:314 odbc_next_row()
Database is not connected!
2008-09-29 18:13:03 [NOTICE] sample.js:1 console_log()
==============================
2008-09-29 18:13:03 [ERR] mod_spidermonkey_odbc.c:235 odbc_exec() Database
is not connected!
Thanks
On Mon, Sep 29, 2008 at 12:29 PM, Michael Jerris <mike at jerris.com> wrote:
>
> On Sep 29, 2008, at 2:45 AM, preetha Ayyappan wrote:
>
>> I have uncommented the line 'langages/mod_spidermonkey_odbc' from
>> /usr/local/freeswitch/modules.conf and installed like the following
>>
>> step1:-I have downloaded the unixodbc and put it in usr/local/freeswitch.
>> step2:-I have installed like the following from the /usr/local/freeswitch
>> a)tar -xvzf unixODBC-2.2.12.tar.gz
>> step3:-In the path /usr/local/freeswitch/unixodbc-2.2.12 ,i have done
>> b)./configure --enable-gui=no
>> c)make
>> d)make install
>>
>> step3:-In the path /usr/local/freeswitch,I have done
>> a)./configure --enable-core-odbc-support
>> b)make all install
>>
>> when doing the above steps
>>
>> a)./configure --enable-core-odbc-support
>> b)make all install, I am getting the lines
>>
>> Making install in src
>> Making install in mod
>>
>> is not a valid FreeSWITCH module dir, skipping it.....
>>
>> is not a valid FreeSWITCH module dir, skipping it.....
>>
>>
>>
>> After making all the above I have put a sample odbc.js in
>> /usr/local/javascript/scripts and tried to run from the freeswitch console
>> like jsrun odbc.js.
>>
>> I am getting the following error:
>>
>> freeswitch at localhost> 2008-09-29 17:44:12 [ERR] mod_spidermonkey.c:3303
>> js_api_use() Error loading ODBC
>>
>>
>> 2008-09-29 17:44:12 [ERR] sample.js:11 mod_spidermonkey() ReferenceError:
>> ODBC is not defined
>>
>> please let me know where i am wrong here.
>>
>> Thanks.
>
> in the file conf/autoload_configs/spidermonkey.conf.xml
>
> uncomment <load module="mod_spidermonkey_odbc"/>
>
> I know you said you did before but double check... are you still getting the
> error that it can not open mod_spidermonkey_odbc.so? When it builds, do you
> see it building mod_spidermonkey_odbc? Does it actually create the so?
>
> Mike
>
>
>
>>
>>
>>
>> On Fri, Sep 26, 2008 at 3:16 PM, David Knell <dave at 3c.co.uk> wrote:
>>>
>>> Hi Preetha,
>>>
>>> You've probably not compiled the module. Have a look in
>>> /usr/src/freeswitch (or wherever your source is); you'll
>>> find a modules.conf there. Uncomment the line
>>> 'langages/mod_spidermonkey_odbc', rebuild, reinstall and things
>>> might get better.
>>>
>>> --Dave
>>>
>>>>
>>>> yes, I did ./configure --enable-core-odbc-support && make && make
>>>> install.When i gave make install during installation,i found the following
>>>> error:
>>>>
>>>>
>>>>
>>>> 2008-09-26 19:37:19 [CRIT] switch_loadable_module.c:767
>>>> switch_loadable_module_load_file() Error Loading module
>>>> /usr/local/freeswitch/mod/mod_spidermonkey_odbc.so
>>>> **/usr/local/freeswitch/mod/mod_spidermonkey_odbc.so: cannot open shared
>>>> object file: No such file or directory**
>>>>
>>>> Thanks
>>>>
>>>>
>>>> On 9/25/08, Raymond Chandler <intralanman at freeswitch.org> wrote:
>>>>>
>>>>> if you built from source, make sure you use the --enable-core-odbc-support
>>>>> option on your ./configure
>>>>>
>>>>> like so
>>>>> ./configure --enable-core-odbc-support && make && make install
>>>>>
>>>>> -Ray
>>>>>
>>>>>
>>>>> preetha Ayyappan wrote:
>>>>>>
>>>>>>
>>>>>> You mean i have to uncomment the line <load
>>>>>> module="mod_spidermonkey_odbc"/>.?
>>>>>> yes.I have uncommented that line.eventhough the same error occurs
>>>>>>
>>>>>>
>>>>>> On Thu, Sep 25, 2008 at 2:33 PM, Michael Jerris <mike at jerris.com> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Sep 25, 2008, at 4:47 AM, preetha wrote:
>>>>>>>
>>>>>>>> >
>>>>>>>> > Hi,
>>>>>>>> > when i try to run a sample odbc code from freeswitch console like
>>>>>>>> > freeswitch at localhost> jsrun odbc.js
>>>>>>>> >
>>>>>>>> > I found the following error:
>>>>>>>> > API CALL [jsrun(odbc.js)] output:
>>>>>>>> > OK
>>>>>>>> >
>>>>>>>> > freeswitch at localhost> 2008-09-25 19:44:35 [ERR] mod_spidermonkey.c:
>>>>>>>> > 3303
>>>>>>>> > js_api_use() Error loading ODBC
>>>>>>>> > 2008-09-25 19:44:35 [ERR] odbc.js:11 mod_spidermonkey()
>>>>>>>> > ReferenceError:
>>>>>>>> > ODBC is not defined
>>>>>>>> >
>>>>>>>
>>>>>>>
>>>>>>> Make sure you have mod_spidermonkey_odbc loaded in your
>>>>>>> spidermonkey.conf.xml file
>>>>>>>
>>>>>>> Mike
>>>>>>>
>>>>>>>
>>>>>>>
>
>
> _______________________________________________
> 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
>
>
>
>
> --
> Preetha.A
>
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20080929/c57c18d4/attachment.html
More information about the Freeswitch-users
mailing list