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