RE: [Serusers] SER does not start with MySQL - sr-users

30 Oct 2003

Hi Jiri,
Please read my comments to your questions below.....

-----Original Message-----
From: Jiri Kuthan [mailto:jiri@iptel.org]
Sent: Wednesday, October 29, 2003 7:03 PM
To: Vo, Tony; serusers(a)lists.iptel.org
Subject: Re: [Serusers] SER does not start with MySQL

I suppose ser would not start without mysql either.

The reason is presumably serctl's way to find SER executable.
It tries to use the same directory for SER as where serctl
lives, certainly a problem with compiled versions and possibly
a problem in some distributions.

Where is your 'ser' and 'serctl' installed? 
...
 >Tony>> /usr/sbin 
Which distribution are you using?
...
 >Tony>> I installed version 8.11 for RedHat
8.0 (ser-0.8.11-0.i386.rpm).  SER works fine without loading mysql module.  Problem only
occurs when trying to load the mysql module. 
Workaround is change the DIR=... lines in serctl to path to ser.
...
 >Tony>> I've tried this and no luck.....

I introduced (hopefuly) more helpful error output to serctl.

Thanks for reporting,

-jiri

At 03:20 AM 10/30/2003, Vo, Tony wrote:
...
 content-class: urn:content-classes:message
Content-Type: multipart/alternative;
        boundary="----_=_NextPart_001_01C39E8C.7267B729"

Hi, 
SER will not start if I am to configure SER to run using MySQL module.  I followed the
instructions in the HowTo guides.  I currently have MySQL version 4.0.16 installed and is
running.  The mysql.so module is in the correct directory as specified in the config file.
 When I run the 'serctl start' script, I would get only this response;

[root@localhost modules]# serctl start 

Starting SER : cat: /var/run/ser.pid: No such file or directory 
started pid() 

Here's an excerpt from my config file (ser.cfg).  Thanks for your advice(s); 

# 
# 
# $Id: ser.cfg,v 1.21.2.1 2003/07/30 16:46:18 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) 
modparam("usrloc", "db_url",
"sql://ser:spirent@localhost/ser") 

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

#database location for auth module 
modparam("auth_db", "db_url",
"sql://serro:spirent@localhost/ser") 

# -- rr params -- 
# add value to ;lr param to make some broken UAs happy 
# modparam("rr", "enable_full_lr", 1) 

_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers 
--
Jiri Kuthan            http://iptel.org/~jiri/ 