[Users] registered("location")

[Helge Waastad]

Hi,
here's the log:


Proxy-02: REGISTER 195.18.134.150:5080 <= 195.18.134.147:5060
(67512391 at 10.46.11.132>)
Proxy-02: sip:67512391 at smartnet.no Authorization for
sip:67512391 at smartnet.no (195.18.134.147) requested, challenging...
Proxy-02: REGISTER 195.18.134.150:5080 <= 195.18.134.147:5060
(67512391 at 10.46.11.132>)
Proxy-02: sip:67512391 at smartnet.no Authorization OK...
Proxy-02: UAC behind NAT...
proxy-02 /usr/sbin/openser[13847]: -----db_load_urecord: AOR is
<smartnet.no>
proxy-02 /usr/sbin/openser[13847]: BUG:usrloc:db_load_urecord: AOR has
no @ while use_domain is enabled
Proxy-02: Register counter +1 ...
proxy-02 /usr/sbin/openser[13847]: -----db_load_urecord: AOR is
<67512391 at smartnet.no>
Proxy-02: sip:67512391 at smartnet.no
(<sip:67512391 at 10.46.11.132>;expires=300) save(location) OK...

br hw



ons, 23,.08.2006 kl. 12.39 +0300, skrev Bogdan-Andrei Iancu:
> Hi Helge,
> 
> I was not able to reproduce the error neither with use_domain=1 nor with 
> use_domain=0.
> (I was using the devel version).
> 
> actually the error is not DB related, but it's about the AOR the 
> db_load_urecord() function is receiving from the calling function - it 
> is called from only one place, from the get_urecord() function...
> 
> please try the attached patch...
> 
> regards,
> bogdan
> 
> 
> Helge Waastad wrote:
> 
> >Hi again,
> >
> >I have:
> >modparam("group|auth_db|usrloc|uri_db|speeddial|registrar|avpops|alias_d
> >b", "use_domain", 1)
> >
> >In location table:
> >| username |  domain     |
> >|          |             |
> >| 123456   | smartnet.no |
> >| 654321   | smartnet.no |
> >
> >If I set usrloc|registrar use_domain=0, the only thing that changes is
> >that the domain column is empty.
> >
> >
> >Br hw
> >
> > 
> >
> >-----Original Message-----
> >From: Bogdan-Andrei Iancu [mailto:bogdan at voice-system.ro] 
> >Sent: 22. august 2006 18:06
> >To: Helge Waastad
> >Cc: Users at openser.org
> >Subject: Re: [Users] registered("location")
> >
> >strange....
> >
> >do you have the use_domain param enabled or disabled?
> >could you check if the location table has for "user" column the correct
> >format (all entries):
> >    username at domain (if use_domain is on)
> >    username (if use_domain is off)
> >
> >regards,
> >bogdan
> >
> >Helge Waastad wrote:
> >
> >  
> >
> >>Hi,
> >>Ive just stopped my openser server,
> >>deleted all entries in the location table and restarted the OpenSER 
> >>server.
> >>
> >>Still i get the same:
> >>
> >>BUG:usrloc:db_load_urecord: AOR has no @ while use_domain is enabled
> >>
> >>message.
> >>
> >>br hw
> >>
> >>tir, 22,.08.2006 kl. 16.36 +0300, skrev Bogdan-Andrei Iancu:
> >> 
> >>
> >>    
> >>
> >>>Hi,
> >>>
> >>>my guess is you had usrloc with use_domain and with contacts into the 
> >>>location table you switched use_domain on.
> >>>BUG:usrloc:db_load_urecord: AOR has no @ while use_domain is enabled 
> >>>please remove the entire contact of the location table and try again.
> >>>
> >>>regards,
> >>>bogdan
> >>>
> >>>Helge Waastad wrote:
> >>>
> >>>   
> >>>
> >>>      
> >>>
> >>>>Hi,
> >>>>
> >>>>I receive a
> >>>>BUG:usrloc:db_load_urecord: AOR has no @ while use_domain is enabled
> >>>>
> >>>>in my syslog. Could this be the reason???
> >>>>
> >>>>br hw
> >>>>
> >>>>
> >>>>
> >>>>tir, 22,.08.2006 kl. 15.28 +0300, skrev Bogdan-Andrei Iancu:
> >>>>
> >>>>
> >>>>     
> >>>>
> >>>>        
> >>>>
> >>>>>Hi Helge,
> >>>>>
> >>>>>it should work. Can you check if any db query is performed by the
> >>>>>          
> >>>>>
> >function?
> >  
> >
> >>>>>regards,
> >>>>>bogdan
> >>>>>
> >>>>>Helge Waastad wrote:
> >>>>>
> >>>>>  
> >>>>>
> >>>>>       
> >>>>>
> >>>>>          
> >>>>>
> >>>>>>Hi,
> >>>>>>I'm just wondering if the 'registered("location")' works when using
> >>>>>>            
> >>>>>>
> >
> >  
> >
> >>>>>>db only mode for usrloc?
> >>>>>>
> >>>>>>br hw
> >>>>>>
> >>>>>>
> >>>>>>_______________________________________________
> >>>>>>Users mailing list
> >>>>>>Users at openser.org
> >>>>>>http://openser.org/cgi-bin/mailman/listinfo/users
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>    
> >>>>>>
> >>>>>>         
> >>>>>>
> >>>>>>            
> >>>>>>
> >
> >
> >  
> >
> 
> vanlig tekstdokument-vedlegg (usrloc.patch)
> ? modules/usrloc/.udomain.c.swp
> Index: modules/usrloc/udomain.c
> ===================================================================
> RCS file: /cvsroot/openser/sip-server/modules/usrloc/udomain.c,v
> retrieving revision 1.23
> diff -u -r1.23 udomain.c
> --- modules/usrloc/udomain.c	4 Aug 2006 08:27:33 -0000	1.23
> +++ modules/usrloc/udomain.c	23 Aug 2006 09:38:31 -0000
> @@ -534,6 +534,7 @@
>  	urecord_t* r;
>  	ucontact_t* c;
>  
> +	LOG(L_ERR,"-----db_load_urecord: AOR is <%.*s>\n",_aor->len,_aor->s);
>  	keys[0] = user_col.s;
>  	vals[0].type = DB_STR;
>  	vals[0].nul = 0;