April 2012 - FreeSWITCH-users - FreeSWITCH Mailing Lists

LUASQL Installation Problem!
by Shahzad Bhatti 15 Apr '12

15 Apr '12

AOA, i tried a lot to install LUASQL but have errors in it . i follow wiki for it http://wiki.freeswitch.org/wiki/Installing_LuaSQL here is my *config* file data [root@localhost luasql-2.1.1]# vim config # Driver (leave uncommented ONLY the line with the name of the driver) T= mysql #T= oci8 #T= odbc #T= postgres #T= sqlite #T=sqlite3 # Installation directories # Default prefix PREFIX = /usr/local # System's libraries directory (where binary libraries are installed) LUA_LIBDIR= $(PREFIX)/lib/lua/5.1 # System's lua directory (where Lua libraries are installed) LUA_DIR= $(PREFIX)/share/lua/5.1 # Lua includes directory #LUA_INC= $(PREFIX)/include LUA_INC= /usr/src/freeswitch/src/mod/languages/mod_lua/lua # Lua version number (first and second digits of target version) LUA_VERSION_NUM= 501 # OS dependent LIB_OPTION= -shared #for Linux #LIB_OPTION= -bundle -undefined dynamic_lookup #for MacOS X LIBNAME= $T.so COMPAT_DIR= ../compat/src # Compilation parameters # Driver specific ####### MySQL DRIVER_LIBS= -L/usr/local/mysql/lib -lmysqlclient -lz DRIVER_INCS= -I/usr/local/mysql/include ######## Oracle OCI8 #DRIVER_LIBS= -L/home/oracle/OraHome1/lib -lz -lclntsh #DRIVER_INCS= -I/home/oracle/OraHome1/rdbms/demo -I/home/oracle/OraHome1/rdbms/public ######## PostgreSQL #DRIVER_LIBS= -L/usr/local/pgsql/lib -lpq #DRIVER_INCS= -I/usr/local/pgsql/include ######## SQLite #DRIVER_LIBS= -lsqlite #DRIVER_INCS= ######## SQLite3 #DRIVER_LIBS= -L/opt/local/lib -lsqlite3 #DRIVER_INCS= -I/opt/local/include ######## ODBC #DRIVER_LIBS= -L/usr/local/lib -lodbc #DRIVER_INCS= -DUNIXODBC -I/usr/local/include WARN= -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic INCS= -I$(LUA_INC) CFLAGS= -O2 $(WARN) -I$(COMPAT_DIR) $(DRIVER_INCS) $(INCS) $(DEFS) CC= gcc # $Id: config,v 1.8 2007/10/27 22:55:27 carregal Exp $ but get the error : my output is as followos: [root@localhost luasql-2.1.1]# make gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/usr/src/freeswitch/src/mod/languages/mod_lua/lua -c -o src/ls_mysql.o src/ls_mysql.c src/ls_mysql.c:19:19: error: mysql.h: No such file or directory src/ls_mysql.c:73: error: expected specifier-qualifier-list before âMYSQLâ src/ls_mysql.c:81: error: expected specifier-qualifier-list before âMYSQL_RESâ src/ls_mysql.c:148: warning: ISO C forbids forward references to âenumâ types src/ls_mysql.c:148: warning: âenum enum_field_typesâ declared inside parameter list src/ls_mysql.c:148: warning: its scope is only this definition or declaration, which is probably not what you want src/ls_mysql.c:148: error: parameter 1 (âtypeâ) has incomplete type src/ls_mysql.c: In function âgetcolumntypeâ: src/ls_mysql.c:151: error: âFIELD_TYPE_VAR_STRINGâ undeclared (first use in this function) src/ls_mysql.c:151: error: (Each undeclared identifier is reported only once src/ls_mysql.c:151: error: for each function it appears in.) src/ls_mysql.c:151: error: âFIELD_TYPE_STRINGâ undeclared (first use in this function) src/ls_mysql.c:153: error: âFIELD_TYPE_DECIMALâ undeclared (first use in this function) src/ls_mysql.c:153: error: âFIELD_TYPE_SHORTâ undeclared (first use in this function) src/ls_mysql.c:153: error: âFIELD_TYPE_LONGâ undeclared (first use in this function) src/ls_mysql.c:154: error: âFIELD_TYPE_FLOATâ undeclared (first use in this function) src/ls_mysql.c:154: error: âFIELD_TYPE_DOUBLEâ undeclared (first use in this function) src/ls_mysql.c:154: error: âFIELD_TYPE_LONGLONGâ undeclared (first use in this function) src/ls_mysql.c:155: error: âFIELD_TYPE_INT24â undeclared (first use in this function) src/ls_mysql.c:155: error: âFIELD_TYPE_YEARâ undeclared (first use in this function) src/ls_mysql.c:155: error: âFIELD_TYPE_TINYâ undeclared (first use in this function) src/ls_mysql.c:157: error: âFIELD_TYPE_TINY_BLOBâ undeclared (first use in this function) src/ls_mysql.c:157: error: âFIELD_TYPE_MEDIUM_BLOBâ undeclared (first use in this function) src/ls_mysql.c:158: error: âFIELD_TYPE_LONG_BLOBâ undeclared (first use in this function) src/ls_mysql.c:158: error: âFIELD_TYPE_BLOBâ undeclared (first use in this function) src/ls_mysql.c:160: error: âFIELD_TYPE_DATEâ undeclared (first use in this function) src/ls_mysql.c:160: error: âFIELD_TYPE_NEWDATEâ undeclared (first use in this function) src/ls_mysql.c:162: error: âFIELD_TYPE_DATETIMEâ undeclared (first use in this function) src/ls_mysql.c:164: error: âFIELD_TYPE_TIMEâ undeclared (first use in this function) src/ls_mysql.c:166: error: âFIELD_TYPE_TIMESTAMPâ undeclared (first use in this function) src/ls_mysql.c:168: error: âFIELD_TYPE_ENUMâ undeclared (first use in this function) src/ls_mysql.c:168: error: âFIELD_TYPE_SETâ undeclared (first use in this function) src/ls_mysql.c:170: error: âFIELD_TYPE_NULLâ undeclared (first use in this function) src/ls_mysql.c: In function âcreate_colinfoâ: src/ls_mysql.c:182: error: âMYSQL_FIELDâ undeclared (first use in this function) src/ls_mysql.c:182: error: âfieldsâ undeclared (first use in this function) src/ls_mysql.c:183: warning: ISO C90 forbids mixed declarations and code src/ls_mysql.c:185: warning: implicit declaration of function âmysql_fetch_fieldsâ src/ls_mysql.c:185: error: âcur_dataâ has no member named âmy_resâ src/ls_mysql.c:191: error: type of formal parameter 1 is incomplete src/ls_mysql.c: In function âcur_fetchâ: src/ls_mysql.c:206: error: âMYSQL_RESâ undeclared (first use in this function) src/ls_mysql.c:206: error: âresâ undeclared (first use in this function) src/ls_mysql.c:206: error: âcur_dataâ has no member named âmy_resâ src/ls_mysql.c:207: warning: ISO C90 forbids mixed declarations and code src/ls_mysql.c:208: error: âMYSQL_ROWâ undeclared (first use in this function) src/ls_mysql.c:208: error: expected â;â before ârowâ src/ls_mysql.c:209: error: ârowâ undeclared (first use in this function) src/ls_mysql.c:213: warning: implicit declaration of function âmysql_fetch_lengthsâ src/ls_mysql.c: In function âcur_closeâ: src/ls_mysql.c:269: warning: implicit declaration of function âmysql_free_resultâ src/ls_mysql.c:269: error: âcur_dataâ has no member named âmy_resâ src/ls_mysql.c: In function âcur_numrowsâ: src/ls_mysql.c:319: warning: implicit declaration of function âmysql_num_rowsâ src/ls_mysql.c:319: error: âcur_dataâ has no member named âmy_resâ src/ls_mysql.c: At top level: src/ls_mysql.c:327: error: expected declaration specifiers or â...â before âMYSQL_RESâ src/ls_mysql.c: In function âcreate_cursorâ: src/ls_mysql.c:337: error: âcur_dataâ has no member named âmy_resâ src/ls_mysql.c:337: error: âresultâ undeclared (first use in this function) src/ls_mysql.c: In function âconn_closeâ: src/ls_mysql.c:359: warning: implicit declaration of function âmysql_closeâ src/ls_mysql.c:359: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c: In function âconn_executeâ: src/ls_mysql.c:374: warning: implicit declaration of function âmysql_real_queryâ src/ls_mysql.c:374: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c:376: warning: implicit declaration of function âmysql_errorâ src/ls_mysql.c:376: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c:379: error: âMYSQL_RESâ undeclared (first use in this function) src/ls_mysql.c:379: error: âresâ undeclared (first use in this function) src/ls_mysql.c:379: warning: implicit declaration of function âmysql_store_resultâ src/ls_mysql.c:379: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c:380: warning: implicit declaration of function âmysql_field_countâ src/ls_mysql.c:380: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c:380: warning: ISO C90 forbids mixed declarations and code src/ls_mysql.c:383: error: too many arguments to function âcreate_cursorâ src/ls_mysql.c:388: warning: implicit declaration of function âmysql_affected_rowsâ src/ls_mysql.c:388: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c:392: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c: In function âconn_commitâ: src/ls_mysql.c:403: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c: In function âconn_rollbackâ: src/ls_mysql.c:413: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c: In function âconn_setautocommitâ: src/ls_mysql.c:424: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c:427: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c: At top level: src/ls_mysql.c:437: error: expected declaration specifiers or â...â before âMYSQLâ src/ls_mysql.c: In function âcreate_connectionâ: src/ls_mysql.c:444: error: âconn_dataâ has no member named âmy_connâ src/ls_mysql.c:444: error: âmy_connâ undeclared (first use in this function) src/ls_mysql.c: In function âenv_connectâ: src/ls_mysql.c:462: error: âMYSQLâ undeclared (first use in this function) src/ls_mysql.c:462: error: âconnâ undeclared (first use in this function) src/ls_mysql.c:466: warning: implicit declaration of function âmysql_initâ src/ls_mysql.c:470: warning: implicit declaration of function âmysql_real_connectâ src/ls_mysql.c:478: error: too many arguments to function âcreate_connectionâ src/ls_mysql.c: In function âluaopen_luasql_mysqlâ: src/ls_mysql.c:557: error: expected â)â before âMYSQL_SERVER_VERSIONâ src/ls_mysql.c:557: error: too few arguments to function âlua_pushlstringâ make: *** [src/ls_mysql.o] Error 1 [root@localhost luasql-2.1.1]# please tell me the reason of the error: Regards Shahzad Bhatti

1 0

media bypass for mod_callcenter
by fieldpeak 15 Apr '12

15 Apr '12

Hi Guys, call flow: pstn->media GW->FS->mod_callcenter->hear music->agent i need media go between media GW and agent, bypass FS, can anyone help advise how to configure, thanks. -- Regards, Charles

1 0

Doing basic arithmetic in the xml dialplan without a language
by Herman Griffin 13 Apr '12

13 Apr '12

Is there a way to do basic arithmetic within the dialplan without running a mod_language script. For instance, to increment a counter on every call. Or to use the modula or division. Herman

3 2

Need some help with dial string matching?
by Frank Church 13 Apr '12

13 Apr '12

I set up a basic installation of freeswitch, but because I want to learn more I haven't removed the existing extensions, but I created a context to send all numbers beginnng with 0 through an external provider. <include> >  > <context name="provider"> > <extension name="outbound"> > <condition field="destination_number" expression="^0?(\d+)$"> > <action application="bridge" data="sofia/gateway/provider/0$1"/> > </condition> > </extension> > </context> > </include> > I noticed that numbers without a leading zero are matched and dialled. Anyway I think I realize that the expression should start wih '^0+' instead of ^0?'. How then do I dial the whole string instead of using 0$1? Because that is what is adding the leading 0 to the numbers without it. I also want to ensure that a minimal number of digits are dialled before the call is allowed. Do I need to add them literally like ^0+dddddd or is there a shortcut for specifying a minimal number of digits? -- Frank Church ======================= http://devblog.brahmancreations.com

1 1

T.30 Fax and Echo cancellation
by Anita Hall 13 Apr '12

13 Apr '12

Hi I know that all echo cancelers are supposed to shut down when they hear the CNG or CED fax tone. Is this always a good thing ? I know that T.30 is supposed to be half duplex, so echo should not be there but in my session recordings, I have seen both sides trying to send at the same time (is that a sign of some other bad thing?) What if my T.30 fax is failing due to echo ? Check out this article http://connectedplanetonline.com/mag/telecom_oil_water_fax/ Thanks, Anita.

1 0

Problem bridging to an external mobile number
by ocset 13 Apr '12

13 Apr '12

Hi My configuration is a GXW4104 (IP 192.168.0.160) with two PSTN lines. The first line is a POTS line and the second line is a GSM gateway device. Both devices work correctly if I dial out but when I try and bridge between the two, nothing works as expected. The bridge is from the POTS line to a mobile number using the GSM gateway. I have created the following bridge for the POTS line (phone numbers removed for privacy reasons) <extension name="pots_line"> <condition field="destination_number" expression="^(xxxxxxxxxx)$"> <action application="bridge" data="sofia/internal/zzzzzzzzzz@192.168.0.160:5062"/> </condition> </extension> The bridge does eventually happen (long delay) but neither party can hear each other. Also, when I hang-up with one or both phones, the connection does not terminate and I have to reboot the GXW4104 to break the connection. I have bought the Freeswitch books and this seems to be something that should easily work. I have not added any variables into the <extension> definition as this is a simple bridge. What have I missed? Thanks in advance

3 6

Possible to disable core codecs?
by Malay Thakershi 13 Apr '12

13 Apr '12

Hello, Is there a way to disable core codecs offered by CORE_PCM_MODULE? I want to use G729 as I need to make more concurrent calls with limited bandwidth. But no matter what I do, system keeps using PCMU codec. I did following modifications based on the wiki but nothing seems to work. In modules.conf.xml, <load module="mod_g729"/> Under SIP profile file, <param name="inbound-codec-negotiation" value="greedy"/> Under vars.xml file, <X-PRE-PROCESS cmd="set" data="global_codec_prefs=G729"/> <X-PRE-PROCESS cmd="set" data="outbound_codec_prefs=G729"/> I also contacted my SIP provider (Vitelity) but they say if I disable other codecs completely, I may be able to use G729. Thanks for help. Malay Thakershi

10 23

Efficient way to query freeswitch - status and info
by Lloyd Aloysius 12 Apr '12

12 Apr '12

Hi All, I would like to find a better[efficient] way to query freeswitch. I am implementing a dashboard [PHP/Jquery] to view status of freeswitch.Lets assume system is a busy and always 100+ active calls. I want to know the following info 1. show calls 2. Sofia status 3. show channels etc What is the better direction to implement this a. Query Data Base tables or b. Event Library or ? Thanks in advanced. Lloyd

4 5

enable_file_write_buffering
by Tamas Jalsovszky 12 Apr '12

12 Apr '12

Hello, Does anybody know how much buffering does the enable_file_write_buffering=true provide? What I've found from source code that there is a buffer with 65536 length but not sure how to calculate the actual buffer length in milliseconds - to estimate IOPS at the end. I would happily add the info to wiki afterwards. Kind regards, Jalsot

2 3

incorrect reg rows in sqlite database sofia_reg_internal.db
by Yuriy Nasida 12 Apr '12

12 Apr '12

Hello guys. I have issue with incorrect reg rows in sqlite database sofia_reg_internal.db. it looks like that one registrations are crossed with others. so sometimes i have 2 inbound call for 2 different users instead of one. What it can be ? probably it is some bug of new FS version ? Can you give me some advise ? sqlite> select * from sip_registrations where sip_user='user2'; 3c73a57f-34be3361(a)10.0.0.140|user2|69.XX.XX.101||user1 <sip:user1@10.0.0.140:5060;fs_nat=yes;fs_path=sip%3Auser1%4079.XX.XX.13%3A5060>|Registered(UDP-NAT)|unknown|1377757948|Linksys/SPA2102-5.2.10;000e081d81c1|user1|69.XX.XX.101|internal|sipproviderdedi1.domain.com|79.XX.XX.13|5060|user1|sip2.sipprovider.com|user1|69.XX.XX.101|69.XX.XX.101|sipproviderdedi1.domain.com|69.XX.XX.101 3bb28227-edc8becf(a)80.XX.XX.131|user2|69.XX.XX.101||user2 <sip:user2@80.XX.XX.131:5060>|Registered(UDP)|unknown|1333557925|Linksys/SPA2102-5.2.10;000e081ac13e|user2|69.XX.XX.101|internal|sipproviderdedi1.domain.com|80.XX.XX.131|5060|user2|sip2.sipprovider.com|user2|69.XX.XX.101|69.XX.XX.101|sipproviderdedi1.domain.com|69.XX.XX.101 Why I have first row here? When I call for user2 I have two call (for user1 an user2) instead of one (for user2).I have separate row for user1... Thanks.

2 6