- FreeSWITCH-users - FreeSWITCH Mailing Lists

IVR Termination
by Jim Flowers 30 Sep '08

30 Sep '08

How do I terminate a menu with an unconditional transfer to an extension (please stay on the line to talk with the receptionist)? Also, how do I terminate a menu by just dropping the call if no digits are pushed? The samples I copy just keep repeating the menu. Thanks -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

3 9

Re: [Freeswitch-users] Load test - performance not even matching Asterisk
by Jon Bruel 29 Sep '08

29 Sep '08

Thanks for the input. I have now upgraded the OS to i86_64 (FC9), and I configured without libcurl, as recommended by Anthony. The FS loaded without problems apart from some "database is locked" errors, which may be harmless? I ran the ulimit as recommended to unlimit all resources. I started the FS after the ulimit. The same performance test showed a slightly better result. Without trying to make this too scientific, the improvement by going from 32 bit OS to 64 bit OS has been 10-20%, at the most. Still the performance is around 30-40% of the performance of Asterisk. With 100 a-leg (no b-leg, as all calls are answered by the echo application) permanent channels the CPU idle is 10%, with 60% system-load and 30% CPU-load. So something is rotten in Denmark... /Jon

3 2

Connecting Freeswitch to SMS centre
by Imthiyaz Ahmed 29 Sep '08

29 Sep '08

Is there a possiblity we can connect freeswitch SMSC ? -- Best Regards G.Imthiyaz Ahmed

1 0

FreeSWITCH Version 1.0.trunk (9609) profile_name field
by Jim Flowers 29 Sep '08

29 Sep '08

My FreeSWITCH Version 1.0.trunk (9609) with samples loaded continually throws an error when answering a call. There is no `profile_name` column in any table in core.db. Log entries follow. freeswitch.log -------------- 2008-09-29 10:26:26 [DEBUG] mod_dialplan_xml.c:119 parse_exten() Regex mismatch 2008-09-29 10:26:26 [DEBUG] mod_dialplan_xml.c:117 parse_exten() Regex: [del-group] destination_number(5000) =~ /^80(\d{2})$/ 2008-09-29 10:26:26 [DEBUG] mod_dialplan_xml.c:119 parse_exten() Regex mismatch 2008-09-29 10:26:26 [ERR] switch_core_sqldb.c:131 switch_core_db_persistant_execute() SQL ERR [table sip_dialogs has no column named profile_name] 2008-09-29 10:26:26 [DEBUG] mod_dialplan_xml.c:117 parse_exten() Regex: [add-group] destination_number(5000) =~ /^81(\d{2})$/ -- Jim Flowers <jflowers(a)ezo.net> -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

3 2

Re: [Freeswitch-users] Load test - performance not even matching Asterisk
by Jon Bruel 29 Sep '08

29 Sep '08

The load on the CPU was after the calls were set up, this indicated that's not a disk access issue. I'm running FC 8, i686, which I understand is 32 bit. Changing to FC 8 or 9 x86_64 is possible on the Intel(r) Core(tm)2 Duo Processor, and if it's worth it; I'll do it. Does anyone have an idea of what the performance boost will be? /Jon

5 4

storing csv file in mysql database
by preetha Ayyappan 29 Sep '08

29 Sep '08

hi, I am getting the call records saved in the folder cdr-csv.I need to save this cdr details in mysql database.Is it possible to do?If yes please assist me to do this. Thanks

5 9

Re: [Freeswitch-users] Load test - performance not even matching Asterisk
by Jon Bruel 29 Sep '08

29 Sep '08

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

3 2

get channel status
by Gopal krishnan 29 Sep '08

29 Sep '08

Hi, Is there any possibilities that I can check my channel status whether it is ringing or answer or hangup. I am trying to fetch thru uuid but couldn't able to do that. any suggestion would be helpful. thanks -- Thank you with regards, Gopal,

1 0

Re: [Freeswitch-users] Error loading ODBC
by B Karthik 29 Sep '08

29 Sep '08

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(a)lists.freeswitch.org> wrote: > Send Freeswitch-users mailing list submissions to > freeswitch-users(a)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(a)lists.freeswitch.org > > You can reach the person managing the list at > freeswitch-users-owner(a)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(a)suspicious.org> > To: <freeswitch-users(a)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(a)consiglia.dk> > *Reply-To: *<freeswitch-users(a)lists.freeswitch.org> > *Date: *Mon, 29 Sep 2008 09:31:54 +0200 > *To: *<freeswitch-users(a)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(a)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(a)suspicious.org> > To: <freeswitch-users(a)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(a)gmail.com> > *Reply-To: *<freeswitch-users(a)lists.freeswitch.org> > *Date: *Mon, 29 Sep 2008 13:06:51 +0530 > *To: *<freeswitch-users(a)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(a)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(a)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(a)gmail.com> > *Reply-To: *<freeswitch-users(a)lists.freeswitch.org> > *Date: *Mon, 29 Sep 2008 12:44:40 +0530 > *To: *<freeswitch-users(a)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@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(a)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@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(a)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(a)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(a)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@localhost> jsrun odbc.js > > > > I found the following error: > > API CALL [jsrun(odbc.js)] output: > > OK > > > > freeswitch@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(a)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(a)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(a)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(a)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(a)lists.freeswitch.org > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org > >

1 0

Error loading ODBC
by preetha 29 Sep '08

29 Sep '08

Hi, when i try to run a sample odbc code from freeswitch console like freeswitch@localhost> jsrun odbc.js I found the following error: API CALL [jsrun(odbc.js)] output: OK freeswitch@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 code is: use("ODBC"); var people = {}; people["authur"] = 30; people["ford"] = 42; people["trillian"] = 29; people["zaphod"] = 304; people["marvin"] = 1000001; db = new ODBC("freeswitchdb", "freeswitch", "1234"); db.connect(); db.exec("create table demo (name varchar(255), age varchar(80));"); for (var i in people) { sql = "insert into demo values('" + i + "', " + people[i] + ");"; console_log("debug", sql + "\n"); db.exec(sql); } sql = "select * from demo;"; var line = "==============================\n"; console_log("notice", line); db.exec(sql); console_log("debug", "row count: " + db.numRows() + "\n"); while(db.nextRow()) { var row = db.getData(); for (var i in row) { console_log("debug", "[" + i + "] = [" + row[i] + "]\n"); } console_log("debug", "\n"); } console_log("notice", line); what should i specify in DSN.here i gave freeswitchdb which is a database name.please assist me to solve this problem Thanks -- View this message in context: http://www.nabble.com/Error-loading-ODBC-tp19665456p19665456.html Sent from the Freeswitch-users mailing list archive at Nabble.com.

6 14