[Serusers] SER does not start with MySQL

[Jiri Kuthan]

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? Which distribution
are you using?

Workaround is change the DIR=... lines in serctl to path to ser.

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/