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_C...
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users