[Serusers] mysql problems on Solaris 8

[Jan Janak]

if (uri==myself) is correct. You SHOULD NOT use if
(uri=~"borabora.eneirb.fr"), add alias="borabora.eneirb.fr" instead if
the condition does not match your domain properly.

  Jan.

On 16-02 13:33, Kapil Dhawan wrote:
> Hi this is because...whats your SIP_DOMAIN.....in your ser.cfg file.....u r 
> using uri==myself....instead of that user uri~="borabora.enseirb.fr" what 
> ever ur domain name is...or a part of it
> 
> 
> >From: Laurent BURGY <burgy at enseirb.fr>
> >To: serusers at lists.iptel.org
> >Subject: [Serusers] mysql problems on Solaris 8
> >Date: Mon, 16 Feb 2004 14:24:43 +0100
> >
> >Hi,
> >
> >By making a symbolic link for libmysqlclient.so.10 , i think i've solved 
> >this first problem....
> >But i have some difficulties for the registration process... In fact, no 
> >one can log in and when i do a serctl moni, i don't see anything except :
> >Usrloc Stats
> >Domain Registered Expired
> >'location' 0 0
> >
> >And i'm sure that users' passwd are the right ones ....
> >In my mysql tables, everything seems to be okay and i haven't modified a 
> >lot my configfile:
> >
> >#
> ># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
> >#
> ># simple quick-start config script
> >#
> >
> ># ----------- global configuration parameters ------------------------
> >
> >#debug=3         # debug level (cmd line: -dddddddddd)
> >#fork=yes
> >#log_stderror=no    # (cmd line: -E)
> >
> >debug=3
> >fork=no
> >log_stderror=yes
> >
> >check_via=no    # (cmd. line: -v)
> >dns=no           # (cmd. line: -r)
> >rev_dns=no      # (cmd. line: -R)
> >#port=5060
> >#children=4
> >fifo="/tmp/ser_fifo"
> >
> ># ------------------ 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"
> >
> ># ----------------- setting module-specific parameters ---------------
> >
> ># -- usrloc params --
> >modparam("auth_db","db_url","mysql://ser:heslo@localhost/ser")
> >modparam("usrloc","db_url","mysql://ser:heslo@localhost/ser")
> >
> >#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)
> >
> ># -- auth params --
> ># Uncomment if you are using auth module
> >#
> >modparam("auth_db", "calculate_ha1", yes)
> >#
> ># If you set "calculate_ha1" parameter to yes (which true in this config),
> ># uncomment also the following parameter)
> >#
> >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)
> >
> ># -------------------------  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==myself) {
> >
> >       if (method=="REGISTER") {
> >
> ># Uncomment this if you want to use digest authentication
> >           if (!www_authorize("borabora.enseirb.fr", "subscriber")) {
> >               www_challenge("borabora.enseirb.fr", "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();
> >   };
> >
> >}
> >
> >And i've tried to follow the sip.edu cookbook configuring ser....
> >So i can't understand.....Maybe it's obvious but i'm a bit lost...
> >
> >Thanks in advance
> >Laurent
> >
> >_______________________________________________
> >Serusers mailing list
> >serusers at lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
> 
> _________________________________________________________________
> Think Marriage!  Think BharatMatrimony.com 
> http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers