[Freeswitch-users] Error loading ODBC

Mon Sep 29 01:32:55 PDT 2008

Refer to one of the many unixODBC howtos like the one found here
http://developer.mimer.com/howto/howto_57.htm
Or visit the unixODBC website @ www.unixodbc.org ....

From: preetha Ayyappan <preetha.ayyappan at gmail.com>
Reply-To: <freeswitch-users at lists.freeswitch.org>
Date: Mon, 29 Sep 2008 13:06:51 +0530
To: <freeswitch-users at lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Error loading ODBC

Where should i configure the data source name in odbc?

On Mon, Sep 29, 2008 at 1:05 PM, preetha Ayyappan
<preetha.ayyappan at gmail.com> wrote:
> Yes. I have uncommented that line before installing itself.Even though i am
> getting the same error.
> 
> 
> On Mon, Sep 29, 2008 at 1:00 PM, Ken Rice <krice at suspicious.org> wrote:
>> In modules.conf in the root of the freeswitch source directory did you
>> uncomment languages/mod_spidermonkey_odbc if you didn't its not building the
>> module
>> 
>> 
>> 
>> 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
>>>> 
>>>> _______________________________________________
>>>> 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
>>>> 
>>>> 
>>>> 
>>>> -- 
>>>> 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/73361984/attachment-0002.html 