> -----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.
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.
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>
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
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/
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
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/
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
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,