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

[Zeus Ng]

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 at 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 at mycompany.com
# serctl alias show

mysql> select username, domain, contact from aliases where
username='1234567';


Zeus

> -----Original Message-----
> From: serusers-bounces at lists.iptel.org 
> [mailto:serusers-bounces at 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 at 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
> }
> 
> ...Record(0xb543beb0)...
> domain: 'location'
> aor   : '1000 at mycompany.com'
> ~~~Contact(0xb543bf00)~~~
> domain    : 'location'
> aor       : '1000 at mycompany.com'
> Contact   : 'sip:1000 at 68.12.33.190;user=phone'
> Expires   : 1967
> q         :
> Call-ID   : 'e812d3d48154550b at 172.16.1.34'
> CSeq      : 105
> replic    : 0
> User-Agent: 'Grandstream BT100 1.0.5.11'
> received  : ''
> State     : CS_SYNC
> Flags     : 0
> next      : (nil)
> prev      : (nil)
> ~~~/Contact~~~~
> .../Record...
>  
> ---/Domain---
> ===/Domain list===
> 
> 
> --- Andrei Pelinescu-Onciul 
> <pelinescu-onciul at fokus.fraunhofer.de> wrote:
> 
> > On Sep 23, 2004 at 07:22, Java Rockx <javarockx at yahoo.com> wrote:
> > > I'm still struggling with getting aliases to work. I've included 
> > > many
> > details
> > > of my configuration. Can anyone see why lookup("aliases") doesn't 
> > > work?
> > > 
> > > Regards,
> > > Paul
> > > 
> > > "serctl alias add 2025551234 sip:1000 at mycompany.com" returns
> > > 
> > >         200 Added to table
> > >         ('2025551234','sip:1000 at mycompany.com') to 'aliases'
> > > 
> > > "serctl alias show 2025551234 at mycompany.com" returns
> > > 
> > >         <sip:2025551234 at mycompany.com>;q=1;expires=-7
> > 
> > Please send also the whole output for "serctl alias show" 
> (without an 
> > uri). I'm interested in the Flags and State fields for 
> 2025551234. Try 
> > also "serctl ping sip:2025551234 at mycompany.com".
> > 
> > What ser version are you using? (how recent is it if it's from the 
> > HEAD branch). Are you using an up-to-date serctl? (you 
> might have an 
> > older one sticking arround somewhere in the PATH).
> > 
> > Andrei
> > 
> 
> 
> 
> 	
> 		
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - 100MB free storage! 
> http://promotions.yahoo.com/new_mail 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
>