<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Lucida Console'; font-size:9pt; font-weight:400; font-style:normal;">On Montag, 7. September 2009, Rajesh wrote:<br>
> > can you do issue a mysql "desc imc_rooms;" on your openser/ kamailio<br>
> > DB to check if the table is correctly setup? And do you configured a<br>
> > database url for the imc module?<br>
><br>
> Thanks Henning for your prompt reply.<br>
><br>
> I did give the command desc imc_rooms and found that the table do exist,<br>
> indeed i created them manually before setting up imc module.What else<br>
> could be the cause of the problem.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Hi Rajesh,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>please always CC to the list. As hinted in some other mail, perhaps the module use not the correct DB URL?<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>I just checked it on my system with 1.5 branch, it loads ok:<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Sep 7 12:56:14 ca ../kamailio[9312]: INFO:core:init_mod: initializing module imc<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:imc:mod_init: db_url=mysql://XXXX:XXXX@localhost/openser/43/0xb7dd4cac<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:find_mod_export: found <db_bind_api> in module db_mysql [../modules/]<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_bind_mod: using db bind api for db_mysql<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_do_init: connection 0x816ca10 not found in pool<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: opening connection: mysql://xxxx:xxxx@localhost/openser<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: connection type is Localhost via UNIX socket<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: protocol version is 10<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: server version is 5.0.75-0ubuntu10.2<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_new_result: allocate 28 bytes for result set at 0x816c8f8<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: 3 columns returned from the query<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_allocate_columns: allocate 12 bytes for result names at 0x816caa8<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_allocate_columns: allocate 12 bytes for result types at 0x816c988<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x816cb60<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x816cb60)[0]=[name]<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[1] at 0x816cb40<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x816cb40)[1]=[domain]<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[2] at 0x816c858<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x816c858)[2]=[flag]<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: use DB_INT result type<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_convert_rows: no rows returned from the query<br>
Sep 7 12:56:14 ca ../kamailio[9312]: INFO:imc:add_from_db: the query returned no result<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing 3 columns<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing RES_NAMES[0] at 0x816cb60<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing RES_NAMES[1] at 0x816cb40<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing RES_NAMES[2] at 0x816c858<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing result names at 0x816caa8<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing result types at 0x816c988<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_rows: freeing 0 rows<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_result: freeing result set at 0x816c8f8<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:find_cmd_export_t: found <load_tm>(0) in module tm [../modules/]<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:pool_remove: removing connection from the pool<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:init_mod: registering stats for imc<br>
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:init_mod: register MI for imc<br>
Sep 7 12:56:14 ca ../kamailio[9312]: INFO:core:init_mod: initializing module maxfwd<br>
[..]<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>I'd suggest that you increase the debug level to '4' in your cfg, and take a look to the output if the DB credentials are correct.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Regards,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Henning</p></body></html>