- sr-users - kamailio.org

Re: [OpenSER-Users] Storing SIP Response Codes with avpops?
by Douglas Garstang 09 Nov '07

09 Nov '07

Daniel, I found that I was able to do this, and openser accepts it, and inserts a database record... avp_db_query("insert into sip_responses (response_code, response_reason) values ('$rs','abc')"); That is in a failure block. However, in the failure block, $rs is 0. I tried putting the avp_db_query into the reply block, and openser tells me that avp_db_query isn't allowed in the reply block, SO I then tried putting this: avp_write("$rs","$avp(result)"); into the reply block, and openser tells me that avp_write can't be used in a reply block. Argh! I just want to get a sip response code for the call and put it into the database. I'm using version 1.1. Douglas. ----- Original Message ---- From: Daniel-Constantin Mierla <daniel(a)voice-system.ro> To: Douglas Garstang <dougmig33(a)yahoo.com> Cc: users(a)lists.openser.org Sent: Thursday, November 8, 2007 1:30:50 PM Subject: Re: [OpenSER-Users] Storing SIP Response Codes with avpops? What version are you using? I just tested with trunk version and all ok? For the other issue, just set: modparam("avpops", "avp_table", "usr_preferences") Daniel On 11/08/07 23:20, Douglas Garstang wrote: > Thanks, but when I try that, I get the following error from openser: > > Nov 7 23:17:32 localhost openser[7035]: ERROR:xl_parse_spec: bad pvar > name "rr{s.escape.common})') " > Nov 7 23:17:32 localhost openser[7035]: > ERROR:avpops:fixup_db_query_avp: wrong format[insert into > sip_responses (response_code, response_reason) values ('$rs', > '$(rr{s.escape.common})') ] > Nov 7 23:17:32 localhost openser[7035]: ERROR: fix_actions: fixing > failed (code=-1) at cfg line 139 > > OpenSER also complains that i need to specify an avp table, but since > I am specifying the table in the query, I don't understand why that's > required. > > Douglas. > > > ----- Original Message ---- > From: Daniel-Constantin Mierla <daniel(a)voice-system.ro> > To: Douglas Garstang <dougmig33(a)yahoo.com> > Cc: users(a)lists.openser.org > Sent: Thursday, November 8, 2007 11:57:35 AM > Subject: Re: [OpenSER-Users] Storing SIP Response Codes with avpops? > > Hello, > > On 11/08/07 21:40, Douglas Garstang wrote: > > All, > > > > I'd like to store SIP response codes in mysql using avpops. Is this > > possible? > > > > I tried to do this a few years ago and couldn't find any > > documentation. Unfortunately, I still can't find any. > > > > Can someone post an example? All I can find online is reference > > documentation for avpops. > > > > I'd really like to see a full example with the modparams defining the > > table structure, and how I would use avp_write and avp_db_store to > > write the $rr response code. > the easiest way is to use avp_db_query(), you can give as parameter any > sql query. In your case, you can use in onreply_route: > > avp_db_query("insert into sip_responses (response_code, response_reason) > values ('$rs', '$(rr{s.escape.common})') "); > > You need to create the table sip_responses, with the two string columns. > > Daniel > > > > > Thanks. > > Douglas. > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Users mailing list > > Users(a)lists.openser.org <mailto:Users@lists.openser.org> > > http://lists.openser.org/cgi-bin/mailman/listinfo/users > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

4 3

[OpenSER-Users] [Fwd: Re: Presence module - NOTIFY not sent after un-SUBSCRIBE]
by Anca Vamanu 09 Nov '07

09 Nov '07

-------- Original Message -------- Subject: Re: [OpenSER-Users] Presence module - NOTIFY not sent after un-SUBSCRIBE Date: Fri, 09 Nov 2007 12:19:57 +0200 From: Anca Vamanu <anca(a)voice-system.ro> To: Pascal Maugeri <pascal.maugeri1(a)gmail.com> References: <990aed650711050832u17bcebeey5fea7e4b593ebf2b(a)mail.gmail.com> <990aed650711071336i16268d29v7826e6c40ec580dd(a)mail.gmail.com> <4732CB99.2020104(a)voice-system.ro> <990aed650711090100l16fc5cd2h32c94ad0504ac12a(a)mail.gmail.com> <47342FBF.7060208(a)voice-system.ro> <990aed650711090210q4112985bt16cbbd28255cdd5f(a)mail.gmail.com> You have to take the latest svn repository for the 1.2.x branch: # svn co https://openser.svn.sourceforge.net/svnroot/openser/branches/1.2 openser More info: http://www.openser.org/mos/view/Download/. Anca Pascal Maugeri wrote: > Do you mean I have to update again with 1.2.2 or should I update to "trunk" ? > > Thanks > Pascal > > On Nov 9, 2007 11:00 AM, Anca Vamanu <anca(a)voice-system.ro> wrote: > >> Hello Pascal , >> >> Indeed the 1.2.x version did not sent Notify when unSubscribe was >> received. It has been fixed in trunk but a back port was forgotten. >> It was fixed with the latest commit. >> >> Thanks and regards, >> Anca Vamanu >> >> >> Pascal Maugeri wrote: >> >>> Hi >>> >>> I've update to 1.2.2 >>> (http://openser.svn.sourceforge.net/svnroot/openser/tags/1.2.2/) and I >>> get the same problem. >>> >>> This is the log of openser I get when I try an unsubscribe: >>> >>> 6(18125) PRESENCE:update_subscription: querying database >>> 6(18125) PRESENCE:update_subscription: expires =0 -> deleting from database >>> 6(18125) parse_headers: flags=ffffffffffffffff >>> 6(18125) check_via_address(10.1.1.7, 10.1.1.7, 0) >>> 6(18125) PRESENCE: get_subs_dialog:The query for subscribtion for >>> [user]= pascal,[domain]= mydomain.net for [event]= presence.winfo >>> returned no result >>> 6(18125) PRESENCE:query_db_notify: Could not get subs_dialog from database >>> 6(18125) PRESENCE:update_subscription:Could not send notify for presence.winfo >>> 6(18125) DEBUG: cleanup_uac_timers: RETR/FR timers reset >>> 6(18125) DEBUG: add_to_tail_of_timer[2]: 0xb60af2b8 (414) >>> 6(18125) DEBUG:tm:UNREF_UNSAFE: after is 0 >>> 6(18125) DEBUG:destroy_avp_list: destroying list (nil) >>> 6(18125) receive_msg: cleaning up >>> 13(18132) DEBUG: timer routine:2,tl=0xb60af2b8 next=(nil), timeout=414 >>> 13(18132) DEBUG: wait_handler : removing 0xb60af270 from table >>> 13(18132) DEBUG: delete transaction 0xb60af270 >>> 13(18132) DEBUG: wait_handler : done >>> >>> It looks there is something wrong with my configuration >>> "query_db_notify: Could not get subs_dialog from database", doesn't it >>> ? >>> >>> FYI, subscription and notifications work OK. >>> >>> Regards >>> Pascal >>> >>> >>> On Nov 8, 2007 9:40 AM, Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> wrote: >>> >>> >>>> Hi Pascal, >>>> >>>> be sure you are using the latest version for 1.2 - try using the SVN >>>> snapshots for 1.2.2 >>>> >>>> Regards, >>>> Bogdan >>>> >>>> >>>> Pascal Maugeri wrote: >>>> >>>> >>>>> Hi >>>>> >>>>> I'm testing the presence module (OpenSER 1.2) and noticed that there >>>>> is no final NOTIFY request sent when I send a SUBSCRIBE to >>>>> un-subscribe from a subscription. >>>>> >>>>> Is there anything to be configured ? >>>>> >>>>> Regards, >>>>> Pascal >>>>> >>>>> >>>>> _______________________________________________ >>>>> Users mailing list >>>>> Users(a)lists.openser.org >>>>> http://lists.openser.org/cgi-bin/mailman/listinfo/users >>>>> >>>>> >>>>> >>>>> >>> _______________________________________________ >>> Users mailing list >>> Users(a)lists.openser.org >>> http://lists.openser.org/cgi-bin/mailman/listinfo/users >>> >>> >>> >> > >

1 0

[OpenSER-Users] TLS Registrations start dropping?
by Chris Heiser 09 Nov '07

09 Nov '07

Information on TLS and OpenSER with this specific issues seems to be scarce. I have 2 different setups. One with about 130 registrations, one with about 250. Both with SSLv23 turned on, and TLS is enabled in the phones. What's odd is after some unknown amount of time, phones start dropping like files and fail to re-register. (Our registration timer is set at 60 seconds to aid in failover). What's interesting is it appears that the SSL handshake completely fails when this starts to happen. The requests from the phones are smaller in size (733 bytes about 970 for a good one). Suspicion would normally lie with the phones. They're obviously not doing something right! Here's the kicker. If I fail over to another OpenSER proxy (we move the IP over, use the same certs, etc...) everyone comes back up, and everything is happy for hours, maybe a day, maybe a week, and then it all starts going downhill again. I've increased the number of OpenSER children, I've played with the tcp_persistent_flag. None of these things have stopped the madness. Anyone have any ideas or thoughts? --Chris

2 5

[OpenSER-Users] Presence module - NOTIFY not sent after un-SUBSCRIBE
by Pascal Maugeri 09 Nov '07

09 Nov '07

Hi I'm testing the presence module (OpenSER 1.2) and noticed that there is no final NOTIFY request sent when I send a SUBSCRIBE to un-subscribe from a subscription. Is there anything to be configured ? Regards, Pascal

4 4

[OpenSER-Users] registrations not saved in the mysql database
by Ovidiu Sas 09 Nov '07

09 Nov '07

Hi all, I was trying to keep persistent registrations in the mysql db, but it seems that something is broken in the latest svn: version: openser 1.3.0-pre1-notls (i386/linux) flags: STATS: Off, EXTRA_DEBUG, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535 poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. svnrevision: 2:3034M @(#) $Id: main.c 3015 2007-11-05 13:08:50Z henningw $ main.c compiled on 11:41:03 Nov 6 2007 with gcc 4.1.2 The config that I used for testing is pretty simple: # ----------- global configuration parameters ------------------------ debug=9 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=no # (cmd line: -E) children=1 disable_tcp=yes # ------------------ module loading ---------------------------------- mpath="/usr/local/lib/openser/modules/" loadmodule "mysql.so" loadmodule "sl.so" loadmodule "tm.so" loadmodule "rr.so" loadmodule "maxfwd.so" loadmodule "textops.so" loadmodule "mi_fifo.so" modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo") loadmodule "usrloc.so" modparam("usrloc", "db_url", "mysql://openser:openserrw@127.0.0.1/openser") modparam("usrloc", "db_mode", 1) loadmodule "registrar.so" #------------------------- request routing logic ------------------- route{ if (!method=="REGISTER") record_route(); if (loose_route()) { # mark routing logic in request append_hf("P-hint: rr-enforced\r\n"); route(1); }; if (!uri==myself) { append_hf("P-hint: outbound\r\n"); route(1); }; if (uri==myself) { if (method=="REGISTER") { save("location"); exit; }; if (!lookup("location")) { sl_send_reply("404", "Not Found"); exit; }; append_hf("P-hint: usrloc applied\r\n"); }; route(1); } route[1] { if (!t_relay()) { sl_reply_error(); }; exit; } Here are the relevant debug logs: Nov 6 12:19:04 localhost /usr/local/sbin/openser[8963]: core:db_double2str: Error in snprintf Nov 6 12:19:04 localhost /usr/local/sbin/openser[8963]: mysql:val2str: error while converting string to double Nov 6 12:19:04 localhost /usr/local/sbin/openser[8963]: core:db_print_values: Error while converting value to string Nov 6 12:19:04 localhost /usr/local/sbin/openser[8963]: usrloc:db_insert_ucontact: inserting contact in db failed Nov 6 12:19:04 localhost /usr/local/sbin/openser[8963]: usrloc:insert_ucontact: failed to insert in database I can see the in memory registration via `openserctl ul show' command, but the mysql database is not updated (verified via `openserctl db show location') Regards, Ovidiu Sas

3 5

Re: [OpenSER-Users] CPL "Location" and "Proxy" behavior
by Bogdan-Andrei Iancu 09 Nov '07

09 Nov '07

Hi Daniel, Could please check the latest SVN version of 1.3 - I made a fix there. If everything ok, I will backport it to 1.2 also. Regards, Bogdan Daniel Grotti wrote: > *Hi Bogdan,* >> Hi Daniel, >> >> Hmmm....I see - you say (for outgoing scenario) that the location set >> is initialized with the A destination instead of B destination, right? > *yes, it's right.* >> If so, please open a bug report on the tracker. > *well, on the bug Repert, if I don't set any location (as in the last > script I have sended), I can see this DEBUG line: > " DEBUG:cpl_proxy_to_loc_set: rewriting Request-URI with < > A@A_ip_address>" > > where : "A@A_ip_address" is the caller IP address, not the destination > address (that is B). > * > > *regards. > daniel > * >> regards, >> Bogdan >> > > > >> Daniel Grotti wrote: >>> Hi bogdan, >>> If it's my cpl outgoing script configuration, from USER A >>> ****************************************************** >>> <cpl> >>> <outgoing> >>> <address-switch field="destination" subfield="user"> >>> <address is="B"> >>> <proxy /> >>> </address> >>> </address-switch> >>> </outgoing> >>> <cpl> >>> ******************************************************* >>> When I make a call from A to B, then the script has called, but in >>> debug I can see that CPL rewrites R-URI with source address >>> (A@A_ip_address) instead of destination address (B@B_ip_address). So >>> the message goes back to user A. >>> >>> regards, >>> Daniel >>> >>> Bogdan-Andrei Iancu wrote: >>>> Hi Daniel, >>>> >>>> there are no differences - the implementation follows the RFC. For >>>> incoming calls, the location set is empty, but it can be populated >>>> by the CPL script during execution. So, when you do "proxy", you >>>> may have multiple entries in the location set. >>>> >>>> The comment in the cpl_sig.c file refers to some implementation >>>> details - how to process the available location set, depeding if it >>>> is the first time doing proxy (for the call) or a second time. >>>> >>>> regards, >>>> bogdan >>>> >>>> daniel grotti wrote: >>>>> Hi all, >>>>> this is what CPL_SIG.c says about forwarding a given message to >>>>> the given location set: >>>>> >>>>> " forwards the msg to the given location set; if flags has set the >>>>> CPL_PROXY_DONE, all locations will be added as branches, >>>>> otherwise, the first one will set as RURI (this is ha case when >>>>> this is the first proxy of the message) >>>>> The given list of location will be freed, returning 0 instead. >>>>> Returns: 0 - OK " >>>>> >>>>> >>>>> My question is : which and what is "the first one" location ? Can >>>>> you explain it better? >>>>> Because RFC 3880 say that : "For the incoming top-level call >>>>> processing action, the location set is initialized to the empty set. >>>>> For the outgoing action, it is initialized to the destination >>>>> address of the call." >>>>> >>>>> So RFC is very clear. I think there are considerable differences >>>>> between RFC and the behavior of CPL interpreter. >>>>> >>>>> Thanks. >>>>> Daniel >>>>> >> >> >

1 0

[OpenSER-Users] CPL processing in OpenSER
by Chris Heiser 09 Nov '07

09 Nov '07

So voip-info.org's wiki page on CPL-C notest that the XML processing is resource consuming and thus common features can be implemented in other OpenSER modules. I was under the impression that the upload of a CPL script into openser caused a binary compile of the script that gets used at runtime to eliminate the terrible overhead of libxml, etc... Or am I completely off base? --Chris

4 4

[OpenSER-Users] lack of notify, subscribe problem
by Stanisław Pitucha 09 Nov '07

09 Nov '07

Hey I've got 2 issues with pub/sub: 1. Openser does correct subscription on grandstream 2020 phone. But then anything happens: register, invite, whatever from monitored phone, openser doesn't generate any notifications for subscribers. Any pointers on it? Is there some variable, that I should set to enable those? 2. Phone issue. Trying to start subscribe on snom 190 - messages sent are: ----- SUBSCRIBE ... ... Event: dialog Accept: application/dialog-info+xml ----- 202 OK ----- NOTIFY ... Event: dialog;sla Subscription-State: active;expires=3600\r\n ----- 489 Bad Event ----- Anything I can do about it? I've tried it with svn version with the same effect. Couldn't really find anything in docs that I could change in config. pub/sub is handled with simple handle_publish/handle_subscribe - nothing fancy in config - just location storing on register and message passing. Thanks for all info.

2 1

[OpenSER-Users] UAC_REPLACE_FROM function
by Allan Chao ( 趙廷睿 ) 09 Nov '07

09 Nov '07

Dear All: I want to use uac_replace_from function to change from header username, it will be successed in the first time , but when i use in the second time , the from header username become <username1 username2> . but i want it become <username2> , how can i solve it , thanks. allan

2 1

[OpenSER-Users] cdrtool radus openser.cfg configuration
by ayeddjalil 09 Nov '07

09 Nov '07

Hi every one It's my first time there, I am trying to install cdrtool, I installed openser with radius and mysql accounting, I follow the install file with cdrtool, but it seam it's not very clear I added these line in my openser.cfg as they said in the install file 268 loadmodule "acc.so" 269 270 modparam("acc", "failed_transaction_flag", 1) 271 modparam("acc", "report_cancels", 0) 272 modparam("acc", "report_ack", 0) 273 modparam("acc", "early_media", 0) 274 275 modparam("acc", "log_level", 1) 276 modparam("acc", "log_flag", 1) 277 modparam("acc", "log_missed_flag", 1) 278 279 modparam("acc", "radius_config", "/etc/openser/radius/client.conf") 280 modparam("acc", "radius_flag", 1) 281 modparam("acc", "radius_missed_flag", 1) 282 modparam("acc", "radius_extra", "Sip-RPid=$avp(s:rpid); \ 283 Source-IP=$si; \ 284 Source-Port=$sp; \ 285 Canonical-URI=$avp(can_uri); \ 286 Billing-Party=$avp(billing_party); \ 287 Divert-Reason=$avp(s:divert_reason); \ 288 X-RTP-Stat=$avp(s:rtp_statistics); \ 289 From-Header=$hdr(from); \ 290 User-Agent=$hdr(user-agent); \ 291 Contact=$hdr(contact); \ 292 Event=$hdr(event); \ 293 SIP-Proxy-IP=$avp(s:sip_proxy_ip)") alone opense do not start intill I added this loadmodule "auth_radius.so" loadmodule "group_radius.so" loadmodule "avp_radius.so" modparam("acc", "service_type", 15) modparam("acc", "radius_extra", "Sip-Src-IP=$si;Sip-Src-Port=$sp") modparam("acc|auth_radius|group_radius|avp_radius", "radius_config", "/etc/radiusclient-ng/radiusclient.conf") the next problem is when adding setflag(ACCOUNTING_FLAG); avp_write("SER_IP","$avp(s:sip-proxy)"); avp_write("$ru", "$avp(can_uri)"); errors comes, here what I get from the command /sbin/openser -c 0(22857) parse error (123,9-24): syntax error 0(22857) parse error (123,9-24): missing '(' or ')'? 0(22857) parse error (123,9-24): bad command: missing ';'? 0(22857) parse error (123,24-25): bad command!) 0(22857) parse error (124,24-25): unknown command, missing loadmodule? 0(22857) parse error (125,25-26): unknown command, missing loadmodule? ERROR: bad config file (6 errors) 0(22857) INFO:mi_fifo:mi_destroy:memory for the child's mi_fifo_pid was not allocated -> nothing to destroy is thier any one has a sample of openser.cfg file for cdrtool Please help -- View this message in context: http://www.nabble.com/cdrtool-radus-openser.cfg-configuration-tf4776366.htm… Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

1 0

Re: [Serusers] Spam Re: Voicemail setup on SER v0.9.6
by roayu 09 Nov '07

09 Nov '07

Hi Mashudi, Thanks for your reply. From the documentation, it seems that I need to install both SER and SEMS under the same directory. 1) I've already installed the SER under /usr/src, can I also install SEMS under /usr/src instead of /usr/local/src ? 2) By the way, I would like to know that does this voicemail able to trigger the voicemail on the IP hard phone? For instance, if there's a new voicemail, can the IP hard phone got the signal of the new voicemail? Thanks. Regards, Roa Yu -----Original Message----- From: mashudi [mailto:mashudiflexi@telkom.co.id] Sent: Saturday, November 10, 2007 2:04 AM To: roayu Subject: Spam Re: [Serusers] Voicemail setup on SER v0.9.6 dear roayu, you can read on http://www.iptel.org/sems/sems_application_development_tutorial just follow the document, you will able run simple voice mail. roayu wrote: > ********************** > Your mail has been scanned by > Telkom Anti Virus System > *********************** > > Hi there! > > > > Could anyone let me know how to setup Voicemail on SER v.0.9.6 ? Do I > need to install SEMS as well? > > > > Thanks > > > > > > Regards, > > Roa Yu > > ------------------------------------------------------------------------ > > _______________________________________________ > Serusers mailing list > Serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers >

1 0

[Serusers] Voicemail setup on SER v0.9.6
by roayu 09 Nov '07

09 Nov '07

Hi there! Could anyone let me know how to setup Voicemail on SER v.0.9.6 ? Do I need to install SEMS as well? Thanks Regards, Roa Yu

1 0

[OpenSER-Users] Forking Madness
by Chris Heiser 09 Nov '07

09 Nov '07

So I've been all over the place looking at various examples, threads, issues, and solutions to all sorts of forking scenarios. What I haven't been able to find is a solution to my odd corner case. Let me explain the forking scenario: Call comes in for user A: - Use avp_db_load to find that user A wants to parallel fork to 123 and 456 - Call to 123 fails because there's no registration - Call to 456 times out == At this point we serial fork to the next step which might hbe - Just call my cell What's unclear to me is how to actually achieve this logic. I mean, getting the initial parallel fork is quite simple using avp_pushto. What's unclear is how to setup the failure route to know that you can ignore a failure in any of the forks until the last fork as failed, and then it's time to move on. Something like, "are there other branches pending?" would be a nice check to determine if the failure route should just drop or if it should append a branch (or two) for the next serial fork. Comments? Ideas? Thoughts? Am I totally insane? Should I be using a specific module for this? --Chris Heiser

4 9

[OpenSER-Users] openser + cdrtool and multiple cdrs
by Morten Isaksen 08 Nov '07

08 Nov '07

Hi! I few times a day I have 2 cdrs for one call but with reverse direction. I have looked at the radius server detail records and as far as I can see this happens: A Acct-Status-Type = Start with Acct-Session-Id = X1 and Sip-To-Tag = X2 and Sip-From-Tag = X3 is logged. I few seconds later Acct-Status-Type = Start with Acct-Session-Id = X1 and Sip-To-Tag = X3 and Sip-From-Tag = X2 is logged. (To and From tag is reversed) When the call is over a Update and a Stop is logged. The Acct-Status-Type is not a unique key in the raddact table and there for I get a CDR for each direction. My theory is that this happens when the server recieves a re-INVITE. Can I prevent this in openser.cfg? Is it safe to add Acct-Session-Id as a unique key to the raddact table? Or is the Session id not globaly unique? -- Morten Isaksen http://www.misak.dk/blog/

1 0

Re: [OpenSER-Users] Storing SIP Response Codes with avpops?
by Douglas Garstang 08 Nov '07

08 Nov '07

Thanks, but when I try that, I get the following error from openser: Nov 7 23:17:32 localhost openser[7035]: ERROR:xl_parse_spec: bad pvar name "rr{s.escape.common})') " Nov 7 23:17:32 localhost openser[7035]: ERROR:avpops:fixup_db_query_avp: wrong format[insert into sip_responses (response_code, response_reason) values ('$rs', '$(rr{s.escape.common})') ] Nov 7 23:17:32 localhost openser[7035]: ERROR: fix_actions: fixing failed (code=-1) at cfg line 139 OpenSER also complains that i need to specify an avp table, but since I am specifying the table in the query, I don't understand why that's required. Douglas. ----- Original Message ---- From: Daniel-Constantin Mierla <daniel(a)voice-system.ro> To: Douglas Garstang <dougmig33(a)yahoo.com> Cc: users(a)lists.openser.org Sent: Thursday, November 8, 2007 11:57:35 AM Subject: Re: [OpenSER-Users] Storing SIP Response Codes with avpops? Hello, On 11/08/07 21:40, Douglas Garstang wrote: > All, > > I'd like to store SIP response codes in mysql using avpops. Is this > possible? > > I tried to do this a few years ago and couldn't find any > documentation. Unfortunately, I still can't find any. > > Can someone post an example? All I can find online is reference > documentation for avpops. > > I'd really like to see a full example with the modparams defining the > table structure, and how I would use avp_write and avp_db_store to > write the $rr response code. the easiest way is to use avp_db_query(), you can give as parameter any sql query. In your case, you can use in onreply_route: avp_db_query("insert into sip_responses (response_code, response_reason) values ('$rs', '$(rr{s.escape.common})') "); You need to create the table sip_responses, with the two string columns. Daniel > > Thanks. > Douglas. > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > Users(a)lists.openser.org > http://lists.openser.org/cgi-bin/mailman/listinfo/users > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

[OpenSER-Users] Storing SIP Response Codes with avpops?
by Douglas Garstang 08 Nov '07

08 Nov '07

All, I'd like to store SIP response codes in mysql using avpops. Is this possible? I tried to do this a few years ago and couldn't find any documentation. Unfortunately, I still can't find any. Can someone post an example? All I can find online is reference documentation for avpops. I'd really like to see a full example with the modparams defining the table structure, and how I would use avp_write and avp_db_store to write the $rr response code. Thanks. Douglas. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

Re: [OpenSER-Users] OpenSER SIP registrar - third party registration
by Klaus Darilion 08 Nov '07

08 Nov '07

Pascal Maugeri wrote: > Thanks for your prompt answer. > > On 10/19/07, Klaus Darilion <klaus.mailinglists(a)pernau.at> wrote: >> It depends on what kind of information should be stored in the other >> server. If you "your server" needs to see the same contact information >> as openser received you could use t_replicate to replicate the REGISTER >> to "your server". In this case "your server" must not challenge the >> REGISTER. > > My server does not need to store any information but the information > that a user has been registered. > > I believe the solution I need is to use this t_replicate but I need to > replicate the register once the registration is achieved successfully. > So how can I do this replicate to my server once the complete dialog > REGISTER-401-REGISTER-OK has been achieved between the UAC and OpenSER > ? Just use t_replicate after save(), e.g: http://lists.iptel.org/pipermail/serdev/2006-June/007518.html regards klaus ps: please Cc: the mailing-list

3 2

[OpenSER-Users] [AS WeSIP & OpenIMSCore]
by Alscion MailingList 08 Nov '07

08 Nov '07

Hi, Does anybody successed to trigg the WeSIP AS with Fokus OpenIMSCore? Do you have some informations about that? Thx.

1 0

[OpenSER-Users] X-lite (for Linux) and BYE Scenario
by Daniel Grotti 08 Nov '07

08 Nov '07

Hi All, I've noticed that using X-lite (for Linux) there are some problems with BYE method. When X-lite generates BYE, it puts in the Route Header field the address known through the record-route added by proxy. As "SER - Gettin Started" shown, an address like : IP_proxy:5060;nat=yes: " /.... .... if(method=="INVITE" && client_nat_test("7")) { record_route_preset ("proxy_ip_address :5060;nat=yes"); .... } /" 1. When we have a BYE message sended by X-lite (user A), it is like this: "/Request-Line: BYE sip: B@proxy_ip_address : 5060 SIP/2.0 Via: SIP/2.0/UDP A_address:5061; rport;branch=xyz From: <sip: A@proxy_ip_address:5061>;tag=123 To: <sip: B@proxy_ip_address:5060>;tag=456 Contact:<sip:A@A_address:5061> * Route: <sip: proxy_ip_address:5060; nat=yes; ftag=9098789; lr=on>* .... ..... .... "/ 2. Now the message BYE is parsed by the Proxy, and it uses the loose_route(): /if(loose_route())/ { forward the message }; but Proxy doesn't recognizes its address and then rewrites the R-URI with the address in Route header field and sends the BYE message.....to itself! then Proxy parses the new BYE (sended by itself) with the URI :/* <sip: proxy_ip_address:5060; nat=yes; ftag=9098789; lr=on>,*/ the the answer to user A is : 404 Destination not found! Why doesn't OpenSER, in the loose_route() function, recognize its address in Route header field? This is what should it do. And then, delete the route header field and then forward the message using R-URI. I think there is something wrong.... Regards, Daniel -- --------------------------------------------------- Daniel Grotti DEIS - University of Bologna Via Venezia, 52 - 47023 Cesena (FC) - ITALY Contacts e-mail : daniel.grotti(a)unibo.it Skype name : Daniel Grotti ---------------------------------------------------

1 0

[Serusers] What are the possible HFNAME values in hf selects in ser rel_2_0_0?
by Tomasz Zieleniewski 08 Nov '07

08 Nov '07

Hi, What are the possible HFNAME values in hf selects in ser rel_2_0_0? When I try to add my own header and then use the a select for it the select is empty. I do it for P-Asserted-Identity header I did the following selects and no results: xlog("L_INFO", " route[AUTHENTICATION]: P-ASS: %(a)hf_value.p-asserted-identity \n"); xlog("L_INFO", " route[AUTHENTICATION]: P-ASS: %(a)hf_value.P_Asserted_Identity \n"); xlog("L_INFO", " route[AUTHENTICATION]: P-ASS: %(a)hf_value.p_asserted_identity \n"); xlog("L_INFO", " route[AUTHENTICATION]: P-ASS: %(a)hf_value2.p-asserted-identity \n"); xlog("L_INFO", " route[AUTHENTICATION]: P-ASS: %(a)hf_value2.P_Asserted_Identity \n"); xlog("L_INFO", " route[AUTHENTICATION]: P-ASS: %(a)hf_value2.p_asserted_identity \n"); Please point me what do I miss. Regards Tomasz

2 1

[Serusers] (no subject)
by Shad Mortazavi 08 Nov '07

08 Nov '07

Shad Mortazavi UK Managing Director Nexus Management (EMEA) Ltd -------------------- T: +44 (0)844 484 2574 M: +44 (0)781 721 0758 Sent from Windows Mobile.

1 0

Re: [OpenSER-Users] CPL "Location" and "Proxy" behavior
by Bogdan-Andrei Iancu 08 Nov '07

08 Nov '07

Hi Daniel, Hmmm....I see - you say (for outgoing scenario) that the location set is initialized with the A destination instead of B destination, right? If so, please open a bug report on the tracker. regards, Bogdan Daniel Grotti wrote: > Hi bogdan, > If it's my cpl outgoing script configuration, from USER A > ****************************************************** > <cpl> > <outgoing> > <address-switch field="destination" subfield="user"> > <address is="B"> > <proxy /> > </address> > </address-switch> > </outgoing> > <cpl> > ******************************************************* > When I make a call from A to B, then the script has called, but in > debug I can see that CPL rewrites R-URI with source address > (A@A_ip_address) instead of destination address (B@B_ip_address). So > the message goes back to user A. > > regards, > Daniel > > Bogdan-Andrei Iancu wrote: >> Hi Daniel, >> >> there are no differences - the implementation follows the RFC. For >> incoming calls, the location set is empty, but it can be populated by >> the CPL script during execution. So, when you do "proxy", you may >> have multiple entries in the location set. >> >> The comment in the cpl_sig.c file refers to some implementation >> details - how to process the available location set, depeding if it >> is the first time doing proxy (for the call) or a second time. >> >> regards, >> bogdan >> >> daniel grotti wrote: >>> Hi all, >>> this is what CPL_SIG.c says about forwarding a given message to the >>> given location set: >>> >>> " forwards the msg to the given location set; if flags has set the >>> CPL_PROXY_DONE, all locations will be added as branches, >>> otherwise, the first one will set as RURI (this is ha case when >>> this is the first proxy of the message) >>> The given list of location will be freed, returning 0 instead. >>> Returns: 0 - OK " >>> >>> >>> My question is : which and what is "the first one" location ? Can >>> you explain it better? >>> Because RFC 3880 say that : "For the incoming top-level call >>> processing action, the location set is initialized to the empty set. >>> For the outgoing action, it is initialized to the destination >>> address of the call." >>> >>> So RFC is very clear. I think there are considerable differences >>> between RFC and the behavior of CPL interpreter. >>> >>> Thanks. >>> Daniel >>>

1 0

[OpenSER-Users] CPL "Location" and "Proxy" behavior
by daniel grotti 08 Nov '07

08 Nov '07

Hi all, this is what CPL_SIG.c says about forwarding a given message to the given location set: " forwards the msg to the given location set; if flags has set the CPL_PROXY_DONE, all locations will be added as branches, otherwise, the first one will set as RURI (this is ha case when this is the first proxy of the message) The given list of location will be freed, returning 0 instead. Returns: 0 - OK " My question is : which and what is "the first one" location ? Can you explain it better? Because RFC 3880 say that : "For the incoming top-level call processing action, the location set is initialized to the empty set. For the outgoing action, it is initialized to the destination address of the call." So RFC is very clear. I think there are considerable differences between RFC and the behavior of CPL interpreter. Thanks. Daniel ----------------------------- Daniel Grotti DEIS - Universita' di Bologna ----------------------------- Via Venezia, 52 47023 Cesena (FC) - ITALY ----------------------------- email:daniel.grotti@unibo.it -----------------------------

2 1

[Serusers] Openser bridging
by Max Lock 08 Nov '07

08 Nov '07

Hi Folks, I'm still struggling with bridging openser between a public and a private network. The private 10.10.12.0/24 network connects openser and an asterisk server that plays a file and hangs up. I've got 2 sip clients connected to the public and private sides of the openser server. When I make calls via openser to the asterisk box, I only get audio on the private networks sip client, and neither client gets hung up correctly at the end of the call. I've put the SIP debug from the external client here: http://pastebin.com/m388a707d My openser and rtpproxy configs are here: http://pastebin.com/m3ed309d3 Can anyone give me any pointers? I've been staring at this for days :( -Cheers Max

2 1

[Serusers] Integrate LCS & SER Server
by elilkumaran s 07 Nov '07

07 Nov '07

Sir/Madam I'm a System administrator of Institute. I use MS LCS 2005 SP1 Enterprise edition & Office Communicator in my work place. I have linux SER Server & CISCO ATA 186 Telephone adapter. I have to run to Messenger client X-Lite for SER Server and Office Communicator for LCS. Because I place TP in Guard Office they can call Staff through SER server / X-Lite. But can't call Office Communicator! CISCO ATA 186 can't registering in LCS, I thing it not possible directly. ( Because LCS use Active Directory Account through Kerbas & NTLM authentication). So I want integrate LCS & SER Server to facilitate TP call to Office Communicator & Office Communicator call TP. I use a pool in LCS as normal TCP (not TLS). SER Server also use normal (with out DB -Any one can registrar with any name) Could you kindly tell the process for integrate LCS & SER Server? Thank You Your truly Elil

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users