Hi,

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
param or not, I deliberately changed it to 

modparam("msilo", "db_url", "mysql://root:xxxxx@localhost/openser");

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, 
db_url is being overwritten by DEFAULT_DB_URL.

0(28806) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/openser
 0(28806) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'openser'@'localhost' (using password: YES)
 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

Thanks
Krish Kura

On Sat, Mar 3, 2012 at 5:14 AM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:
Hello,

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.

Cheers,
Daniel



On 3/3/12 12:39 AM, Krishna Kurapati wrote:
Hi all,

I am trying to use msilo module from modules_k. Unfortunately it if failing during DB initialization.
Other modules are initializing fine. I am using Kamailio 3.2.2.

Not sure why the connection is not found. I tried to increase the MAX mysql connections to 250. I see the
same error after I increase the connections.

The config file is pretty standard:

loadmodule "msilo.so"
modparam("msilo", "add_date", 0);
modparam("msilo", "db_url", DBURL);  # The DBURL works for other modules...

Here is the Log output:

0(14115) DEBUG: <core> [cfg.y:1684]: loading module msilo.so
 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>

.....

0(14117) DEBUG: <core> [sr_module.c:928]: DEBUG: init_mod: msilo
 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]
 0(14117) DEBUG: <core> [db.c:212]: using db bind api for db_mysql
 0(14117) DEBUG: <core> [db.c:299]: connection 0x7fc20d1ace60 not found in pool
 0(14117) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/openser
 0(14117) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'openser'@'localhost' (using password: YES)
 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
 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)
ERROR: error while initializing modules

Any help?

Thanks



_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


-- 
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda