<div dir="ltr">I found the root cause of this issue, as i copied the mysql commands from this link <a href="http://www.kamailio.org/wiki/install/upgrade/4.2.x-to-4.3.0">http://www.kamailio.org/wiki/install/upgrade/4.2.x-to-4.3.0</a> and pasted it in mysql client, apparently that was my issue, what i did to fix this issue was drop the column and add it again but with this mysql command: <div><br></div><div>ALTER TABLE location ADD COLUMN `partition` INT(11) DEFAULT 0 NOT NULL;</div><div><br></div><div>The difference between this mysql command is that I'm using quotes in column name and the mysql commands that are in the link specified above doesn't have the quotes in column names.<br><br>I shouldn't have copy these commands without fix it.<br></div><div><br></div><div>Thank you for your help.</div><div><br>BR<br>José Seabra<br><div><br></div><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-20 17:46 GMT+01:00 José Seabra <span dir="ltr"><<a href="mailto:joseseabra4@gmail.com" target="_blank">joseseabra4@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I changed the column name in the database table from partition to partitionusrloc, and i added a new modparam (<span style="font-size:12.8000001907349px">partition_col</span>) in <span style="font-size:12.8000001907349px">modules/usrloc/ul_mod.c file:</span><span class=""><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">{"partition_col", PARAM_STR, &partition_col},<br></div><div><br></div><div><br></div></span><div>in order to be able to configure the name of this column from partition to partitionusrloc in kamailio module configuration section, with following configuration:</div><span class=""><div><br></div><div><span style="font-size:12.8000001907349px">modparam("usrloc", "partition_col", "partitionusrloc")</span><br></div><div><br></div></span><div>I will enable the mysql log then collect the query log, and reply back to you with this information.</div><div><br></div><div>BR</div><div>Thank you.</div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">2015-07-20 17:24 GMT+01:00 Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
the backticks should be added for columns in where condition. Can
you enable logging the query in mysql server logs and send it over
to see how it looks?<br>
<br>
Or maybe I didn't understand your problem properly and you changed
the name in the database table for column partition, but there was
no way to change that to usrloc module?<br>
<br>
Cheers,<br>
Daniel<div><div><br>
<br>
<div>On 20/07/15 18:04, José Seabra wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div>
<div dir="ltr">Hello Daniel,
<div><br>
</div>
<div>Result of command kamailio -v</div>
<div><br>
</div>
<div>version: kamailio 4.3.1 (x86_64/linux) f38e67-dirty<br>
</div>
<div>
<div>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</div>
<div>ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144,
MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT
PKG_SIZE 8MB</div>
<div>poll method support: poll, epoll_lt, epoll_et, sigio_rt,
select.</div>
<div>id: f38e67 -dirty</div>
<div>compiled on 15:56:29 Jul 20 2015 with gcc 4.4.7</div>
</div>
<div><br>
</div>
<div>Thank you for your support</div>
<div><br>
</div>
<div>BR</div>
<div>José Seabra</div>
</div>
</div></div><div class="gmail_extra"><br>
<div class="gmail_quote"><div><div>2015-07-20 16:58 GMT+01:00
Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Hello,<br>
<br>
the names of columns should be quoted in order to be safe
against<br>
reserved keywords.<br>
<br>
What is the exact version you are using (kamailio -v)?<br>
<br>
Cheers,<br>
Daniel<br>
<span><br>
On 20/07/15 17:37, José Seabra wrote:<br>
> Hello Daniel,<br>
><br>
> After update my kamailio to version 4.3 and change
the table location<br>
> as required in migration process, kamailio start
giving some errors:<br>
><br>
> [root@ccp1 kamailio]# 35(7637) ERROR: db_mysql
[km_dbase.c:121]:<br>
> db_mysql_submit_query(): driver error on query:
Unknown column<br>
> 'partition' in 'where clause'<br>
> 35(7637) ERROR: <core> [db_query.c:132]:
db_do_query_internal(): error<br>
> while submitting query<br>
><br>
> that's is because the column name "partition" is
reserved word<br>
</span>> (<a href="http://dev.mysql.com/doc/refman/5.6/en/keywords.html" rel="noreferrer" target="_blank">http://dev.mysql.com/doc/refman/5.6/en/keywords.html</a>)
in mysql<br>
<div>
<div>> ndbcluster engine, so what i did to
fix this issue was add a new<br>
> modparam in<br>
> modules/usrloc/ul_mod.c file:<br>
><br>
> {"partition_col", PARAM_STR,
&partition_col},<br>
><br>
><br>
> with this i can configure what name i want for this
column in kamailio<br>
> module configuration and configure a diferent
column name in table<br>
> location(ex: modparam("usrloc", "partition_col",
"partitionusrloc") ),<br>
> Can you please check out if what i did is the
correct way to fix it,<br>
> in order to avoid damage something else.<br>
><br>
> Best regards<br>
> --<br>
> Cumprimentos<br>
> José Seabra<br>
<br>
</div>
</div>
</div></div><span><font color="#888888">--<br>
Daniel-Constantin Mierla<br>
<a href="http://twitter.com/#%21/miconda" rel="noreferrer" target="_blank">http://twitter.com/#!/miconda</a>
- <a href="http://www.linkedin.com/in/miconda" rel="noreferrer" target="_blank">http://www.linkedin.com/in/miconda</a><span><br>
Book: SIP Routing With Kamailio - <a href="http://www.asipto.com" rel="noreferrer" target="_blank">http://www.asipto.com</a><br>
<br>
</span></font></span></blockquote>
</div>
<br>
<br clear="all"><span><font color="#888888">
<div><br>
</div>
-- <br>
<div>Cumprimentos
<div>José Seabra</div>
</div>
</font></span></div>
</blockquote><span>
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a></pre>
</span></div>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br><div>Cumprimentos<div>José Seabra</div></div>
</font></span></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Cumprimentos<div>José Seabra</div></div>
</div>