sr-users

sr-users@lists.kamailio.org

19 participants
37530 discussions

RE: [Users] Presence server with MySQL >=5.0.26
by Watkins, Bradley 16 Nov '06

16 Nov '06

> -----Original Message----- > From: users-bounces(a)openser.org > [mailto:users-bounces@openser.org] On Behalf Of Mike Williams > Sent: Thursday, November 16, 2006 12:31 PM > To: users(a)openser.org > Subject: Re: [Users] Presence server with MySQL >=5.0.26 > > All, > > I would still be in favor of moving all of the tables over to > having the primary key be an autoincremented unsigned int. > > > Mike Williams I'm certainluy not opposed to this, especially with the "oh yeah, UTF-8" clue bat Norman hit me with. ;) I was mostly pointing out that there is nothing inherent in MySQL 5.0.26 and up that precludes this table definition (unless you're using UTF-8, of course). - Brad The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

1 0

RE: [Users] Presence server with MySQL >=5.0.26
by Watkins, Bradley 16 Nov '06

16 Nov '06

I originally sent this to the OP instead of the list by mistake: This sounds like a bug in the package you're using or MySQL 5.0.26 itself. The storage requirements for the key should be 388 bytes, which is much less (obviously) than the maximum key length of a MyISAM table. Empirically, I tested this on MySQL 5.0.22 (Fedora RPMs) and MySQL 5.1.11 (RPMs from MySQL's website) with the original values and they both worked. The documentation for 5.0 and 5.1 on MySQL's site both state the 1000 byte limitation (that is, without code modification). As an additional data point not in the original e-mail above, using the 5.0.27 .tar.gz from MySQL also has no problems with this table definition. I've even gone so far as doubling the size of the fields used for the PK, and none of the aforementioned versions balked. With the original sizes, it should even work in older (I think pre 4.1.12?) versions of MySQL where the max key length is 500 bytes. I really don't think there's a problem here. Regards, - Brad > -----Original Message----- > From: users-bounces(a)openser.org > [mailto:users-bounces@openser.org] On Behalf Of Bogdan-Andrei Iancu > Sent: Thursday, November 16, 2006 7:06 AM > To: Nicolas Palix; Anca Vamanu > Cc: users(a)openser.org > Subject: Re: [Users] Presence server with MySQL >=5.0.26 > > Hi Nicolas, > > I think the solution will be to have a primary key a simple > unsigned int outincrement field in the table and move the > primary key as unique. > > I will ask Anca to do this change as most probably it will be > a good idea to do it for the rest of the tables also. > > regards, > Bogdan > > Nicolas Palix wrote: > > >Hi, > > > > > >The primary key of the watchers is too long with this > version of MySQL: > >"Specified key was too long; max key length is 1000 bytes" > > > >Downgrading "[pw]_domain" from 128 to 96. Works. > > > >CREATE TABLE `watchers` ( > > `p_user` varchar(64) NOT NULL, > > `p_domain` varchar(96) NOT NULL, > > `w_user` varchar(64) NOT NULL, > > `w_domain` varchar(96) NOT NULL, > > `subs_status` varchar(64) NOT NULL, > > `reason` varchar(64) NOT NULL, > > PRIMARY KEY (`p_user`,`p_domain`,`w_user`,`w_domain`) > >) ENGINE=MyISAM; > > > >Regards > > > > > > > _______________________________________________ > Users mailing list > Users(a)openser.org > http://openser.org/cgi-bin/mailman/listinfo/users > > The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

4 3

Re: [Users] Can We Use the Stun server for NAT supporting,
by Daniel-Constantin Mierla 16 Nov '06

16 Nov '06

Hello, On 11/15/06 14:08, raviprakash sunkara wrote: > Hello Daniel > Thanks for reply me... > > if U keep My Sip Server direct from Modem( ISP ) to System , Its > working fine, > But problem is when keep My sip Server Behind the Router/Firewall it > not working, UAC's behind the NAT is not Hungup and Audio is Fine at > end points... > Help me ............ check what happens on the firewall/nat, if the messages are forwarded properly between public and private networks. ngrep or ethereal should help here ... Cheers, Daniel > > > On 11/15/06, *Daniel-Constantin Mierla* <daniel(a)voice-system.ro > <mailto:daniel@voice-system.ro>> wrote: > > Hello, > > stun is recommended when the client properly implements it and > does not > sit behind a symmetric NAT (like linux box). For these cases you > need to > use server side nat traversal, look at nathelper/rtpptoxy or > mediaproxy/mediaproxy. > > Cheers, > Daniel > > > On 11/13/06 16:29, raviprakash sunkara wrote: > > Hello Users, > > > > Can I use the Stun server to Support the NAT. > > > > I tried a lot , My UAC's are Not Hungupping in Behind the > NAT/Router > > > > My SIP ip is 192.168.2.75 <http://192.168.2.75> > <http://192.168.2.75 > > > My Public IP is xx.xx.xx.xx > > > > I didn't get any Bye request to SIP server, except the Bye all the > > other Messages are Requested to MY SIP Server > > > > in openser.cfg > > i > > I'm using X-lites for testing in that > > RTP port 12222 > > NAT firewall ip is 192.168.2.1 <http://192.168.2.1> > <http://192.168.2.1> > > Sip domain is xx.xx.xx.xx > > Sip proxy xx.xx.xx.xx > > ______________________________________________ > > modparam ("nathelper",rtpproxy_sock","udp: 192.168.2.75:12222 > <http://192.168.2.75:12222> > > <http://192.168.2.75:12222>" > > > > if(nat_uac_test("19")) > > { > > if(method=="REGISTER") > > { > > fix_nated_register(); > > force_rport(); > > setflag(6); > > } else > > { > > > > if(method=="INVITE") > > { > > fix_nated_sdp("3") > > }; > > fix_nated_contact(); > > }; > > }; > > ______________________________________________ > > -- > > Thanks and Regards > > Ravi Prakash Sunkara > > ravi.sunkara(a)hyperion-tech.com > <mailto:ravi.sunkara@hyperion-tech.com> > <mailto:ravi.sunkara@hyperion-tech.com > <mailto:ravi.sunkara@hyperion-tech.com>> > > M:+91 9985077535 > > O:+91 40 23114549 > > F:+91 40 40208727 > > ravi.sunkara(a)hyperion-tech.com > <mailto:ravi.sunkara@hyperion-tech.com> <mailto: > ravi.sunkara(a)hyperion-tech.com > <mailto:ravi.sunkara@hyperion-tech.com>> > > www.hyperion-tech.com <http://www.hyperion-tech.com> > <http://www.hyperion-tech.com> > > > ------------------------------------------------------------------------ > > > > > _______________________________________________ > > Users mailing list > > Users(a)openser.org <mailto:Users@openser.org> > > http://openser.org/cgi-bin/mailman/listinfo/users > > > > > > > -- > Thanks and Regards > Ravi Prakash Sunkara > ravi.sunkara(a)hyperion-tech.com <mailto:ravi.sunkara@hyperion-tech.com> > M:+91 9985077535 > O:+91 40 23114549 > F:+91 40 40208727 > ravi.sunkara(a)hyperion-tech.com <mailto:ravi.sunkara@hyperion-tech.com> > www.hyperion-tech.com <http://www.hyperion-tech.com>

1 0

[Users] Radius extra: integer attribute type how to
by Pletli Antal 16 Nov '06

16 Nov '06

Hello, I'm trying the radius-extra feature in openser cvs snapshot. In my openser.cfg I set up the following parameter: modparam("acc", "radius_extra", "Acct-Session-Time=$avp(call_length)") modparam( "avpops", "avp_aliases", "start_timestamp=i:100") modparam( "avpops", "avp_aliases", "end_timestamp=i:101") modparam( "avpops", "avp_aliases", "call_length=i:102") (...) avp_op("$avp(end_timestamp)","sub/$avp(start_timestamp)"); avp_op("$avp(end_timestamp)/$avp(call_length)","sub/$avp(start_timestamp )"); I have experienced that when I sent an Accounting-Stop request to radius server, it received the integer value as an string and it decoded the value to the chr code of the "3" In the radius log: * Attr: 46 - Acct-Delay-Time len: 6 val: 51 In the openser.log: Nov 14 16:12:09 sip2 ./openser[727]: INFO:avpops:print_avp: p=0x40623b88, flags=0x0000 Nov 14 16:12:09 sip2 ./openser[727]: INFO: id=<102> Nov 14 16:12:09 sip2 ./openser[727]: INFO: val_int=<3> How can I set the corresponding integer attribute in the request? Thanks in advance, Antal

2 1

[Users] Presence server with MySQL >=5.0.26
by Nicolas Palix 16 Nov '06

16 Nov '06

Hi, The primary key of the watchers is too long with this version of MySQL: "Specified key was too long; max key length is 1000 bytes" Downgrading "[pw]_domain" from 128 to 96. Works. CREATE TABLE `watchers` ( `p_user` varchar(64) NOT NULL, `p_domain` varchar(96) NOT NULL, `w_user` varchar(64) NOT NULL, `w_domain` varchar(96) NOT NULL, `subs_status` varchar(64) NOT NULL, `reason` varchar(64) NOT NULL, PRIMARY KEY (`p_user`,`p_domain`,`w_user`,`w_domain`) ) ENGINE=MyISAM; Regards -- Nicolas Palix http://phoenix.labri.fr/people/palix/

2 1

[Fwd: Re: [Users] Presence module and Snom phones]
by Anca Vamanu 16 Nov '06

16 Nov '06

1 0

[Users] module registrar and path_mode
by Gregoire 16 Nov '06

16 Nov '06

Hi everybody! I want to use the Path support in the module registrar. So I set, in my configuration file, the following parameters: loadmodule "/usr/lib/openser/modules/registrar.so" modparam("registrar", "use_path", 1) modparam("registrar", "path_mode", 2) I expected that OpenSER rejects all REGISTER requests that not have the Path support indicated but in fact it accepts the REGISTER and reply with a 200 OK instead of a 420 - Bad Extension. I am using OpenSER 1.1.0 with TLS support in a debian package. Does anyone have some experience with this module? Thanks Greg

2 3

[Serusers] (no subject)
by ali daher 15 Nov '06

15 Nov '06

I have configured SER on IPV6 on a linux suse 10.1, and i changed ser.cfg so that the server supports IPV6 my clients are on a windows machine and they run also on ipv6 i'm facing a problems: i did set the sip account for a client , after that it rediscovers the network but it can not register and i get this message: registration error 503 service unavaialable so what is the problem and what can i do? regards _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

2 2

[Serusers] Using SER with TLS
by Lami, Avner 15 Nov '06

15 Nov '06

Hello, We have SIP equipment that can work with UDP and TCP. We made many tests with SER and we didn't find any interoperability problems yet. We need to find solution for one of our customers and we want to check whether we can use SER. Our customer use Microsoft LCS 2005 with TLS. Because our equipment can't work with TLS we want to check if we can use SER as proxy that will connect between our equipment and the LCS and will make the translation between TCP to TLS and vice versa. Our questions are: 1) How can we use SER for that solution? 2) Did you make interoperability tests between SER and Microsoft LCS using TLS? 3) Where can we find documentation regarding such scenarios? Regards, Al

2 1

[Serusers] 603 Decline Problem
by pol 15 Nov '06

15 Nov '06

Hi, We are using SER inside a platform we are developing. We have noticed that when the called user reject the call when it hasn't established, SER sends multiple 603 Declined messages to the caller user. I think SER should send just one 603 Declined messages. Is it correct? Any idea? Thanks in advance,

2 1

Jump to page:

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