<html>
<body>
<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, Elton Machado wrote:<br>
<blockquote type=cite class=cite cite="">
<font face="arial" size=2 color="#000080">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>
<br>
<hr>
<div align="center"></font></div>
<font face="tahoma" size=2><b>From:</b> serusers-bounces@lists.iptel.org
[<a href="mailto:serusers-bounces@lists.iptel.org" eudora="autourl">
mailto:serusers-bounces@lists.iptel.org</a>] <b>On Behalf Of </b>IpTel
List<br>
<b>Sent:</b> quinta-feira, 21 de Abril de 2005 8:19<br>
<b>To:</b> Iptel Mailing list<br>
<b>Subject:</b> [Serusers] RE: Ser Crashes<br>
</font><font face="Times New Roman, Times"> <br>
</font><font face="arial" size=2>Hi!<br>
</font><font face="Times New Roman, Times"> <br>
</font><font face="arial" size=2>Thanx for help. It writes that he can't
connect to MYSQL DB now ... Output is the following ... <br>
</font><font face="Times New Roman, Times"> <br>
</font><font face="arial" size=2>
<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>
</font><font face="Times New Roman, Times"> <br>
</font><font face="arial" size=2>
<a href="mailto:root@ignosya:/usr/local/etc/ser">
root@ignosya:/usr/local/etc/ser</a># </font> <br>
<font face="Times New Roman, Times"> <br>
</font><font face="arial" size=2>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>
</font><font face="Times New Roman, Times"> <br>
</font><font face="arial" size=2>Best wishes,<br>
Alexandro.<br>
</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></blockquote></body>
</html>