Trying to create alias, I am getting the following message:
"400 Table 'aliases' Not Found"
Could any can help ? Why the above mentioned table has not been created
?
What is exactly the <uri> format ?
What is the solution for creating alias ?
Thanks in advance,
George
SER Users:
I'm having some problems with aliasing.
I think it is from a mis-behaving client, but I
would appreciate comments if anybody has some insight!
I have a user_id registering as 4695466417, I can call this
number from other SIP devices and from my PSTN gateway.
I set an alias for this user '233200'. The alias table
is updated, and the packet is forwarded correctly to the
device at 4695466417. That device is returning a 486 busy.
Here is the invite packet:
U 216.87.144.205:5060 -> 216.87.145.28:5060
INVITE sip:4695466417@192.168.2.23:5060 SIP/2.0..Max-Forwards: 10..Rec
ord-Route: <sip:PPCprotectedClient797115@216.87.144.205:5060>,<sip:233
200(a)216.87.144.203;branch=0>..Via: SIP/2.0/UDP 216.87.144.205:5060;bra
nch=PPCprotectedClient797115,SIP/2.0/UDP 216.87.144.203;branch=z9hG4bK
5819.87aaef61.0,SIP/2.0/UDP 216.87.145.22:5060..From: greg fausak <sip
:230057@addaline.com>;tag=247809120..To: <sip:233200@addaline.com>..Co
ntact: <sip:230057@216.87.145.22:5060>..Call-ID: 54D527FD-3383-4A70-97
D8-E80324106BF0@216.87.145.22..CSeq: 31104 INVITE..Authorization: Dige
st username="230057",realm="addaline.com",nonce="3ec70a8b000000003b186
6260d18b11488734cf3ee902282",response="f517708e3fc30b2feb733dbe2fa7585
0",uri="sip:233200@addaline.com"..Content-Type: application/sdp..User-
Agent: Addaline build 1002..Content-Length: 275....v=0..o=230057 37866
6493 378666493 IN IP4 216.87.144.205..s=Addaline..c=IN IP4 216.87.144.
205..t=0 0..m=audio 39258 RTP/AVP 0 3 98 97 101..a=rtpmap:0 pcmu/8000.
.a=rtpmap:3 gsm/8000..a=rtpmap:98 iLBC..a=rtpmap:97 speex/8000..a=rtpm
ap:101 telephone-event/8000..a=fmtp:101 0-15..
(sorry about the formatting)
Here is the response:
U 216.87.145.28:5060 -> 216.87.144.205:5060
SIP/2.0 486 Busy Here..From: greg fausak <sip:230057@addaline.com> ;ta
g=247809120..To: <sip:233200@addaline.com> ;tag=c0a80217-13c4-3ec70960
-e8d5-51a5..Call-ID: 54D527FD-3383-4A70-97D8-E80324106BF0(a)216.87.145.2
2..CSeq: 31104 INVITE..Via: SIP/2.0/UDP 216.87.144.205:5060 ;branch=PP
CprotectedClient797115..Via: SIP/2.0/UDP 216.87.144.203 ;branch=z9hG4b
K5819.87aaef61.0..Via: SIP/2.0/UDP 216.87.145.22:5060..User-Agent: FXS
_GW (3502a-sip0402.BIN)..Content-Length:0....
If I do an INVITE directly to 4695466417 it works. The only difference
in the INVITE packet seems to be the To: <sip:233200@addaline.com> or
To: <sip:4695466417@addaline.com>. Is this client misbehaving?
Thanks,
---greg
I just started playing with it today, it's a little quirky but it works
with ser, even presence seems to (at least between portrait ua's).
Unfortunately the PPC version doesn't seem to like authenticated
registrations, but it does work point to point.
Regards,
Phil
I am resending this message with the files zipped.
> Hi Jan,
>
> I am testing the cvs version on Solaris 2.8. It works fine without the
> mysql integration. But if I enable mysql authentication it crashes on
> startup. I compiled with "make all" and then "make prefix=/usr/local
> install". Below are the details with the ser.cfg and the debug output.
>
> Thanks,
> Ricardo
>
> # uname -a
> SunOS hana 5.8 Generic_108528-14 sun4u sparc SUNW,Ultra-5_10
>
> # gcc -v
> Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.2.3/specs
> Configured with:
>
../configure --disable-nls --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/
> ld
> Thread model: posix
> gcc version 3.2.3
>
> # mysqladmin --version
> mysqladmin Ver 8.23 Distrib 3.23.56, for sun-solaris2.8 on sparc
>
>
>
>
>
> ----- Original Message -----
> From: "Jan Janak" <jan(a)iptel.org>
> To: <serusers(a)lists.iptel.org>
> Sent: Tuesday, May 06, 2003 11:28 AM
> Subject: [Serusers] Call for testing
>
>
Hi all,
We have finally integrated all important changes into the CVS and plan
to test the current version for a while, the current CVS version has
been running on iptel.org for more than two weeks.
We would like to ask users to start testing now. The more people will
test it the better. If you find any bugs please send them to us along
with as much description as possible.
This page:
http://developer.berlios.de/docman/display_doc.php?docid=32&group_id=2
contains a description of the cvs access. See section "How to check out
source anonymously".
A daily tarball can be downloaded here:
http://cvs.berlios.de/cgi-bin/viewcvs.cgi/ser/
Note that the database tables changed a little bit too. ser_mysql.sh now
contains a new command 'reinstall' which will convert existing tables into
new ones (use it only if you created the tables using the script from
a stable version).
- Overview of the most important changes can be found in NEWS file.
- So far the documentation was only partially updated, but we are
working on it.
thanks, Jan.
Thank you to all. It works now!
Tom
-----Original Message-----
From: Jan Janak [mailto:jan@iptel.org]
Sent: Thursday, May 15, 2003 12:12 PM
To: Bowar, Tom
Cc: Adriana Simizo; serusers(a)lists.iptel.org
Subject: Re: [Serusers] Help with serweb
Did you create your database tables with ser_mysql.sh script from 0.8.10 release ? If so then you will need to convert it because the tables have been changed.
To convert it you can use the script from the CVS snaphot of ser. Do the
following:
ser_mysql.sh reinstall
Jan.
On 15-05 12:07, Bowar, Tom wrote:
> It seems I am making progress now. Although I still cannot log in, I
> get an error:
>
> error in SQL query, line: 29
>
> Where should I look for the error?
>
> -----Original Message-----
> From: Adriana Simizo [mailto:simizo@telesp.com.br]
> Sent: Thursday, May 15, 2003 11:03 AM
> To: serusers(a)lists.iptel.org
> Subject: [Serusers] Re: Help with serweb
>
>
>
> Verify in php.ini if
>
> register_globals=On
>
>
> Adriana Simizo
> Estagiária
> Diretoria de Planejamento e Tecnologia - Tecnologia para Serviços
> GRUPO TELEFÔNICA NO BRASIL Av. Paulista, 2300 - 18° andar
> CEP 01310-300 S?o Paulo - SP
> Tel: 55 11-3154-6184 Fax: 55 11-3154-6494
> simizo(a)telesp.com.br
> http://www.telefonica.com.br
>
It seems I am making progress now. Although I still cannot log in, I get an error:
error in SQL query, line: 29
Where should I look for the error?
-----Original Message-----
From: Adriana Simizo [mailto:simizo@telesp.com.br]
Sent: Thursday, May 15, 2003 11:03 AM
To: serusers(a)lists.iptel.org
Subject: [Serusers] Re: Help with serweb
Verify in php.ini if
register_globals=On
Adriana Simizo
Estagiária
Diretoria de Planejamento e Tecnologia - Tecnologia para Serviços
GRUPO TELEFÔNICA NO BRASIL
Av. Paulista, 2300 - 18° andar
CEP 01310-300 São Paulo - SP
Tel: 55 11-3154-6184 Fax: 55 11-3154-6494
simizo(a)telesp.com.br
http://www.telefonica.com.br
Verify in php.ini if
register_globals=On
Adriana Simizo
Estagiária
Diretoria de Planejamento e Tecnologia - Tecnologia para Serviços
GRUPO TELEFÔNICA NO BRASIL
Av. Paulista, 2300 - 18° andar
CEP 01310-300 São Paulo - SP
Tel: 55 11-3154-6184 Fax: 55 11-3154-6494
simizo(a)telesp.com.br
http://www.telefonica.com.br
Yes, I have set those to my domain. Perhaps this is a problem: My domain
is set to 'localhost', both in the subscriber table and in the
config.php file.
-----Original Message-----
From: Ricardo Villa [mailto:ricvil@epm.net.co]
Sent: Thursday, May 15, 2003 10:20 AM
To: Bowar, Tom; serusers(a)lists.iptel.org
Subject: Re: [Serusers] Help with serweb
No...I'm refering to the config.php file. These 3 variables must be set
according to your domain:
$this->realm="yourdomain.biz"; $this->domainname="yourdomain.biz";
$this->default_domain="yourdomain.biz"
----- Original Message -----
From: "Bowar, Tom" <bowart(a)nextnetwireless.com>
To: <serusers(a)lists.iptel.org>
Sent: Thursday, May 15, 2003 10:02 AM
Subject: RE: [Serusers] Help with serweb
Are you referring to uncommenting the following line in the ser.cfg
file:
modparam("auth", "calculate_ha1", yes)
I have done this. Actually, I tried changing the domain back to
iptel.org also.
-----Original Message-----
From: Ricardo Villa [mailto:ricvil@epm.net.co]
Sent: Thursday, May 15, 2003 9:20 AM
To: Bowar, Tom
Subject: Re: [Serusers] Help with serweb
If your domain is not iptel.org...you need to fix the php scripts to
point to your real domain. The default scripts will compute the md hash
based on "iptel.org".
----- Original Message -----
From: "Bowar, Tom" <bowart(a)nextnetwireless.com>
To: <serusers(a)lists.iptel.org>
Sent: Thursday, May 15, 2003 8:59 AM
Subject: RE: [Serusers] Help with serweb
That is what I thought. So I added another user 'tom', and set the perms
column to 'admin'. I tried logging in with both 'tom' and 'admin', each
with the same result.
Tom
-----Original Message-----
From: Jan Janak [mailto:jan@iptel.org]
Sent: Thursday, May 15, 2003 3:30 AM
To: Bowar, Tom
Cc: serusers(a)lists.iptel.org
Subject: Re: FW: [Serusers] Help with serweb
Hello,
it is in MySQL database in subscribers table. Initialy only username
'admin' with password 'heslo' exists.
Jan.
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Are you referring to uncommenting the following line in the ser.cfg
file:
modparam("auth", "calculate_ha1", yes)
I have done this. Actually, I tried changing the domain back to
iptel.org also.
-----Original Message-----
From: Ricardo Villa [mailto:ricvil@epm.net.co]
Sent: Thursday, May 15, 2003 9:20 AM
To: Bowar, Tom
Subject: Re: [Serusers] Help with serweb
If your domain is not iptel.org...you need to fix the php scripts to
point to your real domain. The default scripts will compute the md hash
based on "iptel.org".
----- Original Message -----
From: "Bowar, Tom" <bowart(a)nextnetwireless.com>
To: <serusers(a)lists.iptel.org>
Sent: Thursday, May 15, 2003 8:59 AM
Subject: RE: [Serusers] Help with serweb
That is what I thought. So I added another user 'tom', and set the perms
column to 'admin'. I tried logging in with both 'tom' and 'admin', each
with the same result.
Tom
-----Original Message-----
From: Jan Janak [mailto:jan@iptel.org]
Sent: Thursday, May 15, 2003 3:30 AM
To: Bowar, Tom
Cc: serusers(a)lists.iptel.org
Subject: Re: FW: [Serusers] Help with serweb
Hello,
it is in MySQL database in subscribers table. Initialy only username
'admin' with password 'heslo' exists.
Jan.
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers