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