Hello Daniel,
Result of command kamailio -v
version: kamailio 4.3.1 (x86_64/linux) f38e67-dirty flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, DBG_F_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. id: f38e67 -dirty compiled on 15:56:29 Jul 20 2015 with gcc 4.4.7
Thank you for your support
BR José Seabra
2015-07-20 16:58 GMT+01:00 Daniel-Constantin Mierla miconda@gmail.com:
Hello,
the names of columns should be quoted in order to be safe against reserved keywords.
What is the exact version you are using (kamailio -v)?
Cheers, Daniel
On 20/07/15 17:37, José Seabra wrote:
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@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
-- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Book: SIP Routing With Kamailio - http://www.asipto.com