<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/1.0.4">
</HEAD>
<BODY>
<BR>
Ok..I have setup SER according to the guide on the iptel site.
<BR>
Here is a copy of what's in my ser.cfg
<BR>
<BR>
_________________________________________
<BR>
<FONT COLOR="#000080">#</FONT>
<BR>
<FONT COLOR="#000080"># $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $</FONT>
<BR>
<FONT COLOR="#000080">#</FONT>
<BR>
<FONT COLOR="#000080"># simple quick-start config script</FONT>
<BR>
<FONT COLOR="#000080">#</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># ----------- global configuration parameters ------------------------</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">debug=3 # debug level (cmd line: -dddddddddd)</FONT>
<BR>
<FONT COLOR="#000080">fork=yes</FONT>
<BR>
<FONT COLOR="#000080">log_stderror=no        # (cmd line: -E)</FONT>
<BR>
<FONT COLOR="#000080">check_via=no        # (cmd. line: -v)</FONT>
<BR>
<FONT COLOR="#000080">dns=no # (cmd. line: -r)</FONT>
<BR>
<FONT COLOR="#000080">rev_dns=no # (cmd. line: -R)</FONT>
<BR>
<FONT COLOR="#000080">port=5060</FONT>
<BR>
<FONT COLOR="#000080">children=4</FONT>
<BR>
<FONT COLOR="#000080">fifo="/tmp/ser_fifo"</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># ------------------ module loading ----------------------------------</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># Uncomment this if you want to use SQL database</FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/mysql.so"</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/sl.so"</FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/tm.so"</FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/rr.so"</FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/maxfwd.so"</FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/usrloc.so"</FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/registrar.so"</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># Uncomment this if you want digest authentication</FONT>
<BR>
<FONT COLOR="#000080"># mysql.so must be loaded !</FONT>
<BR>
<FONT COLOR="#000080">loadmodule "//usr/lib/ser/modules/auth.so"</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># ----------------- setting module-specific parameters ---------------</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># -- usrloc params --</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">#modparam("usrloc", "db_mode", 0)</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># Uncomment this if you want to use SQL database </FONT>
<BR>
<FONT COLOR="#000080"># for persistent storage and comment the previous line</FONT>
<BR>
<FONT COLOR="#000080">modparam("usrloc", "db_mode", 2)</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># -- auth params --</FONT>
<BR>
<FONT COLOR="#000080"># Uncomment if you are using auth module</FONT>
<BR>
<FONT COLOR="#000080">#</FONT>
<BR>
<FONT COLOR="#000080">#modparam("auth", "secret", "alsdkhglaksdhfkloiwr")</FONT>
<BR>
<FONT COLOR="#000080">modparam("auth", "calculate_ha1", yes)</FONT>
<BR>
<FONT COLOR="#000080">#</FONT>
<BR>
<FONT COLOR="#000080"># If you set "calculate_ha1" parameter to yes (which true in this config), </FONT>
<BR>
<FONT COLOR="#000080"># uncomment also the following parameter)</FONT>
<BR>
<FONT COLOR="#000080">#</FONT>
<BR>
<FONT COLOR="#000080">modparam("auth", "password_column", "password")</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># ------------------------- request routing logic -------------------</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># main routing logic</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">route{</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">        # initial sanity checks -- messages with</FONT>
<BR>
<FONT COLOR="#000080">        # max_forwars==0, or excessively long requests</FONT>
<BR>
<FONT COLOR="#000080">        if (!mf_process_maxfwd_header("10")) {</FONT>
<BR>
<FONT COLOR="#000080">                sl_send_reply("483","Too Many Hops");</FONT>
<BR>
<FONT COLOR="#000080">                break;</FONT>
<BR>
<FONT COLOR="#000080">        };</FONT>
<BR>
<FONT COLOR="#000080">        if (len_gt( max_len )) {</FONT>
<BR>
<FONT COLOR="#000080">                sl_send_reply("513", "Message too big");</FONT>
<BR>
<FONT COLOR="#000080">                break;</FONT>
<BR>
<FONT COLOR="#000080">        };</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">        # Do strict routing if pre-loaded route headers present</FONT>
<BR>
<FONT COLOR="#000080">        rewriteFromRoute();</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">        # if the request is for other domain use UsrLoc</FONT>
<BR>
<FONT COLOR="#000080">        # (in case, it does not work, use the following command</FONT>
<BR>
<FONT COLOR="#000080">        # with proper names and addresses in it)</FONT>
<BR>
<FONT COLOR="#000080">        if (uri=~"computergeeks.hopto.org") {</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">                if (method=="REGISTER") {</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080"># Uncomment this if you want to use digest authentication</FONT>
<BR>
<FONT COLOR="#000080">                        if (!www_authorize("computergeeks.hopto.org", "subscriber")) {</FONT>
<BR>
<FONT COLOR="#000080">                                www_challenge("computergeeks.hopto.org", "0");</FONT>
<BR>
<FONT COLOR="#000080">                                break;</FONT>
<BR>
<FONT COLOR="#000080">                        };</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">                        save("location");</FONT>
<BR>
<FONT COLOR="#000080">                        break;</FONT>
<BR>
<FONT COLOR="#000080">                };</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">                # native SIP destinations are handled using our USRLOC DB</FONT>
<BR>
<FONT COLOR="#000080">                if (!lookup("location")) {</FONT>
<BR>
<FONT COLOR="#000080">                        sl_send_reply("404", "Not Found");</FONT>
<BR>
<FONT COLOR="#000080">                        break;</FONT>
<BR>
<FONT COLOR="#000080">                };</FONT>
<BR>
<FONT COLOR="#000080">        };</FONT>
<BR>
<FONT COLOR="#000080">        # forward to current uri now</FONT>
<BR>
<FONT COLOR="#000080">        if (!t_relay()) {</FONT>
<BR>
<FONT COLOR="#000080">                sl_reply_error();</FONT>
<BR>
<FONT COLOR="#000080">        };</FONT>
<BR>
<FONT COLOR="#000080"></FONT>
<BR>
<FONT COLOR="#000080">}</FONT>
<BR>
<BR>
_________________________________________________
<BR>
<BR>
<BR>
The modules are all where they say they are but when I try to start SER I get this in my messages log file
<BR>
<BR>
<FONT COLOR="#3366ff">May 21 18:58:45 computergeeks ser: ser startup succeeded</FONT>
<BR>
<FONT COLOR="#3366ff">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)</FONT>
<BR>
<FONT COLOR="#3366ff">May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: db_init(): Error while trying to connect database</FONT>
<BR>
<FONT COLOR="#3366ff">May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: mod_init(): Error while connecting database</FONT>
<BR>
<FONT COLOR="#3366ff">May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: init_modules(): Error while initializing module usrloc</FONT>
<BR>
<BR>
<BR>
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.
<BR>
<BR>
If I disable the Mysql integration is works perfect, so I'm thinking it has something to do with the mysql.so module?!?
<BR>
<BR>
Thanks
<BR>
<BR>
Todd
</BODY>
</HTML>