[Kamailio-Users] unknown column 'name' in field list

[Henning Westerholt]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090907/23af8e4d/attachment.htm>