<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; CHARSET=UTF-8">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Did you run the "ser_mysql.sh" script?</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=erilaze@nbnet.nb.ca href="mailto:erilaze@nbnet.nb.ca">Todd</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">Sip Questions List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 21, 2003 5:04
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Serusers] Mysql Connection
Errors</DIV>
<DIV><BR></DIV><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 </BLOCKQUOTE></BODY></HTML>