[Freeswitch-users] Error loading ODBC

B Karthik carthick84 at gmail.com
Mon Sep 29 01:38:43 PDT 2008


This link should help you through that. It did for me :)

http://www.debian-administration.org/articles/496

B Karthik



On Mon, Sep 29, 2008 at 2:03 PM, <
freeswitch-users-request at lists.freeswitch.org> wrote:

> Send Freeswitch-users mailing list submissions to
>        freeswitch-users at lists.freeswitch.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> or, via email, send a message with subject or body 'help' to
>        freeswitch-users-request at lists.freeswitch.org
>
> You can reach the person managing the list at
>        freeswitch-users-owner at lists.freeswitch.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Freeswitch-users digest..."
>
> Today's Topics:
>
>   1. Re: Load test - performance not even matching Asterisk (Ken Rice)
>   2. Re: Error loading ODBC (Ken Rice)
>
>
> ---------- Forwarded message ----------
> From: Ken Rice <krice at suspicious.org>
> To: <freeswitch-users at lists.freeswitch.org>
> Date: Mon, 29 Sep 2008 02:40:10 -0500
> Subject: Re: [Freeswitch-users] Load test - performance not even matching
> Asterisk
>  What he means by 64bit is are you using a 64bit of fedora? If not grab
> the centos5 64bit iso and try that...
> Also, several things upto and including hard disk access times can greatly
> affect the number of calls/sec and other things...
>
> And yes freeswitch can greatly outperform asterisk by an order of
> magnitude... We routinely route 2000 concurrent calls
>
>
> ------------------------------
> *From: *Jon Bruel <jbr at consiglia.dk>
> *Reply-To: *<freeswitch-users at lists.freeswitch.org>
> *Date: *Mon, 29 Sep 2008 09:31:54 +0200
> *To: *<freeswitch-users at lists.freeswitch.org>
> *Subject: *Re: [Freeswitch-users] Load test - performance not even
> matching Asterisk
>
> Regarding the 32bit vs. 64bit questions, I'm a bit uncertain about how I
> answer it, but here is some imformation, which you may use:
> cpu family      : 6
> model           : 15
> model name      : Intel(R) Pentium(R) Dual CPU  E2140  @ 1.60GHz
> flags           : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov
> pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc
> arch_perfmon pebs bts pni monitor ds_cpl est tm2 ssse3 cx16 xtpr lahf_lm
> uname –ar gives: Linux econel2.everdance.com 2.6.25.9-40.fc8 #1 SMP Fri
> Jun 27 16:25:53 EDT 2008 i686 i686 i386 GNU/Linux.
>
> With respect to compiling the FS, I have not been aware of any options, so
> I just did the standard: bootstrap.sh, configure, make and make install.
> I have tried to configure with some 64bit flags: CFLAGS="-m64 -fast"
> CXXFLAGS="-m64 -fast" LDFLAGS="-m64" ./configure --prefix=/opt/freeswitch
> --enable-core-odbc-support --enable-core-libedit-support --enable-64
> --with-openssl=/usr/sfw, but I get an error:
>
> checking for C compiler default output file name...
> configure: error: C compiler cannot create executables
>
> so I may need to install some 64bit libraries? If so some hints would be
> great! /Jon
>
> ------------------------------
> _______________________________________________
> 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
>
>
> ---------- Forwarded message ----------
> From: Ken Rice <krice at suspicious.org>
> To: <freeswitch-users at lists.freeswitch.org>
> Date: Mon, 29 Sep 2008 03:32:55 -0500
> Subject: Re: [Freeswitch-users] Error loading ODBC
>  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
>
> _______________________________________________
> 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/91a0c6a7/attachment-0002.html 


More information about the FreeSWITCH-users mailing list