[SR-Users] Kamailio 3.2.2 Error - usrloc

[Gilbert T. Gutierrez, Jr.]

I realized I did not post to the list on my reply, so here is what I 
sent to Daniel.

Daniel,
I am using the default configuration with some mods that I have made to 
some of the routing sections. Aside from the module sections included in 
the default configuration file, I am using the lcr module and the sqlops 
module. I have not made any changes to the userloc module parameters 
from the default configuration.

#!define WITH_MYSQL
#!define WITH_AUTH
#!define WITH_USRLOCDB
#!define WITH_MULTIDOMAIN
#!define WITH_ALIASDB


# ----- usrloc params -----
/* enable DB persistency for location entries */
#!ifdef WITH_USRLOCDB
modparam("usrloc", "db_url", DBURL)
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "use_domain", MULTIDOMAIN)
#!endif

Because I have defined WITH_MULTIDOMAIN, that last modparam is 1. 
Everything that I have done seems to be working OK from what I have 
seen. I just see this error that I don't expect.

Thank you and Happy Easter,
Gilbert


On 4/6/2012 1:54 AM, Daniel-Constantin Mierla wrote:
> Hello,
>
> have you changed the domain column name via usrloc module parameters?
>
> In the code all looks ok, maybe sharing the module parameters you set 
> for usrloc module will help to track what happens.
>
> Cheers,
> Daniel
>
> On 4/6/12 1:19 AM, Gilbert T. Gutierrez, Jr. wrote:
>> Centos6 x64
>> Kamailio 3.2.2 installed using RPMs installed from 
>> http://download.opensuse.org/repositories/home:/kamailio:/telephony/CentOS_CentOS-6/
>>
>> I am using MySQL as the backend to this system and am setting up a 
>> multidomain server. I am slowly getting all the parts I want put 
>> together but I keep getting the below error everytime I restart the 
>> service...
>>
>> Apr  5 15:56:58 test3 /usr/sbin/kamailio[11565]: CRITICAL: usrloc 
>> [udomain.c:439]: empty domain record for user 100...skipping
>>
>> I have a couple users that go by 100. Below is my subscriber database 
>> which has a domain for each user...
>>
>> mysql> select * from subscriber;
>> +----+----------+---------------------------+----------+---------------+----------------------------------+----------------------------------+------+ 
>>
>> | id | username | domain        | password | email_address | 
>> ha1                              | ha1b                             | 
>> rpid |
>> +----+----------+---------------------------+----------+---------------+----------------------------------+----------------------------------+------+ 
>>
>> |  5 | 100      | test3.xxxx.com | xxxx  |               | 
>> a872d8611e8e5a0d5e02d5c53b44363d | 9c7c858342a79a9fb4caa5f3bdaa4a90 | 
>> NULL |
>> |  6 | 101      | test3.xxxx.com | xxxx  |               | 
>> a4c9cecfa57f211f2dfff2b92a99d27d | 891f84cb602527e64ce63cac5239c8ec | 
>> NULL |
>> |  3 | 100      | test2.xxxx.com | xxxx  |               | 
>> b4e5250cb60357081c731a8340907577 | dfc878dfefb427199673a08f839319e6 | 
>> NULL |
>> |  4 | 101      | test2.xxxx.com | xxxx  |               | 
>> a19dba81db7fb43adcd81b6ea5376018 | 480b80d129f575fb999106e9d25fd5e8 | 
>> NULL |
>> |  8 | 102      | test2.xxxx.com | xxxx  |               | 
>> b09c561b6177c3e0a2a8b1b96749dffe | 1a9ed92187bf7cf0e88b03075d530877 | 
>> NULL |
>> +----+----------+---------------------------+----------+---------------+----------------------------------+----------------------------------+------+ 
>>
>> 5 rows in set (0.00 sec)
>>
>> Where is this user coming from? How do I get rid of this error?
>>
>> Thanks in advance.
>> Gilbert T. Gutierrez, Jr.
>> Operations Manager
>> Phoenix Internet
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>