On Montag, 7. September 2009, Rajesh wrote:
> > can you do issue a mysql "desc imc_rooms;" on your openser/ kamailio
> > DB to check if the table is correctly setup? And do you configured a
> > database url for the imc module?
>
> Thanks Henning for your prompt reply.
>
> I did give the command desc imc_rooms and found that the table do exist,
> indeed i created them manually before setting up imc module.What else
> could be the cause of the problem.

Hi Rajesh,

please always CC to the list. As hinted in some other mail, perhaps the module use not the correct DB URL?

I just checked it on my system with 1.5 branch, it loads ok:

Sep 7 12:56:14 ca ../kamailio[9312]: INFO:core:init_mod: initializing module imc
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:imc:mod_init: db_url=mysql://XXXX:XXXX@localhost/openser/43/0xb7dd4cac
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:find_mod_export: found <db_bind_api> in module db_mysql [../modules/]
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_bind_mod: using db bind api for db_mysql
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_do_init: connection 0x816ca10 not found in pool
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: opening connection: mysql://xxxx:xxxx@localhost/openser
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: connection type is Localhost via UNIX socket
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: protocol version is 10
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_new_connection: server version is 5.0.75-0ubuntu10.2
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_new_result: allocate 28 bytes for result set at 0x816c8f8
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: 3 columns returned from the query
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_allocate_columns: allocate 12 bytes for result names at 0x816caa8
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_allocate_columns: allocate 12 bytes for result types at 0x816c988
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x816cb60
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x816cb60)[0]=[name]
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[1] at 0x816cb40
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x816cb40)[1]=[domain]
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[2] at 0x816c858
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x816c858)[2]=[flag]
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_get_columns: use DB_INT result type
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:db_mysql:db_mysql_convert_rows: no rows returned from the query
Sep 7 12:56:14 ca ../kamailio[9312]: INFO:imc:add_from_db: the query returned no result
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing 3 columns
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing RES_NAMES[0] at 0x816cb60
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing RES_NAMES[1] at 0x816cb40
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing RES_NAMES[2] at 0x816c858
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing result names at 0x816caa8
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_columns: freeing result types at 0x816c988
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_rows: freeing 0 rows
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:db_free_result: freeing result set at 0x816c8f8
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:find_cmd_export_t: found <load_tm>(0) in module tm [../modules/]
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:pool_remove: removing connection from the pool
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:init_mod: registering stats for imc
Sep 7 12:56:14 ca ../kamailio[9312]: DBG:core:init_mod: register MI for imc
Sep 7 12:56:14 ca ../kamailio[9312]: INFO:core:init_mod: initializing module maxfwd
[..]

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.

Regards,

Henning