[Serusers] What's the problem of SER with Mysql

[Felipe Martins]

	There is no problem on SER with MySQL, I have it running here with no problem, maybe the prob is your config file (ser.cfg).
	Have you tried to run SER with the default ser.cfg ?? It runs with no authentication. Have you set all the system variables for MySQL in your system ?

Take a closer look at the manuals


Best Regards.



On Fri, 1 Apr 2005 20:18:39 +0800
"ljzhang" <xueyou38 at 163.com> wrote:

> Hi,
> 
> I configure SER with Mysql. After I start SER, it don't show "successful" word, and can't end. No UA can register to SER. I found when UA sends Register message, it can't receive any response. But I use serctl command to monitor SER, I can't find any error.  After I restart Linux again, Linux'start process is blocked when it is starting ser. My Linux op can't be started. That's horrible. 
> 
> Furthermore, After I configure SER with Mysql, I configure SER without Mysql again, SER also can't start nomally. The only way is to remove it and restall it.
> 
> Can you help me!! Thanks.
> 
> My ser.cfg is as following:
> #
> # $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)
> 
> # Uncomment these lines to enter debugging mode 
> debug=7
> 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/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"
> loadmodule "/usr/lib/ser/modules/auth_db.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_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=~"127.0.0.1") {
> 
> 		if (method=="REGISTER") {
> 
> # Uncomment this if you want to use digest authentication
> 		#	if (!www_authorize("127.0.0.1", "subscriber")) {
> 		#		www_challenge("127.0.0.1", "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();
> 	};
> 
> }
> 
> 
> 
> 
>  				
> 
> ________________jenny
> ________________xueyou38 at 163.com
> ____________________2005-04-01


-- 
Felipe Martins
Mundivox Communications
Tecnologia e Projetos
fmartins at mundivox.com

Tel.: +55 +21 +3820 8839
Cel.: +55 +21 +9823 8602
Fax.: +55 +21 +3820 8844
www.mundivox.com