[Users] registered("location")

[Helge Waastad]

Hi,
save("location") does:

insert into location ...... where username='12345678' and
domain='smartnet.no'

lookup is doing:

select .... from location where username='12345678' and
domain='smartnet.no'

And this works perfectly fine.
No errors.

BTW, this is 1.1.0 version of OpenSER...

br hw



ons, 23,.08.2006 kl. 12.06 +0300, skrev Bogdan-Andrei Iancu:
> Hi Helge,
> 
> is save() and lookup() working properly? only the registered() function 
> generates the error?
> 
> 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
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>    
> >>>>>>
> >>>>>>         
> >>>>>>            
> >>>>>>
> >>>>>>
> >>>>>
> >
> >
> >  
> >
>