[00:06] _charly_ (i=kroseneg@sunrise.schmidham.net) joined #openser. [00:07] <_charly_> hi [00:08] oej (n=olle@apollo.webway.se) left irc: [00:09] <_charly_> i need sip-over-tcp support in asterisk (what is not supported yet), and i thought to setup openser as a proxy for tcp. is there any example config or tutorial somewhere? i haven't found anything yet, i'm still searching [00:11] Is there a way to use avp_db_query and MySQL with a stored procedure? [00:11] I was under the impression that it only worked in the devel version, but I have the same problem ("can't return a result set in the given context" error) still. [00:16] lagggg.... 1 day of it ;) [00:16] sack: so umm yes i checked logs [00:16] nothing in logs at debug level 4 or so showing why [00:16] it does not delay before failure [00:16] instant jump to failure block [00:17] ixx, LOL ! [00:17] ixx , set level 9 ;-) [00:18] yum [00:19] ixx, repeat your issue i almost remember nothing ... [00:21] using dispatcher [00:22] yes ... on failure was the problem ? [00:22] select next server... (round-robin), turn on rtp proxy, turn on jump to failure route if proxy fails.. send to default route for t_relay [00:22] it tries t_relay... fails instantly and jumps to failure route [00:22] that tries next proxy and works [00:23] i can switch the proxy list all around [00:23] it always fails on the first one it chooses [00:23] just ran a call through debug=9 [00:23] checking... [00:24] please paste you config file using http://pastebin.ca/ for instance [00:26] ixx, ngrep also will help you to indetify the problem following the sip callflow [00:26] ngrep -W byline -qt -d any port 5060 [00:28] -W byline does what? [00:28] I think I see a proxy auth requried [00:28] that should not be there [00:28] possibly the issue [00:29] 407 ? [00:29] http://www.tech-invite.com/Ti-sip-CF3665.html#ref33 [00:31] Proxy Authentication Required [00:31] i think that must be the issue [00:31] it should all be turned off [00:31] because this is a private trusted network [00:32] for all the sip clients [00:32] no need for auth [00:33] Nix (n=Nix@85.108.203.217) joined #openser. [00:34] is this auth for providers or auth for clients? [00:36] is the 407 for the sip provider or for the sip phone I mean? [00:37] from what I can tell from ngrep and the openser log I am thinking the phone to openser [00:37] not openser to the provider [00:40] The same provider will work fine if it is selected for after another fails (eg. if it is selected 2nd instead of 1st) [00:41] It's auth for clients [00:44] hmm i don't see where its required.. let me check again [00:47] Nix (n=Nix@85.108.203.217) left irc: Remote closed the connection [00:48] ok for some reason it is jumping to the failure route even though as far as i can tell t_relay is not failing [00:48] in the if (!t_relay()) { ... [00:49] block sl_reply_error(); never gets called [00:52] ok found one area that was funky [00:52] thought it fixed it but i guess not [00:53] cypromis (n=michal@87-194-69-156.bethere.co.uk) left irc: [00:53] so in the route block where there is a if (uri.*) block where I do route(1); and return; after the uri block to end the route I have use_media_proxy(); route(1); [00:53] that should never happen since the uri is mathching [0-9]+ [00:54] I was getting double t_relays though [00:55] ok.. that is just a funky logging issue... but I do not see where that last route(1); would come into play unless someone does a sip address that is not supported... so I'll leave it commented for now [00:56] ok back to square one.. can't figure out why the client auth is being requested [01:00] config file will help :) [01:00] ok I like your ngrep line :) [01:00] i see SIP/2.0 407 Proxy Authentication Required. from the SIP provider [01:00] but if I switch and use it as 2nd instead of 1st it works [01:01] strange [01:01] ok let me paste config [01:01] hehe it's not mine i got from this channel [01:02] http://rafb.net/p/UdFmUc32.html [01:02] that is the main chunk [01:02] if you want more I can put it up [01:06] Can you rewritehostport dynamically? (For example, from an AVP?) [01:07] Vulpyne, yeah you should [01:07] ixx, what version are you unsing 1.2 ? [01:08] because i see many "strange" things ... but i could be wrong [01:08] I tried rewritehostport("$avp(s:qdialstring)"); and it generated an error like: parse_uri: bad port in uri (error at char q in state 8) parsed: (22) [01:08] So apparently the variable wasn't expanded in that. [01:08] Is there any other way I could do it? [01:09] Vulpyne, ummm if you are using 1.2 be carefull i think syntax has changed [01:09] Ah, hmm, I am actually using the svn devel version. [01:09] for $avp() i mean [01:09] yeah ! [01:09] I switched to that in the hope of being able to use stored procedures. [01:09] But that still doesn't work. :( [01:10] That syntax for $avp is working fine in other places. [01:10] Like for printing it out with xlog. [01:10] well i think is not the same [01:11] but i'm not a experiencied user of openser ... just 2 weeks [01:11] Ah. [01:11] Well, thanks for trying to help. [01:12] I'm pretty sure it couldn't be the syntax of $avp, because I am able to print it out. [01:12] And it is correct. [01:12] It seems like rewritehostport just isn't expanding $avp. [01:12] 1.1.1 [01:17] All the examples I can see for rewritehostport seem like they only use a static string. [01:18] Vulpyne, did you try to expand avp outside of rewritehostport ? [01:19] How do you mean? Without quotes? [01:19] I print it out with xlog before I pass it to rewritehostport, and it works. [01:19] I pass it to rewritehostport, and it tries to set the host/port to the literal $blah blah. [01:19] yeah that's what i mean [01:20] So it would be correct if it got expanded in the normal way. [01:21] yeah ... unless there's any restriction in source code ... as static char [01:21] Well, it expects a string, because it wants it like "host:port". [01:21] And the avp contains a string in that format. [01:21] CrazyTux[m] (n=CrazyTux@cpe-24-162-48-94.houston.res.rr.com) left irc: Connection timed out [01:22] here is the full config http://rafb.net/p/eAxzrL25.html [01:29] ixx, you can use xlog() to help you to follow the call flow [01:31] btw is quite complex ... for my knowledge [01:31] yep... thats how I saw that it does not go into the if (!t_relay()) {} block [01:33] which would make me think something is is forcing the failure [01:33] i dunno though [01:36] well if you have t_on_reply and t_on_failure will never enter ... i think [01:37] NormB (n=NormB@smoothwall.goes.com) left irc: "Leaving" [01:38] Vulpyne, maybe you should use textops or avpops instead of rewritehostport() [01:42] i was wondering about that [01:42] techie (n=gus@voip.routedsystems.com) left irc: "My damn controlling terminal disappeared!" [01:42] its currently commented out though [01:42] If i am only listening on an internal interface [01:43] will it still connect out through the ext? [01:43] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [01:43] blah ... i am to tired for this and need to meet something for dinner [01:43] more later... [01:43] thanks sack :) [01:59] How goes it everyone. [02:00] CrazyTux[m] (n=CrazyTux@ppp-70-245-75-100.dsl.hstntx.swbell.net) joined #openser. [02:11] Thanks, using subst_uri worked. [02:54] CunningPike (n=CunningP@dhcp-10-234.district.north-van.bc.ca) left irc: Remote closed the connection [03:10] CrazyTux[m] (n=CrazyTux@ppp-70-245-75-100.dsl.hstntx.swbell.net) left irc: Success [03:48] duckz (n=duckz@141.85.3.18) left irc: Remote closed the connection [04:01] techie (n=gus@voip.routedsystems.com) joined #openser. [04:17] cypromis_ (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [04:17] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) left irc: Read error: 104 (Connection reset by peer) [04:40] cypromis_ (n=michal@host213-123-136-142.in-addr.btopenworld.com) left irc: Read error: 104 (Connection reset by peer) [04:40] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [04:46] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) left irc: Read error: 104 (Connection reset by peer) [04:47] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [04:47] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) left irc: Read error: 104 (Connection reset by peer) [04:49] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [04:53] Nick change: DoberMann[PullA] -> DoberMann[ZZZzzz [04:58] DoberMann[PullA] (n=james@AToulouse-156-1-151-89.w90-30.abo.wanadoo.fr) joined #openser. [05:12] DoberMann[ZZZzzz (n=james@AToulouse-156-1-4-174.w81-250.abo.wanadoo.fr) left irc: Read error: 110 (Connection timed out) [05:14] CrazyTux[m] (n=CrazyTux@cpe-24-162-48-94.houston.res.rr.com) joined #openser. [05:14] blackk (i=bblack@38-118-35-20.rapiddsl.net) left irc: Read error: 110 (Connection timed out) [05:19] cypromis_ (n=michal@host86-149-162-115.range86-149.btcentralplus.com) joined #openser. [05:21] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) left irc: Read error: 104 (Connection reset by peer) [05:21] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [05:36] Hello evertyone [05:36] s/evertyone/everyone/ [05:38] hi [05:41] cypromis_ (n=michal@host86-149-162-115.range86-149.btcentralplus.com) left irc: No route to host [06:42] _0penser_ (n=Administ@58.65.224.5) joined #openser. [07:31] L|NUX (n=linux@unaffiliated/lnux/x-10290) joined #openser. [09:05] L-info (n=l-info@165.34.101-84.rev.gaoland.net) joined #openser. [09:17] oej (n=olle@apollo.webway.se) joined #openser. [09:25] stimpie (n=michiel@ip565faf27.direct-adsl.nl) joined #openser. [10:03] codestr0m (n=asura@88.232.178.70) left irc: Read error: 110 (Connection timed out) [10:07] codestr0m (n=asura@88.232.63.14) joined #openser. [10:10] L-info (n=l-info@165.34.101-84.rev.gaoland.net) left irc: Read error: 110 (Connection timed out) [10:18] oej (n=olle@apollo.webway.se) left irc: [10:33] CrazyTux[m] (n=CrazyTux@cpe-24-162-48-94.houston.res.rr.com) left irc: Read error: 110 (Connection timed out) [10:51] cayorde (n=flexable@host184-111-dynamic.17-87-r.retail.telecomitalia.it) joined #openser. [11:59] L|NUX (n=linux@unaffiliated/lnux/x-10290) left irc: [12:05] codestr0m (n=asura@88.232.63.14) left #openser. [12:58] skminh (n=IceChat7@222.253.137.126) joined #openser. [13:11] Nick change: DoberMann[PullA] -> DoberMann [13:20] good morning [13:28] oej (n=olle@apollo.webway.se) joined #openser. [13:33] oej (n=olle@apollo.webway.se) left irc: Client Quit [13:41] skminh (n=IceChat7@222.253.137.126) left irc: Read error: 110 (Connection timed out) [14:08] codestr0m (n=asura@88.232.115.194) joined #openser. [15:03] dhakatel (n=root@58.65.224.5) joined #openser. [15:11] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) left #openser. [15:21] blackk (i=bblack@38-118-35-20.rapiddsl.net) joined #openser. [15:44] _0penser_ (n=Administ@58.65.224.5) left #openser. [15:54] dhakatel (n=root@58.65.224.5) left irc: "Download Gaim: http://gaim.sourceforge.net/" [15:59] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [16:37] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) left irc: [17:28] cypromis (n=michal@87-194-69-156.bethere.co.uk) joined #openser. [17:52] blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage) left irc: Read error: 110 (Connection timed out) [17:52] blitzrage (n=blitzrag@CPE000fea3dbc27-CM0012c9db3d2e.cpe.net.cable.rogers.com) joined #openser. [18:22] oej (n=olle@apollo.webway.se) joined #openser. [18:46] blitzrage (n=blitzrag@CPE000fea3dbc27-CM0012c9db3d2e.cpe.net.cable.rogers.com) left irc: "Leaving" [18:47] blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage) joined #openser. [19:22] Nick change: cypromis -> cypromis_ [19:22] Nick change: cypromis_ -> cypromis [19:23] Nick change: cypromis -> cypromis_ [19:30] Nix (n=Nix@81.213.125.220) joined #openser. [19:37] Nick change: cypromis_ -> cypromis [20:01] CrazyTux[m] (n=CrazyTux@cpe-24-162-48-94.houston.res.rr.com) joined #openser. [20:29] CrazyTux[m] (n=CrazyTux@cpe-24-162-48-94.houston.res.rr.com) left irc: Read error: 110 (Connection timed out) [20:58] cypromis (n=michal@87-194-69-156.bethere.co.uk) left irc: [21:11] cayorde (n=flexable@host184-111-dynamic.17-87-r.retail.telecomitalia.it) left irc: "Leaving" [21:26] codestr0m (n=asura@88.232.115.194) left irc: "Leaving." [21:27] codestr0m (n=asura@207.135.120.85) joined #openser. [21:31] Nix (n=Nix@81.213.125.220) left irc: Read error: 110 (Connection timed out) [21:32] Nix (n=Nix@81.213.125.220) joined #openser. [21:49] cypromis (n=michal@host213-123-136-142.in-addr.btopenworld.com) joined #openser. [21:52] Nick change: DoberMann -> DoberMann[Flim] [22:00] Nix (n=Nix@81.213.125.220) left irc: "off to a party" [22:44] brettnem (n=brettnem@72.29.102.158) left irc: Remote closed the connection [22:44] brettnem (n=brettnem@72.29.102.158) joined #openser. [23:03] blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage) left irc: "too much work..." [23:42] oej (n=olle@apollo.webway.se) left irc: [23:46] <_charly_> df -h [23:46] <_charly_> oops, wrong window [00:00] --- Sun Apr 29 2007