Re: [Kamailio-Users] unknown column 'name' in field list - sr-users

7 Sep 2009

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