[Serusers] problems about ser server's jabber and location

[C Y]

hi everyone :
there are some problems about ser server's jabber module and database 
location.
1.when i configure the jabber module.there are some errors about database 
sip_jab.However I cannot find the database sip_jab in the server.The 
configuration is  
modparam("jabber", "db_url", "sql://ser:helso@127.0.0.1/sip_jab)

2.there are two tables in databse ser:"server_monitoring" and 
"server_monitoring_agg".But when the server is running.There is no datas in 
the tables.Do the monitor infomations write into them?

3.In the database ser,there is a table location.However when a user log 
in.The field "domain" is still null.How can I write the domain infomation 
into the table "location"?

How can i solve the problem?

     These are some informations  related to my setting and problem:
     1、operating system:Linux 7.0
     2、SER distribution: ser-0.8.14_linux_i386.tar.gz
     3、SER build:  version:  0.8.14 (i386/linux)
flags: STATS:Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, DNS_IP_HACK, SHM_MEM, 
SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, 
MAX_URI_SIZE 1024, BUF_SIZE 65535
@(#) $Id: main.c,v 1.168.4.3 2004/06/28 15:41:21 andrei Exp $
main.c compiled on 12:28:01 Jul 27 2004 with gcc 2.95
     4、SER configuration file :
debug=7         # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=yes 	# (cmd line: -E)

check_via=yes	# (cmd. line: -v)
dns=yes           # (cmd. line: -r)
rev_dns=yes      # (cmd. line: -R)
port=5060
#children=4
fifo="/tmp/ser_fifo"

alias="voipv6.edu.cn" "210.25.130.252" "localhost"
# ------------------ module loading ----------------------------------

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

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

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"


loadmodule "/usr/local/lib/ser/modules/acc.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
loadmodule "/usr/local/lib/ser/modules/group.so"
loadmodule "/usr/local/lib/ser/modules/msilo.so"
loadmodule "/usr/local/lib/ser/modules/print.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/pa.so"
loadmodule "/usr/local/lib/ser/modules/jabber.so"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/vm.so"


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

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


# -- 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", "use_domain", 1)

# -- auth params --
modparam("auth_db", "password_column", "password")

# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)


modparam("jabber", "db_url", "sql://ser:helso@voipv6.edu.cn/sip_jab)
modparam("jabber", "jaddress", "voipv6.edu.cn")
modparam("jabber", "jport", 5222)
modparam("jabber", "jdomain", "voipv6.edu.cn=*")
modparam("jabber", "aliases", "1;msn.x.com=%")

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

# main routing logic

route{

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

	# we record-route all messages -- to make sure that
	# subsequent messages will go through our proxy; that's
	# particularly good if upstream and downstream entities
	# use different transport protocol
	record_route();	
	# loose-route processing
	if (loose_route()) {
		t_relay();
		break;
	};

	# 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=~"voipv6.edu.cn") {

		if (method=="REGISTER") {

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

			save("location");
			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; use stateful forwarding; that
	# works reliably even if we forward from TCP to UDP
	if (!t_relay()) {
		sl_reply_error();
	};

}

_________________________________________________________________
免费下载 MSN Explorer:   http://explorer.msn.com/lccn