I'm trying to build the tables needed for ser in mysql, through the ser_mysql.sh script. This script asks me for a passwd, after the passwd, he gives the following error:
ERROR 1007 (HY000) at line 1: Can't create database 'ser'; database exists.
I'm entering the ser user passwd but i can't get it to work. I tried to create the user ser at mysql with the following command
mysql> create user ser password mvx
But it gives the following error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user ser password mvx' at line 1
I'm using mysql version 4.1.7 ...
What am I doing wrong ?
--
Felipe Martins
Linux System Administrator
Tep Solution Provider
Mundivox Communications
Rua Lauro Muller, 116/Sala 505
RJ - Brasil - 22290-906
Tel.: 55 21 3820-8839
Fax.: 55 21 3820-8844
Dear all,
I was wondering if the current version of SER (0.8.14) is RFC2543 or RFC3261
compliant. On the web it is described as RFC3261 compliant but on the
product sheet as RFC2543.
Can anybody please help me?
Thank you in advance.
Cheers,
Edu
Hi,
I have a problem with the digest authentification: here is my ser.cfg:
_________________________________________________
modparam("usrloc", "db_mode", 2)
modparam("auth", "password_column", "HA1")
modparam("auth", "password_column_2", "ha1b")
.....
if (method=="REGISTER") {
if (!www_authorize("192.168.3.1", "subscriber")) {
www_challenge("192.168.3.1", "1");
break;
};
save("location");
break;
};
..............
________________________________________________
Here are the server auth. request:
WWW-Authenticate: Digest realm="192.168.3.1",
nonce="41a4bc4b000000005991791bfd119f83463ba82e93c3e1cc", qop="auth",
algorithm=MD5
and the client reply:
Authorization: Digest username="nico",realm="192.168.3.1",
nonce="41a4bc4b000000005991791bfd119f83463ba82e93c3e1cc",
response="469f787618a743f08dd6e8768df3173f",uri="sip:192.168.3.1",
algorithm=MD5,qop=auth,cnonce="A8858AF297CE4CE5AC94ADE4467C8A9B",nc=00000134
______________________________________________________
Please !!! helpme, I've spent 2 days on it and... nothing !
Thanks
Vous manquez despace pour stocker vos mails ?
Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/
Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis. A télécharger gratuitement sur http://fr.messenger.yahoo.com
All,
I read up on the acc module regarding account, however the
reliability of the CDR's seems somewhat iffy. The biggest problem is of
course SER isn't "session-stateful", has anyone found a workaround for
this? Perhaps an external application to help with this process? Any
advice is appreciated.
Matt
Hi folks!
I have many users logged on my SER proxy, and routing works fine, but
for some destinations, I have to relay the call for another sip proxy.
Well, on the second proxy, my users login doesn't exist, so I have to
rewrite the username or credentials, before to relay!
I have tried with setuserpass and sethost but doesn't work...
My question is: does this is a normal thing, or I don't have to change
the username from sip message?
Regards.
Hi all,
I'm trying to implement the MD5 digest authentication in my SIP client to
register with SER, and I sent and receive:
REGISTER sip:10.0.0.113:6060 SIP/2.0
Via: SIP/2.0/UDP 205.150.90.93:5060;branch=z9hG4bK0167f788a27be2
From:
<sip:VoiceGenie@10.0.0.113:6060>;tag=AB7327E9-BD62-46F5-F2A0-55C60D2C15A3
To: <sip:VoiceGenie@10.0.0.113:6060>
Max-Forwards: 70
CSeq: 1 REGISTER
Call-ID: ED2DD8A5-2A10-40F6-5BA1-27F0DE4456D1@205.150.90.93:5060
Contact: <sip:VoiceGenie@205.150.90.93:5060>;expires=60
Content-Length: 0
SIP/2.0 401 Unauthorized
Via: SIP/2.0/UDP 205.150.90.93:5060;branch=z9hG4bK0167f788a27be2
From:
<sip:VoiceGenie@10.0.0.113:6060>;tag=AB7327E9-BD62-46F5-F2A0-55C60D2C15A3
To:
<sip:VoiceGenie@10.0.0.113:6060>;tag=224edcece75971e271cb292defd4983a.bf0d
CSeq: 1 REGISTER
Call-ID: ED2DD8A5-2A10-40F6-5BA1-27F0DE4456D1@205.150.90.93:5060
WWW-Authenticate: Digest realm="iptel.org",
nonce="41a27b3b6184801b57dba727f73804c29f91f1b3"
Server: Sip EXpress router (0.8.14 (i386/linux))
Content-Length: 0
Warning: 392 10.0.0.113:6060 "Noisy feedback tells: pid=9455
req_src_ip=205.150.90.93 req_src_port=5060 in_uri=sip:10.0.0.113:6060
out_uri=sip:10.0.0.113:6060 via_cnt==1"
Following RFC 2617,
A1 = admin:iptel.org:heslo
(where SER's default username:password pair "admin:heslo" are used, with
realm="iptel.org)
A2 = REGISTER:sip:10.0.0.113:6060
(where method="REGISTER" and digest-url="sip:10.0.0.113:6060" which agrees
with request URI, and note that SER is running at 10.0.0.113, port = 6060)
Response was calculated as
MD5( MD5(A1):nonce:MD5(A2) )
And my new REGISTER msg is:
REGISTER sip:10.0.0.113:6060 SIP/2.0
Via: SIP/2.0/UDP 205.150.90.93:5060;branch=z9hG4bK01683cc0a27be2
From:
<sip:VoiceGenie@10.0.0.113:6060>;tag=A1C28CFF-9D16-47DD-059A-0E8F88F7F4AE
To: <sip:VoiceGenie@10.0.0.113:6060>
Max-Forwards: 70
CSeq: 2 REGISTER
Call-ID: 30EB6AEA-9A88-4D34-1E92-5050F566665B@205.150.90.93:5060
Contact: <sip:VoiceGenie@205.150.90.93:5060>;expires=60
Content-Length: 0
Authorization: Digest username="admin", realm="iptel.org",
nonce="41a27b3b6184801b57dba727f73804c29f91f1b3", uri="sip:10.0.0.113:6060",
response="55a3888ff8ff7e8a9b31e38091effe21"
But I still get another 401 Unauthorized response ...
I'm pretty sure my A1 is correct. Could it be my A2 where method shouldn't
be REGISTER? Or may be the digest-uri is wrong?
Thank you in advance.
Andrew Ho
Hello List.
I'm trying to set up an enviroment where i have one SER instance (in
one machine), managing two domains. For this i defined two domains
pointing to the same machin. Let's say :
sip1.mydomain.comsip2.mydomain.com
both of them pointing to the 10.0.0.5 (SER).
My configuration file (ser.cfg) is something like this.
route {
if ... {
max_forward routine
};
if ... {
message_too_big routine
};
if (uri=="sip1.mydomain.com") {
if (method=="REGISTER") {
REGISTER_1 routine
};
exec 1 routine
routing 1 routine
} else if (uri=="sip2.mydomain.com")
if (method=="REGISTER") {
REGISTER_2 routine
};
exec 2 routine
routing 2 routine
};
if (!t_relay()) {
sl_reply_error();
break;
};
}
route[1]
....
route[2]
....
I also have in my ser.cfg
#module domain
modparam("domain", "db_url", "/usr/local/etc/ser/domaintables")
modparam("domain", "domain_table", "domain")
modparam("domain", "domain_col", "domain")
Where my domain file is like this:
domain(str)
sip1.mydomain.comsip2.mydomain.com
For this setup i run SER and there is no errors in the initialization. But
when a UA is trying to register, for any domain, is getting the "Too many
Hops" message. I think is maybe a problem with my host name or something
like this.
I don't know what i'm dogin wrong. Do i have to set up something else?,
maybe in my hosts file?.
I really hope that someone could help me.
Best regards,
Ricardo Martinez
Hi all !
How can I use rtpproxy if i want redirect connection
from my client behind NAT to another user registered on another sip server
I can't use SRV records
# redirection to another sip server
if (uri=~"sip:1([0-9])*@.*") {
setflag(1);
strip(1);
if (nat_uac_test("3")) {
fix_nated_sdp("1");
force_rport();
fix_nated_contact();
force_rtp_proxy();
};
record_route();
sethostport("another.sip.server.pl:5060");
if (!t_relay()) {
sl_reply_error();
};
break;
t_relay();
};
The connection is estabilished fine but I don't hear
Thanks
Andrzej
Has anyone tried, with or without success, using linux virtual server
along with SER for load balancing? Is this a good or bad idea? Any
ideas or suggstions are welcome. Thanks.
