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@voice-system.ro] Sent: 22. august 2006 18:06 To: Helge Waastad Cc: Users@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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
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@voice-system.ro] Sent: 22. august 2006 18:06 To: Helge Waastad Cc: Users@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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
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@voice-system.ro] Sent: 22. august 2006 18:06 To: Helge Waastad Cc: Users@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@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@openser.org >http://openser.org/cgi-bin/mailman/listinfo/users > > > > > > > > >
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@voice-system.ro] Sent: 22. august 2006 18:06 To: Helge Waastad Cc: Users@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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
? 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;
Hi, here's the log:
Proxy-02: REGISTER 195.18.134.150:5080 <= 195.18.134.147:5060 (67512391@10.46.11.132>) Proxy-02: sip:67512391@smartnet.no Authorization for sip:67512391@smartnet.no (195.18.134.147) requested, challenging... Proxy-02: REGISTER 195.18.134.150:5080 <= 195.18.134.147:5060 (67512391@10.46.11.132>) Proxy-02: sip:67512391@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@smartnet.no Proxy-02: sip:67512391@smartnet.no (sip:67512391@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@voice-system.ro] Sent: 22. august 2006 18:06 To: Helge Waastad Cc: Users@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@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@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;
ok, now it clear....
I say you are calling the function for a request that has only domain part in the RURI, right? as you can see, the AOR is just <smartnet.no>.
is this the case?
regards, bogdan
Helge Waastad wrote:
Hi, here's the log:
Proxy-02: REGISTER 195.18.134.150:5080 <= 195.18.134.147:5060 (67512391@10.46.11.132>) Proxy-02: sip:67512391@smartnet.no Authorization for sip:67512391@smartnet.no (195.18.134.147) requested, challenging... Proxy-02: REGISTER 195.18.134.150:5080 <= 195.18.134.147:5060 (67512391@10.46.11.132>) Proxy-02: sip:67512391@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@smartnet.no Proxy-02: sip:67512391@smartnet.no (sip:67512391@10.46.11.132;expires=300) save(location) OK...
br hw
-
Bogdan-Andrei Iancu -
Helge Waastad -
Helge Waastad