[Serusers] SER does not start with MySQL

Vo, Tony tony.vo at spirentcom.com
Thu Oct 30 19:49:59 CET 2003


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

-----Original Message-----
From: Jiri Kuthan [mailto:jiri at iptel.org]
Sent: Wednesday, October 29, 2003 7:03 PM
To: Vo, Tony; serusers at 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 at 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 at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers

--
Jiri Kuthan            http://iptel.org/~jiri/ 




More information about the sr-users mailing list