- FreeSWITCH-users - FreeSWITCH Mailing Lists

Route calls to several trunks
by Sayyed Mohammad Emami Razavi 06 Mar '13

06 Mar '13

how to route calls to several trunks without load balancer just with FS? e.g. You're using ICTDialer and just have one trunk for each campaign and you want more trunks to route and you want to handle this with your FS.

2 1

Re: [Freeswitch-users] Error! Failed to log to database using nibblebill
by Shahzad Bhatti 06 Mar '13

06 Mar '13

Mr. Muhammad Shahzad thanks alot for your reply, i think that the user data source is not accessed as i try to use [root@localhost scripts]# isql -v test root 12345678 *[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect * but if i try [root@localhost scripts]# isql -v freeswitch root 12345678 +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ thats what i find, any help now is really highly appreciated. Regards Shahzad Bhatti. On Tue, Mar 5, 2013 at 9:47 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: Playing of mms stream by means of FS (xmppser) > 2. Re: Error! Failed to log to database using nibblebill > (Muhammad Shahzad) > > > ---------- Forwarded message ---------- > From: xmppser <xmppser(a)gmail.com> > To: freeswitch-users(a)lists.freeswitch.org > Cc: > Date: Tue, 5 Mar 2013 07:40:01 -0800 (PST) > Subject: Re: [Freeswitch-users] Playing of mms stream by means of FS > Ok, thanks, > > Since there is no body would like to share the code for this feature, I > will > implement mod_vlc to play video in freeswitch ,and i will opensource the > code. there is no reason , i like opensource. > > Thanks > Best Regards. > > > > -- > View this message in context: > http://freeswitch-users.2379917.n2.nabble.com/Playing-of-mms-stream-by-mean… > Sent from the freeswitch-users mailing list archive at Nabble.com. > > > > > ---------- Forwarded message ---------- > From: Muhammad Shahzad <shaheryarkh(a)gmail.com> > To: FreeSWITCH Users Help <freeswitch-users(a)lists.freeswitch.org> > Cc: > Date: Tue, 5 Mar 2013 17:46:57 +0100 > Subject: Re: [Freeswitch-users] Error! Failed to log to database using > nibblebill > humm, i am not very sure what is the problem then. Can you try below and > reply me with result? > > 1. Enable SQL query log on db server side, and see what SQL FS sends to > the server? An ODBC trace file may also help. > > 2. Why are you defining both column name and custom SQLs? Typically you > use only one of them, not both at the same time, so comment out one of them > and test. > > 3. The custom SQL you are using has back-quotes, though these are > permitted by ANSI SQL, but may create problem for other languages, i.e. the > SQL you specify is in an XML file, which is interpreted by C++, which is > then send to ODBC and then send to actual db server. Any of these > interfaces may misinterpret them (Step 1 will give you clear clue on this). > > Thank you. > > > On Tue, Mar 5, 2013 at 5:11 PM, Shahzad Bhatti <shahzad.bhatti(a)g-r-v.com>wrote: > >> thanks Mr. Muhammad Shahzad for the reply but issue is that when i use to >> access database on console there it works fine but when i use in dialplan >> here it not works >> >> here is my console output >> *[root@localhost includes]# isql -v freeswitch* >> *+---------------------------------------+* >> *| Connected! |* >> *| |* >> *| sql-statement |* >> *| help [tablename] |* >> *| quit |* >> *| |* >> *+---------------------------------------+* >> *SQL> use test;* >> *SQLRowCount returns 0* >> *SQL> select * from tb_accounts;* >> * >> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+ >> * >> *| id | name >> >> >> | cash | >> * >> * >> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+ >> * >> *| 1 | shahzad >> >> >> | 10 |* >> *| 2 | saeed >> >> >> | 50 |* >> *| 3 | usman >> >> >> | 10 |* >> * >> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+ >> * >> *SQLRowCount returns 3* >> *3 rows fetched* >> *SQL> update tb_accounts set cash = cash -1 where id =1;* >> *SQLRowCount returns 1* >> *SQL> select * from tb_accounts;* >> * >> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+ >> * >> *| id | name >> >> >> | cash | >> * >> * >> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+ >> * >> *| 1 | shahzad >> >> >> | 9 |* >> *| 2 | saeed >> >> >> | 50 |* >> *| 3 | usman >> >> >> | 10 |* >> * >> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+ >> * >> *SQLRowCount returns 3* >> *3 rows fetched* >> here u can see that update is also working, and here is my dialplan xml >> * <document type="freeswitch/xml">* >> * <section name="dialplan" description="RE Dial Plan For >> FreeSwitch">* >> * <context name="public">* >> * <extension name="checkBalance">* >> * <condition field="destination_number" >> expression="^126$">* >> * <action application="set" >> data="nibble_rate=0.03"/>* >> * <action application="set" >> data="nibble_account=1"/>* >> * <action application="answer"/>* >> * <action application="hangup"/>* >> * </condition>* >> * </extension>* >> * </context>* >> * </section>* >> * </document> >> * >> >> i also check that the user and password and database is also correct. >> >> any help is appreciated >> >> Regards >> >> Shahzad Bhatti >> >> ---------- Forwarded message ---------- >>>> From: Muhammad Shahzad <shaheryarkh(a)gmail.com> >>>> To: FreeSWITCH Users Help <freeswitch-users(a)lists.freeswitch.org> >>>> Cc: >>>> Date: Fri, 1 Mar 2013 17:07:39 +0100 >>>> Subject: Re: [Freeswitch-users] Error! Failed to log to database using >>>> nibblebill >>>> Problem is with SELECT query, most likely db connection parameters are >>>> missing/invalid OR the db user configured does not have enough permissions >>>> to execute SELECT, >>>> >>>> 2013-03-01 22:29:52.293493 [ERR] mod_nibblebill.c:380 Error running >>>> this query: [SELECT `cash` AS nibble_balance FROM `tb_accounts` WHERE >>>> `id`=1] >>>> >>>> Login db server from FS machine with same db user as configured in FS >>>> configs and run above query, it would give you hint on what is actually >>>> wrong. >>>> >>>> Thank you. >>>> >>>> >>>> On Fri, Mar 1, 2013 at 1:42 PM, Shahzad Bhatti < >>>> shahzad.bhatti(a)g-r-v.com> wrote: >>>> >>>>> hi >>>>> i am using a nibblebill the call cost but have some problem in it. >>>>> my nibblebill.conf.xml file is as >>>>> >>>>> http://pastebin.freeswitch.org/20650 >>>>> >>>>> and console log is >>>>> >>>>> http://pastebin.freeswitch.org/20651 >>>>> >>>>> i got Error *Failed to log to database! *Doing update query >>>>> >>>>> reply me about the issue >>>>> >>>>> Regards >>>>> >>>>> Shahzad Bhatti >>>>> >>>> >> _________________________________________________________________________ >> Professional FreeSWITCH Consulting Services: >> consulting(a)freeswitch.org >> http://www.freeswitchsolutions.com >> >> FreeSWITCH-powered IP PBX: The CudaTel Communication Server >> http://www.cudatel.com >> >> Official FreeSWITCH Sites >> http://www.freeswitch.org >> http://wiki.freeswitch.org >> http://www.cluecon.com >> >> 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 >> >> > > > -- > Muhammad Shahzad > ----------------------------------- > CISCO Rich Media Communication Specialist (CRMCS) > CISCO Certified Network Associate (CCNA) > Cell: +49 176 99 83 10 85 > MSN: shari_786pk(a)hotmail.com > Email: shaheryarkh(a)googlemail.com > > _______________________________________________ > 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

mod_cidlookup and multi-tenant
by Sergey Zhuravlov 06 Mar '13

06 Mar '13

Hi I want to use the module in the multi-domain system all is well, but I want to pass except the numbers in the URL domain name url: http://127.0.0.1:9393/?number=${caller_id_number}&domain=${domain} To in the future, depending on the domain to request a different CRM But substituted the common domain of the settings, not the one that is defined before calling cidlookup <action application="set" data="domain=xxx.xxx.xxxxx.com"/> <action application="set" data="cid_name=${cidlookup(${caller_id_number})}"/> Or another option to have your URL for cidlookup for each domain? Or other ideas? -- WBR, Sergey GTALK/JABBER:4orbit@gmail.com

1 0

[video-media-bug] How to make and load the mod_mp4v2 and mod_fsv modules?
by K K 06 Mar '13

06 Mar '13

Hello, My aim is to record the video from both UAC during a video SIP call. I have checkout the "video-media-bug" branch, because as far as I know there is the source code of the mod_mp4v2 and mod_fsv which can record the video during the communication. I would like to view the recorded video later by some external player, so I guess I should focus on the mod_mp4v2, because the *.fsv is just internal FreeSWITCH format. I am compiling on Windows using the Microsoft Visual C++ 2010 Express. I have firstly compiled the mod_fsv project and replaced the mod_fsv.dll in my FreeSWITCH instalation (1.1.13b). But after running FreeSWITCH I receive the error message box "This application has failed to start because MSVCR100D.dll was not found" and in the console I get the "dll open error" for mod_fsv. Reinstalling the "Visual Studio 2010 C++ Redistributable" package did not help. So I guess the such simple replacement is not working and I will need to compile the whole FreeSWITCH to check how the mod_fsv from "video-media-bug" branch works? So next I have started focus on the mod_mp4v2, but I was not able to find the project file for this module. This module is placed in the "C:\FS_GIT\src\mod\formats" directory, on the Wiki page I have found that it requires the mp4v2 2.0.0 code to be copied into that directory, but still I do not see what project should I compile to obtain the mod_mp4v2.dll for FreeSWITCH? Thank you for any ideas and help.

3 3

switch_core_sqldb.c:579 NATIVE SQL ERR [database is locked]
by Yihui Li 05 Mar '13

05 Mar '13

Hi, I have updated fs to git head today. But the system stopped work and giving out these error message switch_core_sqldb.c:579 NATIVE SQL ERR [database is locked]

3 4

xml cdr - attended transfer cdr - missing aleg uuid
by Lloyd Aloysius 05 Mar '13

05 Mar '13

Hi All I need your help to solve the following issue. I use the following example to explain my issue. User : Marv - Call - User: Dave User : Dave Answer the Call User: Dave - xfer - dial User : Crystal User : Crystal answer the call User : Dave - xfer complete the transfer -- *a_leg cdr* I see one row Dave to Crystal and a_leg_uuid and bridge_uuid. Everything correct here. *b_leg_cdr* I see two records The first record Marv - Dave but *MISSING a_leg_uuid *why the aleg_uuid missing here. I use the following xml_cdr->variables->originating_leg_uuid is comes as empty. Why ? All other scenarios this xml_cdr->variables->originating_leg_uuid works except the attended transfer. Any help is appreciated. Thanks Lloyd * *

4 3

mod_xml_curl docs maintainer
by Cal Leeming [Simplicity Media Ltd] 05 Mar '13

05 Mar '13

Hello, Sadly I have not had any time to work on mod_xml_curl for the last few months, therefore I have unassigned myself as the maintainer for this module documentation. This page could still use some work, so if anyone else decides to pick up on maintaining this page, feel free to hit me up directly if you have any questions or need some guidance. http://wiki.freeswitch.org/wiki/Mod_xml_curl Cal

1 0

Re: [Freeswitch-users] Failing build process - MVC++E2K10 - Why paths have mixed the \ / characters ?
by Peter Olsson 05 Mar '13

05 Mar '13

Sounds quite strange. There is also the "last resort" to use "git clean -fdx" to get it back to the state as it was newly checked out from the git server. However, as I said - using git HEAD probably handles this better already, since it has quite a few improvements for downloading and extracting files. But anyway - good to hear you finally got it up and running! /Peter Från: freeswitch-users-bounces(a)lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] För K K Skickat: den 5 mars 2013 15:20 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] Failing build process - MVC++E2K10 - Why paths have mixed the \ / characters ? Thank you for all help. I still do not understand why it was failing i.e. why the openssl.tar.gz was not automatically downloaded and unpacked during the build process, but I have done it manually, but this time I have copied all the content (not only the crypto directory) and it starts to work. Thank you. !DSPAM:5135fb6a32768157317768!

2 1

aastra connection with freeswitch
by Archana Venugopan 05 Mar '13

05 Mar '13

Hi, Can anyone please tell me how aastra phones retrieve voicemail messages from our freeswitch? And also how aastra phone indicates the missed call and voicemail messages from freeswitch? Thanks Regards, Archana

1 0

Maximum message size
by Kevin Mathy 05 Mar '13

05 Mar '13

Hi List, Another question ;-) , as described in FFT Doc 10.001, the maximum message size is 2048 bytes for SIP messages, and 1024 bytes for SDP bodies; could you, please, confirm that FS is compliant with that ? If not, what the maximum message size supported / sent by FS ? Thanks a lot, * * * Bien cordialement, * * Best Regards, **Kevin MATHY* * * --

4 5