[Serusers] usrlocate troubles - sr-users

1 Apr 2003

Hello,

When the user registeres/authorizes with ser, no update is done to sers 
userlocate database. The 200 reply is sent to user (and from 
documentation save("location"); sends it), and in mysql log I see a 
query for authirization. But no update to is issued to mysql location 
table, and serctl ul show doesnt show the user. Sometimes the user does 
show up in the userlocate database but I was not able to point down when 
this happens.
I`m running the march 19/ 6pm cvs version as was recommended.

here is the ser.cfg :

----------

#
# $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $
#
# simple quick-start config script
#

# ----------- global configuration parameters ------------------------

debug=9          # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no	# (cmd line: -E)
check_via=no	# (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
port=5060
children=1
fifo="/tmp/ser_fifo"
sip_warning=yes

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database
loadmodule "/usr/lib/ser/modules/mysql.so"

loadmodule "/usr/lib/ser/modules/sl.so"
loadmodule "/usr/lib/ser/modules/tm.so"
loadmodule "/usr/lib/ser/modules/rr.so"
loadmodule "/usr/lib/ser/modules/maxfwd.so"
loadmodule "/usr/lib/ser/modules/usrloc.so"
loadmodule "/usr/lib/ser/modules/registrar.so"
loadmodule "/usr/lib/ser/modules/vm_mod.so"
loadmodule "/usr/lib/ser/modules/pa.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !

loadmodule "/usr/lib/ser/modules/auth.so"
loadmodule "/usr/lib/ser/modules/auth_db.so"

# ----------------- setting module-specific parameters ---------------

# -- usrloc params --

# modparam("usrloc", "db_mode",   0)

# Uncomment this if you want to use SQL database 
# for persistent storage and comment the previous line

modparam("usrloc", "db_mode", 2)

modparam("usrloc", "timer_interval", 30)

# modparam("usrloc", "db_url",
"sql://serro:47serro11@localhost/ser")

# -- auth params --
# Uncomment if you are using auth module
#
# modparam("auth", "secret", "12036dabde659847dd9e")
modparam("auth_db", "calculate_ha1", true)
#
# If you set "calculate_ha1" parameter to yes (which true in this config), 
# uncomment also the following parameter)
#
modparam("auth_db", "password_column", "password")

# modparam("auth_db", "db_url",
"sql://ser:heslo@localhost/ser")

# modparam("registrar", "default_expires", 3600)

# -------------------------  request routing logic -------------------

# main routing logic

alias="dg"
alias="phila.dg"

route{

	# initial sanity checks -- messages with
	# max_forwars==0, or excessively long requests
	if (!mf_process_maxfwd_header("10")) {
		sl_send_reply("483","Too Many Hops");
		break;
	};
	if (len_gt( max_len )) {
		sl_send_reply("513", "Message too big");
		break;
	};

	# Do strict routing if pre-loaded route headers present
	#rewriteFromRoute();
	strict_route();

	# if the request is for other domain use UsrLoc
	# (in case, it does not work, use the following command
	# with proper names and addresses in it)
	if (uri==myself) {

		if (method=="REGISTER") {

# Uncomment this if you want to use digest authentication
 			if (!www_authorize("dg", "subscriber")) {
 				www_challenge("dg", "0");
 				break;
 			};

			save("location");
			log(1,"REGISTER - User registered\n");
			break;
		};

	};

	# native SIP destinations are handled using our USRLOC DB
	if (!lookup("location")) {
		sl_send_reply("404", "Not Found");
		break;
	};

	# forward to current uri now
	if (!t_relay()) {
		sl_reply_error();
	};

}

----------

-- 

Anton Yurchenko&lt;phila(a)dg.net.ua&gt;
Digital Generation