[SR-Users] kamailio 4.3v partition column name is reserved word in mysq ndbcluster engine

[José Seabra]

Hello Daniel,

After update my kamailio to version 4.3 and change the table location as
required in migration process, kamailio start giving some errors:

[root at ccp1 kamailio]# 35(7637) ERROR: db_mysql [km_dbase.c:121]:
db_mysql_submit_query(): driver error on query: Unknown column 'partition'
in 'where clause'
35(7637) ERROR: <core> [db_query.c:132]: db_do_query_internal(): error
while submitting query

that's is because the column name "partition" is reserved word (
http://dev.mysql.com/doc/refman/5.6/en/keywords.html) in mysql ndbcluster
engine, so what i did to fix this issue was add a new modparam in
modules/usrloc/ul_mod.c file:

{"partition_col",       PARAM_STR, &partition_col},


with this i can configure what name i want for this column in kamailio
module configuration and configure a diferent column name in  table
location(ex: modparam("usrloc", "partition_col", "partitionusrloc") ),  Can
you please check out if what i did is the correct way to fix it, in order
to avoid damage something else.

Best regards
-- 
Cumprimentos
José Seabra
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150720/f7ad01ba/attachment.html>