/bin/sh -c 'cd /usr/local/mysql ; ./bin/safe_mysqld --user=mysql &'
Gary Goodloff KALG Communications, LTD T: 402-898-4152 C: 402-208-5183 F: 413-294-3404 -----Original Message----- From: serusers-admin@iptel.org [mailto:serusers-admin@lists.iptel.org] On Behalf Of Todd Sent: Wednesday, May 21, 2003 5:05 PM To: Sip Questions List Subject: [Serusers] Mysql Connection Errors
Ok..I have setup SER according to the guide on the iptel site. Here is a copy of what's in my ser.cfg
_________________________________________ # # $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $ # # simple quick-start config script #
# ----------- global configuration parameters ------------------------
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=no # (cmd line: -E) 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"
# ----------------- 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)
# -- auth params -- # Uncomment if you are using auth module # #modparam("auth", "secret", "alsdkhglaksdhfkloiwr") modparam("auth", "calculate_ha1", yes) # # If you set "calculate_ha1" parameter to yes (which true in this config), # uncomment also the following parameter) # modparam("auth", "password_column", "password")
# ------------------------- request routing logic -------------------
# main routing logic
route{
# initial sanity checks -- messages with # max_forwars==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); break; }; if (len_gt( max_len )) { sl_send_reply("513", "Message too big"); break; };
# Do strict routing if pre-loaded route headers present rewriteFromRoute();
# if the request is for other domain use UsrLoc # (in case, it does not work, use the following command # with proper names and addresses in it) if (uri=~"computergeeks.hopto.org") {
if (method=="REGISTER") {
# Uncomment this if you want to use digest authentication if (!www_authorize("computergeeks.hopto.org", "subscriber")) { www_challenge("computergeeks.hopto.org", "0"); break; };
save("location"); break; };
# native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; # forward to current uri now if (!t_relay()) { sl_reply_error(); };
}
_________________________________________________
The modules are all where they say they are but when I try to start SER I get this in my messages log file
May 21 18:58:45 computergeeks ser: ser startup succeeded 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) May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: db_init(): Error while trying to connect database May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: mod_init(): Error while connecting database May 21 18:58:45 computergeeks /usr/sbin/ser[13089]: init_modules(): Error while initializing module usrloc
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.
If I disable the Mysql integration is works perfect, so I'm thinking it has something to do with the mysql.so module?!?
Thanks
Todd
------=_NextPart_000_00B1_01C31FBD.C81364A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN"> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40%22%3E
<head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C31FBD.C730CCD0"> <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:1627421319 -2147483648 8 0 66047 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.EmailStyle17 {mso-style-type:personal-reply; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:navy;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} span.GramE {mso-style-name:""; mso-gram-e:yes;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> </head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in'>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Those SQL = Errors:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3D"#3366ff" face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:#3366FF'>May 21 18:58:45 <span = class=3DSpellE>computergeeks</span> ser: ser startup succeeded</span></font> <br> <font color=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = <span class=3DSpellE>computergeeks</span> /<span = class=3DSpellE>usr/sbin/ser</span>[13089]: <span class=3DSpellE>connect_db</span>(): Can't connect to local <span class=3DSpellE>MySQL</span> server through socket '/<span = class=3DSpellE>var/lib/mysql/mysql.sock</span>' (2)</span></font> <br> <font color=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = <span class=3DSpellE>computergeeks</span> /<span = class=3DSpellE>usr/sbin/ser</span>[13089]: <span class=3DSpellE>db_init</span>(): Error while trying to connect = database</span></font> <br> <font color=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = <span class=3DSpellE>computergeeks</span> /<span = class=3DSpellE>usr/sbin/ser</span>[13089]: <span class=3DSpellE>mod_init</span>(): Error while connecting = database</span></font> <br> <font color=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = <span class=3DSpellE>computergeeks</span> /<span = class=3DSpellE>usr/sbin/ser</span>[13089]: <span class=3DSpellE>init_modules</span>(): Error while initializing = module <span class=3DSpellE>usrloc</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3D"#3366ff" face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:#3366FF'><o:p> </o:p></span></font><= /p>
<p class=3DMsoNormal><font size=3D3 color=3D"#3366ff" face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:#3366FF'>This means that the <span = class=3DSpellE>mysql</span> daemon is either not running or is not running on the default = port.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3D"#3366ff" face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:#3366FF'><o:p> </o:p></span></font><= /p>
<p class=3DMsoNormal><font size=3D3 color=3D"#3366ff" face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:#3366FF'>On <span = class=3DSpellE>freebsd</span> – this is how I start my sql daemon:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 color=3D"#3366ff" face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:#3366FF'>From /etc/<span = class=3DSpellE>rc.local</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>/bin/<span class=3DSpellE>sh</span> = -c '<span class=3DSpellE>cd</span> /<span class=3DSpellE>usr/local/<span = class=3DGramE>mysql</span></span><span class=3DGramE> ;</span> ./bin/<span class=3DSpellE>safe_mysqld</span> = --user=3D<span class=3DSpellE>mysql</span> &'<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p><font size=3D2 color=3Dnavy face=3D"Times New Roman"><span = style=3D'font-size:10.0pt; color:navy;mso-no-proof:yes'>Gary Goodloff<br> KALG Communications, LTD<br> T: 402-898-4152<br> C: 402-208-5183<br> F: 413-294-3404</span></font><font color=3Dnavy><span = style=3D'color:navy; mso-no-proof:yes'> </span></font><o:p></o:p></p>
</div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original = Message-----<br> <b><span style=3D'font-weight:bold'>From:</span></b> = serusers-admin@lists.iptel.org [mailto:serusers-admin@lists.iptel.org] <b><span style=3D'font-weight:bold'>On = Behalf Of </span></b>Todd<br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, May 21, = 2003 5:05 PM<br> <b><span style=3D'font-weight:bold'>To:</span></b> Sip Questions = List<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> [Serusers] Mysql Connection Errors</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><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=3Dnavy><span style=3D'color:navy'>#</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># $Id: ser.cfg,v 1.12 = 2002/10/21 02:40:06 jiri Exp $</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>#</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># simple quick-start = config script</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>#</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># ----------- global = configuration parameters ------------------------</span></font> <br> <br> <font color=3Dnavy><span = style=3D'color:navy'>debug=3D3 &= nbsp; # debug level (cmd line: -dddddddddd)</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>fork=3Dyes</span></font> = <br> <font color=3Dnavy><span style=3D'color:navy'>log_stderror=3Dno # (cmd = line: -E)</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>check_via=3Dno # (cmd. = line: -v)</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>dns=3Dno &n= bsp; # (cmd. line: -r)</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>rev_dns=3Dno # (cmd. line: -R)</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>port=3D5060</span></font> = <br> <font color=3Dnavy><span style=3D'color:navy'>children=3D4</span></font> = <br> <font color=3Dnavy><span = style=3D'color:navy'>fifo=3D"/tmp/ser_fifo"</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># ------------------ = module loading ----------------------------------</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># Uncomment this if you = want to use SQL database</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/mysql.so"</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/sl.so"</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/tm.so"</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/rr.so"</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/maxfwd.so"</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/usrloc.so"</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/registrar.so"</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># Uncomment this if you = want digest authentication</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># mysql.so must be loaded = !</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>loadmodule "//usr/lib/ser/modules/auth.so"</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># ----------------- = setting module-specific parameters ---------------</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># -- usrloc params = --</span></font> <br> <br> <font color=3Dnavy><span = style=3D'color:navy'>#modparam("usrloc", "db_mode", 0)</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># Uncomment this if you = want to use SQL database </span></font><br> <font color=3Dnavy><span style=3D'color:navy'># for persistent storage = and comment the previous line</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>modparam("usrloc", "db_mode", 2)</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># -- auth params = --</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># Uncomment if you are = using auth module</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>#</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>#modparam("auth", "secret", "alsdkhglaksdhfkloiwr")</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>modparam("auth", "calculate_ha1", yes)</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>#</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># If you set "calculate_ha1" parameter to yes (which true in this config), = </span></font><br> <font color=3Dnavy><span style=3D'color:navy'># uncomment also the = following parameter)</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>#</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>modparam("auth", "password_column", "password")</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># = ------------------------- request routing logic -------------------</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># main routing = logic</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'>route{</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># initial sanity checks -- = messages with</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># max_forwars=3D=3D0, or = excessively long requests</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>if (!mf_process_maxfwd_header("10")) {</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>sl_send_reply("483","Too Many Hops");</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>break;</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>};</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>if (len_gt( max_len )) = {</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>sl_send_reply("513", "Message too big");</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>break;</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>};</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># Do strict routing if = pre-loaded route headers present</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>rewriteFromRoute();</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># if the request is for = other domain use UsrLoc</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># (in case, it does not = work, use the following command</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># with proper names and = addresses in it)</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>if (uri=3D~"computergeeks.hopto.org") {</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'>if = (method=3D=3D"REGISTER") {</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># Uncomment this if you = want to use digest authentication</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>if (!www_authorize("computergeeks.hopto.org", = "subscriber")) {</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>www_challenge("computergeeks.hopto.org", "0");</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>break;</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>};</span></font> <br> <br> <font color=3Dnavy><span = style=3D'color:navy'>save("location");</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>break;</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>};</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'># native SIP destinations = are handled using our USRLOC DB</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>if = (!lookup("location")) {</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>sl_send_reply("404", "Not Found");</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>break;</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>};</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>};</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'># forward to current uri = now</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>if (!t_relay()) = {</span></font> <br> <font color=3Dnavy><span = style=3D'color:navy'>sl_reply_error();</span></font> <br> <font color=3Dnavy><span style=3D'color:navy'>};</span></font> <br> <br> <font color=3Dnavy><span style=3D'color:navy'>}</span></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=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = computergeeks ser: ser startup succeeded</span></font> <br> <font color=3D"#3366ff"><span style=3D'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)</span></font> <br> <font color=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = computergeeks /usr/sbin/ser[13089]: db_init(): Error while trying to connect = database</span></font> <br> <font color=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = computergeeks /usr/sbin/ser[13089]: mod_init(): Error while connecting = database</span></font> <br> <font color=3D"#3366ff"><span style=3D'color:#3366FF'>May 21 18:58:45 = computergeeks /usr/sbin/ser[13089]: init_modules(): Error while initializing module = usrloc</span></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 <o:p></o:p></span></font></p>
</div>
</body>
</html>
------=_NextPart_000_00B1_01C31FBD.C81364A0--
-
None