[Serusers] Mysql Connection Errors

[Ricardo Villa]

Did you run the "ser_mysql.sh" script?
  ----- Original Message ----- 
  From: Todd 
  To: Sip Questions List 
  Sent: Wednesday, May 21, 2003 5:04 PM
  Subject: [Serusers] Mysql Connection Errors



  Ok..I have setup SER according to the guide on the iptel site. 
  Here is a copy of what's in my ser.cfg 

  _________________________________________ 
  # 
  # $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $ 
  # 
  # simple quick-start config script 
  # 

  # ----------- global configuration parameters ------------------------ 

  debug=3          # debug level (cmd line: -dddddddddd) 
  fork=yes 
  log_stderror=no # (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 ---------------------------------- 

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

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

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

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

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

  # -- auth params -- 
  # Uncomment if you are using auth module 
  # 
  #modparam("auth", "secret", "alsdkhglaksdhfkloiwr") 
  modparam("auth", "calculate_ha1", yes) 
  # 
  # If you set "calculate_ha1" parameter to yes (which true in this config), 
  # uncomment also the following parameter) 
  # 
  modparam("auth", "password_column", "password") 

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

  # main routing logic 

  route{ 

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

  # Do strict routing if pre-loaded route headers present 
  rewriteFromRoute(); 

  # 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=~"computergeeks.hopto.org") { 

  if (method=="REGISTER") { 

  # Uncomment this if you want to use digest authentication 
  if (!www_authorize("computergeeks.hopto.org", "subscriber")) { 
  www_challenge("computergeeks.hopto.org", "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 
  if (!t_relay()) { 
  sl_reply_error(); 
  }; 

  } 

  _________________________________________________ 


  The modules are all where they say they are but when I try to start SER I get this in my messages log file 

  May 21 18:58:45 computergeeks ser: ser startup succeeded 
  May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: connect_db(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 
  May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: db_init(): Error while trying to connect database 
  May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: mod_init(): Error while connecting database 
  May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: init_modules(): Error while initializing module usrloc 


  Can someone please tell me what I'm doing wrong?  I've searched all over the net for information on this...I'm sure it's something simple..but I'm overlooking it. 

  If I disable the Mysql integration is works perfect, so I'm thinking it has something to do with the mysql.so module?!? 

  Thanks 

  Todd 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030521/afde1d05/attachment.htm>