Messages

31

Yate users hangout place / Re: round robin routing using db query

« on: August 25, 2014, 02:23:11 AM »

please see the attached sniffer. when i dial 99 i can see the script route.php is called but i cant see any effect. i have also put
Yate::Output("gw.conf247.com routing \n");
so it should show this line but i cant see in the logs, any idea?

32

Yate users hangout place / Re: no db query after the expires

« on: August 25, 2014, 01:35:34 AM »

woo i think we nailed it
all good much appreciated.

33

Yate users hangout place / Re: no db query after the expires

« on: August 20, 2014, 01:55:52 AM »

Please see the attached logs
thanks

34

Yate users hangout place / Re: round robin routing using db query

« on: August 20, 2014, 01:35:29 AM »

hi
i have installed it from the source but my /usr/local/etc/yate/extmodule.conf file is not having only 1 line. its a big file like i already sent you the contents of the file.

so the scripts directory path is

[scripts]
scriptname=share/yate/scripts/route.php

35

Yate users hangout place / no db query after the expires

« on: August 19, 2014, 02:44:48 AM »

Hi there,

something i have noticed that the first registration goes fine, but after the expires my soft phone sends the re-registration to yate but i get Not Found.
i am using [user.auth] , [user.register] and [user.unregister] from DB. it works fine when i register first time i have 60 seconds expire time set on my softphone but after this expire my softphone sends the re-register request to yate but the yate response is Not found. It does not happen when i use regfile

any idea please thanks

36

Yate users hangout place / Re: cdr not working

« on: August 18, 2014, 07:58:39 PM »

ah you mean i can introduce a custom sip header in register.conf?
like

[call.route]

yate_call_id = ${billid}

37

Yate users hangout place / Re: cdr not working

« on: August 14, 2014, 10:51:01 PM »

i am liking yate, i am going to use yate as my SBC. My billing is written on the other RTP servers so when i send calls to them the customer IP is ofcorse overwritten with my SBC IP.
because my RTP sees the call from yate and RTP thinks this is the customer IP. the only piece left is yate_cdr integration with my own billing. thats what i am acheiving by saving yate_cdr.
any idea how can i send yate cdr id in the SIP INVITE to other rtp servers? so on RTP i can extrat these headers and look for the real customer IP from the yate_cdr

38

Yate users hangout place / Re: cdr not working

« on: August 14, 2014, 10:07:26 PM »

Ok all done, thanks now i can save the cdr fine. for some reason default query had errors. i changed to the column name and it seems fine now.
just not getting any value in ${reason} variable

39

Yate users hangout place / Re: round robin routing using db query

« on: August 14, 2014, 10:03:59 PM »

hi thank you for your reply thanks
can you please have a look what else i have to change in this file ? the route.php path is /usr/local/share/yate/scripts/route.php
thanks


here is my [root@gw ~]# vim /usr/local/etc/yate/extmodule.conf


[general]
; General settings for the external module

; scripts_dir: string: The absolute or relative path used by default to load
;  scripts if no full path is specified
; Note that a trailing path separator should be added
; Uncomment the following line when running in the sources directory
scripts_dir=share/yate/scripts/

; priority: int: Priority of the call.execute handler
;priority=100

; timeout: int: How many milliseconds to wait for a module to answer
;timeout=10000

; timebomb: bool: Kill the module instance if it timed out
;timebomb=false

; waitflush: int: Milliseconds to wait at script shutdown after waiting messages
;  and message relays are flushed, valid range 1-100 ms
;waitflush=5
; trackparam: bool: Add the external module to the handler tracking parameter
;  The default of false lets each external script do so
trackparam=true

[scripts]
; Add one entry in this section for each global external module that is to be
;  loaded on Yate startup
; Each line has to be on the form:
scriptname=share/yate/scripts/route.php
; The script name should hold either the absolute path and name or the path
;  and name relative to the scripts_dir in section [general]
; The parameter is optional and if present is passed to the script as the first
;  (and single) parameter
[execute]
; Add one entry in this section for each external program that is to be
;  executed on Yate startup
; Each line has to be on the form:
;   progname=parameter
; The program name should hold the absolute path to the program
; The parameter is optional and if present is passed to the program as the first
;  (and single) parameter

40

Yate users hangout place / cdr not working

« on: August 13, 2014, 08:21:30 PM »

hi guys,
i have hard time to configure the cdr thingy. i can make calls without any issue but i also want to log my call record in the cdr table of database. i can register users using db without any issue.

for cdr i have changed the below lines. cant see anything in the table and also on the console. i am on the debug level 9. can anyone guide me please

[call.cdr]
; Queries for the CDR updating message

cdr_initialize=INSERT INTO yate_cdr VALUES(NULL, '${time}', '${billid}', '${chan}', '${address}', '${caller}', '${called}', '${billtime}', '${ringtime}', '${duration}', '${direction}', '${status}',
 '${reason}', 0)


cdr_update=UPDATE yate_cdr SET address = '${address}', direction = '${direction}', billid = '${billid}', caller = '${caller}', called = '${called}',
duration = '${duration}', billtime = '${billtime}', ringtime  = '${ringtime}', status = '${status}', reason = '${reason}'
WHERE chan = ${chan}' AND time = CAST(${time} AS UNSIGNED)

cdr_finalize=UPDATE yate_cdr SET address = '${address}', direction = '${direction}', billid = '${billid}', caller = '${caller}', called = '${called}',
duration = '${duration}', billtime = '${billtime}', ringtime = '${ringtime}', status = '${status}', reason = '${reason}', ended = 1 WHERE chan = '${chan}'
AND time = CAST(${time} AS UNSIGNED)

41

Yate users hangout place / Re: how return first and last name to Yate client by call (db auth)

« on: August 13, 2014, 08:17:39 PM »

hi oldbay,
i had the same kind of question a few days back but now i just did it.
got to register.conf and edit the below context accordingly

[user.auth]

query=SELECT secret FROM sip_users WHERE username='${username}' AND secret IS NOT NULL
result=secret

42

Yate users hangout place / Re: round robin routing using db query

« on: August 11, 2014, 05:34:32 PM »

Hi thanks for the reply,
yes i found /usr/local/share/yate/scripts/route.php
and modified like like. where $trunk_ip is having my all the allowed ips . but the piece of code is not called thats what the logs are showing.

         if (!in_array($ev->getValue("address"),$trunk_ip)) {
                 $ev->error = "noroute";
                 $ev->handled = true;
           }
here are the logs. it should not send calls to my mysipserver.com as this is not a registered user neither the ip is in the trunk_info array. can you suggest anything please. thanks

20140811233228.371866 <INFO> Could not classify call from 'test', wasted 2 usec
20140811233228.371938 <cdrbuild:INFO> Got message 'call.route' for untracked id 'sip/623'
20140811233228.372097 <INFO> Routing call to '12022899898' in context 'default' via 'fork | sip/sip:12022899898@mysipserver.com' in 92 usec
20140811233228.422545 <callfork:CALL> Call 'sip/623' calling on regular 'fork/303/1' target 'sip/sip:12022899898@mysipserver.com'
20140811233234.119916 <callfork:NOTE> Call 'sip/623' lost slave 'fork/303/1' reason 'forbidden' remaining 0 regulars, 0 auxiliars, 0 persistent

43

Yate users hangout place / Re: round robin routing using db query

« on: August 07, 2014, 10:16:01 PM »

hi thanks for the reply. sorry i m newbee did not understand where i need to write a script. i will use php if i have to write a script.
so my scanrio will be like if the incoming user is not registered then check its ip if it is in my db then let it dial. if it is registered user then let it dial. everything else will be rejected.

right now i am using regexroute.conf where my unauthenticated user is rejected and registered user is able to dialout. the only bit left is where i have to check the IP
can you please guide me which file i have to write a query for valid ip?
thanks

44

Yate users hangout place / round robin routing using db query

« on: July 22, 2014, 05:19:16 PM »

hi folks,
i am new in yate, just installed. i want to achieve round robin but need to check first the incoming registered user IP and then route it to appropiate IP.
like my users would register on yate, the incoming call IP will be checked from db and then i will be able to set the server for routing.
i know the static round robin routing can be achieved like ^00.*$=fork $(index,$idx00,| sip/sip:\0@provider1.com,| sip/sip:\0@provider2.com) | sip/sip:\0@provider3.com

anyone who has done this before? please guide.

45

Other Yate server issues / ss7 over ip

« on: July 06, 2014, 10:29:16 PM »

hi folks,

does anybody knows if the SS7 over IP works in yate without any card?

thanks