[SR-Users] Kamailio 3.2.2 Error - usrloc

[Daniel-Constantin Mierla]

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


-- 
Daniel-Constantin Mierla
Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany
http://www.asipto.com/index.php/kamailio-advanced-training/