[Serusers] Re: Hi Steve

[Steve Blair]

Ravi:
 
  It would be helpful to send the list the output from the
ngrep command so we can see exactly what is happening
when the registration fails. Sending this to the list will get
your question answered quicker especially since I am headed
out of town for a week.

Thanks,Steve

ravi kuru wrote:

> Hi Steve,
>  
> I am Ravi and I did configure SER with Mysql.
> I created user in subscriber table then I did try to register with 
> that user using xlite, but registration is failling.
>  
> Can you please help me find solution for this.
>  
> this is my ser.cfg file
>  
>
> debug=4        # debug level (cmd line: -dddddddddd)
> fork=yes
> log_stderror=yes        # (cmd line: -E)
>  
> 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 ----------------------------------
>  
> 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"
> loadmodule "/usr/local/lib/ser/modules/auth.so"
> loadmodule "/usr/local/lib/ser/modules/auth_db.so"
> modparam("usrloc", "db_url","sql://ser:heslo@localhost/ser")
> modparam("auth_db", "db_url","sql://ser:heslo@localhost/ser")
> modparam("auth_db", "user_column", "username")
> modparam("auth_db", "password_column", "password")
>  
> modparam("usrloc", "db_mode", 2)
>  
> modparam("auth_db", "calculate_ha1", yes)
> modparam("auth_db", "password_column", "password")
>  
> modparam("rr", "enable_full_lr", 1)
>  
>
> route{
>  
>         log (1, "in the routing\n");
>         # 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
>         log (1, "Trying to record_route\n");
>         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 addressres in it)
>         log (1, "Trying to myself************************\n");
>         if (uri == myself) {
>  
>                 if (method=="REGISTER") {
>                        log (1, "Trying to 
> register******************************\n");
> # Uncomment this if you want to use digest authentication
>                         if (!www_authorize("", "subscriber")) {
>                                  log (1, "Trying to 
> challenge***************\n");
>                                 www_challenge("", "0");
>                                 break;
>                         };
>                         log (1, "Trying to location\n");
>  
>                         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();
>         };
>  
> }
>  
>  
> Thanks for your help
> Ravi


-- 
  
ISC Network Engineering
The University of Pennsylvania
3401 Walnut Street, Suite 221A
Philadelphia, PA 19104  


voice: 215-573-8396 

       215-746-8001

fax: 215-898-9348    

sip:blairs at upenn.edu