<div>Hi,</div><div><br></div>Thanks for the response. I looked at the DBURL and it looked just fine. I wanted to test and see if the module is reading the config<div>param or not, I deliberately changed it to </div><div><br>
</div><div>modparam("msilo", "db_url", "mysql://root:xxxxx@localhost/openser");</div><div><br></div><div>When I ran it, the logs shows the user as 'openser' not the 'root' that I gave in config param. May be somewhere in the code, </div>
<div>db_url is being overwritten by DEFAULT_DB_URL.</div><div><br></div><div><div>0(28806) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/openser</div><div> 0(28806) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'openser'@'localhost' (using password: YES)</div>
<div> 0(28806) ERROR: <core> [db.c:312]: could not add connection to the pool 0(28806) ERROR: msilo [msilo.c:365]: failed to connect to the database</div><div><br></div><div>Thanks</div><div>Krish Kura</div><br><div class="gmail_quote">
On Sat, Mar 3, 2012 at 5:14 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
the error says the username, password or IP address are invalid to
connect to mysql -- access denied. There does not seem like being
other connections using same db_url, check for typos in db_url
parameter.<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<br>
On 3/3/12 12:39 AM, Krishna Kurapati wrote:
</div></div><blockquote type="cite"><div><div class="h5">Hi all,
<div><br>
</div>
<div>I am trying to use msilo module from modules_k. Unfortunately
it if failing during DB initialization.</div>
<div>Other modules are initializing fine. I am using Kamailio
3.2.2.</div>
<div><br>
</div>
<div>Not sure why the connection is not found. I tried to increase
the MAX mysql connections to 250. I see the</div>
<div>same error after I increase the connections.</div>
<div><br>
</div>
<div>The config file is pretty standard:</div>
<div><br>
</div>
<div>loadmodule "msilo.so"</div>
<div>
<div>modparam("msilo", "add_date", 0);</div>
<div>modparam("msilo", "db_url", DBURL); # The DBURL works for
other modules...</div>
</div>
<div><br>
</div>
<div>Here is the Log output:</div>
<div><br>
</div>
<div>
<div>0(14115) DEBUG: <core> [cfg.y:1684]: loading module
msilo.so</div>
<div> 0(14115) DEBUG: <core> [sr_module.c:557]:
load_module: trying to load
</usr/local/kamailio-3.2.2/lib64/kamailio/modules_k/msilo.so></div>
</div>
<div><br>
</div>
<div>.....</div>
<div><br>
</div>
<div>
<div>0(14117) DEBUG: <core> [sr_module.c:928]: DEBUG:
init_mod: msilo</div>
<div> 0(14117) DEBUG: <core> [sr_module.c:667]:
find_export_record: found <db_bind_api> in module
db_mysql
[/usr/local/kamailio-3.2.2/lib64/kamailio/modules/db_mysql.so]</div>
<div> 0(14117) DEBUG: <core> [db.c:212]: using db bind api
for db_mysql</div>
<div> 0(14117) DEBUG: <core> [db.c:299]: connection
0x7fc20d1ace60 not found in pool</div>
<div> 0(14117) DEBUG: db_mysql [km_my_con.c:94]: opening
connection: mysql://xxxx:xxxx@localhost/openser</div>
<div> 0(14117) ERROR: db_mysql [km_my_con.c:109]: driver error:
Access denied for user 'openser'@'localhost' (using password:
YES)</div>
<div> 0(14117) ERROR: <core> [db.c:303]: could not add
connection to the pool 0(14117) ERROR: msilo [msilo.c:319]:
failed to connect to the database</div>
<div> 0(14117) ERROR: <core> [sr_module.c:932]:
init_mod(): Error while initializing module msilo
(/usr/local/kamailio-3.2.2/lib64/kamailio/modules_k/msilo.so)</div>
<div>ERROR: error while initializing modules</div>
</div>
<div><br>
</div>
<div>Any help?</div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a> -- <a href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a></pre>
</font></span></div>
</blockquote></div><br></div>