<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=PT link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>And did you confirm if
your mysql accept local connection with user name and password you are using? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>What do you mean by your
authentication is working? Can you provide us a snip of your code? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Regards, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
Edgardo O. Gonzales II [mailto:edgardo.g@pacific.net.ph] <br>
<b><span style='font-weight:bold'>Sent:</span></b> sexta-feira, 29 de Abril de
2005 5:36<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Elton
Machado</st1:PersonName>; 'IpTel List'; 'Iptel Mailing list'<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [Serusers] RE: Ser
Crashes</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
I already did.. Im sure my username and password is correct because my
authentication is working..<br>
any other suggestion ..<br>
<br>
At 06:17 AM 4/29/2005, <st1:PersonName w:st="on">Elton Machado</st1:PersonName>
wrote:<br>
<br>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Did you checked out well your
configuration? <br>
<br>
You have to have something like... <br>
<br>
loadmodule "/usr/local/lib/ser/modules/mysql.so"<br>
loadmodule "/usr/local/lib/ser/modules/usrloc.so"<br>
loadmodule "/usr/local/lib/ser/modules/auth.so"<br>
loadmodule "/usr/local/lib/ser/modules/auth_db.so"<br>
<br>
#...... <br>
modparam("auth_db|usrloc", "db_url", "mysql://ser:heslo@localhost/ser")<br>
modparam("auth_db", "calculate_ha1", 1)<br>
modparam("auth_db", "password_column",
"password")<br>
modparam("usrloc", "db_mode", 2)<br>
<br>
to ser load things up from database, check if you have the right username
and password, and if your mysql database is running. <br>
<br>
<br>
Regards, <br>
<br>
<br>
<br>
<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
serusers-bounces@lists.iptel.org [<a href="mailto:serusers-bounces@lists.iptel.org"
eudora=autourl> mailto:serusers-bounces@lists.iptel.org</a>] <b><span
style='font-weight:bold'>On Behalf Of </span></b>IpTel List<br>
<b><span style='font-weight:bold'>Sent:</span></b> quinta-feira, 21 de Abril de
2005 8:19<br>
<b><span style='font-weight:bold'>To:</span></b> Iptel Mailing list<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Serusers] RE: Ser
Crashes<br>
</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hi!<br>
</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanx
for help. It writes that he can't connect to MYSQL DB now ... Output is the
following ... <br>
</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><a
href="mailto:root@ignosya:/usr/local/etc/ser">root@ignosya:/usr/local/etc/ser</a>#
ser -E -d<br>
Listening on<br>
127.0.0.1 [127.0.0.1]:5060<br>
84.230.194.213 [84.230.194.213]:5060<br>
192.168.1.1 [192.168.1.1]:5060<br>
Aliases: 1.1.168.192.in-addr.arpa:5060
a84-230-194-213.elisa-laajakaista.fi:5060 localhost:5060<br>
<a href="mailto:root@ignosya:/usr/local/etc/ser">root@ignosya:/usr/local/etc/ser</a>#
stateless - initializing<br>
Maxfwd module- initializing<br>
0(15143) connect_db(): Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)<br>
0(15143) db_init(): Error while trying to connect database<br>
0(15143) mod_init(): Error while connecting database<br>
0(15143) init_mod(): Error while initializing module usrloc<br>
ERROR: error while initializing modules<br>
</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><a
href="mailto:root@ignosya:/usr/local/etc/ser">root@ignosya:/usr/local/etc/ser</a>#
</span></font><br>
<br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>So, it
seams for me, that it's like MYSQL problem. So, i have to reconfigure it ... or
check it up ... <br>
But, are there any methods selecting mysql host adres? For example, if mysql is
not on local machine ... is it enough to set SQL_HOST var?<br>
</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Best
wishes,<br>
Alexandro.<br>
</span></font>_______________________________________________<br>
Serusers mailing list<br>
serusers@lists.iptel.org<br>
<a href="http://lists.iptel.org/mailman/listinfo/serusers" eudora=autourl>http://lists.iptel.org/mailman/listinfo/serusers</a><o:p></o:p></p>
</div>
</body>
</html>