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

Daniel-Constantin Mierla Daniel-Constantin.Mierla at fokus.fraunhofer.de
Fri Nov 5 08:48:47 CET 2004



On 11/05/04 04:45, C Y wrote:

> 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)

you have to create it. The SQL is provided in the doc subdirectory of
the source tree of jabber module.
http://cvs.berlios.de/cgi-bin/viewcvs.cgi/*checkout*/ser/sip_router/modules/jabber/doc/xjab.sql?rev=HEAD&content-type=text/plain

>
> 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?

you have to install some crond scripts to fill these table. Searching
into mailing list archive may give you some hints. The tables are used
by serweb.

>
> 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"?

this is related to the parameter use_domain of registrar module -- see
the README of the module.

Daniel

>
> 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
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>




More information about the sr-users mailing list