RE: [Serusers] HELP - lookup("aliases") not working

Zeus,

You are an absolute genius! If you were here in Orlando, Florida I'd buy you a beer.

That fixed my problem! Talk about a detail I totally missed.

Thank you. Paul

--- Zeus Ng zeus.ng@isquare.com.au wrote:

In your ser.cfg, set modparam("usrloc", "use_domain", 1) and try the test again.

Zeus

...

-----Original Message----- From: Java Rockx [mailto:javarockx@yahoo.com] Sent: Saturday, 25 September 2004 2:20 PM To: Zeus Ng Cc: 'ser users' Subject: RE: [Serusers] HELP - lookup("aliases") not working

Zeus,

Thanks for the reply. I saw that the domain column in the aliases table was blank and understand that myself. I assumed it just wasn't used.

FYI, I obtained a fresh copy of the source code tonight using this:

cvs -z3 -d:pserver:anonymous@cvs.serweb.berlios.de:/cvsroot/serweb co -r HEAD sip_router

I compiled it and checked the version which is reported as follows:

version: ser 0.8.99-dev6 (i386/linux) flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, 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 @(#) $Id: main.c,v 1.193 2004/09/19 20:22:51 andrei Exp $ main.c compiled on 21:44:37 Sep 24 2004 with gcc 3.2

Here is the information you asked for:

[root@sip01 root]# serctl alias add 123456 sip:someone@mycompany.com 200 Added to table ('123456','sip:someone@mycompany.com') to 'aliases'

[root@sip01 root]# serctl alias show Dumping all contacts may take long: are you sure you want to proceed? [Y|N] y ===Domain list=== ---Domain--- name : 'aliases' size : 512 table: 0xb543c5d8 d_ll { n : 3 first: 0xb543e5e0 last : 0xb543ffe0 }

.../Record... ...Record(0xb543ffe0)... domain: 'aliases' aor : '123456'

domain    : 'aliases'
aor       : '123456'
Contact   : 'sip:someone@mycompany.com'
Expires   : -8
q         : 1
Call-ID   :
'The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything'
CSeq      : 42
replic    : 0
User-Agent: 'SIP Express Router FIFO'
received  : ''
State     : CS_SYNC
Flags     : 128
next      : (nil)
prev      : (nil)
~~~/Contact~~~~
.../Record...

---/Domain---
===/Domain list===


mysql> select username, domain, contact from aliases where 
mysql> username='123456';
+----------+--------+---------------------------+
| username | domain | contact                   |
+----------+--------+---------------------------+
| 123456   |        | sip:someone@mycompany.com |
+----------+--------+---------------------------+
1 row in set (0.01 sec)


Regards,
Paul

--- Zeus Ng <zeus.ng@isquare.com.au> wrote:

> Your AOR for aliases does not contain the domain part 
whereas the AOR 
> for location does. A dirty fix would be stop ser, login to 
mysql and 
> update that record with domain part in the aliases table 
and restart 
> ser.
> 
>         
+-------------+---------------------+------------------------+
>         | username    | domain              | contact       
         |
>         
+-------------+---------------------+------------------------+
>         | 2025551234  |mycompany.com        | 
sip:1000@mycompany.com |
>         
+-------------+--------+------------+------------------------+
> 
> 
> Normally, ser will insert the domain part into aliases 
table. Not sure 
> how you get a record without domain. It would be interested 
to see if 
> this is a bug with the CVS head. Could you do the following 
and send 
> in the output.
> 
> # export SIP_DOMAIN=mycompany.com
> # serctl alias add 1234567 someone@mycompany.com
> # serctl alias show
> 
> mysql> select username, domain, contact from aliases where
> username='1234567';
> 
> 
> Zeus
> 
> > -----Original Message-----
> > From: serusers-bounces@lists.iptel.org
> > [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Java Rockx
> > Sent: Saturday, 25 September 2004 7:53 AM
> > To: ser users
> > Subject: Re: [Serusers] HELP - lookup("aliases") not working
> > 
> > 
> > I'm using ser from CVS which I checked out last week. I doubt
> > that I have an old copy of serctl since I've never used ser 
> > before last week.
> > 
> > Anyhow, "serctl alias show" returns the following. Is there
> > some documentation that will explain to me the meaning of 
> > things in this output such as "Flags" and "state" as you 
> > mentioned before?
> > 
> > Regards,
> > Paul
> > 
> > ===Domain list===
> > ---Domain---
> > name : 'aliases'
> > size : 512
> > table: 0xb543c950
> > d_ll {
> >     n    : 1
> >     first: 0xb543bda0
> >     last : 0xb543bda0
> > }
> >  
> > ...Record(0xb543bda0)...
> > domain: 'aliases'
> > aor   : '2025551234'
> > ~~~Contact(0xb543c3b0)~~~
> > domain    : 'aliases'
> > aor       : '2025551234'
> > Contact   : 'sip:1000@mycompany.com'
> > Expires   : -5
> > q         : 1
> > Call-ID   :
> > 
'The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything'
> > CSeq      : 42
> > replic    : 0
> > User-Agent: 'SIP Express Router FIFO'
> > received  : ''
> > State     : CS_NEW
> > Flags     : 128
> > next      : (nil)
> > prev      : (nil)
> > ~~~/Contact~~~~
> > .../Record...
> >  
> > ---/Domain---
> > ---Domain---
> > name : 'location'
> > size : 512
> > table: 0xb5439a50
> > d_ll {
> >     n    : 7
> >     first: 0xb543ba58
> >     last : 0xb543beb0

=== message truncated ===

_______________________________ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com